I have uploaded 2 CSV tables, for each site, but on my CA site CSV data converts from USD to CA USD
For example:
CSV(CA)
20$ (for each region)
But on my site it becomes 25,78$(CA USD)
Hello @ussorawayf4404
Kindly follow below link. We have used the same with same scenario.
It may help you!
Thank you
not working
Hi @ussorawayf4404 ,
If you are using multi currency website and you are facing rate issue due to amount getting converted from csv that you have imported then its because of base and display currency settings.
You can add different csv for table rates for different website.
So, I suggest to add different rate in CA CSV.
Example: For CA all region you can add 15.51 rate in CSV which will convert on front-end and customer can see 20 shipping rate for CA as well.
Hope it helps!
Thanks
Hello @ussorawayf4404
Please update the website-based currency rate of the CA site to the CA currency and the US website to USD currency based on this configuration your issue gets solved.
If my answer is helpful full then please set the accept solution flag and kudos flag so other members can take the same reference.