|
devshb
Senior Member
United Kingdom
1904 Posts |
 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:
http://www.bigyellowzone.com/shopexd.asp?id=114
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)
or:
delete from products where hide=1
etc
Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons |
 |
|
All Forums
Delete hidden products.
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
