Purpose
This procedure is used to upload Inventory details from a file created outside of the system for existing products. This is an alternative way of entering these details and is useful where you are entering large volumes of new data. Using this method a “spread-sheet” style tool can be used to create a list of products you want with sizes and colours details as needed, plus the inventory location information required.
Note: This function only uploads inventory details for existing products. For additional details on creating upload files see the note HERE.
Data Input
Step 1 – File Upload
Upload File
Select the spread sheet file you wish to upload, by clicking Browse. This assumes you have access to the file with the new data from the browser you are currently using.
Return to the Top
Step 2 – Review details
The price details of the file selected will be displayed so that you can review the data and confirm that the correct file has been uploaded before you continue.
Click Submit to submit all the details.
Return to the Top
Spread sheet format
The spread sheet must be in a csv format.
The first row of the spread sheet must be a heading row – it does not matter what the headings are, as long as they are meaningful to you e.g. you could have ‘Product’, ‘Product Code’ or ‘SKU’.
Columns for all 6 location ‘sets’ must be present – even if you are not using 6 locations. They can be left blank, but they must be present in the file as the upload tool expects a set number of columns in each file.
The columns required are too numerous to document here. Download the spread sheet template from here.
Updating
Once you click submit, the rows on the spread sheet are validated. If no invalid data is detected, the Inventory Master files are updated with the new details.