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.
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
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 |
