I am trying to: Add VAT to a secondary currency, but the calculated figures are wrong
Link to a page where the issue can be seen: hidden link
I expected to see: I expect to see the Shipping costs to be rounded to the nearest euro, Zasilkovna: 2.00 €
Instead, I got: When VAT is applied to the primary currency and then converted, the outcome is wrong. Zasilkovna: 1.98 €
Conversion rate is set as 1 Kc = 0.04 euro, VAT rate is 21%.
Zasilkovna shipping cost is set at 41.3 Kc ex VAT, so it's 50 Kc inc VAT.
So it should be 2 € exactly.
In WPML Woocommerce Multicurrency, rounding of euro is disabled, because enabling it gives even worse conversion calculation (2.42 €)
Welcome to WPML Support. I'll do my best to help you solve this issue.
1) I see you are using some 3rd party plugin for shipping. Does the issue happen with regular default WooCommerce shipping methods also?
2) I created a minimal installation of WordPress, WPML, and all necessary WPML add-ons.
You can access the WordPress dashboard using the link below:
- hidden link
Kindly follow the steps below:
- Set up WPML
- Install the necessary plugins.
- Try to replicate the issue with dummy simple example
- Share with me step by step guide on how can I check the issue
This will help us check issues faster and to report the probable issue to the developers' team to solve the possible problem faster.
Yes, I am using a 3rd party plugin for Shipping, but that is not the source of the issue.
I have set up the demo shop, with WPify 3rd party plugin.
This is used to provide a Pickup delivery option to the customer and to integrate with the delivery companies systems.
Kc is primary currency with no decimal places, with Euro at a conversion rate of 1 Kc = 0.04 euro. Euro is set for 2 decimal places.
Shipping options are set up for CZ and SK zones, at 50 Kc (inc 21% VAT) (41.3 ex VAT) and 100Kc (inc 21% VAT) (82.6 ex VAT)
So shipping to CZ costs 50 Kc and 100Kc, when not showing decimal places. Correct!!
But 49.67 Kc and 100.35 Kc ---when Kc is showing 2 decimal places!!!!. Not correct!!
Shipping to SK costs €1.98 and €4.02 when Kc is not showing decimal places. Not correct!!
But €2 and €3.99 ---when Kc is showing 2 decimal places!!!!! Not correct!!
Client needs to show 2 decimal places for euro, and none for Kc.
I know that in the standard WC shipping methods, I can specify a cost in euro, but then the customer has no Delivery pickup options available to them at checkout.
Is it possible to extend this option to specify cost to all Shipping methods?
Also would like to add, that when I use the standard WC Shipping options, and use the Automatic conversion calculations, then the euro costs are still wrong.
So it's not the WPify plugin that is giving incorrect shipping costs, it is coming from the WPML currency convertor.
thanks for getting back and taking the time to reproduce.
1) Is it possible to extend this option to specify the cost to all Shipping methods?
I am not 100% sure I understand, but currently, I do not see such an option, maybe if the plugin author is interested in providing WPML compatibility and making such an option together with WPML developers.
2) So it's not the WPify plugin that is giving incorrect shipping costs, it is coming from the WPML currency convertor.
Great, that is good news as it would mean we can simply reproduce it and escalate it to our developers as a WPML bug.
So, can you please reproduce the issue now without 3rd party plugin, share with me a simple step-by-step guide on how can I see the issue, what goes wrong, and what should be the correct result.
I do not see it without 3rd party plugin, so not really sure how to reproduce it.
If it still happens and is confirmed, I can escalate it to our developers for further debugging.
Steps are as follows:
Add Czech and Slovak languages to WPML.
Configure WPML Multicurrency with Kc and euro. Kc primary and 0.04 conversion rate.
Assign Kc to Czech and euro to Slovak.
2 Decimal places in euro and no rounding.
Choose Currency based on Site Language.
Configure Woocommerce as:
General tab:
Enter some address info and choose Czech Republic as country.
Sell to Czech Republic and Slovakia.
Enable tax rates
0 Decimal places in Czech Currency
Tax tab:
Enter prices inclusive of tax
Calculate based on Shop address
Shipping tax class as Standard
Display prices including tax, for both shop and cart/checkout
Display tax items Itemized
Set up Standard rate of 21% for all countries (*) and assign to Shipping
Set up Reduced rate of 15% for all countries (*), do not assign to Shipping.
Shipping tab:
Create Shipping zone for Czech Republic and add Flat Rate shipping. Configure as Taxable and enter 41.3 for cost. Allow automatic currency calculations.
Create Shipping zone for Slovakia and add Flat Rate shipping. Configure as Taxable and enter 41.3 for cost. Allow automatic currency calculations.
Payments tab:
Enable COD, and configure COD for Flat Rate shipping method and for Czech Republic and Slovakia.
Products:
Create test product in CS, with cost of 500 Kc, and Reduced Tax rate.
Translate product into SK. Cost is still 500 Kc.
Shop:
Go to Shop page in CS language.
Add product to Cart.
Product price is 500 Kc.
Shipping charge is 50 Kc. This is correct, 41.3 +21%(8.67) rounded to nearest.
Product price is €20 (500Kc * 0.04). This is correct.
Flat Rate shipping charge is €1.98. This is incorrect, it should be €2 exactly.
In WPML Multicurrency, if I set euro to have 0 Decimal places, then Shipping cost becomes €1????
If I enable euro Rounding to Nearest 1, Shipping cost becomes €2.42 (€2 + 21%)????
If I set 2 Decimal places in Kc, then euro shipping cost is €2, but CZK shipping cost becomes 49.97 Kc???
thanks for getting back and sharing this helpful guide.
I have checked and could see the issue you described.
Also, I can see, if you set EURO to 0 decimal places and rounding, it shows and works fine. But that is not what you need, since you need Euro set to 2 decimals and KC 0.
I have shared this ticket and info with our 2nd tier support to check and advise.
our second-tier checked the issue and it seems the calculations are correct.
What is happening right now, 41.3 * .04 = 1.65 rounded to 2 then 21% tax added resulting in 2.42 Euro.
What we suggest is to set the shipping price including the tax and disable taxation so shipping cost will be correctly converted and rounded to up.
Please check and let me know if this works for you.
If not, please install on sandbox and set up the shipping plugin you are using on your website then we will check for any solution/settings that might be helpful for you.
As mentioned, there is No Rounding on the euro currency, only 2 Decimal places.
So the calculation should be 41.3 * .04 = 1.652 , then 1.652 +21%, 1.652 + 0.347 = 1.9989.
This is where the rounding should take place, to 2 decimal places, so becoming 2.00.
As for charging shipping without VAT, that won't work either, because the eshop will be shipping to other countries, and to businesses in those other countries.
When a foreign company enters a valid Tax number from their country, the eshop should deduct that 21% from this shipping, along with any VAT on the products themselves.
Setting a service as not taxable is not complying with EU taxation rules.
As for the other shipping plugin, it displayed the same behaviour, but if you can create a new sandbox system for me, I'll set it up for you there.
My issue is not resolved, as it looks like something wrong with how WooCommerce is rounding other currencies.
I'll wait for a proper solution from them, but the support I got from Dražen was excellent.
