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 4.x releases:
Extract file 'export_import.ocmod.zip' from the the 'export-import-4-14.zip' archive
Go to Extensions > Installer
Upload the 'export_import.ocmod.zip'
Click on Install button
Go to Extensions > Extensions > Other
Click on Install button for Export/Import Tool
Click on Edit button for Export/Import Tool and enable it
That's it! You should now see the Export/Import menu entry at System > Maintenance > Export / Import
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 4.x releases:
Extract file 'export_import.ocmod.zip' from the the 'export-import-4-14.zip' archive
Go to Extensions > Installer
Upload the 'export_import.ocmod.zip'
Click on Install button
Go to Extensions > Extensions > Other
Click on Install button for Export/Import Tool
Click on Edit button for Export/Import Tool and enable it
That's it! You should now see the Export/Import menu entry at System > Maintenance > Export / Import
