Jump to content

delete Entire Category


Guest BuymyJewelry
 Share

Recommended Posts

Guest vrakas

No, you cant. :rolly:

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 :w00t:

Not sure if there is mod that can allow you to mass move products and then allow you to delelte the category.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Guest BuymyJewelry

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

Link to comment
Share on other sites

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.

;)

Link to comment
Share on other sites

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.

:)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...