Jump to content

How to move all products in one category to another


Recommended Posts

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.

  • Like 1
Link to comment
Share on other sites

×
×
  • Create New...