Skip to content Skip to sidebar

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: 

This topic contains 6 replies, has 1 voice.

Last updated by martinS-7 1 week, 3 days ago.

Assisted by: Laura.

Author Posts
August 16, 2025 at 1:21 pm #17324862

martinS-7

Background of the issue:
I'm trying to automate setting prices in other currencies manually for new products when importing from an Excel file. I'm using the Import WooCommerce Products using Import Export Suite for WooCommerce plugin to import the Excel file. I found a support article on WPML that addresses this issue, but the solution is private.

Symptoms:
The solution to automate setting prices in other currencies is private, and I need assistance with it.

Questions:
How can I automate setting prices in other currencies for new products when importing from an Excel file?
Is there a way to access the private solution mentioned in the WPML support article?

August 18, 2025 at 4:11 pm #17328693

Lauren
WPML Supporter since 10/2015

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

Thank you for contacting WPML support. While you are waiting for one of my colleagues to take this ticket and work on it, let me provide you with first debugging steps or if I can perhaps help with the issue quickly. Please share a link to the ticket where you found the private solution and we will be happy to look further into this for you.

August 18, 2025 at 4:18 pm #17328731

Bigul
WPML Supporter since 01/2013

Languages: English (English )

Timezone: Europe/Vienna (GMT+02:00)

Hello,

Welcome to the WPML support forum. Before passing this thread to my colleague, I would like to share some suggestions and possible solutions for the issues you mentioned.

To help you faster, I have enabled the option to share debug information in this ticket. Please follow the steps in this link to provide it:
http://wpml.org/faq/provide-debug-information-faster-support/

This seems to be a custom requirement. We would like to confirm whether you are referring to the following tickets. Please check and let us know your feedback.

https://wpml.org/forums/topic/automating-set-prices-in-other-currencies-manually-for-new-products/

https://wpml.org/forums/topic/can-i-set-set-prices-in-other-currencies-manually-as-default-on-the-product-page/

--
Thanks!

Bigul

August 18, 2025 at 9:47 pm #17329512

martinS-7

Hi and yes this is the tickets I'm referring to.

August 19, 2025 at 1:35 pm #17331612

Laura
WPML Supporter since 05/2018

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

Hello, I will take care of your ticket from now on.

I can see this ticket https://wpml.org/forums/topic/automating-set-prices-in-other-currencies-manually-for-new-products/ has a summary, can't you see it?

August 19, 2025 at 2:22 pm #17331777

martinS-7

Hi and yes I can see that ticket. But I don't understand the solution, and if I click on the other tcket it's private:

https://wpml.org/forums/topic/can-i-set-set-prices-in-other-currencies-manually-as-default-on-the-product-page/#post-15771848

August 19, 2025 at 2:43 pm #17331829

Laura
WPML Supporter since 05/2018

Languages: English (English ) Italian (Italiano )

Timezone: Europe/Rome (GMT+02:00)

The solution is this one

Since there is no central feature in the WooCommerce Multilingual plugin to switch to the manual price option for variations, you need to use custom coding. Add the following code to the functions.php file of your theme to set 'Set prices in other currencies manually' as the default for new product variations:

function set_default_manual_currency_pricing($post_id) {
    if (get_post_type($post_id) === 'product_variation') {
        update_post_meta($post_id, '_wcml_custom_prices_status', '1');
    }
}
add_action('save_post', 'set_default_manual_currency_pricing', 20, 1);

To apply this change to existing product variations, add this code, run it once, and then remove or comment it out:

function update_existing_variations_to_manual() {
    $args = array(
        'post_type'   => 'product_variation',
        'post_status' => 'publish',
        'numberposts' => -1,
    );

    $variations = get_posts($args);

    foreach ($variations as $variation) {
        update_post_meta($variation->ID, '_wcml_custom_prices_status', '1');
    }
}
add_action('init', 'update_existing_variations_to_manual');

If you need further assistance with custom coding, consider hiring a professional developer.

Note that we can't provide full support for custom coding so as suggested in the ticket if you need further help you should hire a developer.

August 19, 2025 at 4:49 pm #17332298

martinS-7

Thanks a lot.
It seems to be working just fine.

I hope this feature to switch to the manual price option for variations will be added to WooCommerce Multilingual plugin in the future.

Thanks again