We've removed demo products, but they're showing up on customers' invoices?

[UT-Ryan]

Hi,

 

One of our clients is having an issue with the latest installation. A customer recently made a purchase and found that three products were on an invoice that she did not add to the cart; normal mistake at first glance, but the products that she didn't order turned out to be the demo products we've removed from the catalog. After attempting to delete the products from the order, the total fee on the invoice increased from $24.99 to $87.14 (or something around that nature) and the products were still listed on the order. Although the customer was charged the proper amount, an invoice depicting products that they didn't order along with a false total would through anybody off.

 

Has anybody run into a similar issue, if so, how did you go about resolving it?

[NemoPS]

Several users reported the same issue, did you reset anything like order ids or product ids? You should check for leftovers in order_invoice

[vekia]

it looks like customer get old order, orders table was truncated? or any other ps_order_* table ?

[UT-Ryan]

it looks like customer get old order, orders table was truncated? or any other ps_order_* table ?

 

I found reference to the demo products in order_detail. Should we drop the database entries referring to these demo products?

[NemoPS]

They might conflict, yeah, you can drop them, just make sure there are no ID mismatches across _orders and _order_detail

[UT-Ryan]

They might conflict, yeah, you can drop them, just make sure there are no ID mismatches across _orders and _order_detail

 

Thanks so much Nemo, you've been a great help!