Find the format and accepted inputs for all columns in the Inventory Data upload file
The columns included in the Inventory File are:
- SKU
- Atelier Code
- Inventory Location ID
- Units
- Unit Cost
Note: You can download the Sales and Inventory File Templates here.
SKU
The SKU is your internal item SKU that you have imported to Loupe. This ID helps us connect the data you are importing to Loupe with the data that is already in Loupe.
The data in this column is:
- Optional - you can leave the cell blank
- 1 to 37 characters long
- Allowed to contain numbers, letters and special characters (e.g. -,/.*#)
Example:
ABC-123
Atelier Code
The Atelier Code is a code that Loupe gives to every unique product in your assortment. Two different products in Loupe cannot share the same Atelier Code. You can find the Atelier Code of each product either on the Linesheet inside of Loupe or in any of the Linesheet exports.
The data in this column is:
- Required - you cannot leave the cell blank
- 1 to 15 characters long
- Numbers, letters only - Atelier Codes never contain special characters
Example:
AZ12345
Inventory Location ID
When you have multiple locations, there is sometimes an identifier used to determine which store the sale came from. These IDs can be words or numbers but are always unique per store.
The data in this column is:
- Optional - you can leave the cell blank
- 1 to 50 characters long
- Allowed to contain numbers, letters and special characters (e.g. -,/.*#)
Example:
1001
Units
This is the number of units you have in-stock for this SKU.
The data in this column is:
- Required - you cannot leave the cell blank
- An Integer - the value must be a whole number, no decimal places
- Positive - the value must be positive
Example:
50
Unit Cost
This is the average cost of units you have in-stock for this SKU.
The data in this column is:
- Required - you cannot leave the cell blank
- A currency value - do not add the currency symbol when loading the data. Loupe will add that for you in the UI (e.g. you load 238.87 and we will show $238.87 in Loupe)
- Up to 6 decimal places
Example:
99.99