Export/Import tool for OpenCart 1.5.0.x

Hello, i have a question about the module. I imported the products but if URL Seo mod is enable the subcategories does't show the products. What could be the probleme? Thx in advance.

When i try to import products i get this error:

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 ')' at line 4
Error No: 1064
INSERT INTO `product_to_category` (`product_id`,`category_id`) VALUES (181,59), (181,63), (181,); in /BannerShop.com/system/database/mysql.php on line 49

has anyone else run into this problem? please advise

nefram wrote:Hello, i have a question about the module. I imported the products but if URL Seo mod is enable the subcategories does't show the products. What could be the probleme? Thx in advance.

I don't think this has anything to do with the Export/Import module, rather, this is an issue with your chosen SEO keywords which have to be unique for each main and sub category.

earink wrote:When i try to import products i get this error:

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 ')' at line 4
Error No: 1064
INSERT INTO `product_to_category` (`product_id`,`category_id`) VALUES (181,59), (181,63), (181,); in /BannerShop.com/system/database/mysql.php on line 49

has anyone else run into this problem? please advise

Make sure that for product 181 the categories list in the spreadsheet doesn't have a trailing comma, e.g. it should be something like '59,63', not '59,63,' !

Amazing extension.

Is there a way for me to import options? I need to create options with 90 values (it's for prescription glasses, so there are a lot of options). I know that I can attach options to products, but can I use this tool to create the options? It would save me hours of work.

i2020vision wrote:Amazing extension.

Is there a way for me to import options? I need to create options with 90 values (it's for prescription glasses, so there are a lot of options). I know that I can attach options to products, but can I use this tool to create the options? It would save me hours of work.

Yes, you can. Just do an Export of the Opencart sample data to see the format of the spreadsheet's Options worksheet.

I have a problem with the inputing.
I have uploaded the .xls file but none of the products or categories are added.

I am using Version 1.51 and the installation went fine. I am trying to upload about 500 prooducts.
I will attach the xls file in about half an hour.

One thing I did was enter a value for the date added in the products section. Not sure if this was correct

first i try was imported 5k products. After i tried with Export/Import Tool 10k products import but it's not import.
I didn't take any error however it's not import on my web site. i tried a lot of times but i didn't import.

Can i import it 50.000 products ? it's total 25Megabite
My host is unlimited.
My Oc 1.5.1.1

Thanks.

i am new to opencart
Ok My version is 1.4.9.4

uploaded the admin and system files
Made the modifications manually because i have never installed VQmod.

in step 3

Before using this newly installed Export/Import feature for the first time, you must set the
access rights for top administrator as follows:
In the admin interface,
choose
System > Users > User Group
From there, select 'Top Administrator',
then click on the 'Edit' link to the right.
This will open up an edit window with multichoice dropdown lists for 'Access' and 'Modify' rights.
In both of them, you'll see a new entry for 'tool/export' which you can select by clicking
on their check boxes.

I really don't know how to do this step .. i don't know what is system>user and where i can find it .

Please Help

How come i don't have System Tab in the admin panel ????

anti91 wrote:first i try was imported 5k products. After i tried with Export/Import Tool 10k products import but it's not import.
I didn't take any error however it's not import on my web site. i tried a lot of times but i didn't import.

Can i import it 50.000 products ? it's total 25Megabite
My host is unlimited.
My Oc 1.5.1.1

Thanks.

Not very likely because the memory requirements will be way too high.

Greetings! This is a great extension and one I rely on a lot. I used it recently to export from a 1.4.9 and import to 1.5.3 system. All seemed fine (once I'd figured out the Excel column changes), but now I've noticed an odd thing happening with Options.

To give a simple example, I am importing products which have sizes - Small, Medium, Large, etc. Although the database shows all these options imported successfully, they don't show in the live shop, nor in Admin (under product or options). In particular, the 'Medium' doesn't show (for any product). The only thing to note about 'Medium' is it's the first item in the list of options in the import file. When I reordered it (to experiment) so that 'Small' was first, then Small wasn't showing up. Curious!

I can't think what might be causing this, but if anyone has a clue where I might look, it might save me a lot of time! If I find an answer, I'll post it back here.

Thanks in advance
Martin

There a recent bugfix, install the latest version of the Export/Import tool and letme know if you still get thesame problem.

Thanks 'J'. Can you confirm how I find out the version numbers of the tool? I only recently downloaded it so I amy already have that version.

In the meantime, it seems I have sorted the problem. After importing my data, the option I referred to above (eg 'Medium') was not in the list of Options. So I added it, and on the next attempt at importing all seems to be in order - at least, I've not found any errors yet! Does that make any sense at all?!

M

just want to say this is the best! they should implement this into the next OC release.

I have a question, this tool was working great and then, as of today it says /index.php?route=tool/export&token=7e5da90a5ac473d8bc6ca page not found.

Any changes I make to the databse don't get updated. I don't see any errors in the error log, has anyone else run into a similar problem? if so did you find a solution?

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 96 bytes) in /home/alisver2/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 96 bytes) in /home/alisver2/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

What is that ? i have this error.

Nice work JNeuhoff! I have bin using your tool and it´s great, but have run into a problem, i´m working on a portuguese store... using utf-8 all tex apears great but when i upload the xls file i got a problem, aparently every thing seems ok but when i do a search in admin or in the store for a product that has specific char like Ç Ã Ó etc it says product not found!!! and i have hundreds of product.

I tried to check everything and what i found was that when i create a new product from the admin the chars are ok in mysql, and i can find them with search... but when i load them via xls i get the problem because mysql as registered every product with strange char... for an example the word Pinça apears in my sql as Pinça.

Any help would be great,
Thanks!
Pedro Martins

duck123 wrote:Nice work JNeuhoff! I have bin using your tool and it´s great, but have run into a problem, i´m working on a portuguese store... using utf-8 all tex apears great but when i upload the xls file i got a problem, aparently every thing seems ok but when i do a search in admin or in the store for a product that has specific char like Ç Ã Ó etc it says product not found!!! and i have hundreds of product.

I tried to check everything and what i found was that when i create a new product from the admin the chars are ok in mysql, and i can find them with search... but when i load them via xls i get the problem because mysql as registered every product with strange char... for an example the word Pinça apears in my sql as Pinça.

Any help would be great,
Thanks!
Pedro Martins

This is a known issue, and I am working on a solution.

Hello all,

I'm looking for a bit of direction with what I'm trying to do. The site I'm working on sells prescription glasses so each product has 629 rows of options. I have 263 products. My brain hurts with how many rows this will add to my spreadsheet. Is there a way to have options apply to more than one product_id? I've tried 1, 2 but it gave me an error.

I've got a brand new OC 1.5.1.3 install and am trying to import a file that I've previously exported from a working OC 1.4.9.5 install.

Every time I import the file I get the error message:
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

and also:

Notice: Trying to get property of non-object in /home/xxxxxx/public_html/testing/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 177

If I export the current list of items (blank as I deleted the sample data already) and then immediately reimport that same file it works. I'm using the latest version of the import/export extension and have installed the necessary files as well as vqmod on my system.

Any ideas of where to go next on troubleshooting this?