Aantar

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

  1. Press More, then Till settings, then Admin, then Import Products.
  2. 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.
  3. 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.99 written with other characters.
  • Tax: the name or rate as the company has it (GST 5%, GST + BC PST 12%), or none, no tax or exempt for no tax. A tax the company does not have can be made by the import.
  • To track an item's stock, put yes in 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.