Products › Import (CSV, Excel) brings in your products from your till, your old website or a spreadsheet.
The 4 steps
File: drop a CSV, Excel (.xlsx) or OpenDocument (.ods) file. The first row must hold the column names. Only the first sheet is read (5,000 rows and 10 MB at most). A CSV template can be downloaded from the page.
Columns: ShopKollect recognises the columns (name, price, VAT, reference, category, stock, image…). Check the matching and correct it if needed. Choose what to do with a product already in the shop (same reference, otherwise same name): update it or leave it as it is.
Check: the number of products to create, to update, and the rows with errors.
Import: the products are created; images are downloaded afterwards, in the background.
Good to know
For a category inside a sub-category, write the path with >: Drinks > Sodas.
If you give a price excl. tax, the price incl. tax is calculated with the row's VAT (or the default rate).
Save the matching as a profile: next time, the columns will be recognised in one go.
Formulas are never calculated: a cell “=…” stays as text.