Aantar POS
Import promotions from a file
Load hundreds of promotions at once from a CSV, with a check of every row before anything is written.
Where: More ▸ Back office ▸ Promotions ▸ Import CSV
A store with hundreds of deals a week does not make them one by one. Prepare them in a spreadsheet, one promotion a row, save it as CSV, and import it. The import checks every row first and writes nothing until every row is right; then it writes them all at once, or none.
Before you start
- Sign in as the owner or a manager (Manage promotions).
- Promotions are part of the Aantar POS Plus and Pro plans.
- Up to 2,000 promotions can be imported at a time.
The columns
The first row names the columns. Only the columns a promotion needs are required; leave the others out or empty.
| Column | What to put in it |
|---|---|
name |
The promotion's name (required) |
type |
price, amount_off, percent_off, qty_break, n_for, bxgy or threshold |
price, amount, percent |
The sale price, the amount off, or the percent off |
qty |
For n_for: how many for the price |
buy, get, get_percent |
For bxgy (get_percent 100 = free) |
min_subtotal |
For threshold |
tiers |
For qty_break: from:price pairs, for example 1:2.49;6:1.99 |
items |
Barcodes or SKUs separated by ;. SKU*2 for a bundle's counted row, cat:Frozen for a department, brand:Name for a brand |
get_items |
For bxgy: the items you get, when they differ |
starts_at, ends_at |
2026-11-20 or 2026-11-20 08:00; an end with no time runs the whole day |
days |
Mon;Tue or Mon-Fri |
time_from, time_to |
Daily hours, 16:00 |
stores |
Store names or numbers separated by ;; empty for every store |
priority, stackable |
As on the form |
customer_group |
For a members-only deal |
short_text, name_fr |
The receipt text, and the name in French |
Example:
name,type,qty,price,items,starts_at,ends_at,short_textPasta sauce 2 for $6,n_for,2,6.00,0601234500011;0601234500028,2026-11-20 08:00,2026-11-26,2 for $6Cereal $1 off,amount_off,,,cat:Cereal,2026-11-20 08:00,2026-11-26,$1 off
Import the file
- Open the CSV in Notepad or Excel and copy all of it.
- Press More, then Back office, then Promotions.
- Press Import CSV.
- Press Paste. The text appears in the box.
- Press Check. Nothing is written. The box shows the count of rows ready and to fix, and lists each row with a problem and why, in red. Rows with only a warning show in amber.
- Fix the rows in your spreadsheet, copy it again, press Paste and Check again, until nothing is left to fix.
- Press Import. Every promotion is written in one go, and the list shows them with their status.
Import stays greyed out while any row has an error.
Note: The import does not set coupon codes. Add a code on the form afterwards (Coupon codes).
Note: The import box takes pasted text. There is no button to choose a file from the disk.
A row with a warning still imports. The warnings are Another row in this file has the same name. and A promotion with this name already exists.
Warning: The import does not check British Columbia's legal minimum liquor prices, as the promotion form does. A sale that such a promotion takes under the minimum is refused when the sale is recorded. For liquor promotions, open each imported one and press Save promotion: the form refuses a price under the minimum and names the item. See Legal minimum prices (BC liquor).
After the import
Check the week's promotions on the list, filtered by Scheduled, and try a few on a sample basket. To change many at once, see Edit many promotions at once.
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.