I would like to request temporary access (wp-admin and FTP) to your site to test the issue.
(preferably to a test site where the problem has been replicated if possible)
**Before we proceed It is necessary to take FULL BACKUP of your database and your website. Providing us with access, you agree that a backup has been taken **
I often use the Duplicator plugin for this purpose: http://wordpress.org/plugins/duplicator/
You will find the needed fields for this below the comment area when you log in to leave your next reply.
The information you enter is private which means only you and I have access to it.
NOTE: If access to the live site is not possible and the staging site does not exist please provide me with a duplicator package created with the duplicator plugin.
I have run a few tests and it took me a few attempts to reproduce the issue this time around (reloading the checkout page at least 3-5 times).
--- In the settings I set the currency for USD to be twice the cost of EUR to make it easy to see if what pulls through is just the currency icon or the price as well.
It looks like the currency along with the EUR price is pulled through.
I also see this error when logging in the site now:
WordPress database error: [Unknown column 'posts.ID' in 'on clause']
SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM db5q_wc_orders AS orders INNER JOIN db5q_woocommerce_order_items AS order_items ON orders.id = order_id INNER JOIN db5q_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN db5q_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id INNER JOIN db5q_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.type IN ( 'shop_order' ) AND orders.status IN ( 'wc-completed','wc-processing','wc-on-hold' ) AND order_item_meta.meta_key = '_qty' AND order_item_meta_2.meta_key = '_product_id' AND orders.date_created_gmt >= '2024-08-01' AND orders.date_created_gmt <= '2024-08-23 02:10:44' AND currency_postmeta.meta_key = '_order_currency' AND currency_postmeta.meta_value = 'EUR' GROUP BY product_id ORDER BY qty DESC LIMIT 1
The issue at the moment looks like a possible compatibility issue.
Do I have your permission to migrate a copy of your site onto our Cloudways staging servers for further debugging?
As a sidenote I believe Woopayments also offers this option and it is a free plugin from WC.
might be worth a try.
You can let their support (Mollie payments) know that the checkout page loads correctly in USD but then refreshes and pulls the EUR currency due to no available payment method for USD.
The topic ‘[Closed] The total amount in Woocommerce is shown in € instead $’ is closed to new replies.
