Skip to content

Import products from a CSV or Excel file

The template, columns, variants, limits and file errors.


You can add your whole catalogue from a CSV or Excel file, wherever it comes from. A file is the only import that carries stock counts. You find it in Products, then "Import", below "or".

Upload the file

  1. Open Products and press "Import".
  2. Press "Download the template" for a file with the column names and one example row.
  3. Fill in your products and save the file.
  4. Drop the file on the box, or click it and choose the file. On a phone, press "Choose file".
  5. We check the file straight away. If it is clean, the import page opens and you can leave it.

We accept CSV (comma or semicolon separated) and Excel .xlsx only, up to 10 MB and 2,000 products per file. A product with several variants counts once, however many rows it takes. Only one import runs at a time.

The columns

This is the template's first row:

handle,title_ar,title_en,description_ar,description_en,price,compare_at_price,currency,sku,stock,brand,tags,sections,option1_name,option1_value,option2_name,option2_value,option3_name,option3_value,images,variant_image,requires_shipping
  • There is no mapping screen. We recognise each column by its English or Arabic name (for example اسم المنتج, السعر, الكمية, الأقسام) and ignore columns we do not know.
  • Only a product name is required, in Arabic or English. A product with no price arrives as "Draft".
  • price is in riyals, for example 49.00. currency is blank or SAR.
  • stock is a whole number. A product with a stock number starts with stock tracking on; one without starts untracked.
  • tags and sections are separated by semicolons. A collection named in sections that does not exist is created by that name.
  • images holds public photo links, separated by spaces or semicolons. We download the photos and keep them on Uqail.
  • requires_shipping takes yes or no (or نعم or لا).

Variants

A product with variants takes one row per variant, all with the same handle. The first row carries the product's own details: names, description, brand, tags and sections. Each row carries its option values in option1_name and option1_value, up to three options. Every row must use the option names of the product's first row, and a variant row with no price takes the product's price.

Uploading the file again

We know a product by its handle. Upload a corrected file with the same handles and we update the same products instead of adding copies. A blank handle is made from the product name. Stock is written on a product's first import only and never changed by a later one.

If it does not work

If any row has a problem, nothing is imported. We list the first three by their spreadsheet row number, for example "Row 4: Price isn't a number", and end with "Fix them in your file and upload it again." The row problems are "No title", "Price isn't a number", "Compare-at price isn't above the price", "Photo link isn't valid", "Its options don't match the product's first row", "Currency isn't Saudi riyal", "Stock must be a whole number" and "Same handle as another product".

  • "The file is over 10 MB. Split it into two."
  • "We read CSV or Excel files only.": also shown when a file's extension does not match what is inside it.
  • "We couldn't find the column names. Download the template and copy your products into it.": we need at least two columns we know within the first five rows.
  • "The file has no products in it."
  • "The file has more than 2000 products. Split it into smaller files."
  • "We couldn't read the file's characters. Save it from Excel as .xlsx and upload that."

More in Migrating to Uqail