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 and category
    • 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 and category 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
• 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
• 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
    • Required columns are there, else fail entire file
    • category_id must be unique
    • category_id and category_path are required, else fail entire file
• 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
• 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
• 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