HomeHome Product Discus... Product Discus...RazorCartRazorCartDeleted products, how does it work and searchDeleted products, how does it work and search
Previous
 
Next
New Post
10/31/2018 2:37 PM
 
We are trying to eliminate some items from our search results. When we go into the product record and mark it as deleted, it sets a boolean "Logically Deleted" on the product record but doesn't appear to actually delete or remove the record.

I'm trying to understand the intention here. Is there some sort of cleanup process that deletes all the product records marked as logically deleted at some point (similar to emptying the Recycle Bin in DNN itself) or is it intended that the record remain in the database and it is hidden through code actions?

If the second, there might be a bug that the search engine still "sees" the record even though it is logically deleted. 

If it is the first, what is the mechanism for removing the logically deleted records, how often does it run and is there a way to trigger it manually?

Thank you,
George
 
New Post
11/2/2018 1:51 PM
 
The reason we set the logically deleted flag on the product instead of removing it from the table is to maintain integrity of order history. While we store alot of the product fields in the order detail like product name, price, weight, etc. there are some fields that are not saved in the order details and need to be referenced in the original product record like download url, product roles, etc. Regarding the search issue this has been fixed in the latest version 1.5.6 you can download here https://www.smith-consulting.com/Support/Downloads

Cheers,
Dave

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...RazorCartRazorCartDeleted products, how does it work and searchDeleted products, how does it work and search