Walmart_v2

Walmart ETL connector for data replication

Locate the API keys on seller dashboard

1. Log in to seller dashboard (https://www.seller.walmart.com)

2. Click on Settings -> API Key Management

3. Click on Walmart Developer Portal. You will be redirected to Walmart developer portal.

4. Note down the client ID and client secret on Production keys tab. These will be used to create the integration in Daton.

Snapshot

Features	Details
Release Status	Released
Source API Version	V3
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Client ID Client Secret
Replication Type	Full Replication Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	1 hr

Walmart Tables

Reports

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

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

1. Delivery_DefectReport

Purpose: provides all information about delivery defects

Replication: Full load

Field name

Name	Datatype
Destinationstate	STRING
orderplaceddt	STRING

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

3. CancellationReport

Purpose: provides information about cancellation of items

Replication type: Full load

Fields

destinationstate	STRING
orderplaceddt	STRING

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

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

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

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

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

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

Raw Tables

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

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

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

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

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

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