Aantar POS
Run the import, check it, and fix problems
Choose the file, match its columns, read the check page, import, and bring in the rows that failed after fixing them.
Where: More ▸ Till settings ▸ Admin ▸ Import Products
The import never writes anything until you have seen the check page. Read it carefully: it says how many items are new, how many will be updated, and every row with a problem.
Before you start
- The file is ready (Prepare the CSV or Excel file).
- Sign in as the owner or a manager.
1. Choose the file
- Press More, then Till settings, then Admin, then Import Products.
- Under Choose your product file, pick the file (.xlsx, .csv, .txt or .tsv).
- For a workbook with several sheets, check What is on each sheet? and correct any guess.
2. Match the columns
- The page says Headers on row and the row it found the headers on.
- For each Column in your file, check Import as. The First values column shows what is in it. Choose Don't import for a column you do not want.
- The product name column is required; without it the page says Choose the column with the product name.
- To use the same matching again, press Save this mapping and name it, for example
Old till export. Next time, choose it under Use a saved mapping.
On the screen: the Check step: the counts of new products, to update, already there (skip) and with problems, the options, and What will be imported with each row's status.
3. Check
- Read the counts at the top.
- Set the options:
- Create missing categories, taxes and groups: departments, units, brands and taxes (with a rate, like "GST 5%") the company does not have are added. Tick it for a first import.
- Update products I already have or Leave products I already have alone. An item is the same when its SKU or barcode matches, or else its name.
- The prices in my file include tax: tick it only if they do.
- Set stock on hand from the file: the stock column is counted in as one stock count at the first store, after the items are added.
- Read every row marked Problem, and the notes on rows. Fix the file and start again if many rows have problems.
- Press Import with the number of items, for example Import 1,240 items.
4. Import and fix what failed
The page shows Importing… and then Import finished, or Import finished, with some rows left out, with the counts of products added, updated, skipped and not imported.
If rows did not import:
- Press Save them as CSV. The file has each failed row with the reason.
- Fix the rows in that file.
- Press Import another file and import the fixed file.
Press Done when all is in.
After the import
- Check every item's tax, department by department (How each item gets the right tax).
- Set the till fields of weighed items, multi-packs, deposits and age rules where the preset did not (Add, change or deactivate an item).
- Scan a few items at a till to check the code, price and tax.
Important: The stock count made from the file is dated when you import. Import the stock figures on the day the store counts them.
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.