HomeHome Product Discus... Product Discus...SmithCartSmithCartManual Purge of Logically Deleted Products.....Manual Purge of Logically Deleted Products.....
Previous
 
Next
New Post
1/6/2012 12:39 PM
 
Cathy Dew
No Ranking


Joined: 3/24/2010
Posts: 33

Howdy...

I'm thinking of manually deleting all products that are logically deleted from the Products table. Any concerns about this idea? What support tables should I target that might hold the product ID?

Would this totally screw up old orders?

 
 
New Post
1/6/2012 12:50 PM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
Hi Tony,
If you purge deleted products the only support table that you will run into issues with is the "StoreOrderDetails" table which has the productid key in it. If you purge deleted products that have associated orders and try to view them in the manage order details screen you will not be able to view the line item detail products that were ordered.
At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartManual Purge of Logically Deleted Products.....Manual Purge of Logically Deleted Products.....




Questions? Contact us for answers!

Contact Us!