Catalog Management - Common Use Cases
Steps to Address 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):
- Catalog Enrichment file:
- Variant Attributes: Use the existing variant attributes including SKU #, name, images, etc.
- Product Attributes:
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).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.
- 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.
- 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.
- 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/Edit
link. - On the Product detail page, copy the
External Product ID
andName
fields - These will be used for theproduct_id
andproduct_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 theExternal Product ID
value from step #2 for all variants to group togetherproduct_name
: Add theName
value from step #2 for all variants to group together
- Variant Attributes: Use the existing variant attributes including SKU #, name, images, etc.
- 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.
- 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.
- 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.
- 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
- 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
- Upload newProduct zip to SFTP
Updated 3 months ago