cheap gaming pcs Posted April 7, 2013 Share Posted April 7, 2013 Hi All How can i move all products in one category to another at the same time There must be any easy way Many Thanks Link to comment Share on other sites More sharing options...
hxd Posted April 8, 2013 Share Posted April 8, 2013 You can do that directly in the database by executing an SQL query using phpMyAdmin. Execute a query like this one: UPDATE `ps_category_product` SET `id_category` = 3 WHERE `id_category` = 7 Replace ps with the actual table prefix of your database and the category IDs with those of the categories for which you want to move products. In the above example all products from the category with ID 7 will be moved to the category with ID 3. You can check what the ID of a category is from the back office; the table that lists the categories also show the ID of each category. Hope this helps. 1 Link to comment Share on other sites More sharing options...
Recommended Posts