7 replies to this topic

[boran]

Hi,

Lets say a client places an order with many items, and we notices that one is not in stock and cannot be delivered for a long time.
So we contact the client who says to forget that item and deliver the rest.

In Back Office >> Orders, the item is deleted from the Order.
But the order totals on the top right are not deleted.

Is the normal, or a bug?

Thanks in advance.

[TropischBruin]

Bug, solved in the SVN I think.

[boran]

I'm using SVN from early Jan. Is it very recent?

Sean

[TropischBruin]

Why not check and update?

[boran]

Well it took me several days to update, not a trivial task :-)
I'm now running SVN 468.

This bug has not been fixed.

[L. Brett Sinclair]

yes, it's a bug

you need to manually update total_paid,total_product,total_paid_real in table ps_orders

[boran]

Has a bug been registered, I'd like to track it.
I don't suppose you've example SQL statements that I can use as a starting point, i.e. that calculate the total correctly?

Sean

[L. Brett Sinclair]

since it is on a rare occasion, I handle it on case by case basis.
I do not have a SQL that recalculate everything.

In your case, I would delete the line ps_order_detail related to that order. (based on your DB host, phpadmin, you can just click the "delete" button)
Then, I would decrease the record in ps_orders to the amount value that I deleted.

Now there are some statistics tables that should be updated that I do not update at the moment.