Download: Inventory data template (with replenishment delivery windows)

Use replenishment delivery windows to provide multiple deliveries or Prebook windows for a product. Before using this template, review the information provided below and in Delivery windows overview. 

Note: Replenishment delivery windows can also be managed via an FTP or API integration.

Things to keep in mind

Note the below requirements and tips before updating and uploading your inventory data:

• If you’d rather download your inventory data from NuORDER instead of using the blank template, both Vertical and Horizontal formats are available, but only the Vertical format can be used when uploading inventory.
• Use one or a mix of the following column combination options as the product identifier:
  • Option 1: STYLE NUMBER, SEASON, COLOR, and SIZE
  • Option 2: BRAND ID and SIZE
  • Option 3: UPC
• Populate the PERIOD START, PERIOD END, and PREBOOK columns to identify the delivery window.
  • PERIOD START: Enter the earliest ship date. For immediate availability, enter today’s date or leave it blank.
  • PERIOD END: Enter the cutoff date for the product’s availability. If you don’t want an end date, leave it blank.
  • PREBOOK: Enter Y for prebook or N if not.
• Mange Prebook in one place only. If using an inventory data file to denote Prebook, then remove all other Prebook rules (from Brand Admin > Settings > Inventory Settings).
• As a best practice, use UPC for Inventory with replenishment delivery windows.
• Remove the first 2 instruction rows before uploading this template.

Note: The below example spreadsheet includes a mix of product identifiers.

back to top

Old process

The above Things to keep in mind section outlines the new process for managing inventory with replenishment delivery windows. Below is the old process, which uses the AVAILABLE FROM column (old) instead of the PERIOD START, PERIOD END, and PREBOOK columns (new). While you can continue using the old process for now, it will be removed in a future release.

The AVAILABLE FROM date can be either today, yesterday, tomorrow, or a future date.

• Today or Yesterday: Inventory displays as Immediate availability.
• Tomorrow: Inventory sent today displays as Future.
• Future: Inventory displays with the specific future dates.

Note: If you don't have an Available Until date, then any future dates will accumulate and present that quantity.