Aantar POS
Prepare the CSV or Excel file: the columns
The columns the item import understands, the header names it recognises, and how to lay out the file.
Where: More ▸ Till settings ▸ Admin ▸ Import Products
The import reads one item a row, with a header row on top naming the columns. It recognises the usual names other systems use, so an export from another till often needs no editing. This article lists the columns and how to fill them.
Get a blank sheet
- Press More, then Till settings, then Admin, then Import Products.
- On Choose file, press No file yet? Save a blank sheet to fill in. A CSV file with the headers and two example rows is saved.
- Open it in Excel, fill in your items, and save it as .xlsx or .csv.
Note: The Download Excel tile of Admin opens a template on the Aantar website. If that file is an old Excel 97-2003 workbook (.xls), the import refuses it with This is an old Excel 97-2003 workbook (.xls). Open it in Excel and save it as .xlsx or CSV, or use the blank sheet above.
The columns
| Column | What to put in it | Header names it recognises (examples) |
|---|---|---|
| Name (required) | The item's name as it should print | name, product name, item name, title, item description |
| SKU | The store's own code | sku, item code, product code, code, item number |
| Barcode | The UPC, EAN or PLU the till scans | barcode, upc, ean, gtin, plu, scan code |
| Category | The department | category, department, dept, group |
| Sub-category | A department under the category | sub category, sub department |
| Brand | The brand | brand, vendor, supplier, manufacturer |
| Price | The selling price | price, retail price, selling price, unit price |
| Cost | What the store pays | cost, unit cost, purchase price, vendor cost |
| Tax | The tax name or percentage, for example GST 5% |
tax, tax rate, tax code, gst, hst |
| Unit | The unit, for example Each or kg |
unit, uom, unit of measure |
| Stock | Stock on hand | stock, qty, quantity, on hand |
| Low-stock alert | The alert quantity | reorder point, min stock, low stock |
| Track stock | yes or no | track stock, track inventory, manage stock |
| Description | A longer description | description, notes |
The blank sheet's columns are: Name, SKU, Barcode, Category, Price, Cost, Tax, Unit, Stock, Option1 Name, Option1 Value, Modifier Groups.
Note: A column named "vendor" or "supplier" is read as the brand, not as a supplier link.
How to fill them
- One item a row. Leave no blank rows inside the list.
- Every item needs a name and a selling price.
- Prices with a point:
4.99, not$4.99written with other characters. - Tax: the name or rate as the company has it (
GST 5%,GST + BC PST 12%), ornone,no taxorexemptfor no tax. A tax the company does not have can be made by the import. - To track an item's stock, put
yesin Track stock, or give it a stock figure. An item made with no stock column and no track column does not track stock. - Sizes and colours: use Option1 Name (for example
Size) and Option1 Value (Small,Large) on one row per variation, with a parent code to group them.
Several sheets
An Excel workbook may have several sheets. The import guesses what each holds (Products, Modifiers (add-ons), Variations (sizes, colours…) or Ignore this sheet) and lets you correct the guess.
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.