OpenCart Community

JNeuhoff wrote:

oc4 wrote:Hi,

probably it is a known issue, but i cant find a solution in forum.
After the import using this tool one can see new categories over web interface ... BUT ALL categories in Catalog->Categories of the Admin UI are disappeared. Same happened with products after import. I checked the DB, new products are in DB, openCart can see them, but Admin UI shows empty Product list. There were no errors in the log.
Can smbd help me?

You are probably using langauges for the front end default language and the admin backend language, please fill in your categories and products data for all languages.

vryannn wrote:I upload the extension and it was fine, then went to modifications and click refresh and got the

"500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed."

JNeuhoff wrote:

SVN wrote:I installed OC 2.0.2.0 and only this export/import extension.
When I export, it works great, I can see all the demo data that is the clean install of OC.

That exported file I open and copy/past some other data in in.
I make sure every line is filled in like the demo data.

This error I get when I'm trying to upload the xlsx file.

2015-05-13 20:15:12 - PHP 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 ''A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1' at line 1<br />Error No: 1064<br />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 (28,12,'','','','','','','',,'A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/A003196/poortautomatisatie.eu/maasland.poortautomatisatie.eu/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP 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 ''AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,' at line 1<br />Error No: 1064<br />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 (29,13,'','','','','','','',,'AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/system/library/db/mysqli.php on line 41

You forgot to set the stock_status_id. On a standard OpenCart 2.0.x
install, it can be one of the following numeric values:

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

Warning: mysqli::query() [mysqli.query]: (21000/1242): Subquery returns more than 1 row in /home/progamershop.cz/progamershop.cz/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=50') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '50' AND pd.language_id = '2' in /home/progamershop.cz/progamershop.cz/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/progamershop.cz/progamershop.cz/admin/model/catalog/product.php on line 345

Hi, im trying to install the module using ocmod but i'm getting this error message, i was wondering if anyone could understand what it was about? Thanks

Ljubo wrote:I have a fresh install on oc 2.0.3 and installed your tool.
However, after successsfull instalation, it gives me Permission Denied error.
The problem is that there is no "tool/export_import" showing under Settings/Users/User Groups/Administrator, so that I can not set access to it.
Weird... any advice?