Guest BuymyJewelry Posted August 13, 2006 Share Posted August 13, 2006 Can I delete an entire category without deleting each and ever prod in that category? I am trying to do this and I cant. :w00t: Quote Link to comment Share on other sites More sharing options...
Guest vrakas Posted August 13, 2006 Share Posted August 13, 2006 No, you cant. On the one side its good, it helps avoiding deleting products by accident but on the other side it is a bit of a pain Not sure if there is mod that can allow you to mass move products and then allow you to delelte the category. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 15, 2006 Share Posted August 15, 2006 Sure you can if you're not afraid of SQL. Here's what you need: DELETE FROM CubeCart_inventory WHERE cat_id = ## DELETE FROM CubeCart_cats_idx WHERE cat_id = ## DELETE FROM CubeCart_category WHERE cat_id = ## That will delete all the products, the product index and the category itself. Quote Link to comment Share on other sites More sharing options...
Guest BuymyJewelry Posted August 16, 2006 Share Posted August 16, 2006 wow that is awful!! One category has 300 products and I need to delete it all...! I am not comfortable with SQL. Quote Link to comment Share on other sites More sharing options...
Guest BuymyJewelry Posted August 16, 2006 Share Posted August 16, 2006 never mind went into my phpadmin. ;) Quote Link to comment Share on other sites More sharing options...
Guest vrakas Posted August 16, 2006 Share Posted August 16, 2006 and ..... ? You could give us the details for further use on how to do this. Someone else might have the same question/problem. Quote Link to comment Share on other sites More sharing options...
Guest BuymyJewelry Posted August 16, 2006 Share Posted August 16, 2006 in my host, I noticed a MYPHPADMIN Icon, so I opened it and them I went in to the Categories area under the SQL and clicked Browse, found the categories I wanted to delete and then I clicked on the RED X, it deleted all the categories and the products in One quick swoop! So easy. get it here. http://www.phpmyadmin.net/home_page/downloads.php melissa Quote Link to comment Share on other sites More sharing options...
Guest Posted August 16, 2006 Share Posted August 16, 2006 Melissa, if that's all you did, then you didn't really delete the items, you simply removed the category. Did you also delete all the entries from the CubeCart_inventory table and accompanying entries from the CubeCart_cats_idx tables? If not, then you did not accomplish what you set out to do. In PHPMyAdmin, you should see a link on the top of the right pane that says "SQL". That would give you a box where you can enter raw MySQL commands and they would be executed. If you would put the commands that I gave you earlier in this thread into that box, it would indeed properly remove everything you needed removed. The only thing you'd need to know is what the cat_id was that you wanted gone. Nice and easy. You said what I gave you was awful...I think you misunderstood to think you had to do that with each product. That's not the case. Those three lines will delete EVERYTHING you needed gone. ;) Quote Link to comment Share on other sites More sharing options...
Guest BuymyJewelry Posted August 16, 2006 Share Posted August 16, 2006 i dont know. When I open my admin the products are gone. So it is gone. Quote Link to comment Share on other sites More sharing options...
Guest vrakas Posted August 20, 2006 Share Posted August 20, 2006 So are we going to get the complete procedure? :zorro: Quote Link to comment Share on other sites More sharing options...
Guest Posted August 23, 2006 Share Posted August 23, 2006 Vrakas, I'm not sure if what she did was proper, but the three SQL snippets I listed above WILL work to completely eliminate a category with any number of products in it. Now, the only potential issue would be options and such tied those deleted products....that's something that you'd have to deal with separately me thinks. :) 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.