Moving products

[CosTed]

Hello,

 

I have a problem with moving prodducts to the diffrent category. For example in category A I have 100 mp3 players, 100 mobile phones and 50 photo cameras. So i have 250 diffrent products and I need to change those products category. So changing products category individually it would take a long time to do that. Is there somekind of module to do that faster ? For example chosing all televisions and then moving them to other category ?

[Richard S]

You could change database records for this, however you should be very careful and see if everything is changed by your database query as there might be problems after that with products showing in bad categories, or bad translations and so on. However, i think editing database directly with some query would be an easiest way if you did not find any module.

[CosTed]

I dont think that by editing database would be the easiest way to move the products. Its almost the same thing as editing products in individually. I think prestashop should make an improvment to this.

[Richard S]

You just need to write your query well. For example UPDATE `table` SET `id_category` = 'id_number' WHERE `id_category` = 'id_other_number'. And everything will be done automatically. However, as I have said you need to check all the relations in order not to make mistakes.