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.
New 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 now supported, too.
Requirements and Limitations
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.
See embedded 'readme.txt' for installation details. For 1.5.x OpenCart versions, a pre-installed VQMod (Virtual file modification system) is required for installation.
Note: If during the install you get an error saying "Could not connect as ......" while uploading this zipped extension via the Extension Installer, you probably have the FTP support disabled from your hosting. In that case you may try this OpenCart Extension Installer fix first.
Further help and customized versions
This tool has been successfully tested for the standard OpenCart versions 1.5.1 to 1.5.6.x, 2.0.x, 2.1.x, 2.2.x and 2.3.x. Don't use other Opencart versions with this tool.