Hi,
Try replacing the code:
if(!empty($concat) && count($concat))
$p_code = 'CONCAT('.$p_code.', '.implode(',\'_\',', $concat).')';
$query = 'INSERT IGNORE INTO '.hikashop_table('product').' (product_code, product_type, product_parent_id, product_published, product_modified, product_created, product_group_after_purchase) '.
' SELECT '.$p_code.' as c_product_code, '. $this->database->Quote('variant') .','. (int)$product_id . ','.(int)$config->get('variant_default_publish',1).',' . $t . ',' . $t . ',' . $this->database->Quote(@$element->product_group_after_purchase) .
by:
$config =& hikashop_config();
$symbols = explode(',',$config->get('weight_symbols', 'kg,g'));
$weight_unit = $symbols[0];
$symbols = explode(',', $config->get('volume_symbols', 'm,cm'));
$volume_unit = $symbols[0];
if(!empty($concat) && count($concat))
$p_code = 'CONCAT('.$p_code.', '.implode(',\'_\',', $concat).')';
$query = 'INSERT IGNORE INTO '.hikashop_table('product').' (product_code, product_type, product_parent_id, product_published, product_modified, product_created, product_group_after_purchase, product_weight_unit, product_dimension_unit) '.
' SELECT '.$p_code.' as c_product_code, '. $this->database->Quote('variant') .','. (int)$product_id . ','.(int)$config->get('variant_default_publish',1).',' . $t . ',' . $t . ',' . $this->database->Quote(@$element->product_group_after_purchase).','.$this->database->Quote($weight_unit).','.$this->database->Quote($volume_unit).
' FROM ' . implode(', ', $tables);
in the file administrator/components/com_hikashop/classes/product.php
Note that it will only work when you create new variants. Existing ones won't be affected.