Collections

How to import collections into Open Loyalty using CSV files for use in other modules.

Collections are groups of values (such as product SKUs, store IDs, or category names) that can be referenced in other modules. Use the collection import to load these values in bulk rather than entering them manually.

File format: CSV

Sample file

Collections Import.csv

137B

Open

collections-import-sample.csv

value
SKU-001
SKU-002
SKU-003
SKU-004
SKU-005

Format rules

• The file must include the header row value

• Each subsequent row contains one collection value

• The collection must contain at least three records

• No extra columns — only value is supported

• Save as .csv with UTF-8 encoding

Minimum three records required. Collections must contain at least three values. Files with fewer records will not be accepted.

Collections are used in other modules, e.g. campaign conditions or custom fields. Once imported, you can reference the collection in campaign expressions — for example, to award points only for purchases of products whose SKU is in a specific collection.

Common mistakes

Mistake	Fix
Fewer than three values	The minimum is three records
Missing description column	Both value and description columns are required, even if there is no description.
Missing header row	The value,description header is required

To find out more, please refer to the article below:

Collections