Export/Import Tool

Export/Import Tool
What it does
The Import/Export Tool allows the admin user to do a bulk export of categories, products, options, attributes, filters and customers to an Excel spreadsheet file. The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.

Features include:
  • The Import can be incremental, that is, data is updated or added to the OpenCart server. Or it can be non-incremental which means all old data is first deleted before the Import.
  • The Export can be limited to certain data ranges only for products and categories.
  • Multiple languages are supported, too.


Requirements and Limitations
Use version 4.11 of the Export/Import tool for systems with PHP Version 7.2 or later.
Older PHP versions are still supported by our older version 3.22 of the Export/Import tool.

Memory requirements can be quite high.

Not every shared web hosting account supports a high process memory usage. Therefore, if you use a basic shared web hosting account, no more than a few thousand products can be exported or imported at a time. Use a more dedicated web hosting account if a higher number of products are to be processed in one go. Or export and import multiple times in smaller batches.


Installation for OpenCart 2.x and 3.x
In the OpenCart admin backend, do the following steps:
  1. Install via Extensions > Marketplace or via Extensions > Installer > Upload
  2. Go to Extensions > Modifications, you should see an entry for this Export/Import tool
  3. Click on the Refresh button (top right of the page)
  4. Go to System > Users > User Group > Edit Administrator
  5. Set access and modify permissions for 'extension/export_import' (for OC 3.x or later) or 'tool/export_import' (for OC 2.x or earlier)
That's it! You should now see the Export/Import tool under the menu System > Maintenance > Export / Import (for OC 3.x or later) or under the menu System > Tools > Export / Import (for OC 2.x or earlier).


Installation for OpenCart 1.x
  1. Unzip and upload the folders 'admin', 'system' and 'vqmod' from the 'upload' directory to your remote OpenCart main directory.
  2. Before using this newly installed Export/Import feature for the first time, you must set the access rights in the OpenCart admin backend at System > Users > User Group for the 'tool/export_import'.
That's it! You should now see the Export/Import tool under the menu System > Tools > Export / Import.


Further help and customized versions
This tool has been successfully tested for standard OpenCart 1.5.x, 2.x, and 3.x versions.
Don't use other Opencart versions with this module.
If you need a customized version of the Export/Import Tool, let us know and we can create one for a charge.

License
This Export/Import Tool is Copyright (c) 2008-2021 by MHCCORP.COM and is made available under the terms of the Commons Clause with the GPLv3.

Note
Please use the regular OpenCart forum for support, not this comments section! See also our FAQ page for more details on how to resolve installation problems and other common errors!

What customers say about Export/Import Tool

MarcosLegal
The best extension and the most important one. You need to have that. I wish it was compatible with php 7.4
~MarcosLegal
xs_Ron
I also like to export/import orders but that is not possible. Overall I like this extension.
~xs_Ron
kzap
Does not work
~kzap




Download
  • Developed by OpenCart Community
  • Documentation Included

Rating

Compatibility
1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4, 3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8, 2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2, 3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8, 1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4, 2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2

Last Update
25 May 2022

Created
24 Apr 2010
194791 Downloads
1799 Comments
JNeuhoff
JNeuhoff
Member since: 23 Apr 2010

View all extensions Get Support