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.
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!