Skip to content
KernoHelp Center
    Open Kerno
    Help CenterProducts & VariantsImport products from a spreadsheet

    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…

    2 min readUpdated November 10, 2026

    On this page (4)
    • Import your products
    • What goes in the file
    • Good to know
    • Related articles

    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

    1. Go to Products and click Import.
    2. Download the Excel template or the CSV template, or start from your own spreadsheet. The first row holds the column names.
    3. Choose your file and click Continue. A file can be CSV or Excel (.xlsx), up to 5 MB and 2,000 rows.
    4. Check each Kerno field against the column in your file, then click Preview import.
    5. Fix any row marked with a problem with Edit, and choose what happens When a product already exists: Skip it or Update it.
    6. 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

    • Create a product
    • Add variants (scent, size, vessel)
    • Product types and selling prices
    More in Products & Variants

    Still need a hand?

    Our support team is here when you need a person.

    Contact support

    In this guide

    • Import your products
    • What goes in the file
    • Good to know
    • Related articles

    Related guides

    • Add variants (scent, size, vessel)
    • Create a product
    • Product types and selling prices
    © 2026 Kerno, Inc. All rights reserved
    Privacy Policy (opens in a new tab)Terms of Service (opens in a new tab)Cookies (opens in a new tab)