Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Walmart

Walmart ETL connector for data replication

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        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

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Product Glossary
        • April
        • Essential Attributes and Supported Tables for Amazon Selling Partner
        • September
        • Essential Attributes and Supported Tables for Pinterest

        Table of Contents

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

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand