[RELEASED] Export/Import Tool for OpenCart 1.4.8

kjp wrote:Thanks for the quick response -

the IMPORT/EXPORT Function is already displaying in the SYSTEM Drop down menu. The problem seems to be that when I click on this function it takes me to a page that does not contain any import or export buttons. The page looks exactly like the back-up restore page, and the "back-up" button only offers the .sql download. So, I am guessing maybe something is weird with my config, but everything looks to be in place so I'm not sure what's missing.

Thanks for your help.

I think there is something wrong in one of your header files
admin/controller/common/header.php
admin/language/english/common/header.php
admin/view/template/common/header.tpl

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

I was looking for a way to import 1,000 or so products into a new OpenCart store and found this tool. I installed everything onto a freshly-installed OpenCart store (Version 1.4.9.3), and uploaded to production, but received some strange-looking pages. The login page had text on top of text and the internal pages had none of the normal formatting. I reverted back the three files: admin/controller/common/header.php, admin/language/english/common/header.php, and admin/view/template/common/header.tpl, and everything appears normal again. Any idea what could have caused this?

Also, we use a shared server on Hostgator and were given the following limits:

memory_limit = 64M (MAXIMUM)
post_max_size = 64M (MAXIMUM)
upload_max_filesize = 64M (MAXIMUM)

Does this have a chance of working despite the lower size limits?

Use the VQmod XML file for the header file changes which comes with the Export/Import tool, this way you won't have to touch the OpenCart core files.

JNeuhoff wrote:Use the VQmod XML file for the header file changes which comes with the Export/Import tool, this way you won't have to touch the OpenCart core files.

Does the VQMOD folder get uploaded to the store root, or do I extract everything out of VQMOD and put them in the store root? Thanks.

Also, when editing the index.php file, as documented in opencart_install.txt, do I edit the index.php file in the root or under admin?

the vqmod folder under the upload directory goes in the root folder. As for which index.php to edit, if you read the instructions you will see you need to edit both files

JAY6390 wrote:the vqmod folder under the upload directory goes in the root folder. As for which index.php to edit, if you read the instructions you will see you need to edit both files

Yes, I saw that as I read the next step. Thanks for the clarification. Now that I've gone through all the installation steps and uploaded to production, where do I go to find some sort of user's guide?

The use of it is pretty simple. Just upload the XML files that come with your modifications to the /vqmod/xml/ folder. Your modifications you download from other developers should come with instructions on how to do this. There are also vqmod examples that ship with it to give you an idea of what you can do with it

JAY6390 wrote:The use of it is pretty simple. Just upload the XML files that come with your modifications to the /vqmod/xml/ folder. Your modifications you download from other developers should come with instructions on how to do this. There are also vqmod examples that ship with it to give you an idea of what you can do with it

I might be climbing up the wrong tree. I was looking for a way to upload products using a CSV or Excel file. I downloaded all the products from a Yahoo Store and need to import them into the new OpenCart store.

Oh you mean you want detailed instructions on how to use the Export/Import mod not how to install vqmods? Best way is to do an export of the basic store first, and use that excel file to upload with. You should note the tabs at the bottom of the excel workbook, containing categories, products etc on different sheets

JAY6390 wrote:Oh you mean you want detailed instructions on how to use the Export/Import mod not how to install vqmods? Best way is to do an export of the basic store first, and use that excel file to upload with. You should note the tabs at the bottom of the excel workbook, containing categories, products etc on different sheets

Jay - That's correct. I'm also trying to locate documentation for the simplest of tasks, such as exporting the basic store first, as you recommended. Can you point me in the right direction? Thanks.

Well if you've used the vqmod file that comes with the module, it should be under SYSTEM > IMPORT/EXPORT or something similar

JAY6390 wrote:Well if you've used the vqmod file that comes with the module, it should be under SYSTEM > IMPORT/EXPORT or something similar

I've installed the Export/Import Tool as well as the vqmod file, but there's no such option under SYSTEM.

If that is the case then there's something wrong with either the vQmod install or the vqmod hasn't been placed in /vqmod/xml/ folder

JAY6390 wrote:If that is the case then there's something wrong with either the vQmod install or the vqmod hasn't been placed in /vqmod/xml/ folder

Does the vqmod folder go under the root (public_html) or under the admin folder?

The vQmod and the admin folder should be in exactly the same folder, so if your admin folder is in public_html then so should the vQmod folder. it should look like

I quite often have this text come up after exporting, editing then importing again.
_x000D_. Sometimes it comes up multiple times.
Other than that, it's a great product. It saved a great deal of time.
It is 1.4.9.3

WebDev22 wrote:

JAY6390 wrote:Well if you've used the vqmod file that comes with the module, it should be under SYSTEM > IMPORT/EXPORT or something similar

I've installed the Export/Import Tool as well as the vqmod file, but there's no such option under SYSTEM.

What version of OpenCart are you using?

If it is 1.4.8b or older then the Export/Import tool doesn't include the VQmod xml files, so you'd have to manually edit the 3 header files as per the instructions here.

I've just installed the import/export tool, but now when i click export, all i get is

Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/ikatere.com/ikatere.com/httpd.www/admin/controller/tool/export.php on line 76ÐÏࡱá;þÿ

followed by what appears to be all my product details in a row in an html format. Could anyone tell me what has gone wrong and how i can fix it please. I have already deleted the set_time line in export file but still no luck.

Thank you!!

Comment out the set_time_limit() calls in the admin/model/tool/export.php.

Or use another webhost, such as Hostgator.