Howdy...
(This might be a duplicate post - but I can't seem to find my original posting.)
Our client contacted us the other day about an order. A customer placed an order for an item that had an old (lower) price. I investigated the order and found that there are two products in the DB, one has been "logically deleted". And the "deleted" product was the one that was ordered. The deleted product was most likely deleted 14 months ago, based on time date stamps in the DB. Additionally, in the Shopping Cart table, there are several records with the deleted product listed. This might be related to the order under investigation, the timing is about right (but there is no way to conclusively tie these two together).
I've pretty sure this isn't a case of saving a product in the cart, admin deletes it, and the customer attempts to order the newly deleted product.
I've used the public and admin interfaces to search for the deleted product, but have not been able to get it to show up.
I can use the deleted Product ID in theURL to view the product and add it to the cart. (I haven't pushed it through as a test order yet.) Might want to close those holes.
So maybe the customer saved the original URL 14 months ago?
Anyway DNN version 5.6.2, Cart Version 4.58.
Ideas?