Hi, I believe I managed to do this by commenting out the following pieces of code in product.php:
First this section:
Code:
if($variants>500){
$this->database->setQuery($query.implode(',',$insert).';');
$this->database->query();
$this->database->setQuery('SELECT product_id,product_code FROM '.hikashop_table('product').' WHERE product_code IN ('.implode(',',$db_codes).')');
$objs = $this->database->loadObjectList();
foreach($objs as $obj){
foreach($codes[$obj->product_code] as $k){
$newVariants[]= '('.(int)$k.','.$obj->product_id.',0)';
}
}
if(!empty($newVariants)){
$this->database->setQuery('INSERT IGNORE INTO '.hikashop_table('variant').' (variant_characteristic_id,variant_product_id,ordering) VALUES '.implode(',',$newVariants));
$this->database->query();
}
$codes=array();
$variants=0;
$insert=array();
$db_codes=array();
$newVariants =array();
and this section of code:
Code:
if(!empty($insert)){
$this->database->setQuery($query.implode(',',$insert).';');
$this->database->query();
$this->database->setQuery('SELECT product_id,product_code FROM '.hikashop_table('product').' WHERE product_code IN ('.implode(',',$db_codes).')');
$objs = $this->database->loadObjectList();
foreach($objs as $obj){
foreach($codes[$obj->product_code] as $k){
$newVariants[]= '('.(int)$k.','.$obj->product_id.',0)';
}
}
if(!empty($newVariants)){
$this->database->setQuery('INSERT IGNORE INTO '.hikashop_table('variant').' (variant_characteristic_id,variant_product_id,ordering) VALUES '.implode(',',$newVariants));
$this->database->query();
}
}
