Link Search Menu Expand Document

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