Developer forum

Forum » Ecommerce - Standard features » Shipping Fee rules based on VAT price

Shipping Fee rules based on VAT price

Gunnar Örn Baldursson
Reply

Hi, I was debugging some shipping fee rule setups for a client and it seems to me they have it configured such that rules are applied after discount calculation on product price without VAT stored in the database. However, they want to setup rules that are applied after product with VAT calculation and discount are applied but I've not found anything in the configuration that would make it so. 

Only solution I've been able to think of for them is to change the prices to be stored with VAT in the DB which would require some bit of work in other parts of the application, is there a different solution to this?

Their application version:  9.12.4

Kind regards,

Gunnar


Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

HI Gunnar,

I've quickly checked the issue on last DW9.13.8 and was not reproduce it. What scenario did you check in the debugging and specify conditions regarding product prices are provided via matrix/aren't and which VAT option is uses inside the matrix? Specify VAT using in frontend as well, please. We need more deep research to comment final solution. Thanks.

BR, Oleg QA 

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Reply

Hi Gunnar,

There is a setting for whether shipping fee should be calculated from product prices with or without VAT.
Is that what you are looking for?

/Morten

 
Gunnar Örn Baldursson
Reply

Hi, thanks for your replies

@Morten, I had tried that setting and it seemed to add the VAT percentage to the applied Shipping Fee so I turned it off again. I've tested it again on the staging server and I don't see it actually changing anything there so I'm not sure about that.

As for more details about their config, they're using DW 9.12.4 and an integrated ERP system without complex price matrices. They simply import the price without VAT into the ProductPrice field on EcomProducts. They have a single currency and country setup, which adds 24% VAT to that price. If there is a specific setting you wish me to check, please let me know.

I've added a few pictures as attachments to hopefully better show the client is asking about. The total price for my product in the images is 719 iSK after discount, the shipping method I then added has the rule to add shipping fee of 790 ISK if the price is < 600 ISK. Once I add the shipping method, the extra fee is added, and then the discount is subtracted from the total, instead of what they expected which was the total price to simply remain as 719 ISK. Best reason I can guess, is that the rule was triggered because the free shipping is based on discounted price, and the raw product price without discount goes under the < 600 ISK condition on my shipping method.

Hopefully that clarifies some things :)

-Gunnar

 

 

1.shipping_settings.PNG 2.price_price_total.PNG 3.shipping_fee_rule.PNG
 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

Hi Gunnar,

First of all, please, have a look at the attachment to understand meaning using of the default fee. I suppose the fee will always be applied in you case, use 'Total price' amount in a rule added instead. Refer to manual for details as well. Perhaps, Morten has other opinion, welcome.

BR, Oleg QA

 

2022-06-21_08-47-39.png
 
Gunnar Örn Baldursson
Reply

They're trying to use the setting below the one you highlighted, to only add shipping fee if the total price of the order is above a threshold, in which case, the default fee is not applied. They do not have a rule matrix, they're only using the default fee and free shipping settings. I don't see an option in the rule matrix to add a fee if the total price is below a value.

They are asking, can the free shipping not be applied after discount calculation on the price with VAT?

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply
This post has been marked as an answer

Hi,

New task 8261 has been submitted to add new option in shipping settings to handle free fee shipping amount corresponds to order prices with/without VAT. I hope it will be fixed soon.

BR, Oleg QA

Votes for this answer: 1

 

You must be logged in to post in the forum