Export / import module by JNeuhoff

I'm running a clean OC v2.0 install with V2.17 of the export/import module.

seem to be unable to import my file. (tried to import an edited exported file using this tool)

I have used the previous version all perfect and there doesn't seem to be a problem generally with the OC v2 one according to recent forum posts..

So i'm thinking its something i'm doing wrong?

here's some of the error code when uploading :

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 ''N/a',12,'',1,0.84,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' 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,0,'0.5M-EE','','','','','','',,'N/a',12,'',1,0.84,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.72,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' 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 (2,0,'0.5M-ESC','','','','','','',,'N/a',12,'',1,0.72,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.8,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' 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 (3,70,'0.5M-ESS','','','','','','',,'N/a',12,'',1,0.8,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.2,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' 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 (4,483,'10-16HPC','','','','','','',,'N/a',12,'',1,0.2,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,1,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1

i've done a few checks cross referencing to other similar issues but no fix.. I have the installer patch installed as well to fix the installing issue.. install..

Thanks!

Anyone? i've made it improve but i still get "duplicate" errors, i've checked through every character etc. i press back on the browser and its seems to have uploaded my file so why am i getting errors showing?

PM JNeuhoff?

Think I may have too, but doesn't really help in future searches when other people come across the same problem.
I could always post the fix after I guess!

Thanks

You need to fill in the stock_status_id which can have the following values on a standard OpenCart 2.0:

7 = In Stock
8 = Pre-Order
5 = Out Of Stock
6 = 2-3 Days

Ah I see how it's formatted now! I think I did fill them in, but if that's what's wrong then I'll do it in a short while.
Thank you for your reply and I'll be back with the result later on.