Catalog Management - Common Use Cases

Ungrouping Variants from Products

To ungroup existing variants from an existing product to a new product, you must use the newProduct zip to create a new product to associate the existing variant(s):

1. Catalog Enrichment file:
   1. Variant Attributes: Use the existing variant attributes including SKU #, name, images, etc.
   2. Product Attributes:
      1. product_id: Create a new & unique product_id to associate the variant to. If an existing product_id is used, the variant will be associated with that product grouping (see the below if this is your goal).
      2. product_name: Add the new product name that the variant(s) will be associated with. If this is a standalone variant, it can match the variant name.
2. Inventory file: Include the variants from the catalog enrichment file and match or update the existing inventory for all fulfiller locations where this is sold.
3. Pricing file: Include the variants from the catalog enrichment file and match or update the existing pricing for all fulfiller locations where this is sold.
4. Zip files together into newProduct file and upload to SFTP

Grouping Variants to an Existing Product

To group existing variants to a product, you can use the Catalog Enrichment file to group them:

• Find the existing product to group them under: Locate all variants to group together in Foxtrot and navigate to product to group them under. This can be found in Foxtrot by navigating to the Variant Detail Page > General/Display tab > Base Data section and clicking on the Product View/Editlink.
• On the Product detail page, copy theExternal Product ID and Name fields - These will be used for the product_id and product_name fields.
• Catalog Enrichment file:
  • Variant Attributes: Use the existing variant attributes including SKU #, name, images, etc.
  • variant_options: Please ensure each variant uses the same option type(s) for the product grouping.
• Product Attributes:
  • product_id: Add the External Product ID value from step #2 for all variants to group together
  • product_name: Add the Name value from step #2 for all variants to group together
• Upload the Catalog Enrichment file to the SFTP

Adding Product Assortment to new Fulfiller Locations

To add a new Fulfiller Location (Warehouse or Mall), please open a change request for Spresso to setup the Fulfiller Location in Foxtrot. Once this is complete, you will need to populate the Fulfiller Location's product assortment via file ingestion.

1. When the Fulfiller Location is created, the assortment will be empty. To populate you will need to run the newProduct zip with all existing products to populate the new mall or warehouse.
2. Catalog Enrichment: This should match your full catalog of products & variants regardless of whether they will be sold in the new Fulfiller Location. This can be controlled via the inventory file.
3. Inventory File: Add corresponding rows for each variant. Use the new mall_code and store_code values provided by the Spresso team to set the inventory at the new FL
4. Pricing File: Add corresponding rows for each variant. Use the new mall_code and store_code values provided by the Spresso team to set the price at the new FL
5. Upload newProduct zip to SFTP
6. Wait for job to run (every 5 minutes)
7. Confirm the changes were successful

Change a variant's Fulfillment Method

Spresso allows a variant to be listed with both Express (Local Delivery & Pick Up via timeslot) and Standard (Parcel, 3PL, lead time based) via our flexible fulfillment methods so merchants can expand assortment to a wide servicable area. To update a variant's fulfillment method:

1. Export the existing variant via Foxtrot Catalog Export page for the Fulfiller Locations you'd like to update
2. Set the inventory file column: fulfillment_method to one of the following options:
   1. 0 - Parcel/Standard
   2. 1 - Local Delivery/Pickup
   3. 0,1 - Parcel + Local Delivery/Pickup
3. Save the updated inventory file
4. Zip with the Catalog Enrichment, Inventory, and Pricing files into the newProduct zip
5. Upload the newProduct zip to the SFTP
6. Wait for job to run (every 5 minutes)
7. Confirm the changes were successful