Inventory Data File Upload Columns

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