Importing Skus

If you are rewarding points for point of sale purchases, this import type will upload identifying information for any Skus that the POS system uses.


See here for an example CSV


To bulk update Skus, create a CSV that adheres to the following rules.

  • You must include the following headers:
sku, description, category, bucket
  • The 'sku' column should correspond to the ID column on the skus list

    The 'description' column should be a plain text description of the item, e.g. '12 oz Coke'

    The 'category' should be the name of a category for this sku, e.g. 'Sodas'

    The 'bucket' should be the name of a group. It must be either 'Merchandise' or 'Concessions' Statistics in the commerce tab will be aggregated to this level. e.g. 'Concessions'

  • 'Locked' SKUs will not be affected by any changes uploaded. Any unlocked SKU will be updated to reflect the values in the CSV being uploaded.
  • An example csv might look like this:

This import will update existing entries (by matching sku) and create entries that do not exist.

sku description category bucket
486156615 Rum & Coke Spirits Concessions
842684848 Hot Dog Food Concessions

Note:

Please save your .csv files using the MS-DOS Comma Separated value option for best import results!