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.

Report support Spanish and English headers hence first two rows in .csv file are reserved for header columns.

rowFilters such 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 floor range value or ceiling range value or both values. Currently, the supported columnName value is INVENTARIO 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. Go to 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 (otherwise known as “ID de nodo de envío”).

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.

FieldDescriptionOrigin
GTINThe Global Trade Item Number associated with this itemSeller
WUPCWalmart-specified identifier for the item.Walmart
Offer IdUnique identifier which is a combination of SKU and partnerIdWalmart
Nombre del productoName of the itemSeller
Nombre corto del productoShort Name of the itemSeller
InventarioQuantity 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 ordersSeller
Fecha de creaciónDate when an inventory was createdSeller
Fecha de última modificaciónDate when an inventory was updatedSeller
ID de nodo de envíoIdentifies the Fulfillment Center (otherwise known as “Ship Node”)Walmart
Nombre del nodo de envíoName of the Fulfillment Center or “Ship Node.” This is a custom name that the seller can create to identify the ship node. For example: “TwoDay_WestCoast” or “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:

  • ID de nodo de envío = N/A
  • Nombre del nodo de envío = N/A
  • Inventario= 0

To update item inventory, Call the POST Update Item Inventory per Ship Node API. For more details about inventory updates, go to Update item inventory.