I need to delete over 200 products. Can I delete by bulk or do I have to delete 1 by 1
I need to delete over 200 products. Can I delete by bulk or do I have to delete 1 by 1
Unfortunately ... there is not a bulk deleter at this time and to delete just the products table based on products_status would leave junk in multiple tables and really make a mess ...
You could write custom code for this to be used in the future ... but for now, unless all the products are in the same category and you want to get rid of the whole category this is not possibly to do enmass ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
AWWWW!!! darn, ok thanks anyways
Ajeh,
What if you wanted to delete all of your zero quantity items via sql, and you deleted just a portion of the data, then used easy populates built-in clean up function to get the rest of it. Could that work? And if so, could you please share a snippet that will delete zero quantity products?
What I have right now is something you posted a while back in a different thread that "hides" zero quantity items:
Thanks in advance.UPDATE products SET products_status = 0 WHERE products_quantity <= 0;
I Think, Therefore I Zen. I Zen, Therefore, I AM!
Personalized Flowers!
Flowertown Speaking Roses using version 1.5.7-06232020
Changing products_status in a bulk manner based on products_quantity = 0 is very different from deleting the product ...
To delete the product you have to also clean up the associated tables:
products
products_description
products_to_categories
products_attributes
products_attributes_download
specials
featured
meta_tags_products_description
customers_basket
customers_basket_attributes
reviews
reviews_description
to name just a few ...
While this could be written to manage all of this, it is not something I can just whip together without really working on thi$ for $ome period of time and te$t everything need to make thi$ a perfect add-on to $ave you time and money ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
I do believe I get get what you're $aying
PM me if'n you wanna talk $ome more about thi$.
Thank$
Tom
I Think, Therefore I Zen. I Zen, Therefore, I AM!
Personalized Flowers!
Flowertown Speaking Roses using version 1.5.7-06232020
Bookmarks