Hi,
I am using Export / Import Tool v 2.26 on OC 2.0.3.1 Which I believe is correct
My problem is importing products (categories I have managed to do). Essentially if I use the template that I export of the default products - replacing with my categories and product info then I always get syntax errors on import for the new product entries but the products exported are always imported fine! - I have copied the format of the exported products done everything - bottom line I can only import products that were exported.
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 ''TEST5',0,'s00.jpg',1,1.0,0,NOW(),NOW(),NOW(),1,1,1,1,0,0,0,0,'1','2','1','2')' at line 1
Error No: 1064
INSERT INTO `oc_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 (5666,1,'','','','','','','',,'TEST5',0,'s00.jpg',1,1.0,0,NOW(),NOW(),NOW(),1,1,1,1,0,0,0,0,'1','2','1','2'); in /xxxxxxxxxxxxxxxxxxxxx/system/library/db/mysqli.php on line 41
I am only importing 3 products 2 that were exported from teh shop and 1 that I manually add... once i get this working then I will import the 0ther 6000 products!
All help greatly appreciated.
Regards
andy
I am using Export / Import Tool v 2.26 on OC 2.0.3.1 Which I believe is correct
My problem is importing products (categories I have managed to do). Essentially if I use the template that I export of the default products - replacing with my categories and product info then I always get syntax errors on import for the new product entries but the products exported are always imported fine! - I have copied the format of the exported products done everything - bottom line I can only import products that were exported.
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 ''TEST5',0,'s00.jpg',1,1.0,0,NOW(),NOW(),NOW(),1,1,1,1,0,0,0,0,'1','2','1','2')' at line 1
Error No: 1064
INSERT INTO `oc_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 (5666,1,'','','','','','','',,'TEST5',0,'s00.jpg',1,1.0,0,NOW(),NOW(),NOW(),1,1,1,1,0,0,0,0,'1','2','1','2'); in /xxxxxxxxxxxxxxxxxxxxx/system/library/db/mysqli.php on line 41
I am only importing 3 products 2 that were exported from teh shop and 1 that I manually add... once i get this working then I will import the 0ther 6000 products!
All help greatly appreciated.
Regards
andy
You forgot the stock_status_id which normally contains one of the following numeric values:
7 In Stock
8 Pre-Order
5 Out Of Stock
6 2-3 Days
7 In Stock
8 Pre-Order
5 Out Of Stock
6 2-3 Days
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
Thanks for quick reply - and voila it worked with my test import - many thanks indeed.
now to the 6000+ product import
regards
Andy
Thanks for quick reply - and voila it worked with my test import - many thanks indeed.
now to the 6000+ product import
regards
Andy
You may want to split that into 2 or 3 smaller batches in case you encounter memory_limit problems.now to the 6000+ product import
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
Ok - back to error
Just trying to import two records - first works perfect - 2nd record not imported, no idea why as I have followed exact same format ... could I impose on your help again please?
Regards
andy
Notice: Undefined index: Mirliton in /home/timfitch/public_html/oc/admin/model/tool/export_import.php on line 739Notice: 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 ''/catalog/images/am001.jpg',1,9,0,NOW(),NOW(),NOW(),0.08500000000000001,1,1,0,0,' at line 1
Error No: 1064
INSERT INTO `oc_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,'','','','','','','',5,'AM001',,'/catalog/images/am001.jpg',1,9,0,NOW(),NOW(),NOW(),0.08500000000000001,1,1,0,0,0,0,0,'1','1','1','1'); in /home/xxx/public_html/oc/system/library/db/mysqli.php on line 41
Ok - back to error
Just trying to import two records - first works perfect - 2nd record not imported, no idea why as I have followed exact same format ... could I impose on your help again please?
Regards
andy
Notice: Undefined index: Mirliton in /home/timfitch/public_html/oc/admin/model/tool/export_import.php on line 739Notice: 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 ''/catalog/images/am001.jpg',1,9,0,NOW(),NOW(),NOW(),0.08500000000000001,1,1,0,0,' at line 1
Error No: 1064
INSERT INTO `oc_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,'','','','','','','',5,'AM001',,'/catalog/images/am001.jpg',1,9,0,NOW(),NOW(),NOW(),0.08500000000000001,1,1,0,0,0,0,0,'1','1','1','1'); in /home/xxx/public_html/oc/system/library/db/mysqli.php on line 41
Hi,
yep you are correct - thank you.
(should have realised that having to import categories separately then you woudl need to do the same for manufacturers..._
Slowly getting there and understanding OC ways of doing things.
regards
andy
yep you are correct - thank you.
(should have realised that having to import categories separately then you woudl need to do the same for manufacturers..._
Slowly getting there and understanding OC ways of doing things.
regards
andy
I'm sorry for being a little off-topic
How did you install this add-on?
I tried installing it via Opencart interface and this is what I get
http://s26.postimg.org/l5t7ugsqx/Untitled.png
How did you install this add-on?
I tried installing it via Opencart interface and this is what I get
http://s26.postimg.org/l5t7ugsqx/Untitled.png
Hi,
Sorry I cannot help with the install other than I did exactly what it said in the instructions to install and it worked.
my import all now sorted and I imported 6200+ products in under a minute... very good tool once you ensure you enter all the relevant data for each product.
regards
andy
Sorry I cannot help with the install other than I did exactly what it said in the instructions to install and it worked.
my import all now sorted and I imported 6200+ products in under a minute... very good tool once you ensure you enter all the relevant data for each product.
regards
andy
Who is online
Users browsing this forum: No registered users and 42 guests