Issue with Price display in orders export
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hi there,
We're having an issue with orders statistics in WooCommerce, specifically regarding price display for the added currency (EUR) with FOX currency switcher.
Our setup includes EUR and USD currencies, with USD set as the main currency in woocommerce. We have different tax rates based on the visitor's country, and woocommerce settings are configured to display all prices in the shop, cart, and checkout with included tax.
The problem arises when viewing order statistics, for instance, when exporting orders (Analytics -> Orders -> Download). For EUR orders, the columns"Order Subtotal Amount" and"Item cost" display prices without tax (see screenshot). This issue doesn't occur for USD orders, and the"Order Total Amount" field correctly displays prices for both currencies.
This inconsistency is causing troubles running statistics, especially for orders with multiple products. Any guidance on solving this and ensuring all prices, including the Order Subtotal Amount and Item cost, are saved in database with tax included would be appreciated.
Thanks for your assistance!
Hello
What plugin version number are you using?
How this is displayed on the order editing page?
Thank you for your quick reply.
I have my plugins updated, so it is Version 1.4.1.7.
If I open the order it is also shown with tax, which it shouldn be.
Screenshot of EUR order - https://ibb.co/t8q8Kxr
Screenshot of USD order - https://ibb.co/MRgzsky
Kind regards,
Marty
Hello Marty
Please drop me wp-admin access - https://clip2net.com/s/4kgbvfT ->https://c2n.me/4kgbxcZ.png i will check it
I apologize for the delayed response. We are still experiencing this issue and would greatly appreciate a solution I've sent you the access data. Please tell me if this kind of support is only available with the PRO plan, so we can resolve this quickly.
Additionally, I have a question regarding testing USD currency on landing pages (I'm from europe). Is there any better way other than using VPN everytime?
Thank you
We've just purchased the Pro plugin because we really want this issue to be resolved. I've added the code into the access data.
Hello
You shouldn't have bought a plugin before you were sure it worked correctly.
This is a very strange error because the plugin does not affect tax rates in analytics. We need to find patterns:
Does this happen with all orders in EUR?
Is this field empty for all orders (EUR)? - https://share.pluginus.net/image/i20240226171420.png
Are these orders made in the same payment system?
do you have a test/staging site?
Hi Pablo,
I'm sorry for a bit late reply. The plugin works for us, especially in its ability to geo-locate visitors and display the correct currency on all pages.
We can also run statistics, but only by using Order Total.
Now to answer your questions:
1. Yes, this happens to all orders in EUR. As an interesting fact: we have established another online store where we also use your plugin and we have the same exact issue. I've added access data into Private data box.
2.Yes, this field is empty for all EUR and USD orders as well.
3.No, these orders are not made in same payment system. Its variety of credit cards, paypal, applepay and googlepay.
For your information, we have also added this filter on both our sites in our functions file:
add_filter( 'woocommerce_adjust_non_base_location_prices', '__return_false' );
This ensures that the same price is shown on the frontend regardless of taxes and the selected country.
To summarize our issue again: In orders paid in EUR, the individual item price is saved without tax. This is noticeable when reviewing individual orders or exporting our order data. This makes it tricky for us to track individual product sales accurately.
Currently we don't have testing site yet. Please tell me if its neccesary to create one.
Please tell me if you need any more information.
Hello
Ok! It would be great if you make a test site and give me wp-admin+ftp access
The thing is that I can’t reproduce this error on my site (I’m missing some settings).