Aantar

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_text Pasta sauce 2 for $6,n_for,2,6.00,0601234500011;0601234500028,2026-11-20 08:00,2026-11-26,2 for $6 Cereal $1 off,amount_off,,,cat:Cereal,2026-11-20 08:00,2026-11-26,$1 off

Import the file

  1. Open the CSV in Notepad or Excel and copy all of it.
  2. Press More, then Back office, then Promotions.
  3. Press Import CSV.
  4. Press Paste. The text appears in the box.
  5. 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.
  6. Fix the rows in your spreadsheet, copy it again, press Paste and Check again, until nothing is left to fix.
  7. 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.