boran Posted February 5, 2009 Share Posted February 5, 2009 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. Link to comment Share on other sites More sharing options...
TropischBruin Posted February 5, 2009 Share Posted February 5, 2009 Bug, solved in the SVN I think. Link to comment Share on other sites More sharing options...
boran Posted February 5, 2009 Author Share Posted February 5, 2009 I'm using SVN from early Jan. Is it very recent?Sean Link to comment Share on other sites More sharing options...
TropischBruin Posted February 5, 2009 Share Posted February 5, 2009 Why not check and update? Link to comment Share on other sites More sharing options...
boran Posted February 17, 2009 Author Share Posted February 17, 2009 Well it took me several days to update, not a trivial task :-)I'm now running SVN 468.This bug has not been fixed. Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 17, 2009 Share Posted February 17, 2009 yes, it's a bugyou need to manually update total_paid,total_product,total_paid_real in table ps_orders Link to comment Share on other sites More sharing options...
boran Posted February 17, 2009 Author Share Posted February 17, 2009 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 Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 17, 2009 Share Posted February 17, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts