Aantar POS
Update prices and costs from a file
Change the prices and costs of many existing items at once by importing a file that names them by code.
Where: More ▸ Till settings ▸ Admin ▸ Import Products
The item import also updates items the store already has. A file with each item's code and its new price (and cost) changes those items in one run. Use it when a price list arrives as a spreadsheet.
Before you start
- The file has one item a row, with its SKU or Barcode, its Name, and the new Price, and Cost if costs change.
- Sign in as the owner or a manager.
Steps
- Press More, then Till settings, then Admin, then Import Products, and choose the file.
- On Match columns, check that the code, name, price and cost columns are matched.
- On Check, choose Update products I already have.
- The counts show how many items are to update. Each row shows Update, New or a Problem.
- Press Import.
How items are matched
An item in the file is the same as one the store has when its SKU or barcode matches a code of the item, or else when its name matches. A row that matches nothing is added as a new item: check the new products count before you import.
What an update changes
- The selling price and cost of each matched item.
- The department, unit, tax, description, track stock and alert quantity, when the file gives them.
Limits
- A Name column is required, even for an update.
- An item with sizes or variations keeps its prices unless the file lists its variation rows; the check page says it has variations, so its prices were not changed.
- A row with no selling price is refused.
Important: Prices changed by an import do not go on the shelf tag queue, are not in the Price changes undo list, and cannot be scheduled for a date. For a price change you want to schedule, preview or undo, or to queue shelf tags, use Change prices (Change many prices at once, now or on a date).
A supplier's price list
A supplier's price list with its own codes and case costs is imported in Aantar Books, which links the supplier codes to your items. See Vendor price files.
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.