[Skip to main content](#vessel-content)

#   Change order status alters Order Total

##

- **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")**
- [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author
- [ Offline](/forum/user/33546-stratacorps)

Less More

- Posts: 116
- Thank you received: 7
-

12 years 2 months ago [\#166960](#166960) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")  *[Change order status alters Order Total](/forum/35-orders-management/870274-change-order-status-alters-order-total#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?")* was created by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")*

-- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg3MDI3NC1jaGFuZ2Utb3JkZXItc3RhdHVzLWFsdGVycy1vcmRlci10b3RhbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86320
- Thank you received: 14279
-
-

12 years 2 months ago [\#166971](#166971) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change order status alters Order Total](/forum/35-orders-management/870274-change-order-status-alters-order-total#166971 "-- 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?")*

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&gt;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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg3MDI3NC1jaGFuZ2Utb3JkZXItc3RhdHVzLWFsdGVycy1vcmRlci10b3RhbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")**
- [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author
- [ Offline](/forum/user/33546-stratacorps)

Less More

- Posts: 116
- Thank you received: 7
-

12 years 2 months ago [\#167471](#167471) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")  Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Change order status alters Order Total](/forum/35-orders-management/870274-change-order-status-alters-order-total#167471 "-- 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?")*

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.

[ ![order.png](/forum/attachment/18992) ](/forum/attachment/18992 "order.png")

[ ![invoice.png](/forum/attachment/18993) ](/forum/attachment/18993 "invoice.png")

- [ ![order.png](/forum/attachment/18992) ](/forum/attachment/18992 "order.png") [ ](/forum/attachment/18992?download=1 "order.png")
- [ ![invoice.png](/forum/attachment/18993) ](/forum/attachment/18993 "invoice.png") [ ](/forum/attachment/18993?download=1 "invoice.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg3MDI3NC1jaGFuZ2Utb3JkZXItc3RhdHVzLWFsdGVycy1vcmRlci10b3RhbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

12 years 2 months ago [\#167544](#167544) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Change order status alters Order Total](/forum/35-orders-management/870274-change-order-status-alters-order-total#167544 "-- 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?")*

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 &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg3MDI3NC1jaGFuZ2Utb3JkZXItc3RhdHVzLWFsdGVycy1vcmRlci10b3RhbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.100 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
