Developer forum

Forum » Ecommerce - Standard features » Taxes being recalculated when viewing order in backend

Taxes being recalculated when viewing order in backend

Mario Santos Dynamicweb Employee
Mario Santos
Reply

Hi there,

While checking completed orders in the backoffice, when we go to the log section and navigate to a different page, taxes are being recalculated: https://www.screencast.com/t/xEEN2Xs9

DW version - 9.8.6

BR, Mario


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Mario,
we could not reproduce your issue. Do you use some custom moules or custom code's or any Live Integration (custom or standard) or some custom scheduled tasks?
Could you also provider the url to your solution?
From the logs it shows that: OrderHandler: "Sending order to the ERP system" - but we do not have such a string in our Live Integration code.
Also the last lines of the log shows that the order was saved from the other IP address.
And it was saved during the TaskExecute.aspx page which is used in the Scheduled Tasks.
So maybe this is a caching issue and your order is updated by the scheduled task at the time when you are browsing the order logs?

Kind regards, Dmitrij

 
Mario Santos Dynamicweb Employee
Mario Santos
Reply

Hi Dmitriy,

We are using a custom Avalara Tax Provider and a custom Live Integration - but I think none of these are the root cause.
In the Avalara logs we are able to see that a new request was made to Avalara when we went to page 2 - it seems that DW is recalculating taxes again.

Here's the solution url - http://dev-walleye.dw-demo.com/

Thanks,
BR, Mario

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Mario,
yes, indeed it looks like the taxes are recalculated once you get on the second page of the log, you can check the TaxProvider log in the System/Ecom/TaxProvider log folder.
That is caused because the order is considered as "edited/changed" and that is why its taxes then gets recalculated.
I am not just sure what is causing this, I think that could be related to the OrderLineFields values collection.
For that order it shows that in the db, while there are no values stored in the collection:


Could you set this field to the value of: "<OrderLineFieldValueCollection />" in the database and in your Live Integration code when the order is completed and then check if the problem goes away?
Thanks
Kind regards, Dmitrij
 

 
Mario Santos Dynamicweb Employee
Mario Santos
Reply

Hi Dmitriy,

I disabled the LiveIntegration to be out of the equation. The problem still persisted - https://www.screencast.com/t/7Um6fy1O3P
Then, I set the the OrderLineFieldValues column to "<OrderLineFieldValueCollection />" restarted the website and could not reproduce the problem - https://www.screencast.com/t/AjROzbvQ2 - and the Tax Provider logs did not had any new information wrote.

Hope this helps to track down the issue.

BR, Mario

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Mario,
I've created the tfs# 80155 to fix this bug. As a workaround you could try to remove the OrderLineFields from Ecom or in the LiveIntegration try to disabled the option "Include order line custom fields in request" or in the Live integration CheckoutDoneOrderIsCompleteNotificationScubscriber try to set the OrderLineFieldValues field to "<OrderLineFieldValueCollection />" when the Order lines field value collection contains empty values.
Kind regards, Dmitrij

 
Mario Santos Dynamicweb Employee
Mario Santos
Reply

Hi Dmitriy,

My guess is that LiveIntegration unlikely has anything to do with this, because in my last test LiveIntegration was disabled.
It seems that it can be related to the recent edit order feature maybe. Let's see what you guys find out.

Thanks for taking a look.

BR, Mario

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Mario,
you can try to upgrade to the latest Dynamicweb 9.8.7 and check if  your issue is solved.
Kind regards, Dmitrij

 
Mario Santos Dynamicweb Employee
Mario Santos
Reply

Hi Dmitriy,

Yes, the issue is resolved in DW 9.8.7.  Thanks.

BR, Mario

 

You must be logged in to post in the forum