Import your stock from Excel
In short: Upload an .xlsx file, match its columns to StoreBook, review the preview and import.
- 1
Open Import from Excel
On the Home screen, choose Add inventory, then Import from Excel.
- 2
Choose what you are importing
Products only creates or updates your product list and does not move stock. It is best for first setup. Physical stock records what you have on the shelf today as opening stock, and the IMEI check still applies to phones.
- 3
Upload your file
Drop your .xlsx file, or browse for it. A file can have up to 5,000 rows.
- 4
Match your columns
StoreBook guesses which column is which. Check the matches, and fix any that say Not mapped.
- 5
Review and import
Look at the first rows, then validate. If StoreBook finds problems, such as a repeated IMEI, it tells you before anything is saved.
Tip
Start with a small file of about 10 rows to see how it works, then import the rest.