How to upload Inventory Data

Overview

Inventory data can be uploaded to give buyers an accurate count of current and future availability. Inventory data should represent the current available-to-sell (ATS). The inventory quantities will be deducted in NuORDER as orders are placed by your users. The Inventory Data will be uploaded to NuOrder's system by importing a file with the appropriate information for your products. This article will outline the different sections of the Inventory Data page, the elements that are required on the Inventory Data file, and the correct process of uploading Inventory Data file to a portal. 

 

Navigate to the Inventory Data page using the click-path Settings > Brand Admin > Data > Inventory Data. 

 

Inventory Data Page

Before going through the steps of uploading your Inventory Data, we should get familiar with the page first. Once the Inventory Data page is displayed, the page will be divided into four sections.

                                        

1. Upload Area - This is the spot on the page where you will drag-and-drop the Inventory Data file, once it is updated. Next to the upload area, the section also includes helpful hits to remember when you are uploading the Inventory Data file like clearing ALL formatting from the file before uploading or omitting any products from the file will result in that product not being updated. Underneath the Upload Area is a list of the accepted file types for Inventory Data files.
2. Download Inventory Section - This section is where you will download your current Inventory Data file from your portal. There are filters that can be applied to your export, which can be helpful if you are looking for inventory information for a specific Season or Color of a style. If your brand utilizes multiple warehouses, there will be a section for you to filter your Inventory Data file export by specific warehouses. This section also allows the user to select the file type and page orientation of the file that will be exported.
3. ATS Inventory - This section allows the you to download the an active ATS report of your products, including their images.
4. Delete All Inventory - You guessed it, yes, this button will delete ALL of the Inventory Data that is associated with the products on your portal. 

 

Inventory Data File

To download a copy of your Inventory Data File go to the download inventory section of the page, apply any filters you wish, and click 'Download'. This will trigger a download of the Inventory Data file from your portal. Once you open the file you will be presented with an Excel document containing a header row (row A) and then the remaining rows will be your product's inventory information. Below is an example of what an Inventory Data file looks like.

                                              

 

Unique Identifiers on Inventory Data File

Size, Quantity, Warehouse Columns

The next columns on the Inventory Data file are Size - the size value of the item, Quantity - the number of units available for the item, and Warehouse - the location where the inventory is located. If your brand only utilizes one warehouse, then the value in the Warehouse column will be 'default' for all of your products.

Date Column

• For products that have a FUTURE availability date, the value of this future date will go in the 'Date' column. 

• For products that have an IMMEDIATE availability date, either the values “immediate” or at once” should be types into the 'Date' column. This will create inventory available to be sold for an immediate delivery. 

                     

• For products that have PREBOOK quantities available, the value 'prebook' should be typed into the 'Date' column. This will allow unlimited future bookings of the product.

                    

Notes: One product may be listed multiple times on an Inventory Data File with future date, typed 'immediate'/'at once' and 'prebook' values.

With a full understanding of what information should be included on the Inventory Data file, you can fill in the Inventory File and get ready to upload to NuORDER!

Uploading Inventory Data 

Once you have the Inventory Data file filled out (and saved), you can then upload the file to NuORDER. You will drag-and-drop the Inventory Data File to the Upload Area of the page.

                                                                   

 

After the drag-and-drop, a prompt will appear letting you the Inventory upload has been queued and that an email will be sent with the results

 

                                                      

 

An email will then be sent and generated to your email address associated with NuORDER with the results of the Inventory Data upload. The email will have a result of success or error.

 

Result emails will have a CSV for you to download, that will provide a CSV version of the results. If any errors were found on Inventory Data file during the upload process, that information will be on the CSV. 

If you have any additional questions about Inventory or the uploading process, please reach out to heroes@nuorder.com and our Support team will further assist you!