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 perfumeWe 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 = 0categories = duplicate (which you will have previously created in Sc)redirect_id_item = the id of the product converted into a combinationredirect_type = 301-product