Remapping Variants to Another Product Cluster


You may need to reassign existing product variants to another product cluster (e.g. when variant was added to the wrong product).



  1. Unlink variants from the wrong product if the product is published and will be used further; otherwise, proceed to the next step.
    1. From Symphony Manage, navigate to Catalog > Products.
    2. Search for the product using an SKU# of one of the affected variants.
    3. Open the product and expand the Variants/SKUs section by clicking on the menu/Hide icon.


    4. Click on the delete button next to each variant you want to unlink from the product.


    5. Confirm the removal by clicking OK.
    6. Click Save in the top right corner of the page.
  2. Submit a request to Symphony Support, including the IDs of the variants and the ID of the product cluster to which the variants need to be linked.
    Once the variants are remapped, they will be accessible under the URL of the new product. Additionally, you can set up a redirect from the old product URL to the new one.



  1. If the brand requested to move all variants from a specific product (didn't provide variant IDs), perform steps 1.a-1.c and copy the Symphony Id for each variant.
  2. Create a Change Request Jira ticket under the SPC project, including the query to map variants to the correct product cluster and rollback the change.
    Note: If remapping needs to be done urgently (e.g. due to promotion), you can elevate the case to the PS team who also have write access to the database.
    • Query to add variants to the correct product - separate query needs to be included for each variant; use Excel or Google Sheets to generate the queries
      INSERT IGNORE INTO ProductCluster_Product
      (productCluster_id, product_id, published)
      VALUES (<product cluster id>,<variant id>, 1);
    • Rollback query:
      DELETE FROM ProductCluster_Product
      WHERE productCluster_id=<Old/incorrect Product Cluster id>
      AND product_id IN (<Variant ids separated by comma>);
      • You can also use the following query when the brand also requires to remap and unlink variants from the old product.
        Note: It should be used only when unlinking a large number of variants; otherwise, the variants should be unlinked manually.
        UPDATE ProductCluster_Product
        SET ProductCluster_id =<New Product Cluster id>
        WHERE ProductCluster_id = <Old/incorrect Product Cluster id>
        AND Product_id = <Variant ids separated by comma>;
  3. Additionally, you may need to set up a URL redirect from the initial product cluster to the product to which the variants were remapped (if explicitly requested by the customer).
  4. Under Catalog > Products, find the product to which you mapped the variants and open it.
  5. Expand the Variants/SKUs section and check if newly mapped variants are in place and displayed properly.
  6. If the images are not displayed or the ability to modify variants is missing, you will need to recreate the product cluster by exporting and uploading it (with a new identifier and URL that will be changed), and then remap all of the linked variants to the newly created product cluster.

    Images and the ability to manage variants are missing.
    Variants are displayed properly

    • After remapping is complete, set the correct product URL for the recreated product:
      1. Find the former corrupted product (under Catalog > Products) and open it.
      2. Expand the Search Engine Visibility section.
      3. Copy the URL for this product.
      4. Add duplicate or invalid in the product URL field.


      5. Unpublish the product and click Save in the top right corner of the page.


      6. Find the new product to which you mapped the variants (under Catalog > Products) and open it.
      7. Expand the Search Engine Visibility section.
      8. Paste the correct URL of the former product (copied in step c).
      9. Publish the product and click Save in the top right corner of the page.





Article is closed for comments.