Walmart

Walmart ETL connector for data replication

Need help with something?

Talk to data expert

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
  1. 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
  1. 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
  1. 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
  1. 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
  1. 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
  1. 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
  1. ShippingProgramReport     
    Purpose: Provides seller-specific details of SKU-level shipping-program.     
    Replication type: Full load

Fields

Name
Datatype
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
  1. ReturnItemOverridesReport     
    Purpose: Provides the information of item level overrides for all seller’s items.     
    Replication type: Full load

Fields

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

Name
Data Type
sku
STRING
shipNodes
RECORD

Related Articles

Table of Contents

Locate the API keys on seller dashboard Snapshot Walmart Tables On-Request Reports Pre-Generated Reports Insights Raw Tables