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 3.x releases:
Go to Extensions > Extension Installer
Upload the 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 the access and modify permissions for 'extension/export_import'
That's it! You should now see the Export/Import tool under the menu System > Maintenance > Export / Import.
Last edited:
