To create a support ticket, start a search

Converting simple products to a product with combinations

If you use several simple products such as :

perfume 50ml
perfume 100ml
perfume 150ml

And you want to convert them into a single product with combinations, i.e. Perfume + 3 combinations Capacity 50ml + 100ml + 150ml

This can be done by doing a csv export (to extract the data from the existing products), work on the resulting file to add the combinations, and then import this file to create them.

Taking the example of these 3 Perfume products, we will keep one which will have the combinations.
As for the other two, we will deactivate them, add them to a hidden category and also add a redirection to the product we are keeping (the one that will use the combinations).

Export the products by including id_product (which will be the identifier for the import).
You can also add the fields 'quantity' and 'price excl. Tax' to your export, in order to define them on the new combinations that you will create.


The exported file is worked on to :

1. Keep the 50ml perfume
We modify its name and add the 3 combinations of capacity in a new column (and any other information you want to add to these new combinations, such as the reference, the stock, the price)
=> it will be the product + 3 combinations

2. For the other two products: perfume 100ml and perfume 150ml: the following columns and values are added:
active = 0
categories = duplicate (which you will have previously created in Sc)
redirect_id_item = the id of the product converted into a combination
redirect_type = 301-product



Finally, we import the file that will give us :
Perfume + 3 combinations
Perfume 100ml deactivated, placed in the hidden category 'duplicate' and redirected to the product Perfume + 3 combinations
Perfume 150ml deactivated, placed in the hidden category 'duplicate' and redirected to the product Perfume + 3 combinations