Skip to content

Import products from a spreadsheet

Match columns, review errors and check the result before importing a larger catalogue.

Prepare your file

Use CSV, XLSX or XLS, up to 5 MB and 1,000 products per file. Start with a small sample. Keep product codes as text so leading zeros are not lost. Remove unrelated worksheets and avoid formulas for values you need to import.

AI-assisted file cleanup is planned, not available in this release. The current import uses column mapping and validation.

Download a small CSV example. It uses fictional products with text codes 000101 and 000102. The sample's quantities are opening quantities, not an instruction to overwrite current stock. Make sure its categories/base units exist, or deliberately select Create missing categories, brands, suppliers and base units during review.

For a catalogue-only first step, download the simpler starter CSV. It contains names, codes, costs and prices, but no opening quantities. Choose an existing default category in the preview, or allow creation of the default General category. Record opening stock separately after checking the products.

Preview and import

  1. Open Products > Import Products. Use Download template if you need a starting file.
  2. Choose your Product file and select Continue.
  3. Under Match your columns, choose the worksheet, header row and number format. Match your product fields to the correct columns.
  4. For Existing product codes, choose Update mapped fields, Skip existing products, or Stop for review.
  5. Review the opening-stock store choice. Do not map opening stock when you only intend to update existing names or prices.
  6. Generate the preview, correct the reported errors, then start the import when the preview matches your intent.
  7. Wait for Import complete, then select View products and check several records.

Inventix import column mapping for the public two-product CSV sample

Inventix reviewed import showing two new products, their product codes and selling prices

Expected result

The completion summary shows what was imported. An invalid batch should not leave some products saved and others missing. Existing-product stock is not reset by treating an imported opening quantity as a new current balance.

For a fresh store using the example file, check that the two products retain their leading-zero codes, prices of 16 and 12, and starting quantities of 12 and 8 before any sale. An update that maps only selling price should leave unmapped details and current stock unchanged.

Inventix completed import with two products created and no updated or skipped products

If the import stops

An expired preview needs a new upload and review. If a job is queued, wait for its result rather than submitting the same file repeatedly. Keep the import reference when contacting support. Use Not imported for fields you do not want changed.

Legacy customer, supplier and stock-count imports use their own templates; they do not share this product mapping experience. Add a product manually when you need to check the field meaning first.

Use the Excel switching guide to prepare a catalogue before moving it. The 1,000-product rule applies per file, not as a subscription limit on the number of products in your business.

Still stuck? Tell us what happened. Never include your password or recovery codes.