Importing prizes

Last updated: Oct 30, 2026|3 min read|Prizes, Instant Wins & Winners

You can add or update many prizes at once by uploading a CSV file in Prize Catalogue > Import Prizes (or the Import button on the Prizes page). The importer maps your spreadsheet's columns to prize fields, then creates new prizes, updates existing ones, or both.

Don't see Import Prizes in your sidebar? Add the Import app from Apps. See Adding and removing apps.

This is the quickest way to bring a prize list across from another platform or a supplier's spreadsheet. The menu item needs the Create Competitions team permission.

Before you start

Click Download CSV template at the top of the import page for a sample file with every column filled in. A few rules:

  • Your CSV must have headers in the first row.
  • Money is in pounds, not pence: 199.99, not 19999.
  • Separate multiple values with a semicolon, for example VIP;Experiences in the Categories column.
  • Test with a small batch before importing your whole catalogue.

The columns

Three fields are required: Prize Name, Prize Value (retail) and Prize Cost (what you paid). The optional ones are:

  • Prize ID: only needed if you want to update existing prizes by ID.
  • Prize Description.
  • Status: active (or enabled, on) makes the prize active. A blank cell also means active. Any other value makes it inactive.
  • Prize Type: physical, cash, credit or digital. A new prize with no type is created as physical.
  • Cash Alternative Enabled and Credit Alternative Enabled: yes/no (or true/false, 1/0). Leave blank to follow your store rates.
  • Cash Alternative Value and Credit Alternative Value: a fixed amount in pounds. A value on its own also switches that alternative on for the prize.
  • Categories: category names, separated by semicolons.

The importer recognises common header names (such as Price, Value, Cost or COGS) and maps them for you.

Pictures are not imported: the template has an Image URLs column, but this version of the importer does not fetch images from it. Add pictures on each prize afterwards, or through the Media Library.

Running an import

  1. Choose your file under Select CSV file. The Field reference guide lists every field and marks the required ones.
  2. Under Import settings, pick What do you want to do?:
    • Import all prizes: update prizes that match, create the rest.
    • Only update existing prizes: rows that do not match an existing prize are skipped.
    • Only create new prizes: rows that match an existing prize are skipped.
  3. If you are updating, choose Match prizes by: Prize Name or Prize ID.
  4. Turn on Create categories that don't exist yet if your file names categories you have not created.
  5. Under Map CSV columns, check each column is mapped to the right field, or skipped. The box headed How your import will work summarises what will happen.
  6. Click Start import.

The progress panel counts rows Processed, Created, Updated and Failed, and lists any Row errors so you can fix those rows and import them again. Duplicate rows for the same prize name in one file are merged into one prize.

What an update keeps

Things the CSV has no column for are left as they are when a prize is updated: its supplier, who ships it, the graded card and winner's choice settings, and whether it is marked out of stock. Fill in the value and cost on every row you import, including updates.

See also

Was this article helpful?
Last updated: Oct 30, 2026

Related articles

💬
Still need help?Our support team is here for you.
Contact Support
Create your free account