Hi,
Thanks for the report, we have corrected on our end.
To correct that thanks to edit the plugin "plg_hikashop_massaction_product" and replace the function "onProcessProductMassFiltercharacteristicColumn()", by:
function onProcessProductMassFiltercharacteristicColumn(&$elements,&$query,$filter,$num){
if(empty($filter['type']) || $filter['type']=='all') return;
if(!isset($this->massaction))$this->massaction = hikashop_get('class.massaction');
if(count($elements)){
foreach($elements as $k => $element){
$filter['type'] = strtolower($filter['type']);
if(!isset($element->$filter['type'])){
$in = false;
}else{
$in = $this->massaction->checkInElement($element, $filter);
}
if(!$in) unset($elements[$k]);
}
}else{
$db = JFactory::getDBO();
if(!empty($filter['value'])){
$query->leftjoin['variant'.$num] = hikashop_table('variant').' AS hk_variant'.$num.' ON hk_variant'.$num.'.variant_product_id = hk_product.product_id';
$query->leftjoin['characteristic'.$num] = hikashop_table('characteristic').' AS hk_characteristic'.$num.' ON hk_characteristic'.$num.'.characteristic_id = hk_variant'.$num.'.variant_characteristic_id';
$query->leftjoin['characteristic_parent'.$num] = hikashop_table('characteristic').' AS hk_characteristic_parent'.$num.' ON hk_characteristic'.$num.'.characteristic_parent_id = hk_characteristic_parent'.$num.'.characteristic_id';
//$query->where[] = 'hk_characteristic.characteristic_value'.' '.$filter['operator'].' '.$db->quote($filter['value']).' AND hk_characteristic_parent.characteristic_value = '.$db->quote($filter['type']).'';
if(!empty($filter['value']) || (empty($filter['value']) && in_array($filter['operator'],array('IS NULL','IS NOT NULL')))){
$rquery = str_replace($filter['type'],'',$this->massaction->getRequest($filter));
$query->where[] = 'hk_characteristic'.$num.'.characteristic_value '.$rquery.' AND hk_characteristic_parent'.$num.'.characteristic_value = '.$db->quote($filter['type']).'';
}
}
}
}