Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to delete all products in category at once?


arc

Recommended Posts

hi,

 

i was wondering how to delete all products in a category at once? right now i'm manually going thro each product and deleting them. tedious. =)

 

i guess i could delete the category? and then add the category again? but does that actually delete the products or leave them as orphans?

 

Thanks,

 

Johnny

Link to comment
Share on other sites

That's the only easy way i know of. If you are any good w/ mysql, you could write a quick querry to do it (one line). unfortunately I am not, but it can't be that hard.

Link to comment
Share on other sites

So you want to CHANGE the product's category OR just REMOVE the category and keep the products (w/ no category)?

 

If you want to change the category for a bunch of products then try EASYPOPULATE contribution. It may even remove categories, i'm not sure.

Link to comment
Share on other sites

to clarify,

 

the products i am selling are unique. so if i sell one, it's gone forever. i usually do them in batches (sell them all..and if not, remove it from the site and upload them again).

 

it's tedious to delete each product each time.

 

thanks!

Link to comment
Share on other sites

Best way I know , delete the catagorie, then go back to top and recreate the catagorie, the products will be gone, will except for the images. But they won't show up unless you link back to them. If you want to get rid of the images you have to delete them one by one

Link to comment
Share on other sites

thanks. having orphan pictures won't be that big of a deal. i was just afraid that after awhile, i would have alot of orphans in the database.

 

thanks again,

 

johnny

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...