Import products from Excel or CSV

Bring your whole item file in: download the template, map columns, import in batches and fix row errors.

  1. 1

    Create units and categories first

    The importer matches unit and category names, so create Box 100, Coil 50 m and your categories before importing.

  2. 2

    Download the template

    Products → Import products → download the sample file.

  3. 3

    Paste your data

    Fill SKU, name, unit, category, prices, tax, barcode type, rack/row/position and stock settings.

  4. 4

    Import a small batch

    Try 50 rows first, fix any errors the importer reports by row number.

  5. 5

    Import the rest

    Then import in batches of a few thousand rows.

  6. 6

    Add opening stock

    Import opening stock per location separately.

Columns hardware stores get wrong

ColumnWatch out for
SKU / barcodeFormat as Text so Excel keeps leading zeros
UnitMust match a unit you already created
Selling priceInclusive or exclusive of tax, matching your setting
Rack / row / positionOnly if racks are switched on

See the in-depth guide: how to import 30,000 SKUs into a new POS.

Common questions

Is there a row limit?
No SKU limit; batches of a few thousand rows make errors easier to fix.
Can I update prices by re-importing?
Yes, existing products are matched by SKU.