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

  1. 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.
  2. 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.
  3. Check: the number of products to create, to update, and the rows with errors.
  4. Import: the products are created; images are downloaded afterwards, in the background.

Good to know