Bulk editing Woocommerce CSV Import for Euro currency

  • Resolved nickqui7

    (@nickqui7)


    3 years, 9 months ago

    Hi, I am trying to use your plugin to get a fixed Euro Price on the site, all works as expected however I now need to apply this to over 800+ products in a short space of time, now that I have installed the currency plugin I can export all my current products and I see there is a a custom field called “Meta: _regular_price_wmcp” with the one product I manually entered the fixed price for showing as {“EUR”:”27.50″} under it.

    Do you know a way for me to add this pricing format to all 800+ of my product prices, I have all the euro prices listed in excel beside it however because the {“EUR”:”27.50″} is coming up as a function in excel I cannot use the likes of the CONCATENATE formula to bulk add this to other products.

    Have you any idea on how to get round this without me having to manually go through each product and add in a fixed euro price as I would prefer and need to do it via CSV going forward.

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi,

    Are you wanting to bulk import the fixed prices for over 800 products by CSV files?

    The option as you want is not available now.

    We will consider adding this feature on our next update.

    Best regards,

    Any update here? This is a big missing feature.

    Plugin Support mivtt

    (@mivtt)

    Hi,

    This feature is in-building, please kindly follow our plugin changelog.

    Best regards.

    This is possible using functions with WP Import All.

    Under Manage Imports -> Edit Import, add below code to function editor 

    
function encode_currency($currency,$price){
$a= array( $currency => $price);
if($price=='')
	return("");
else
	return(json_encode($a));
}

    Then inside the custom fields section,
    set
    name: _regular_price_wmcp
    value: [encode_currency(“CAD”,{cadpricing[1]})]

    Where cadpricing is the column with the Canadian price.

    Hope that helps.
    Larry

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Bulk editing Woocommerce CSV Import for Euro currency’ is closed to new replies.