Wrong prices when importing to Woocommerce with WPML and WPML All Import

Hello,
This is a very strange issue I agree with you.
Would it be possible that you open a new ticket in our forum at wpml.org so that we can properly investigate this?
I am not sure if you are setting the prices manually for the second currency how this is being imported in via WP All Import.
Are you sure that the prices are imported properly?
Maybe you are missing the price in the default currency? You need to have that price set too.
Or maybe the prices are being recalculated automatically based on the exchange rate that you specified.
What happens if you change the exchange rate?

Hello George,

Thanks for your reply.

I opened here, because I noticed that around here the tickets are answered and solved much faster ??
But here it is the ticket in the wpml.org forum : https://wpml.org/forums/topic/wrong-prices-when-importing-to-woocommerce-with-wpml-and-wpml-all-import/

Regarding your questions :
No, the prices are being set correctly in the import for both currencies. I know this, because as I said, when I edit the product the prices in the variations for both currencies are set correctly… and if I save the product without making any changes, the prices start showing correctly …

I didn’t thought that the prices were being recalculated based on exchange rate, because I’m not using that option, I’m using the following option in the variations : “Set prices in other currencies manually”.

But, after your suggestion, I tried to change the exchange rate and after importing I do see a different price in the frontend. I edit the product, save and it’s all good in the frontend … So, there’s definitely something not being correctly set or missing when importing.

Besides, importing all the necessary woocommerce fields using the All Import woocommerce addon, I’m also setting up the following custom fields to work with WPML:
_regular_price_USD (price in USD)
_wcml_custom_prices_status (= 1)
_sale_price_USD (price in USD)
_variation_description
_regular_price (price in EUR – store base currency)
_sale_price (price in EUR – store base currency)
_price (price in EUR – store base currency)

If you prefer we could continue in the wpml forum, and I cloud give you access to our dev site.

Thanks,
Adriano

Ok, your questions made me dig a bit more, and after 2 changes I fixed it and prices are now being displayed correctly after import.

First :
The All import woocommerce addon says “Regular Price (€)”, do you see the “€” (EUR) sign?
So, I was adding my EUR price there, but it seems that because I’m importing to my wordpress base language (English), and the currency in English is not EUR it’s USD, I have to put there the price in USD. So, forget the misleading € sign.

Second :
Besides the custom fields I referenced in my previous post, I also needed to set the custom field _price_USD.

These 2 changes fixed it. ??

The first one, it’s a bit tricky, maybe you can add a reference in the WPML All import docs to avoid other people losing so much time, or better yet, make a change so that the correct currency symbol is shown there.

Thanks for your questions that lead me to the solution ??

Regards, Adriano

It is nice that you found a solution. I am very happy for that.
If I understand you correctly, the problem is that for your language that you are doing the import – you have another currency set as default. Is that correct?

It took me a while to get the appropriate plugin and an environment set on my local machine and I am going to test that now.
As far as I can see – the price in the WooCommerce import plugin is always shown to be in the default currency.
About the second part – yes, it is always needed to have all the price fields imported – otherwise, problems may occur as you discovered for yourself.

Yes, you are right, this is the scenario :
– WordPress default language : English
– WC base/default currency : EUR
– English currency : USD
– I’m importing to English/USD

You are also right that in the WC import plugin it’s always shown the base/default currency.

I am having issues reproducing the problem.
If your offer to provide me some import files is still valid, I would like to take you up on that.

Sure. Were can I send you the files?

I will activate the private reply in your ticket in wpml.org so you can share a link.

Ok, private reply sent with as many details as possible, but if you have any additional questions or need any additional information, please let me know.

Thanks.