Change order status alters Order Total

  • Posts: 116
  • Thank you received: 7
  • Hikashop Business
10 years 6 months ago #166960

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.4.30
-- Browser(s) name and version -- : any
-- Error-message(debug-mod must be tuned on) -- : none

We have a strange behavior and can't track down the reason/culprit when changing the status of an order.

We get orders with the status as confirmed with the completion of the payment gateway.

When we ship the order, we normally just list the orders on the screen via the Orders listing and using the Dropdown status box, change it to Shipped. This seemed to work fine.

One of the users changed the method because she wanted to look at the whole order and used the Edit Order to change the status to Shipped. When we do this, the Order Total is now just the amount of the Freight/Shipping amount.

So say an order total was $105.00 with $100 being merchandise and $5.00 being shipping. When you edit the order, the total of the order is now just $5.00. This new total of course is throwing off the reporting as well.

Any ideas? Also, how can we get back the original order and paid amounts?

Please Log in or Create an account to join the conversation.

  • Posts: 83344
  • Thank you received: 13481
  • MODERATOR
10 years 6 months ago #166971

Hi,

I'm not able to reproduce the problem so it must be a specific case do to your settings, etc. So hard to understand why this happened and thus hard to fix.
But if you want to put back the normal amount, you can manually calculate it and create a mass action via the menu System>Mass actions like this:
one filter "order column" on order_id with the id of the order
one action "update the values" on order_full_price with the full amount of the order in the field and the "string" choice selected.
Then, click on process and it will update the full price of the order.

Please Log in or Create an account to join the conversation.

  • Posts: 116
  • Thank you received: 7
  • Hikashop Business
10 years 6 months ago #167471

All of our orders have a subtotal of zero, why would that be? We have an order, for example, with 6 line items. These are product variations and individually their price is 0.00 but their parent item price dictates the total. So the order total is $100.00 plus 6.00 shipping, but the Order shows 0.00 subtotal, Freight 6.00, and total Order $106.00.

I think this is why changing the order status from Edit Order alters the entire order total incorrectly. I've attached an Invoice (which incorrectly shows VAT which may be a subtotal? but we don't use VAT) and the Order details screen from the admin. back end.



Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26201
  • Thank you received: 4032
  • MODERATOR
10 years 6 months ago #167544

Hi,

Because you have the history type "modification", it means that the order status has been changed from the order listing, using the dropdown. The status is not changed from the order edition (clicking on the "edit" button to just edit the main information).

I tried to reproduce your problem and I couldn't.
I really don't understand why your products are modified and their price are set to 0.
I think you have an external plugin which is plugged on the trigger "onBeforeOrderUpdate / onAfterOrderUpdate" and which does not react correctly (because only the order status is modified, he might not found something in the order it is looking for and so, have a disproportionate reaction).

But like that, I don't have enough details to be able to say which plugin can be the source of the trouble.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds
Powered by Kunena Forum