Importing Skus

If you're rewarding points for point of sale purchases, the Skus import loads the identifying information for every item your POS system sells. Existing SKUs are updated, ones we don't have yet are created.

Find it in the admin under Reports & Imports › Imports, at app.fanmaker.com/admin/settings/imports. Pick Skus from the What are you importing? picker, then click Download example CSV to start from a file with the right headers.

Import Rules

Your file needs every one of these columns in its header row:

• sku — matches the ID column on the SKUs list

• description — a plain-text description of the item, for example "12 oz Coke"

• category — the name of a category for this sku, for example "Sodas"

• bucket — either Merchandise or Concessions

Example CSV

A file with the headers sku, description, category and bucket, and two rows:

• 486156615 — Rum & Coke — Spirits — Concessions

• 842684848 — Hot Dog — Food — Concessions

Worth knowing

Note: Statistics in the Commerce tab are aggregated by bucket, which is why the value has to be exactly Merchandise or Concessions. That's the whole reason the column exists.

Note: SKUs are matched by sku. An existing one is updated to match your file, and a sku we don't have yet is created.

Note: Locked SKUs are left alone. If a sku in your file doesn't change, check whether it's locked on the SKUs list.