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

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

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

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

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