Bulk Creation and Management
Spresso Commerce system enables organizations to easily create and update catalog information using SFTP file exchanges.
- newProduct - A zip file of required files can be dropped in SFTP to create new products, variants and store inventory
📣 Recommended file drop at 3am local to allow for updates to be made during downtime. Job runs every 5 min- Zip file name must follow format of
products_YYYYMMDD_timestamp.zip
- Zip file must contain
catalog_enrichment
pricing
inventory
andcategory
category
file is required only if new product and variants are part of new categories- See catalog enrichment, pricing, inventory and category user guides for additional details and rules
- If there are any missing mapping between
catalog_enrichment
pricing
inventory
andcategory
those rows will be skipped - If file contains any existing products and variants, those records will get updated
- If the team is adding inventory for a sku for the first time, a new product zip must be uploaded for the sku to create all the necessary mappings
- Zip file name must follow format of
- Catalog Enrichment - A CSV of existing products and variants for updates
📣 Recommended file drop at 3am local to allow for updates to be made during downtime. Job runs every 5 min- File name must follow format of
catalog_enrichment_YYYYMMDD_timestamp.csv
- Validations and rules:
- File must be CSV. We recommend to pass system generated CSVs to avoid ut8 encoding errors with special characters.
- Required columns are there, else fail entire file
- Duplicate
sku
entries will fail entire file sku
must be unique, else skip rows- Product image is created once using the first variant image
- Variant images are updated when number of links is different from existing variant images
- If required values are missing at a row level skip row update
- File name must follow format of
- Category - A CSV of all categories for updates
📣 Recommended file drop at 3am local to allow for updates to be made during downtime. Job runs every 5 min- File name must follow format of
category_YYYYMMDD_timestamp.csv
- Validations and rules:
- Category file must contain full category tree
- Any category ids not on the file will be automatically marked in system as
isVisible = false
- Any category ids not on the file will be automatically marked in system as
- Required columns are there, else fail entire file
category_id
must be uniquecategory_id
andcategory_path
are required, else fail entire file
- Category file must contain full category tree
- File name must follow format of
- Pricing - A CSV of existing sku pricing updates
📣 Recommended file drop at 3am local to allow for updates to be made during downtime. Job runs every 5 min- File name must follow format of
pricing_YYYYMMDD_timestamp.csv
- If existing SKU is launching in a new store, upload through newProduct zip first to create necessary mappings.
- Validations and rules:
- Required columns are there, else fail entire file
- Check for existing sku id. If SKU does not exist, skip row
- Check for existing mall code and store code, else skip row
- File name must follow format of
- Inventory - A CSV of existing sku inventory updates
📣 Recommended file drop at 3am local to allow for updates to be made during downtime. Job runs every 5 min- File name must follow format of
inventory_YYYYMMDD_timestamp.csv
- If existing SKU is launching in a new store, upload through newProduct zip first to create necessary mappings.
- Validations and rules:
- Required columns are there, else fail entire file
- Check for existing sku id. If SKU does not exist, skip row
- Check for existing mall code and store code, else skip row
- File name must follow format of
- Inventory Delta - A CSV of existing sku intraday inventory updates
📣 Recommended file drop at 3am local to allow for updates to be made during downtime. Job runs every 5 min- File name must follow format of
inventory_delta_YYYYMMDD_timestamp.csv
- If existing SKU is launching in a new store, upload through newProduct zip first to create necessary mappings.
- Validations and rules:
- Required columns are there, else fail entire file
- Check for existing sku id. If SKU does not exist, skip row
- Check for existing mall code and store code, else skip row
- File name must follow format of
Updated 4 months ago