Products & Variants
Import products from a spreadsheet
Bring in what you make and sell from a CSV or Excel file, with product types, SKUs and selling prices. A product with variants comes in too, one row per…
Bring in what you make and sell from a CSV or Excel file, with product types, SKUs and selling prices. A product with variants comes in too, one row per variant. Product types you don't have yet are added.
Import your products
- Go to Products and click Import.
- Download the Excel template or the CSV template, or start from your own spreadsheet. The first row holds the column names.
- Choose your file and click Continue. A file can be CSV or Excel (.xlsx), up to 5 MB and 2,000 rows.
- Check each Kerno field against the column in your file, then click Preview import.
- Fix any row marked with a problem with Edit, and choose what happens When a product already exists: Skip it or Update it.
- Click Import followed by the number of rows.
The results list each row and what happened to it, such as a product created or a variant added. Click View products to see them, or Import another file.
What goes in the file
- Name and Product type are required. Everything else is optional and can be added later.
- Leave SKU empty and Kerno makes one. On a row with options, the SKU is the variant's.
- Selling price is read in your workspace currency. A price written in another currency is refused. On a row with options, it's the variant's price.
- Unit is how the product is counted, such as jar, bar or box. It can't change once the product has stock, a BOM, production or orders.
- For a product with variants, give each variant its own row with Option 1 name and Option 1 value, such as Size and 8 oz. You can use up to three options. Rows with options and the same name, or the same Product handle, become one product.
- Other columns include Description, Status, Sales channels, Low-stock threshold, Reorder point, Reorder quantity, Track lots, Track expiration dates, Shelf life days, Lot allocation and Allow negative stock.
Good to know
- Nothing is saved until you click import on the preview.
- Kerno matches a row to a product you already have by SKU first, then by name.
- A product type in your file that doesn't exist yet shows as a warning in the preview, and Kerno creates it when you import.
Related articles
Still need a hand?
Our support team is here when you need a person.