Guest gorbry Posted November 1, 2005 Share Posted November 1, 2005 Hi All, Does any one know how to bulk move all products in one category to another? Look for a quick way.. Thanks BRyce Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted November 1, 2005 Share Posted November 1, 2005 Bryce, Using phpMyAdmin, make a backup of your database and run the following two SQL commands. Change 1234 to the OLD category ID, and change 5678 to the NEW category ID. Also you may need to change the table names (e.g. to test1_CubeCart_inventory etc) if you have a table prefix. UPDATE CubeCart_inventory SET cat_id=5678 WHERE cat_id=1234 UPDATE CubeCart_cats_idx SET cat_id=5678 WHERE cat_id=1234 Estelle :whistle: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.