[RELEASED] Export/Import tool for OpenCart 1.5.3.x

Thanks Juergen you're a star, thats sorted it.
I love this tool, it saves so much time.

Cheers

Ben

Hello,

Using the las export/import tool for OC 1.5.3.1 and vqmod.
Export works, but when i try to import it uploads the file, and probably upon the insert it just shows me the store's default 404 page. BUT, page url doesnt change, in address bar it still shows /admin/index.php?route=tool/export...

Nothing gets inserted or updated. Vqmod log -empty, OC log empty, apache log says 200 OK, php throws no errors at all, as said in documentation, php.ini is adjusted as it should be.
Any ideas?
It worked with 1.5.2..

Thanks, regards.

Hi,
Can someone help me for importing an .xlsx file? I have product options which consist of more than 65,536 rows. Only an .xlsx file can support more than 65,536 rows. Any alternate or suggestion will highly be appreciated.

Regards,

fari22882 wrote:Hi,
Can someone help me for importing an .xlsx file? I have product options which consist of more than 65,536 rows. Only an .xlsx file can support more than 65,536 rows. Any alternate or suggestion will highly be appreciated.

Regards,

The Export/Import tool doesn't support the XLSX format, only the XLS. Even if it did, the memory requirements for parsing such a big file would way too high for a normal web server.

Dear Sir,

Need your help.

When i am trying to import product, able to see the product in admin tab but not in store. Also product image which i had mapped in excel also not showing. every time i have to update the image in admin->product & resubmit the things.

Please help

JNeuhoff wrote:

fari22882 wrote:Hi,
Can someone help me for importing an .xlsx file? I have product options which consist of more than 65,536 rows. Only an .xlsx file can support more than 65,536 rows. Any alternate or suggestion will highly be appreciated.

Regards,

The Export/Import tool doesn't support the XLSX format, only the XLS. Even if it did, the memory requirements for parsing such a big file would way too high for a normal web server.

What do you suggest me? I am just waiting for incremental import/export tool. May be that would work for me. May i know the expected schedule for release of incremental import/export tool?

Appreciate your efforts.

Regards,

I get an error too, for some reason it comes twice:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

I have only 550 products, and no long descriptions. And I even tryed to upload latest version(my previous version was from 7/6-12), but it did not help. It has worked great before, and to my knowledge I did everything just as the other times. I used it last time 5-6 days ago with no problems.

wrangster wrote:I get an error too, for some reason it comes twice:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

I have only 550 products, and no long descriptions. And I even tryed to upload latest version(my previous version was from 7/6-12), but it did not help. It has worked great before, and to my knowledge I did everything just as the other times. I used it last time 5-6 days ago with no problems.

Increase your PHP memory_limit setting.

P.S.: Before asking how to do it: Google is your friend.

Hi again!
I tryed to increase the memory in the php.ini file, first to 128M, then 256, 512, 1024 and 2048M, still get the same message every time, only with small changes in the numbers of bytes.

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

wrangster wrote:Hi again!
I tryed to increase the memory in the php.ini file, first to 128M, then 256, 512, 1024 and 2048M, still get the same message every time, only with small changes in the numbers of bytes.

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/3/n/netzoo/www/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

Looks like you'll have to change your webhost then. It appears your webhost never accepts more than 64MB for the memory_limit.

Ok, I'll write to support and see if they can set it higher. Thanks for superfast answers!

I got answer today, they could not set the memory higher for me. Is there no other way to make it use less memory? The file is only 400kb, I don't understand how it can use up 64M. How high does your host let you set the memory?

For example: I have 470 products now. What happens if I import a file now with 50 products, where id's and model are new and unique. Will I have 520 or 50 products in my shop? To say it in other words: do I need to import all products every time, or only the once I want to add?

My import shows no errors. all my items show up, but no images at all. if i manually add an image to the product, the file permissions are the same as those i batch uploaded to the server, and after i do an export, all fields - of the manually added imaged product - are the same, except for description and name of course.

in short - my images are not showing up.

I have installed everything and the import export button is now in the drop sown. It lets me export and the file saves. When I open the file it only has the categories... am I missing something somewhere? I have 30 products in my opencart?

Can someone help direct me in the right direction?

Thanks
Scott

never mind about question above. Everything is there in separate tabs!. Awesome extension!

Hi to all,

One problem I have so far, is that the exported xls file has corrupted data, please see attachment. Actually there is only one tab....

Thanks,

Kostas

How soon can you get incremental updates? Can I pay you to complete this now? I am converting from prestashop to open cart and I need my new site to launch this week, I ran into a php memory limit at 3K items:
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 1048576 bytes)

So I had my host bump the settings way up, cleared the cache and tried to import again same issue.

This issue here is that this makes no sence because I had my host change the settings to 2048mb. Here is my list of current php settings (VPS Manged Server). This is hwo they appear in cPanel phpconfig

max_execution_time 1000
max_input_time -1
Resource Limits memory_limit 2048M
register_globals OFF
safe_mode OFF
upload_max_filesize Maximum allowed size for uploaded files. 100M

Apache version 2.2.22
PHP version 5.3.10
MySQL version 5.5.22-cll
Architecture x86_64
Operating system linux

kmirmiris wrote:Hi to all,

One problem I have so far, is that the exported xls file has corrupted data, please see attachment. Actually there is only one tab....

Thanks,

Kostas

It may not work with the Greek Language, I have had several bug reports relating to that language.

Also, it's always worth a try using OpenOffice or LibreOffice Calc instead of MS Office Excel.

In fact I very tempted to switch over to the ISO Open Document Format for Office Applications (ODF) for future releases of the Export/Import tool, so as to have proper UTF-8 support and other improvements missing in proprietary MS Excel formats.

FusionDecals wrote: This issue here is that this makes no sence because I had my host change the settings to 2048mb. Here is my list of current php settings (VPS Manged Server). This is hwo they appear in cPanel phpconfig

max_execution_time 1000
max_input_time -1
Resource Limits memory_limit 2048M
register_globals OFF
safe_mode OFF
upload_max_filesize Maximum allowed size for uploaded files. 100M

What about the post_max_size setting?