Export and Update DSV Inventory Attributes in Bulk

Updated 1 month ago ​by Merch Transformation Change Management

Maintenance is not yet supported in Supplier One for: Assortments, Import Shippers (General Merchandise), Pharmacy, and Fees. Please continue using your current processes (e.g., legacy workflows or systems).

You can export a spreadsheet in the Maintenance Hub to update DSV Inventory.

Which Facilities and Attributes Can You Download in this Export?

Facilities

  • All facilities
  • Custom facilities

Attributes

  • Availability Code
    • AA = Infinite Inventory
    • AC = Standard Inventory
  • Quantity (On Hand Inventory)
    • This is the number of available units a DSV supplier has on hand to sell, including the number of units in the process of shipping.

Create and Export Your Spreadsheet

  1. In the left navigation menu, click Items and Inventory and select Maintenance Hub.
  2. On the DSV Inventory tile, click Update inventory.
  3. Copy and paste up to 5,000 GTINs for the items that you are updating. Then, click the Continue button.
    The primary identifier for DSV maintenance is changing from SKU to GTIN. You can find your item's GTIN in the Products view of the catalog.
  4. Open the drop-down menu and select all facilities or search for and select custom facilities.
    You may manage up to 10,000 total rows in a single spreadsheet. If you have selected facilities that will exceed 10,000 rows, try selecting fewer facilities.
  5. Click the Export button.

Complete and Submit Your Spreadsheet

  1. Open the spreadsheet and provide the inventory attribute(s). Refer to Row 6 under the attribute names for definitions and data requirements.
    1. If you select AA (Infinite Inventory) for the Availability Code, you should not provide the Quantity (On Hand Inventory).
    2. If you select AC (Standard Inventory) for the Availability Code, you must provide the Quantity (On Hand Inventory).
      By default, your spreadsheet will be named with the date and time it is created. Remember to save your spreadsheet in Excel Workbook, or .xlsx, format when you're done.
  2. To submit your file in Supplier One:
    • Click the Upload button in the top navigation menu.
    • Drag and drop your file into the upload window, or click Choose file to select the files.
      • Upfront validations will check for common errors. If any are found, click the Download error file button to fix the errors before trying your upload again.
      • If no common errors are found, click the Continue button.
    • Provide a maintenance description.
    • Click Submit.

Track Your Changes

Read Track Your Submissions.

Seeing Different DSV Inventory Counts After Successful Updates?

  • Once your DSV inventory submission is successfully completed, the inventory unit count shown in the DSV Facility Overview is updated in near real-time.
  • The Full Item Report is updated and synced once daily with all active DSV facilities mapped to the item. If the DSV inventory count does not match your successful submission, check again the following day.

Have Questions or Need Help?

If you experience any issues viewing and managing your catalog, please click "Help" in the top navigation menu and select "Manage tickets" to file a case ticket. Or, select "Chat" to get real-time help from our chat bot or click "Search articles" to search Supplier One HelpDocs. 

Make sure to select the issue type Items and Inventory.

For detailed instructions, refer to Manage Case Tickets.


How did we do?