Walmart
Walmart ETL connector for data replication
Last updated
Walmart ETL connector for data replication
Last updated
Log in to seller dashboard (https://www.seller.walmart.com)
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.
Source documentation: https://developer.walmart.com/doc/us/us-mp/us-mp-onrequestreports/
Purpose: To view all the information associated with your items that are set up on Walmart’s platform.
Replication: Full load
Replication key: NA
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
Source documentation: https://developer.walmart.com/doc/us/us-mp/us-mp-reports/
Frequency: Data loaded once in a day after 6am PST.
Purpose: provides all information about a seller’s items that are currently set up on Walmart.com.
Replication: Full load
Replication: N/A
Purpose: provides buy box information about seller’s items.
Replication: Full load
Replication: N/A
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
Purpose: provides insights into performance data of seller’s catalog.
Replication type: Full load
Purpose: provides all active and future promotions of seller.
Replication type: Full load
Purpose: provides SKU-level template configuration to node mapping for the seller.
Replication type: Full load
Purpose: Provides seller-specific details of SKU-level shipping-program.
Replication type: Full load
Fields
Purpose: Provides the information of item level overrides for all seller’s items.
Replication type: Full load
Purpose: Lists all payment and order reconciliation for a specific date for seller.
Replication type: Full load
Source documentation: https://developer.walmart.com/doc/us/mp/us-mp-insights/
Frequency: hourly
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:
Purpose: Using the Trending Items API to discover what items are currently trending best sellers at Walmart.
Replication type: Incremental
Replication key:
Source documentation: https://developer.walmart.com/doc/us/us-mp/us-mp-orders/
Frequency: hourly
Replication type: Incremental
Replication key: OrderDate
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
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
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