morroni

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