If you are building a large store with OpenCart, adding products one by one can be long repetitive process. There’s an extension that you can install that will allow you to export your current products in Excel, work offline on adding or editing new products, and importing the spreadsheet to add the new products to your store. This can save valuable time in getting your store operational.

You must have vQmod installed to use this extension. If you do not have vQmod installed and want more information about it please see our article on vQmod.

The memory requirements for this extension can be quite high. If you have more than 2,000 products in your store and are on a shared server, this plugin may not be suitable for you to use due to the high memory usage.

Installing the Bulk Import/Export Extension

  1. Download the extension from here: Bulk Export/ Import Extension for OpenCart. Be sure to scroll down the page and locate the Download tab. Download the one for your particular OpenCart version.
  2. Extract the files that you just downloaded
    opencart_export_1
  3. Upload the folders “admin”, “system”, and “vqmod” and their files from the “upload” directory to your root directory of your OpenCart Store using a FTP program.opencart_export_2
  4. Login to your OpenCart Dashboard
  5. In your OpenCart Dashboard go to: System > Users > Users Group
  6. Select the Top Administrator and click Edit on the right side.opencart_export_3
  7. Find the entry for tool/export in both Access and Modify dropdown lists and place a check by clicking on their boxes.

    Now you can use the tool in your dashboard by going to: System Export/Import

Congratulations, now you know how to install the bulk import/export extension for OpenCart Products!

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Comments

Post a comment
2012-11-15 7:32 am
when i click the link you provide "Bulk Export/ Import Extension for OpenCart" the page cannot be found on opencart website.
2013-03-02 7:37 am
yes after enabled , i dont see any in the meny System , same in the photo from you u send .
2013-09-19 5:23 am
hi. i have instll the extension. everything was ok. after i change the admin from config.php. i noticed that the export/import was no found in the system of open cart dashboard. please assist. thanks
Staff
4,112 Points
2013-09-19 8:01 am
Be sure that you have uploaded the files in the correct directory for your OpenCart installation. Also, you may have a browser caching issues, in which clearing your browser cache may also help.
2013-09-19 9:32 am
error 403 appeared after i import my product data. When i want to manually insert new product or category, this error 403 appeared.
Staff
5,603 Points
2013-09-19 1:31 pm
Hello maneii,

A 403 error means access denied, so it could possibly be a permission issue with your files. We have an article on the 403 forbidden error that explains why you might be getting this.

Other than that it could be possible that you have a rule in your .htaccess file that is causing the 403 error. You might want to try to temporarily re-name your .htaccess file to something like .htaccess-BAK and see if you're still having issues, and then re-name it back if the issues are still persisting.

Please let us know if that works for you, or if you're still having problems.

- Jacob
2013-10-27 9:50 pm
Followed all instructions in the Bulk Import Export tutorial for opencart. Received the following error after I downloaded the excel file:
Fatal error: Class 'ZipArchive' not found in /home/gremilli/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234
Please help me.
Staff
5,603 Points
2013-10-28 7:26 pm
Hello mgremillion09, and thanks for your comment.

What version of OpenCart are you running, and which version of the OpenCart Export/Import Tool are you running?

When I downloaded opencart-1-5-4-x-export-import-13.zip and took a look at the /system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php file on line 234 there is no mentions of a ZipArchive class. It sounds like possibly you don't have all of the files uploaded, or have the improper version for your version of OpenCart.

- Jacob
2014-02-03 2:17 am
Hi Dear,
I really appreciate your work can you give me the Excel Format file to test it please.
Shan Ali

Staff
4,112 Points
2014-02-03 9:09 am
Hello alirajpoot44,

Unfortunately, we do not have a file in which you may use to test this functionality. You may, however, easily create one using Excel.
n/a Points
2014-04-07 8:58 am

I already have VQMod on my Opencart site. http://rocklove.us  Will I mess it up if I upload thes files from Bulk IMpor/Export?

Staff
10,078 Points
2014-04-07 10:34 am
Hello David,

Uploading the folders over existing folders will update any older files with newer copies. It should not have any detrimental effect on them. However, I would make copies of all the folders as a backup just in case.

Kindest Regards,
Scott M
n/a Points
2014-04-07 10:40 am

OK I will try..after I make a backup.   What confuses me is that the Template I had installed has the admin folder.. so if I overwrite the admin folder.. well is that gonna wipe out the files for the template?

Staff
10,078 Points
2014-04-07 10:59 am
Hello David,

No, the extension will add its own files to the admin folder. Files for other extensions and templates should not be affected at all. Just be sure to make the copy so you can always roll back in case of an error.

Kindest Regards,
Scott M
n/a Points
2014-04-07 11:24 am

Got it to install.. BUT the "System > Export/Import" is not showing up.  The boxes are checked.  My site is "rocklove.us" hosted of course on INMotion.

Staff
5,444 Points
2014-04-07 3:21 pm
Hello David,

Thank you for your question. As a test, I setup this extension on a new installation of OpenCart, and it does work successfully.

The important part of the guide, is where it states "You must have vQmod installed to use it." Make sure you have installed vqmod in OpenCart, before attempting this guide.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul
Staff
5,603 Points
2014-04-07 3:40 pm
Hello David,

It looks like while you had already uploaded the vQmod files, it doesn't look like your /vqmod folder had the correct permissions, and it didn't look like the install was ever run which is mentioned in our vQmod for OpenCart guide.

It was also hard to tell if you had the correct version of the Import/Export tool downloaded to match your version of OpenCart. So I went ahead and insured the correct version opencart-1-5-6-x-export-import-17.zip compatible with OpenCart v1.5.6, v1.5.6.1 was used as well.

I went ahead and left a copy of admin-BAK, system-BAK, and vqmod-BAK which had you original files in them in case you ran into any issues. But it looks to be working now.

Please let us know if you had any further questions at all.

- Jacob
n/a Points
2014-04-07 3:57 pm

Hey hey hey! It's workin now..and it also now uses the coolio "OpenShop" extension that I had! That must have been it.. the Template designer installed it for me.. I am not sure if he did the VQmod though!  But all's well that ends well..nice job fellas.  THANKS!!

Staff
5,603 Points
2014-04-07 4:04 pm
Hey David,

Awesome! Glad to hear that's working for you now, no problem at all!

The vQmod install step is an easy one to miss, and we've already updated this article itself to try to make it more apparent that needs to be done for this extension to function.

- Jacob

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 2241
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5675

Related Questions

Here are a few questions related to this article that our customers have asked:
Bulk Import/Export extensions not appearing
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!