Posted - September 01 2007 : 06:52:48
| it's not just the products table; you'd also need to delete the corresponding prodcategories, discounts, coupons, etc, and also consider the aspect of being able to view historic orders.
my advice, especially if you have historic orders for the products, would be to leave them as hidden and not delete them.
but, if you're feeling brave then you could do it either via admin on the product summary (ie query all the products which have hide set, and then flag those as deleted), but if you have thousands of them then you could do it in sql instead.
in case you do want to do something like that in sql, you could try our freebie:
Advanced SQL Execution:
it's basically just a text-box where you can submit whatever sql text you want, such as:
delete from prodcategories where exists (select 1 from products where hide=1 and intcatalogid=catalogid)
delete from products where hide=1
Web Design, Online Marketing and VPASP addons