HomeHome Product Discus... Product Discus...SmithCartSmithCartbulk delete of productsbulk delete of products
Previous
 
Next
New Post
8/4/2010 5:31 AM
 

Hi

Is there a way to delete all products in the buynow module in one go? Maybe a sql script we can run?

While we develop we are testing different variations, product combinations etc - but before we go live, we will want to delete all the test data prior to populating the store with proper product data.

Thanks :)

 
New Post
8/4/2010 10:50 AM
 

From sql mgmt studio run the following command:

truncate table smith_products

If you have product variants then run the following command:

truncate table smith_productvariants

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/5/2010 1:37 AM
 

Thanks Scott :)

 
New Post
9/1/2010 2:43 AM
 

You should also run truncate table smith_CategoryProduct when doing a bulk delete - if you don't, you end up getting duplication in the product listings

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartbulk delete of productsbulk delete of products