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
PHP Version 7.3 or higher is required.
For OpenCart 1.5.x releases a pre-installed VQmod modification system is required.
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 1.5.2 to 1.5.6.x releases:
Upload via FTP the whole folders 'admin', 'system' and 'vqmod' from the 'upload' directory to your remote OpenCart main directory.
In the OpenCart admin backend, go to System > Users > User Groups
Set access and modify permissions for 'tool/export_import'