Convert Product to GenericVariantProduct

serdar_dere_ex · ‎2025 Jan 24

Hello Community,

I am trying to enable Variants and tried few things which failed:

1. I wanted to snyc existing catalog to new catalog, copy them to baseproducts with suffix _B and change them to GenericVariantProduct while changing the TypePkString in DB, which failed

2. I tried to write groovy Scripts, but they mostly stopped with timeouts from DB.

3. I tried to export the products but it looks like, that not everything was exported.

My Question here is: is there a simple way to deeply copy Products to save them as GenericVariantProducts with small Category changes? Or can I somehow use the CatalogSyncJob to help me out here?

Maybe Groovy was the right answer, but how can I stop the process from running into timeout?

Or ist here a simple way to use flexible Search in impex to add columns from different table?

I hope someon can help me here, the existing two posts in this board were not helpful.

Cheers,

Serdar

mansurarisoy · ‎2025 Jan 27

We did something similar in Backoffice, where our aim was to convert a GenericVariantProduct to a Product type by clicking a button in Backoffice.

By default, SAP Commerce does not allow changing the type of an item directly. However, it can be achieved via SQL, followed by clearing the cache. I believe something similar to the following approach should work for converting a GenericVariantProduct to a Product type. Although I haven’t tested the code, I rearranged it based on my original code used for converting to GenericVariantProduct, so I believe it should work.

You may need to adjust the part where the supercategories of the product are set. By default, the GenericVariantProductValidateInterceptor ensures that the supercategories of a variant and its base product are consistent. However, if you assign the correct categories before saving, it should not cause any issues.

Additionally, you can programmatically disable the interceptor before saving to bypass the validation.

protected ProductModel convertToVariantProduct(final ProductModel product, final ProductModel baseProduct){
    final ComposedTypeModel productType = typeService.getComposedTypeForClass(GenericVariantProductModel.class);
    int rows = jdbcTemplate.update("UPDATE products SET TypePkString = ?, p_baseproduct = ? WHERE PK = ?", productType.getPk().getLong(), baseProduct.getPk().getLong(), product.getPk().getLong());
    if(rows != 1){
        LOG.warn("Could not update TypePK of product {}", product.getCode());
        return null;
    }

    Utilities.invalidateCache(product.getPk());

    final GenericVariantProductModel variantProduct = modelService.get(product.getPk());

    try {
        List<CategoryModel> categories = new ArrayList<>();
        variantProduct.setSupercategories(categories);
        modelService.save(variantProduct);
        return variantProduct;
    } catch (Exception ex){
        LOG.error("An exception occurred while trying to convert variant product {}", product.getCode(), ex);
    }

    return null;
}

Convert Product to GenericVariantProduct

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (1)

Answers (1)