The Import/Export is a new administrative feature which allows the admin user to do a bulk export
of all the categories, products, and product options to an Excel spreadsheet file.
The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.

This module also provides some minor changes to the existing Backup/Restore module:

- The control panel contains a brief description of the module
- The buttons labelled 'Export' and 'Import' are now renamed to 'Backup' and 'Restore'
- The arrow-up and arrow-down images for the buttons have been swapped

Also, though not yet ported to Opencart 1.1.x, this Export/Import module already has built-in support for the following optional modules and/or extensions to the database:

Hello JNeuhoff,
first thank you for posting the import/export plugin. It's surely nice feature, but I have problem with it. I am using Opencart 1.2, I installed the plugin, allowed it in User group. I can see under Admin/Configuaration/Export/Import link but when I press Export button I got 500 error. What could be the problem?
Whole shop works just fine.

It seems like tempnam() was failing to create a temporary file within the Excel-exporting library when it was just a null string (""), so I hardcoded a writable directory into admin/Spreadsheet/Excel/Writer/Workbook.php as a temporary hack. There's probably a better place to set it, but this seems to have fixed the problem for me. Hopefully it helps someone or a better fix can be implemented in the release. This may be related to Sulix's issue if mod_sec or another security module arbitrated it instead, and threw a 500 error.... wild guess though.

It normally uses a temporay file with a name of something like this: '/tmp/OLE_PPS_FileXXXXXX'. That means, your PHP script running under your user account must have write and read access to the '/tmp' directory. If you can't solve it, you may try this in the export.php file, in function download:

I inserted this piece of code to model/tool/export.php file and set up cache directory with read and write permission
...........
// Creating a workbook
$workbook = new Spreadsheet_Excel_Writer(); $workbook->setTempDir(getcwd().'/../cache');
$workbook->setVersion(8); // Use Excel97/2000 Format
..........
Now, small progress! After the pressing Export button it generates in cache directory some files:
Generating took very long (about two minutes)
cache.manufacturer.1237926586
cache.product.latest.1.8.1237926590
cache.product.latest.6.8.1237926586
cache.product.popular.1.5.1237926590
cache.product.popular.6.5.1237926586

Sulix, you'll probably have to at least check your apache error log and look for telltale php errors/warnings. If you're not sure where it is, ask your host. The problem will usually be pretty obvious from the logs, but if you think it's an incompatibility, then post it here. It might be that php reached its max_execution_time since you said it took a very long time, but it could be many things.

btw, I am mlrazzano from above... forgot that I had registered back in 0.7.x. I will try to contribute more from now on.

I am not exactly sure what the problem was it was saying something about different products so I deleted those products 1 by 1 and after about 20 of them it worked fine. I am assuming those products had something wrong with them.

Would like to Thank you though for offering to help it is much appreciated.

Sulix, there are either access permission issues (not allowed to access /usr/share/pear/PEAR.php), or the PEAR.php is genuinely not there. The error log should give some further clues. If you can't solve these issues you might consider using a different webhost, such as HostGator.