In method uploadProducts you need to make sure to access the cells using the correct column indexes:
Code: Select all
.....
$productId = trim($this->getCell($data,$i,1));
if ($productId=="") {
continue;
}
$name = $this->getCell($data,$i,2);
$name = htmlentities( $name, ENT_QUOTES, $this->detect_encoding($name) );
$categories = $this->getCell($data,$i,3);
$sku = $this->getCell($data,$i,4,'0');
$location = $this->getCell($data,$i,5,'0');
$quantity = $this->getCell($data,$i,6,'0');
$model = $this->getCell($data,$i,7,' ');
$manufacturer = $this->getCell($data,$i,8);
$imageName = $this->getCell($data,$i,9);
$shipping = $this->getCell($data,$i,10,'yes');
$price = $this->getCell($data,$i,11,'0.00');
$dateAdded = $this->getCell($data,$i,12);
$dateAdded = ((is_string($dateAdded)) && (strlen($dateAdded)>0)) ? $dateAdded : "NOW()";
$dateModified = $this->getCell($data,$i,13);
$dateModified = ((is_string($dateModified)) && (strlen($dateModified)>0)) ? $dateModified : "NOW()";
$dateAvailable = $this->getCell($data,$i,14);
$dateAvailable = ((is_string($dateAvailable)) && (strlen($dateAvailable)>0)) ? $dateAvailable : "NOW()";
$weight = $this->getCell($data,$i,15,'0');
$unit = $this->getCell($data,$i,16,$defaultWeightUnit);
$length = $this->getCell($data,$i,17,'0');
$width = $this->getCell($data,$i,18,'0');
$height = $this->getCell($data,$i,19,'0');
$measurementUnit = $this->getCell($data,$i,20,$defaultMeasurementUnit);
$cleaning_code = $this->getCell($data,$i,21);
$repeat_dir = $this->getCell($data,$i,22,'0');
$xroll_dir = $this->getCell($data,$i,23,'0');
$fabric_dir = $this->getCell($data,$i,24,'0');
$roll_width = $this->getCell($data,$i,25,'0');
$status = $this->getCell($data,$i,26,'true');
$taxClassId = $this->getCell($data,$i,27,'0');
$viewed = $this->getCell($data,$i,28,'0');
$langId = $this->getCell($data,$i,29,'1');
if ($langId!=$languageId) {
continue;
}
$keyword = $this->getCell($data,$i,30);
$description = $this->getCell($data,$i,31);
$description = htmlentities( $description, ENT_QUOTES, $this->detect_encoding($description) );
$meta_description = $this->getCell($data,$i,32);
$meta_description = htmlentities( $meta_description, ENT_QUOTES, $this->detect_encoding($meta_description) );
$meta_keywords = $this->getCell($data,$i,33);
$meta_keywords = htmlentities( $meta_keywords, ENT_QUOTES, $this->detect_encoding($meta_keywords) );
$additionalImageNames = $this->getCell($data,$i,34);
$stockStatusId = $this->getCell($data,$i,35,$defaultStockStatusId);
$storeIds = $this->getCell($data,$i,36);
$related = $this->getCell($data,$i,37);
$tags = $this->getCell($data,$i,38);
$sort_order = $this->getCell($data,$i,39,'0');
$subtract = $this->getCell($data,$i,40,'true');
$minimum = $this->getCell($data,$i,41,'1');
$cost = $this->getCell($data,$i,42,'0.00');
......
