Aantar

Aantar POS

Import your item list

Bring the store's whole item list in from a spreadsheet or another till's export, in four steps, with a check before anything is written.

Where: More ▸ Till settings ▸ Admin ▸ Import Products

A store with hundreds or thousands of items does not type them in one by one. Import Products reads a spreadsheet (Excel .xlsx, CSV or tab-separated text) or the item export of another till, matches its columns to the till's fields, checks every row, and only then adds or updates the items.

The four steps

  1. Choose file: pick the file, or save a blank sheet to fill in.
  2. Match columns: say which column of the file holds the name, code, price and so on. Most are matched for you.
  3. Check: see what will be added, updated or left alone, and every problem, before anything is written.
  4. Import: the items are written, with a list of the rows that did not import and why.

See Prepare the CSV or Excel file and Run the import, check it, and fix problems.

What an import can do

  • Add new items with their code, barcode, department, sub-department, brand, unit, tax, price, cost and description.
  • Update items the store already has, matched by SKU or barcode, or else by name (see Update prices and costs from a file).
  • Make the departments, units, brands and taxes the file names that the company does not have yet.
  • Set stock on hand from the file, as one stock count at the first store.
  • Bring in items with sizes or colours (variations) and modifier groups.

What it does not do

  • It does not bring in customers, sales history or supplier links.
  • It does not set the till fields (scale code, pack size, deposits, age rules); set them after the import (Add, change or deactivate an item).

Before you start

  • Sign in as the owner or a manager (the import permission of Users & Roles).
  • Have the accountant's tax list at hand: check every item's tax after the import (How each item gets the right tax).
  • Make a backup first if the store already has items (The Backups page).

Tip: Try the file with a few rows first. When those come in right, import the whole list.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.