Product Catalog

How to import product catalog into Open Loyalty using CSV files.

The Product Catalog import lets a client load their product catalog into Open Loyalty from a single CSV file. Open Loyalty is not the source of truth for products - the client's e-commerce/PIM is; the catalog in OL is a copy used for reference and as the data source for SKU-based campaigns. The catalog is populated by this import (there is no manual product CRUD in the admin panel).

File format: CSV

Sample file

Product Catalog Import.csv

9KB

Open

products-sample.csv

action,sku,name,category,brand,unit,unit_base_price,unit_cost,attr_color,attr_size,attr_material,attr_warranty_months
upsert,NOV-1001,Nova Spark 5,Smartphones,Nova,pc,543.89,337.72,black,6.1in,polycarbonate,24
upsert,NOV-1002,Nova Spark 5 Pro,Smartphones,Nova,pc,330.78,203.12,black,6.1in,polycarbonate,24
upsert,NOV-1003,Nova Edge 8,Smartphones,Nova,pc,1015.02,715.79,white,6.1in,polycarbonate,12

Import your catalog

1. Download the sample file.

2. Add or update one product per row.

3. Save the file as UTF-8 CSV.

4. Upload it in Imports & Exports → Imports.

The first row must contain column names. You can change their order.

Column reference

Column	Required	Use
sku	Yes	Unique product identifier.
action	No	Use upsert to create or update. Use delete to remove.
name	No	Product name.
category	No	Product category path.
brand	No	Product brand.
unit	No	Unit of measure.
unit_base_price	No	Product price. Use a dot for decimals.
unit_cost	No	Product cost. Use a dot for decimals.
attr_<name>	No	Custom product attribute, such as attr_color.

Fixed column names are case-insensitive. Custom attr_ columns are case-sensitive.

Use non-negative prices with up to two decimal places.

Check your SKUs before uploading.

A missing SKU column or duplicate SKU rejects the complete file.

Importing does not replace your full catalog.

Products absent from the file remain unchanged. Empty optional cells clear existing values.

If an import fails

Some file issues reject the whole upload. These include a missing header, missing sku column, duplicate header, duplicate SKU, or unknown column.

Other issues affect individual rows only. The valid rows still import. Review the import report for invalid SKUs, prices, categories, or actions.

Custom attribute rules

Start every custom column with attr_. For example, use attr_color.

Attribute names can use letters, numbers, underscores, and hyphens. Each product supports up to 50 attributes.