OpenCart Community

I am using this AMAZING tool to set up a couple shops, but I'm having a problem. It's only exporting SOME of the products. I need to edit ALL my products!! The categories are all there, but only about half of the products. I have less than 30 products total.

Please help!!

Thanks in advance!

I am unable to replicate your error, if any.

If you send me a PM with your FTP and Opencart details then I can take a look at it.

Hi
I have been using Export/Import tool very successfully and it has saved me many hours. Today I tried exporting the db, and it is exporting a database that says the extension is a different format than the specified file extension. Then when it does open after cancelling that error, the excel spreadsheet is blank. I need your urgent help on this please.

Thanks

I was successful with importing several versions of the product database, but am suddenly getting this error message:

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 '' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`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 (227,1000,'0','',7,'chunwasi61x8',0,'data/Products/aa_no_image.jpg',1,5.95,'2011-05-06 11:09:00','0000-00-00 00:00:00','2011-04-17',#N/A,0,1,9,0,0,0,0,'3','1','1','1',0);

Any ideas on how to fix?

WebDev22 wrote:I was successful with importing several versions of the product database, but am suddenly getting this error message:

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 '' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`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 (227,1000,'0','',7,'chunwasi61x8',0,'data/Products/aa_no_image.jpg',1,5.95,'2011-05-06 11:09:00','0000-00-00 00:00:00','2011-04-17',#N/A,0,1,9,0,0,0,0,'3','1','1','1',0);

Any ideas on how to fix?

You have a wrong value in your 'weight' field.

JNeuhoff wrote:

WebDev22 wrote:I was successful with importing several versions of the product database, but am suddenly getting this error message:

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 '' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`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 (227,1000,'0','',7,'chunwasi61x8',0,'data/Products/aa_no_image.jpg',1,5.95,'2011-05-06 11:09:00','0000-00-00 00:00:00','2011-04-17',#N/A,0,1,9,0,0,0,0,'3','1','1','1',0);

Any ideas on how to fix?

You have a wrong value in your 'weight' field.

That was it. Three of the records had a value of "#N/A", which caused the script to fail because it was expecting the value to be numeric. Thanks.

I have a product image that appears fine on the item page level, but it doesn't appear on the category page level. Any ideas what could cause this?

WebDev22 wrote:I have a product image that appears fine on the item page level, but it doesn't appear on the category page level. Any ideas what could cause this?

I don't thin that's an issue with the Export/Import tool. Post your URLs hereof your product and category pages so we can see what's wrong.

I can't add items to cart and think I know why. All the weights in the shopping cart admin are set to "Kilogram", but need to be "Pound". I have a field in my spreadsheet called "units", which were all set to "lbs", but I changed it to "Pound", thinking that was going to resolve the problem. It did not. I then changed "units" to "Weight Class" and reuploaded, but that didn't fix the problem.

I manually changed one of the items to "Pound' and was able to add that product to cart on the front end. So, I exported the database to see where and what to edit, but the "unit" field was blank for all the items. Any ideas on what else to try to get this fixed?

WebDev22 wrote:I can't add items to cart and think I know why. All the weights in the shopping cart admin are set to "Kilogram", but need to be "Pound". I have a field in my spreadsheet called "units", which were all set to "lbs", but I changed it to "Pound", thinking that was going to resolve the problem. It did not. I then changed "units" to "Weight Class" and reuploaded, but that didn't fix the problem.

I manually changed one of the items to "Pound' and was able to add that product to cart on the front end. So, I exported the database to see where and what to edit, but the "unit" field was blank for all the items. Any ideas on what else to try to get this fixed?

I figured it out. The "unit" field needed "lb" instead of "lbs" or "Pound".

I'm trying to use your tool with 1.4.9.4 opencart. Downloaded latest version from MHC download section. It works, but I get only numbers in exported XLS. No text, like it drops strings. Even Columns titles are blank, I have only numbers. I have cyrillic text, using UTF-8 encoding.

I have installed a new theme (Shoppica) and installed export/import Tool. It has worked perfectly in all other themes I installed, but this time it keeps telling me that Permission is Denied. I have setup all my users to Top Adminsitrator, but nothing seems to work. Please can you help me, as I desperately need to have this Tool work, as I have thousands of products to load.

Tobievr wrote:I have installed a new theme (Shoppica) and installed export/import Tool. It has worked perfectly in all other themes I installed, but this time it keeps telling me that Permission is Denied. I have setup all my users to Top Adminsitrator, but nothing seems to work. Please can you help me, as I desperately need to have this Tool work, as I have thousands of products to load.

System > Users > User Groups > Edit Top Administrator >

Access Permission on: tool/export
Modify Permission on: tool/export

Thanks for your reply, but I have done exactly what you have said. It gives me the option to export under System>Export, but when I go to Users>Top Administrator the Tool/Export is not there. I checked with my other site, so I know what it should look like. Is there a possible conflict with the theme?

hey, thanks very much, but I sat and figured it out. Missed one of the processes. Sorry for wasting your time.

Thanks

I am using bluehost space, my products over 5000. I get a error xls when I export them.
Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

I tried run SET SQL_BIG_SELECTS=1 and run SET SQL_MAX_JOIN_SIZE=800000 in mysql database, but nothing happened
I asked customer service, they can not help me, they said:"you must modify your database". I do not know what it is meaning.

Anyone can help? how to export products data use this extension. or tell me how to modify in mysql.
thanks

Hi,

I get the following error when I try to edit a product after import:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/system/database/mysql.php on line 55Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/system/database/mysql.php on line 55Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/system/database/mysql.php on line 55Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/system/database/mysql.php on line 55Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/system/database/mysql.php on line 55Warning: Cannot modify header information - headers already sent by (output started at /nfs/c03/h04/mnt/86151/domains/applecart.no/html/admin/index.php:83) in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/vqmod/vqcache/vq2-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /nfs/c03/h04/mnt/86151/domains/applecart.no/html/admin/index.php:83) in /nfs/c03/h04/mnt/86151/domains/applecart.no/html/vqmod/vqcache/vq2-system_engine_controller.php on line 29

This is not working for me, I copied all the files asked for from the folder. Yet in the export/imoprt page I can see the stock export tool, not the new one. VQmod is also installed to support it, what now?

Hi, I installed the mod in my opencart but I cant find the tool/export.php achive when you need to give them permission. How to fix that?

todokeys wrote:Hi, I installed the mod in my opencart but I cant find the tool/export.php achive when you need to give them permission. How to fix that?

You haven't uploaded all the files, or you haven't uploaded them to the correct place.