en:catalogue:importer
Import a CSV or Excel file
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.
en/catalogue/importer.txt · Last modified: by 127.0.0.1
