[Solved] Extra product displayed in ordered products list.

[Amazzing]

Hello everybody!

I am running PS 1.4.2.5
And I just faced a problem with ordered product list in BO.

Here is the case:
Customer adds to cart the following products: product1-$50, product2-$70, product3-$100.
After that he goes to cart page and deletes product 3. So, the total amount of order is $120.
I go to BO and see a new order for $120.
Everything seems all right till now.

But when I open the order details, there are 3 products in the list: product1-$50, product2-$70, and random_product-$150. BUT the total amount is still $120.
I made some test orders in this way. And every time 3-rd product is selected randomly and doesn't affect the total amount.

I guess script responsible for deleting the product doesn't work properly...but I am not sure about that.

Does anybody have any ideas why it is happening?

[olea]

Have you cleaned the ps_order table by yourself ( for example, to delete the orders placed for test) ?

Or enabled the 'delete' button in the orders list ?


Usually, this issue is due to the fact that some entries are deleted from the ps_order table but the corresponding entries are not deleted from the ps_order_detail table.
So when a new entrie is created in ps_order table (a new order), it may be linked to old entries in ps_order_detail.

[Amazzing]

Yes, I deleted some test orders.
I found this advise on this forum:

to delete one order at at time…

Click on one of the orders ( in the back office) and replace the parameters “vieworder” with “deleteorder” from the url

For example

http://yourdomain.com/admin/index.php?tab=AdminOrders&id_order=7&vieworder;&token;=798dfd720021761c80d828eb3f2a8621

Change it to:

http://yourdomain.com/admin/index.php?tab=AdminOrders&id_order=7&deleteorder;&token;=798dfd720021761c80d828eb3f2a8621

Works like a charm!

So the only way to fix this problem is to delete corresponding entries from ps_order_detail?

[Amazzing]

upd: I have corrected the ps_order_detail.

Everything looks fine now.
Thank you, Olea for the advice!

Is there anything else required to change in order to avoid reading old entries from corresponding fields?

[tonis]

I have had this same problem. I corrected the database fields and it seems to be fine. Thanks for the solution.