====== 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.