How to add extra field?

Code: Select all

Notice: Undefined offset: 13 in .../htdocs/catalog/admin/model/tool/export.php on line 266Notice: Undefined offset: 16 in .../htdocs/catalog/admin/model/tool/export.php on line 269Notice: Undefined offset: 23 in .../htdocs/catalog/admin/model/tool/export.php on line 275Notice: Undefined offset: 24 in .../htdocs/catalog/admin/model/tool/export.php on line 276Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''felina','0','0','0','','in',1,'testing agai',0,and finally,'data/felina-parchme' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`cleaning_code`,`repeat_dir`,`xroll_dir`,`fabric_dir`,`roll_width`,`manufacturer_id`,`image`,`shipping`,`price`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`,`cost`) VALUES (1,0,'','',,'felina','0','0','0','','in',1,'testing agai',0,and finally,'data/felina-parchment-500x500.jpg','','yes',0,0,0,0,lb,0,1,,'0','1','1','1',0);

Code: Select all

// generate and execute SQL for storing the products
		foreach ($products as $product) {
			$productId = $product[0];
			$productName = $database->escape($product[1]);
			$categories = $product[2];
			$quantity = $product[3];
			$model = $database->escape($product[5]);
			$manufacturerName = $product[6];
			$manufacturerId = ($manufacturerName=="") ? 0 : $manufacturerIds[$manufacturerName];
			$imageName = $product[7];
			$shipping = $product[9];
			$shipping = ((strtoupper($shipping)=="YES") || (strtoupper($shipping)=="Y")) ? 1 : 0;
			$price = trim($product[10]);
			$dateAdded = $product[12];
			$dateModified = $product[13];
			$dateAvailable = $product[14];
			$weight = ($product[15]=="") ? 0 : $product[15];
			$unit = $product[16];
			$weightClassId = (isset($weightClassIds[$unit])) ? $weightClassIds[$unit] : 0;
			$status = $product[17];
			$status = ((strtoupper($status)=="TRUE") || (strtoupper($status)=="YES") || (strtoupper($status)=="ENABLED")) ? 1 : 0;
			$taxClassId = $product[20];
			$viewed = $product[21];
			$productDescription = $database->escape($product[23]);
			$stockStatusId = $product[24];
			$meta_description = $database->escape($product[25]);
			$length = $product[26];
			$width = $product[27];
			$height = $product[28];
			$keyword = $database->escape($product[29]);
			$lengthUnit = $product[30];
			$cleaning_code = $database->escape($product[31]);
			$repeat_dir = $database->escape($product[32]);
			$xroll_dir = $database->escape($product[33]);
			$fabric_dir = $database->escape($product[34]);
			$roll_width = $database->escape($product[35]);
			$lengthClassId = (isset($lengthClassIds[$lengthUnit])) ? $lengthClassIds[$lengthUnit] : 0;
			$sku = $database->escape($product[36]);
			$location = $database->escape($product[37]);
			$storeIds = $product[38];
			$related = $product[39];
			$tags = $database->escape($product[40]);
			$subtract = $product[41];
			$subtract = ((strtoupper($subtract)=="TRUE") || (strtoupper($subtract)=="YES") || (strtoupper($subtract)=="ENABLED")) ? 1 : 0;
			$minimum = $product[42];
			$cost = trim($product[43]);
			$meta_keywords = $database->escape($product[44]);
			$sort_order = $product[45];
			$sql  = "INSERT INTO `".DB_PREFIX."product` (`product_id`,`quantity`,`sku`,`location`,";
			$sql .= "`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,";
			$sql .= "`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`cleaning_code`,`repeat_dir`,`xroll_dir`,`fabric_dir`,`roll_width`,`sort_order`,`subtract`,`minimum`,`cost`) VALUES ";
			$sql .= "($productId,$quantity,'$sku','$location',";
			$sql .= "$stockStatusId,'$model',$manufacturerId,'$imageName',$shipping,$price,";
			$sql .= ($dateAdded=='NOW()') ? "$dateAdded," : "'$dateAdded',";
			$sql .= ($dateModified=='NOW()') ? "$dateModified," : "'$dateModified',";
			$sql .= ($dateAvailable=='NOW()') ? "$dateAvailable," : "'$dateAvailable',";
			$sql .= "$weight,$weightClassId,$status,";
			$sql .= "$taxClassId,$viewed,$length,$width,$height,'$lengthClassId','$cleaning_code','$repeat_dir','$xroll_dir','$fabric_dir','$roll_width','$sort_order','$subtract','$minimum',$cost);";
			$sql2 = "INSERT INTO `".DB_PREFIX."product_description` (`product_id`,`language_id`,`name`,`description`,`meta_description`,`meta_keywords`) VALUES ";
			$sql2 .= "($productId,$languageId,'$productName','$productDescription','$meta_description','$meta_keywords');";
			$database->query($sql);
			$database->query($sql2);
			if (count($categories) > 0) {
				$sql = "INSERT INTO `".DB_PREFIX."product_to_category` (`product_id`,`category_id`) VALUES ";
				$first = TRUE;
				foreach ($categories as $categoryId) {
					$sql .= ($first) ? "\n" : ",\n";
					$first = FALSE;
					$sql .= "($productId,$categoryId)";
				}
				$sql .= ";";
				$database->query($sql);
			}
			if ($keyword) {
				$sql4 = "INSERT INTO `".DB_PREFIX."url_alias` (`query`,`keyword`) VALUES ('product_id=$productId','$keyword');";
				$database->query($sql4);
			}
			foreach ($storeIds as $storeId) {
				$sql6 = "INSERT INTO `".DB_PREFIX."product_to_store` (`product_id`,`store_id`) VALUES ($productId,$storeId);";
				$database->query($sql6);
			}
			if (count($related) > 0) {
				$sql = "INSERT INTO `".DB_PREFIX."product_related` (`product_id`,`related_id`) VALUES ";
				$first = TRUE;
				foreach ($related as $relatedId) {
					$sql .= ($first) ? "\n" : ",\n";
					$first = FALSE;
					$sql .= "($productId,$relatedId)";
				}
				$sql .= ";";
				$database->query($sql);
			}
			if (count($tags) > 0) {
				$sql = "INSERT INTO `".DB_PREFIX."product_tags` (`product_id`,`tag`,`language_id`) VALUES ";
				$first = TRUE;
				$inserted_tags = array();
				foreach ($tags as $tag) {
					if ($tag == '') {
						continue;
					}
					if (in_array($tag,$inserted_tags)) {
						continue;
					}
					$sql .= ($first) ? "\n" : ",\n";
					$first = FALSE;
					$sql .= "($productId,'".$database->escape($tag)."',$languageId)";
					$inserted_tags[] = $tag;
				}
				$sql .= ";";
				if (count($inserted_tags)>0) {
					$database->query($sql);
				}
			}
		}