Schema Information

This topic provides a structured reference to assist you in working with Daton's Walmart_v2 connector and the associated fields and tables.

Saras Daton

Need help with something?

Talk to data expert

Schema Information

This topic provides a structured reference to assist you in working with Daton's Walmart_v2 connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Walmart_v2 connector:

Delivery_DefectReport
InventoryReport
CancellationReport
ItemPerformanceReport
PromoReport
ShippingConfigurationReport
ShippingProgramReport
ReturnItemOverridesReport
ReconReport
Orders
Returns
Inventory
WFSInventory
ItemDetails

Reports

Source documentation: https://developer.walmart.com/doc/us/us-mp/us-mp-reports/

Frequency: Data loaded once in a day after 6am PST.

Delivery_DefectReport

Purpose: provides all information about delivery defects

Replication: Full load

Fields

Name	Datatype
Destinationstate	STRING
orderplaceddt	STRING

InventoryReport

Purpose: provides inventory information about seller’s items.

Replication: Full load

Fields

Name	Datatype
sku	STRING
item_id	INTEGER
product_name	STRING
ship_node_id	NUMERIC
ship_node_name	STRING
input_quantity	INTEGER
availtosell_quantity	INTEGER

CancellationReport

Purpose: provides information about cancellation of items

Replication type: Full load

Fields

Name	Datatype
destinationstate	STRING
orderplaceddt	STRING

ItemPerformanceReport

Purpose: provides insights into performance data of seller’s catalog.

Replication type: Full load

Fields

Name	Datatype
brand	STRING
authorized_orders	INTEGER
authorized_sales	NUMERIC
category	STRING
item_conversion_rate	NUMERIC
commission	NUMERIC
super_department	STRING
total_ly_gmv	NUMERIC
authorized_units	INTEGER
department	STRING
cancelled_sales	NUMERIC
total_product_visits	INTEGER
gmv_commission	NUMERIC
aur	NUMERIC
gmv_comp__	NUMERIC
product_name	STRING
base_item_id	INTEGER
product_level_conversion_rate	NUMERIC
total_units_sold	INTEGER
cancelled_units	INTEGER
product_level_pageviews	INTEGER
refunded_sales	NUMERIC
gmv	NUMERIC
item_id	INTEGER
sku_id	STRING
sub_category	STRING

PromoReport

Purpose: provides all active and future promotions of seller.

Replication type: Full load

Fields

Name	Datatype
Partner_ID	NUMERIC
SKU	STRING
Item_ID	STRING
Product_Name	STRING
Product_Category	STRING
Promo_ID	STRING
Promo_Effective_Date	STRING
Promo_Expiration_Date	STRING
Current_Price	STRING
Current_Price_Currency	STRING
Comparison_Price	STRING
Comparison_Price_Currency	STRING
Promo_Type	STRING
Promo_Status	STRING

ShippingConfigurationReport

Purpose: provides SKU-level template configuration to node mapping for the seller.

Replication type: Full load

Fields

Name	Datatype
SKU	STRING
Item_ID	NUMERIC
Product_Name	STRING
Publish_Status	STRING
Lifecycle_Status	STRING
Ship_Node_ID	STRING
Ship_Node_Name	STRING
Ship_Node_Type	STRING
Template_ID	STRING
Template_Name	STRING
Template_Type	STRING

ShippingProgramReport

Purpose: Provides seller-specific details of SKU-level shipping-program.

Replication type: Full load

Fields

Name	Data Type
Product_Name	STRING
Item_ID	NUMERIC
SKU	STRING
Publish_Status	STRING
Lifecycle_Status	STRING
Program_Participation	STRING
Template_ID	STRING
Template_Type	STRING
Coverage_Areas	STRING

ReturnItemOverridesReport

Purpose: Provides the information of item level overrides for all seller’s items.

Replication type: Full load

Fields

Name	Data Type
partnerId	NUMERIC
SKU	STRING
Keep_It	STRING
Return_Restricted	STRING
Restriction_Reason	STRING
Return_Center_Brace_Alias_Brace	STRING

ReconReport

Purpose: Lists all payment and order reconciliation for a specific date for seller.

Replication type: Full load

Fields

Name	Datatype
period_start_date	STRING
period_end_date	STRING
total_payable	STRING
currency	STRING
transaction_key	STRING
transaction_posted_timestamp	STRING
transaction_type	STRING
transaction_description	STRING
customer_order__	STRING
customer_order_line__	STRING
purchase_order__	STRING
purchase_order_line__	STRING
amount	STRING
amount_type	STRING
ship_qty	STRING
commission_rate	STRING
transaction_reason_description	STRING
partner_item_id	STRING
partner_gtin	STRING
partner_item_name	STRING
product_tax_code	STRING
ship_to_state	STRING
ship_to_city	STRING
ship_to_zipcode	STRING
contract_category	STRING
product_type	STRING
commission_rule	STRING
shipping_method	STRING
fulfillment_type	STRING
fulfillment_details	STRING
original_commission	STRING
commission_incentive_program	STRING
commission_saving	STRING
customer_promo_type	STRING
campaign_id	STRING
reportdate	STRING

Orders

Source documentation: https://developer.walmart.com/doc/us/us-mp/us-mp-orders/

Frequency: hourly

Replication type: Incremental

Replication key: OrderDate

Fields

Name	Data Type
shipNodeType	STRING
purchaseOrderId	NUMERIC
customerOrderId	NUMERIC
customerEmailId	STRING
orderType	STRING
orderDate	TIMESTAMP
shippingInfo	RECORD
orderLines	RECORD
shipNode	RECORD

Returns

Purpose: Retrieves the details of return orders for the specified filter criteria.

Source documentation: https://developer.walmart.com/doc/us/mp/us-mp-returns/

Replication type: Incremental

Replication key: ReturnOrderDate

Fields

Name	Data Type
returnOrderId	NUMERIC
customerEmailId	STRING
customerName	RECORD
customerOrderId	NUMERIC
returnOrderDate	TIMESTAMP
returnByDate	TIMESTAMP
refundMode	STRING
totalRefundAmount	RECORD
returnLineGroups	RECORD
returnOrderLines	RECORD
returnChannel	RECORD

Inventory

Source documentation: https://developer.walmart.com/doc/us/mp/us-mp-inventory/

Purpose: This API will retrieve the inventory count for all of a seller's items across all ship nodes by item to ship node mapping. Inventory can be zero or non-zero.

ReplicationType: Full load

Fields

Name	Data Type
sku	STRING
nodes	RECORD

WFSInventory

Source documentation: https://developer.walmart.com/api/us/mp/inventory

Purpose: You can use this API to get the current Available to Sell inventory quantities for all WFS items in your catalog.

Replication type: Incremental

Replication key: FromModifiedDate

Fields

Field name	Type
sku	STRING
shipNodes	RECORD
offerId	STRING

ItemDetails

https://developer.walmart.com/api/us/mp/items#operation/getSearchResult

Purpose: You can use this API to get additional details about items

Replication type: Incremental

Fields

Name	Datatype
itemid	STRING
ismarketplaceitem	BOOLEAN
images	RECORD
customerrating	STRING
freeshipping	BOOLEAN
offercount	NUMERIC
price	RECORD
description	STRING
title	STRING
brand	STRING
producttype	STRING
properties	RECORD

Table of Contents

Tables/APIs Reports Delivery_DefectReport Fields InventoryReport Fields CancellationReport Fields ItemPerformanceReport Fields PromoReport Fields ShippingConfigurationReport Fields ShippingProgramReport Fields ReturnItemOverridesReport Fields ReconReport Fields Orders Fields Returns Fields Inventory Fields WFSInventory Fields ItemDetails Fields

Schema Information

Contact Us

Saras Daton

Schema Information

Tables/APIs

Reports

Delivery_DefectReport

Fields

InventoryReport

Fields

CancellationReport

Fields

ItemPerformanceReport

Fields

PromoReport

Fields

ShippingConfigurationReport

Fields

ShippingProgramReport

Fields

ReturnItemOverridesReport

Fields

ReconReport

Fields

Orders

Fields

Returns

Fields

Inventory

Fields

WFSInventory

Fields

ItemDetails

Fields

Related Articles