janvanherp 15 years ago

Sorry but the app gives a failure:
The menu item shows this text: Notice:Undefined variable export in /home/portuuradm/domains/portuur.nl/public_html/shop/vqmod/vqcache/vq-admin_view_template_common_header.tpl on line 123

line 123 : <?php @$this->load->language('tool/csv'); ?>

Hook61 15 years ago

Dear
It works well, only this:
the table product_related is correctly compiled, but the related items are not shown both in the front and back office
Opencart 1.5.0.5

mommaroodles 15 years ago

In addition to the above - I visited your website and sent an email inquiring whether it was possible to have the module allow me to select which categories I want to export or import, which attributes I want to export or export for eg image only, product pricing only, product description only or ALL and etc. - to this I have not received a reply - I am more than willing to pay for this!

Ideally the module would work a lot better if one was able to just import the new products without it deleting all the categories and products in the database, and not have to append the new products to an existing file. In time that file obviously will become larger and the export/import process will be subject to
potential problems. In my case, the module does not allow the import the original export file and as a result seem to have lost over 300 categories and 24 416 products.!!!

mommaroodles 15 years ago

Now what has happened to me is - being unaware of the fact that you have to append your new products to the existing export file - I just added the new products and imported them - this resulted in all my categories (over 300 of them) and all the products being deleted. The only thing that imported successfully was the new category the actual products did not import! I've been trying to import the original export file that lists the 24 416 products and its been more than 30 minutes and it still has not imported which leaves me with the question of how I'm gonna get all those products back again.

mommaroodles 15 years ago

First of all - I'm using OC version 1.4.9.5. The module was installed successfully and the settings in the php.ini is as follows.

memory_limit = 512M;
post_max_size = 30M;
upload_max_filesize = 999M;

Firstly I exported the file to see the file layout etc. We have 24 416 products - and still much more to come. Now what I didnt know and it does not seem to be documented in the Read.me file - is the fact that you CANNOT just import your new products, it has to be appended to the existing export file. If you have as many products as I do - the import process takes forever despite the fact that the limits have been increased in the php.ini file.

JIM2Y 15 years ago

is very great module.........this can save my more time... Thank you very much..

I used 1.5.1.1

aryellys 15 years ago

I have a problem. It exports with no problems.
But when I Import gives me this error:

Error: MySQL server has gone away
Error No: 2006
DELETE FROM `product_image`

A little help please ...
V v1.4.9.6

b2bblack 15 years ago

Tried to use with 1.5.1.1 and vqMod. Absolute disaster! It exported just fine, so I changed one number in the spreadsheet and tried to import it to make sure it would work, but it errored out after about 100 items (we have approximately 2000). Have since tried importing multiple times with absolutely no luck. Now I'm trying to rebuild the site from scratch...

dengine 15 years ago

Just tested it in 1.4.9.3 and works really well! Thank you for all the hard word in this great feature. I do have some adjustments I did myself. I renamed some of the folders and at first the script didnt work. I have changes this:

chdir( '../system/PHPExcel' );
require_once ( /Classes/PHPExcel.php');
chdir( '../../admin' );

Into:

require_once (DIR_SYSTEM . 'addons/PHPExcel/Classes/PHPExcel.php');

I have put the PHPExcel and PEAR files/folders into a addons dir and the DIR_SYSTEM comes from the config file off course. I did te same for this peice:

chdir( '../system/pear' );
require_once ('/Spreadsheet/Excel/Writer.php');
chdir( '../../admin' );

Script works like a charm so I'm very very happy with this. Would be great if it would support mulitlanguages but I can imagine that must be a real pain in the .....

tfurrows 15 years ago

I'm using Opencart 1.5.1, and followed the install instructions for vQmod and "auto install" of this import/export extension... and there was not menu entry in the admin>system menu.

The fix was to set /index.php and /admin/index.php to 777 writable and re-run the /vqmod/install so that vqmod would work properly. To be fair, the error in my case is in the vqmod documentation, and not with this extension.

vlada_v 15 years ago

I have reached limit for import, around 750 products :-( Any suggestions? Thanks a lot for any

ciprianrpp 15 years ago

works on 1.5.1! thank you

marez 15 years ago

I have installed on 1.5.1 and when i tray to import base, i get this error

Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.') in /users/marez/www/oc5/opencart_v1.5.1/upload/admin/model/tool/export.php on line 1476

aaron1988 15 years ago

It does work with 1.5.1 as i just tested importing it with using "options" and it added them.

So it does work, you must be doing something wrong mate.

dony_b 15 years ago

Actually it does not work with v1.5.1

dony_b 15 years ago

It works with v1.5.1 but it breaks the admin backup/restore link so you will have to manually do it ..

Opencartisalright 15 years ago

OC 1.5.1 support yet?

sjp1170 15 years ago

Hi All

OK i can get this to export but..... i am unable to get it to import the attributes. If i enter them manual (admin side ) they export fine. But if i enter them via the upload they don't appear anywhere.

What am i doing wrong? Any ideas?

Thanks

tipud 15 years ago

I am getting the same error as gil719 above.

My file is not so big only 1.1MB

Fatal Error: Out of memory (allocated 80740352) (tried to allocate 5 bytes) in **********/store/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 130

This is a fresh install.
i was using this tool to bring in products. i got up to 1200 products no problem then i got this error.
checked php.ini memory is set at 64MB just changed it to 128MB still same error.
Any ideas

gil719 15 years ago

This is apparently an awesome script! However, no matter what I do, I can not get the file to upload. I keep getting:
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 95 bytes) in /xxx/xxx/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
I have raised the limits in my php.ini file and still no luck.
When exported, the file size is 11MB. It is pretty big as I do have thousands of products. If I am too "big" for this tool, does anyone know of another option?
I AM WILLING TO PAY for something that does this and works with my site. I get an average of 50-100 new products every month.
Please email me at gil[at]delightfulimports.com if this can be done. Thank you again!