Importing Products
Contents
Introduction
The Spaaza product import file set consists of two CSV files uploaded at intervals to manage product and variant catalogue information within the Spaaza platform.
Product File Set Overview
The file set consists of the following 2 files in CSV format:
1. Product List file
Provides a list of products/items sold by the retailer and includes information such as product name, brand, season, base price, image URL and identifiers. Always includes all products carried by a retailer.
Sample product list file data:
| PRODUCT ID | PRODUCT CODE | PRODUCT NAME | PRODUCT DESCRIPTION | SELL INCL | SUPPLIER | BRAND | GENDER | RANGE | BARCODE | CREATED DATE | SEASON | DELETED | PRODUCT WEBSHOP URL | PRODUCT UNIT | COST PRICE | CATEGORY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4062 | O-62716 | Super Tank Top | Tank top for summer wear | 25.00 | ACME FASHION DISTRIBUTOR | TANK TOPTASTIC | F | TANK TOPS | 2016-01-28 | WINTER 2016 | 0 | http://www.example.com/tank_top_42.html | Item | 17.40 | Clothing > Tops > Tank Tops | |
| 4063 | 85296 | Loose Leaf Ceylon Tea | Loose leaf tea from the wilds of the Sri Lankan mountains | 0.04 | ACME TEA DISTRIBUTOR | ACME TEAS | TEAS OF THE WORLD | 4023232300131 | 2017-02-21 | 0 | http://www.example.com/ceylon_loose_leaf_tea.html | g | 0.03 | Loose Leaf Teas |
Download sample product list file
Product List Field Definitions:
| Field Name | Description |
|---|---|
| PRODUCT ID | (optional) Retailer’s internal ID; also used in Variant/Stock file. This is often named a “SKU” or “SKU ID” by retailers |
| PRODUCT CODE | (optional) Unique retailer product code (stored as string although only contains numerals). Can be same as PRODUCT ID |
| PRODUCT NAME | (optional) Name or short description |
| PRODUCT DESCRIPTION | (optional) Longer description |
| SELL INCL | (optional) Selling price including taxes. Decimal point (.) as separator, no thousand separators |
| SUPPLIER | (optional) Supplier name |
| BRAND | (optional) Product brand |
| GENDER | (optional) M / F for male/female |
| RANGE | (optional) Range or category name |
| BARCODE | (optional) Product barcode or stem |
| CREATED DATE | (optional) Format YYYY-MM-DD |
| SEASON | (optional) Seasonal designation (e.g. WINTER 2016) |
| DELETED | (boolean 0 or 1) If product is no longer carried |
| PRODUCT WEBSHOP URL | (optional) Product page URL |
| PRODUCT UNIT | (optional, default “item”) Unit of sale (e.g. item, litre) |
| COST_PRICE | (optional) Cost price before margin. Used for margin analytics |
| CATEGORY | (optional) Category path, levels separated by > (e.g. Clothing > Tops > Sweaters) |
2. Variant List file
Lists all product variants (sizes, colours, barcodes). Often incremental — only changes since the last upload are included unless resynchronising.
See the Spaaza Variant List File documentation for detailed field definitions and examples.
Naming Files
Product files follow this naming convention:
<filetype>_<YYYYMMDD>_<HHMMSS>.csv
The filetype prefixes are:
- Product List file:
productlist - Variant List file:
variantlist
Where:
<YYYYMMDD>= date (year, month, day)<HHMMSS>= time (hours, minutes, seconds, 24-hour clock)
Example filenames:
productlist_20251024_100000.csv
variantlist_20251024_100000.csv
When uploading files, both files in a set must use exactly the same date and time in the filename. The Spaaza importer processes files in increasing order of date and time of creation.
File Contents
Product files are valid CSVs with:
- Comma separators
- Double quotes (
") as escape characters - First row = column headers (UPPERCASE)
- UTF-8 encoding in Unix format (LF line endings)
Old-format feeds remain compatible; new fields are always added at the end of each file.
We recommend using a CSV validator to validate files before upload.
Version Tracking
| Date | Version Changes |
|---|---|
| 2016-10-04 | Initial documentation version documenting existing feed |
| 2016-12-04 | Added product category, webshop URL and unit, and variant image URL |
| 2017-03-24 | Clarified product category information |
| 2017-09-27 | Updated definitions and removed extraneous fields in line with latest importer code |
| 2018-01-30 | Updated to explicitly state decimal separator |
| 2019-07-16 | Added product cost price and category fields |
| 2023-07-13 | Updated product field descriptions for clarity |
| 2025-10-24 | Updated SOH file name to “Variant List file”. Separated store import documentation into dedicated page |