Export and Update DSV Inventory Attributes in Bulk

Updated 9 months ago ​by Merch Transformation Change Management

Maintenance is not yet supported in Item 360 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 (select facilities from the drop-down menu)

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 Maintenance. Then, click the DSV Inventory tile.
  2. Copy and paste up to 5,000 GTINs for the items that you are updating. Then, click the Next 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.
  3. You can either: Select all facilities or Select custom facilities.
    To select custom facilities, open the drop-down menu and select the DSV 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.
  4. Click the Download button.

Complete and Submit Your Spreadsheet

  1. Open the spreadsheet and fill in the new values for the attributes. Refer to Row 6 under the attribute names for definitions and data requirements.
    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 Item 360:
    • Click Upload in the left navigation menu.
    • Select Spreadsheet.
    • Click the Next button.
    • Select the file from your computer.
    • Provide a maintenance description.
    • Click Submit.

Track Your Changes

DSV Inventory maintenance will not appear in the Activity Manager yet. In the meantime, go to the DSV Facility Overview in the Item 360 Catalog to view successful changes.

Need to File a Case Ticket?

Please contact Partner Support. For detailed instructions, refer to this article.

Want to Update Lag Time for DSV Items?

Refer to this article.


Was this article helpful?