How do I import or export my products as a spreadsheet?

In Products, Export CSV writes the product list to a file you can open in Excel. Import CSV/Excel reads a CSV or Excel file: products whose SKU already exists are updated, the others are created.

Export

  1. Open Products and press Export CSV.
  2. Choose where to save the file. Open it in Excel or any spreadsheet program.

Import

  1. Prepare a file with one product per line and the column names in the first line. The easiest way is to export first and keep the same columns.
  2. In Products, press Import CSV/Excel and choose the file (.csv, .txt or .xlsx).
  3. The till shows how many products were created and updated, and lists the lines it could not read.

Columns the till recognises (other names for the same thing are accepted too):

Column Meaning
sku your product code; decides whether a line updates or creates
name, name_ar, name_fr the names
barcode one or several barcodes
price, cost selling price and cost
department, category, brand created when they do not exist yet
tax the name of the tax rate
unit, weighed, plu for goods sold by weight
stock opening stock for a new product
reorder_point, active reorder level; active yes / no

For: Manager Owner since version 1.0.0

Did this help?

Print this article · Contact support