The standard Backstore format for importing the initial state of a product is primarily used for the initial import from the system used by the client into the Backstore.
Excel document structure for importing opening stocks
The Excel document should have a .xls extension and be compatible with Excel 97-2003, or if you are using Microsoft Excel 2007 or Open Office, you should save the file in Excel 97-2003.
An Excel document should have at least one sheet that identifies an individual warehouse and has columns with the following names (text) in the first row:
- Product ID (SKU)
- Quantity
- Average purchase price
All information is mandatory.
When sending the completed table, it is obligatory to state the date on which we import the opening stocks.