Walmart

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

On-Request Reports

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

1. ItemReportsOnRequest

Purpose: To view all the information associated with your items that are set up on Walmart’s platform.

Replication: Full load

Replication key: NA

Fields

Name	Datatype
ReportDateTime	DATETIME
SKU	STRING
Item_ID	NUMERIC
Product_name	STRING
Lifecycle_Status	STRING
Publish_status	STRING
Status_Change_Reason	STRING
Product_category	STRING
Price	NUMERIC
Currency	STRING
Buy_Box_Item_Price	NUMERIC
Buy_Box_Shipping_Price	NUMERIC
MSRP	NUMERIC
Product_Tax_Code	NUMERIC
Ship_Methods	STRING
Shipping_weight	NUMERIC
Shipping_weight_Unit	STRING
Fulfillment_lag_Time	NUMERIC
Fulfillment_Type	STRING
WFS_Sales_restriction	STRING
WPID	STRING
GTIN	NUMERIC
UPC	NUMERIC
Item_page_URL	STRING
Shelf_name	STRING
Primary_category_path	STRING
Brand	STRING
Offer_start_date	DATE
Offer_end_date	DATE
Item_Creation_date	DATE
Item_Last_updated	DATE
Reviews_count	NUMERIC
Average_rating	NUMERIC
Searchable__	STRING
Competitor_URL	STRING
Competitor_price	NUMERIC
Competitor_Ship_Price	NUMERIC
Competitor_Last_Date_Fetched	DATE

2. InventoryReportOnRequest

Purpose: The report shows individual rows for each fulfillment center that holds inventory for that item. For example, if you have one item at four fulfillment centers, you will see 4 rows in the report for that item, each row for the corresponding fulfillment center (aka “ship node”).

Replication: Full load

Replication key: NA

Fields

Name	Datatype
ReportDateTime	DATETIME
SKU	STRING
Item_ID	NUMERIC
Product_Name	STRING
Ship_Node_ID	NUMERIC
Ship_node_name	STRING
Input_quality	STRING
AvailToSell_Quantity	NUMERIC

Pre-Generated 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. ItemReport

Purpose: provides all information about a seller’s items that are currently set up on Walmart.com.

Replication: Full load

Replication: N/A

Field name

Name	Datatype
ReportDate	DATE
PARTNER_ID	NUMERIC
SKU	STRING
PRODUCT_NAME	STRING
PRODUCT_CATEGORY	STRING
PRICE	NUMERIC
CURRENCY	STRING
BUY_BOX_ITEM_PRICE	NUMERIC
BUY_BOX_SHIPPING_PRICE	NUMERIC
PUBLISH_STATUS	STRING
STATUS_CHANGE_REASON	STRING
LIFECYCLE_STATUS	STRING
INVENTORY_COUNT	NUMERIC
SHIP_METHODS	STRING
WPID	STRING
ITEM_ID	NUMERIC
GTIN	NUMERIC
UPC	NUMERIC
PRIMARY_IMAGE_URL	STRING
SHELF_NAME	STRING
PRIMARY_CAT_PATH	STRING
OFFER_START_DATE	STRING
OFFER_END_DATE	STRING
ITEM_CREATION_DATE	STRING
ITEM_LAST_UPDATED	STRING
ITEM_PAGE_URL	STRING
REVIEWS_COUNT	NUMERIC
AVERAGE_RATING	NUMERIC
SEARCHABLE__	STRING
COMPETITOR_URL	STRING
COMPETITOR_PRICE	NUMERIC
COMPETITOR_SHIP_PRICE	NUMERIC
COMPETITOR_LAST_DATE_FETCHED	STRING
BRAND	STRING
PRODUCT_TAX_CODE	NUMERIC
MSRP	NUMERIC
SHIPPING_WEIGHT	NUMERIC
SHIPPING_WEIGHT_UNIT	STRING
FULFILLMENT_LAG_TIME	NUMERIC
FULFILLMENT_TYPE	STRING
WFS_SALES_RESTRICTION	STRING

2. BuyBoxReport

Purpose: provides buy box information about seller’s items.

Replication: Full load

Replication: N/A

Fields

Name	Datatype
ReportDate	DATE
Seller_Id	NUMERIC
Sku	STRING
Item_ID	NUMERIC
Product_Name	STRING
Product_Category	STRING
Seller_Name	STRING
Seller_Item_Price	NUMERIC
Seller_Ship_Price	NUMERIC
IsSellerBuyBoxWinner	STRING
Buybox_Seller_ID	NUMERIC
Buybox_Item_Price	NUMERIC
Buybox_Ship_Price	NUMERIC
Offer2_Seller_ID	NUMERIC
Offer2_Item_Price	NUMERIC
Offer2_Ship_Price	NUMERIC
Offer3_Seller_ID	NUMERIC
Offer3_Item_Price	NUMERIC
Offer3_Ship_Price	NUMERIC
Offer4_Seller_ID	NUMERIC
Offer4_Item_Price	NUMERIC
Offer4_Ship_Price	NUMERIC

3. CAPReport

Purpose: provides the CAP Item Opt-in file that helps sellers to get information about all items eligible for Competitive price adjustments.

Replication type: Full load

Replication key: N/A

Fields

Datatype
ReportDate	DATE
PARTNER_ID	NUMERIC
SKU	STRING
SKU_OPT_IN	STRING
PRODUCT_NAME	STRING
CURRENCY	STRING
PRICE	STRING
SHIP_PRICE	STRING

4. ItemPerformanceReport

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

Replication type: Full load

Fields

Name	Datatype
ReportDate	DATE
Product_Name	STRING
Item_ID	NUMERIC
SKU_ID	STRING
Super_Department	STRING
Department	STRING
Category	STRING
Sub_Category	STRING
Brand	STRING
GMV	NUMERIC
Commission	NUMERIC
GMV_Dash_Commission	NUMERIC
AUR	NUMERIC
Total_Units_Sold	NUMERIC
Cancelled_Units	NUMERIC
Cancelled_Sales	NUMERIC
Item_Conversion_Rate	NUMERIC
Base_Item_Id	NUMERIC
Total_Product_Visits	NUMERIC
GMV_Comp__Percent	NUMERIC
Authorized_Orders	NUMERIC
Authorized_Units	NUMERIC
Authorized_Sales	NUMERIC
Total_LY_GMV	NUMERIC

5. PromotionsReport

Purpose: provides all active and future promotions of seller.

Replication type: Full load

Fields

Name	Datatype
ReportDate	DATE
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
ReportDate	DATE
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
ReportDate	DATE
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
ReportDate	DATE
partnerId	NUMERIC
SKU	STRING
Keep_It	STRING
Return_Restricted	STRING
Restriction_Reason	STRING
Return_Center_Brace_Alias_Brace	STRING

9. ReconciliationReport

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

Replication type: Full load

Fields

Name	Data Type
ReportDate	DATE
Walmart_dot_com_Order__hash	NUMERIC
Walmart_dot_com_Order_Line__hash	NUMERIC
Walmart_dot_com_PO__hash	NUMERIC
Walmart_dot_com_P_dot_O_dot__Line__hash	NUMERIC
Partner_Order__hash	STRING
Transaction_Type	STRING
Transaction_Date_Time	STRING
Shipped_Qty	NUMERIC
Partner_Item_ID	STRING
Partner_GTIN	NUMERIC
Partner_Item_name	STRING
Product_tax_code	NUMERIC
Shipping_tax_code	STRING
Gift_wrap_tax_code	STRING
Ship_to_state	STRING
Ship_to_county	STRING
County_Code	STRING
Ship_to_city	STRING
Zip_code	NUMERIC
shipping_Underscore_method	STRING
Total_tender_to__slash__from_customer	NUMERIC
Payable_to_Partner_from_Sale	NUMERIC
Commission_from_Sale	NUMERIC
Commission_Rate	NUMERIC
Gross_Sales_Revenue	NUMERIC
Refunded_Retail_Sales	NUMERIC
Sales_refund_for_Escalation	NUMERIC
Gross_Shipping_Revenue	NUMERIC
Gross_Shipping_Refunded	NUMERIC
Shipping_refund_for_Escalation	NUMERIC
Net_Shipping_Revenue	NUMERIC
Gross_Fee_Revenue	NUMERIC
Gross_Fee_Refunded	NUMERIC
Fee_refund_for_Escalation	NUMERIC
Net_Fee_Revenue	NUMERIC
Gift_Wrap_Quantity	NUMERIC
Gross_Gift_Dash_Wrap_Revenue	NUMERIC
Gross_Gift_Dash_Wrap_Refunded	NUMERIC
Gift_wrap_refund_for_Escalation	NUMERIC
Net_Gift_Wrap_Revenue	NUMERIC
Tax_on_Sales_Revenue	NUMERIC
Tax_on_Shipping_Revenue	NUMERIC
Tax_on_Gift_Dash_Wrap_Revenue	NUMERIC
Tax_on_Fee_Revenue	NUMERIC
Effective_tax_rate	NUMERIC
Tax_on_Refunded_Sales	NUMERIC
Tax_on_Shipping_Refund	NUMERIC
Tax_on_Gift_Dash_Wrap_Refund	NUMERIC
Tax_on_Fee_Refund	NUMERIC
Tax_on_Sales_refund_for_Escalation	NUMERIC
Tax_on_Shipping_Refund_for_Escalation	NUMERIC
Tax_on_Gift_Dash_Wrap_Refund_for_escalation	NUMERIC
Tax_on_Fee_Refund_for_escalation	NUMERIC
Total_NET_Tax_Collected	NUMERIC
Tax_Withheld	STRING
Adjustment_Description	STRING
Adjustment_Code	STRING
Original_Item_price	STRING
Original_Commission_Amount	STRING
Product_Type	STRING
Spec_Category	STRING
Contract_Category	STRING
Flex_Commission_Rule	STRING
Return_Reason_Code	STRING
Return_Reason_Description	STRING
Fee_Withheld_Flag	STRING
Fulfillment_Type	STRING

Insights

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

Frequency: hourly

1. UnpublishedItemsReport

Purpose: Get insights into why your items are getting unpublished with Unpublished Items APIs. Find out reasons why items got unpublished and republish them. Find out what is the total cost of all items unpublished for a specific reason

Replication type: Incremental

Replication key:

Fields

Name	Data Type
gtin	STRING
marketPrice	RECORD
offerStartDate	DATE
marketTrending	STRING
lifecycleStatus	STRING
unpublishReasons	STRING
conversionRate	NUMERIC
productName	STRING
gmvAmount	RECORD
itemId	NUMERIC
customerRating	STRING
pageViews	NUMERIC
price	RECORD
unpublishedDate	DATE
brand	STRING
sku	STRING
productType	STRING
offerEndDate	DATE
publishStatus	STRING

2. TopTrendingItemsReport

Purpose: Using the Trending Items API to discover what items are currently trending best sellers at Walmart.

Replication type: Incremental

Replication key:

Fields

Name	Data Type
ReportDate	DATE
DepartmentId	NUMERIC
TimeFrame	NUMERIC
departmentName	STRING
isbn	STRING
categoryName	STRING
productName	STRING
subCategoryName	STRING
isTwoDayEligible	NUMERIC
itemId	STRING
totalOffers	NUMERIC
issn	STRING
superDepartmentName	STRING
existsForSeller	NUMERIC
rank	NUMERIC
brand	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