Notice: Error: 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 ‘=IF(K2>0,“7”,“5”),‘PNW Arms’,152,‘data/Products Pictures/pnwpic300blkhnt125btip2’ at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`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`) VALUES (1,5,‘93579’,‘855118002572’,’‘,’‘,‘83964’,‘300BLKHNT125BTIP20’,’‘,=IF(K2>0,“7”,“5”),‘PNW Arms’,152,‘data/Products Pictures/pnwpic300blkhnt125btip20.jpg’,1,23.3625,0,NOW(),NOW(),NOW(),0.8,5,0,11,0,5,2.625,1.5,‘3’,‘1’,‘0’,‘1’); in/hermes/bosweb26a/b1700/ipg.athetralcom/Athetral/system/database/mysql.php on line 49
=======================================================================================
I am trying to import excel sheet in opencart admin panel. I got this error only when i put formulas in my excel sheet. I tried without formula and import the excel sheet and it worked but not with FORMULA. please help me to find out the root cause of this error. In addition, i am a drop shipper with around 40k products in the excel sheet. when i try to upload the excel sheet at the same time with 40 k products, it doesn’t give me any error and get blank (nothing upload or happen). Please let me know from which file this error coming so i can fix it,Please give me your suggestion.
Thansk