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.
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 releases:
Before installation, make sure the OpenCart Extension Installer is correctly configured, especially for the FTP settings, including the FTP Root.
In the OpenCart admin backend, do the following steps:
Go to Extensions > Extension Installer
Upload the opencart-2-x-export-import-multilingual-3-x.ocmod.zip file
Go to Extensions > Modifications
You should see an entry for this Export/Import tool
Click on the Refresh button (top right of the page)
Go to System > Users > User Group > Edit Administrator
Set access and modify permissions for 'tool/export_import'
