DSV inventory report
Drop ship vendors (DSV) can use the on request DSV_INVENTORY report to view all of the items they sell via the DSV channel and key information at each one of their ship nodes, such as:
- Item inventory levels
- Cost at each ship node
Note: This report does not contain any inventory for items purchased by Walmart.
DSV inventory report information
The report shows individual rows for each item and every fulfillment center or ship node that the Supplier has set up.
For example, if users have one item and four fulfillment centers, they will see four rows in the report for that item. There will be individual rows for the corresponding fulfillment center or ship node.
Note: Only active ship nodes or fulfillment centers will be included on the report.
Here is an example to show the report CSV file opened in a spreadsheet application.
Note: The global trade item number (GTIN) values often start with leading 0’s. If users open the CSV file in Microsoft® Excel®, make sure to open the file with the GTIN field as a string, rather than a number, to get the full GTIN value.
Key report information includes the following:
- Report name:
DSV_INVENTORY - Versions available: 1
- Report primary keys: Item/ship node
- Report data refreshed: Every 24 hours at 4 AM CT
- Supports filters: Yes, per the following table:
| Supports defining attributes included in the report? | No; attributes in this report do not vary |
| Value Filters | Yes; the report supports value (enum) filters on the following 2 fields: Published Status: PUBLISHED; UNPUBLISHED Active Item Configuration: Yes; No |
Report field descriptions
The CSV report file contains the following fields:
| Field | Description | Origin |
|---|---|---|
| SKU | Specifies the supplier-specified stock keeping unit identifier for the item. | Supplier |
| GTIN | Specifies the global trade item number (GTIN-14) is an internationally recognized identifier for a product. | Supplier |
| Walmart Item Number | The Walmart Item Number for the item. This is a Walmart created identifier that is provided to the Supplier post Item Setup; this is used to manage data such as Cost | Walmart |
| Product Name | Specifies the name of the item. | Supplier |
| Published Status | Defines if the item is published on Walmart.com and available for customers to view the item | Walmart |
| Active Item Configurations | Defines if one or more of the item configuration setup by the Supplier is being actively sold to Walmart. This is managed with the “Supply Item Status Code” Attribute. | Supplier |
| Ship Node ID | Specifies an identifier for the fulfillment center or ship node. | Walmart |
| Ship Node Name | Specifies the name of the fulfillment center or ship node. This is a custom name the supplier can create to identify the ship node; for example, “TwoDay_WestCoast” or “CA_Standard”. | Supplier |
| Ship Node Address | This is the Address of the Ship Node | Supplier |
| Input Quantity | Specifies the quantity of an item that is input by the supplier. This amount represents the total item inventory, including items that are sold, but not yet shipped. | Supplier |
| AvailToSell Quantity | Specifies the 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 |
| Ship Node Unit Cost | The cost for the item sold via this ship node. | Supplier |
To update item inventory, use the 1P Supplier DSV Inventory API calls.
Updated 3 days ago