Request an inventory report
Sellers can use the on-request Inventory report to view their entire inventory for all items across all fulfillment centers.
Once the report is available, sellers can download it to return all the information associated with the items that are set up on Walmart’s platform.
rowFilters such as rangeFilter can be used to get specific results.
rangeFilter
This can be used to filter based on a range. You must pass a parameter with the floor range value, ceiling range value, or both values. Currently, the supported columnName value is INVENTORY COUNT for the rangeFilter.
OPTIONAL: Use an app to parse the CSV file
Instead of downloading the CSV file, you can use an app to parse the CSV file for you, you can use the Java code shown in the Pre-Generated Reports guide. See Parse reports CSV file with Java.
What’s in the report file
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 four rows in the report for that item, each row for the corresponding fulfillment center (aka “ship node”).
Here is an example to show the Report CSV file opened in a spreadsheet application.
Example: Inventory report
Note: All example API calls shown assume the Walmart API endpoint: https://marketplace.walmartapis.com
Report field descriptions
The CSV report file contains the following fields. The identifiers can be specified by either the seller or Walmart.
| Field | Description | Origin |
|---|---|---|
| Seller SKU | Seller-specified unique identifier for the item. | Seller |
| Offer ID | Unique identifier which is a combination of SKU and partnerId | Walmart |
| Inventory Count | Quantity of an item that is currently in-stock and available to sell. This inventory count does not show any items that are committed to open, undelivered orders | Walmart |
| Product Name | Name of the item | Seller |
| Walmart SKU ID | Walmart-specified unique identifier for the item | Walmart |
| Ship Node ID | Identifies the Fulfillment Center (otherwise known as “Ship Node”) | Walmart |
| Ship Node Name | Name of the Fulfillment Center or “Ship Node.” This is a custom name that seller can create to identify the ship node. For example: “CA_Standard” | Seller |
Item has zero inventory count and N/A for ship node
If a row in the report holds the values for these three columns, it implies that the corresponding item was not updated since the ingestion:
- Ship Node ID = N/A
- Ship Node Name = N/A
- Inventory Count = 0
To update item inventory, call the POST Update Item Inventory per Ship Node API. For more details about inventory updates, see Update item inventory.
Updated about 1 month ago