for anyone how comes across this post the support guy (Diego) gave me an incredible solution and was crazy fast.
the solution is below:
this goes into the regular price section for WooCommerce WP import. Just remember to put your references from your CSV/XML for price and category by dragging and dropping it.
[example_adjust_price_by_category({cost[1]},{category[1]})]
this goes into the function editor (add categories by copy and pasting a section after the break)
function example_adjust_price_by_category ($price, $category = '') {
if ( !empty($category) ) {
switch($category) {
case 'Shoes':
return $price * 1.2;
break;
case 'Jackets':
return $price * 1.4;
break;
default:
// No category specified, so we return nothing
break;
}
}
}
