Search Sign in
All help topics

Help topics

On this page

How to Import Products with Smart Import

Written by the SellarPro team · Published 12 October 2026 · 2 min read

Short answer

Open Smart Import and click New Import. Upload your Excel or CSV file in any layout, check how its columns were matched to SellarPro fields, then on the review screen choose the location, how stock is loaded and what happens to products you already have. Import, and check the results.

Smart Import reads a product list from any system, in any layout, and shows you what it will do before anything is saved.

Switch on Smart Import under Settings → Menu & Modules if it is not in your menu.

Step 1: upload

  1. Open Smart Import and click New Import.
  2. Click Choose File, or drag the file in: .xlsx, .xls or .csv, up to 20 MB and 20,000 rows.
  3. Click Upload & Analyze.

Step 2: check the columns

Under Match your columns to SellarPro fields, each column of your file is shown with sample values and the SellarPro field it was matched to, with a confidence score. Change any that are wrong, and set a column you do not want to Ignore this column. Tick Save this mapping for future imports if you will import files like this again. Click Continue.

Match your columns to SellarPro fields: Item Name to Product Name, Barcode, Category, Unit, Cost Price to Purchase Price, Selling Price and Qty to Opening Stock, each at 100% confidence
Each of your columns, its sample values and the field it fills.

Step 3: review

  1. Read the counts: rows ready, rows that need review and errors, and any Problems detected.
  2. Choose the Location for opening stock.
  3. Choose Stock at the location: add the file's quantities to what is there, or set stock to the file when the file is a fresh count.
  4. Choose what happens When a product already exists in SellarPro: keep it as it is (recommended), update it, or create a separate product anyway.
  5. Tick Generate SKUs automatically if your file has no codes. Click Looks good — continue.

Step 4: import

Click Import. The results show how many products were Created, Updated, Skipped or Failed, the units in the file against the units loaded, and the stock value loaded, so you can check it against your sheet.

Import Complete: 3 created, 0 updated, 0 skipped, 0 failed, with the units and stock value loaded and a Reverse Import button
Units in the file against units loaded: they should match.

Common questions

My file has a title row above the headings.
Smart Import finds the heading row itself and tells you which row it used.
Can I fix the problem rows in Excel?
Yes. Download cleaned sheet gives you an Excel workbook: one sheet ready to import, and one listing every row that needs a human first.

Related articles

How to Update Prices or Reverse a Smart Import

Upload the same file again and Smart Import recognises it. Choose Update prices only to take the file's new prices without loading the stock twice. To undo an import, open it in Import History and click Reverse Import; products sold or changed since are kept.

Products & Inventory · Updated 12 Oct 2026 · 1 min read

How to Import Each Branch's Opening Stock with Smart Import

Import one spreadsheet per branch with Smart Import. Choose the branch as the Location for opening stock, and choose whether to add the file's quantities to what the branch holds or set the branch's stock to the file. Products that already exist from another branch receive this branch's quantity and price.

Branches · Updated 12 Oct 2026 · 3 min read

Still need help?

Can’t find the answer you’re looking for? Our support team in Accra can help.

Chat on WhatsApp Email support