|
|
How to delete from CATALOOK shopping cart in DotNetNuke all products from Single Store
|
|
|
Location: Blogs General Diary |
 |
| Posted by: Conrad Woolston |
Tuesday, April 25, 2006 |
How to delete from CATALOOK shopping cart in DotNetNuke all products from Single Store
delete from cat_products
where categoryid in
(select categoryid from cat_categories where cat_categories.portalid=37)
delete from cat_categories where cat_categories.portalid=37
The second statement deletes categories created at the same time:
You may also wish to set the quantity to zero so the buy now button etc doesnt appear. This is done using:
update CAT_Products
set
orderquant=0
WHERE
Categoryid in
(select categoryid from cat_categories
where
cat_categories.portalid=37)
|
| Copyright ©2006 Conrad Woolston |
| Permalink |
Trackback |
|
|
Website Design Brisbane*Web Design Brisbane
|