Importing products from a CSV

If you already have your products in a spreadsheet or in another shop, you can bring them into Comrc in one go instead of typing each one. Import is for adding new products. It never changes products you already have.

Import your file

1. 1In the console, open Products and press Import. On a new store with no products yet, the same page is behind Import a CSV.
2. 2Press Choose CSV file and pick your file. It must be a .csv file with a header row, no bigger than 4 MB.
3. 3The import runs straight away. You see how many products were imported and how many rows failed.
4. 4Press View products to check them.

Coming from Shopify, Wix or Squarespace

A product export from Shopify, Wix or Squarespace imports as it is. Comrc recognises the file from its column headings and gathers each product's rows into one product with its variants. Two things to know: photos are not copied across, so add them on each product afterwards, and if the other shop didn't count stock, those products start with a stock of 0, so set your stock before you sell.

Using your own spreadsheet

The easiest template is your own catalogue. On the Import page, follow the link to download the product export, or press Export on the Products page. It gives you the right columns with your products already in them, so you can copy a row and change it. The columns are:

• slug, name, description, status, category, is_featured, vat_class, tags, meta_title, meta_description.
• sku, barcode, options, price, compare_at_price, cost, stock_qty.
• weight_grams, length_mm, width_mm, height_mm.

Only name, sku and price are required. Everything else is optional.

• Prices are in pounds, for example 50 or 49.99. compare_at_price is the "was" price and must be higher than price. cost is only ever shown to you.
• stock_qty is a whole number. Leave it empty for 0.
• category is a category name. Use "Parent > Child" for a subcategory. A category that doesn't exist yet is created for you.
• vat_class is standard, reduced or zero. Leave it empty for standard. See VAT settings.
• tags is a comma-separated list. meta_title and meta_description set how the product appears in search results.
• weight_grams, length_mm, width_mm and height_mm are whole numbers, used for shipping.
• barcode is optional, for a GTIN such as an EAN or UPC. Each barcode can only be used once.
• status is draft, active or archived. If you leave it empty, the product is imported as a draft.
• is_featured is yes or no (1 or 0 also work).

Products with variants

Give every variant of a product the same slug, one row each, with its own sku and price. In the options column, name that row's options separated by semicolons, such as "Size=M; Colour=Red". You can use up to 5 options. Product-level columns such as name, description and category are read from the first row. A row with no slug is a product of its own. See Variants and options.

Check before you open

Imported products are drafts unless your file says otherwise, and shoppers can't see drafts. Open Products, check a few, then set the ones you want to sell to Active. You can select several and choose Set active from Bulk action.

When some rows fail

A row with a problem is skipped and the rest still import, so one typo doesn't lose the whole file. Failed rows are listed with their row number, SKU and the problem, for example that a SKU already exists. Fix those rows in your spreadsheet and import them again. Import just the failed rows, not the whole file: the products that did import already exist, so their SKUs would be refused a second time.

• A SKU or barcode that already exists in your store is refused. Import never updates an existing product, so to change one, edit it in the console.
• Two rows in the same file with the same SKU or barcode: the second is refused.
• A missing name, SKU or price, or a price that isn't a number, is refused.
• An empty file, or a file with a header row but no products, is refused with a message.