[RELEASED] Export/Import tool for OpenCart 1.5.5.x

How do I add new products without a product_id? I thought maybe I put 0 in this column so it would know it's a new item but that didn't work.

I could not find any instructions to indicate how to add a new product. Did I miss that somewhere?

Thanks for any advice.

This would be impossible. Each product must have a product_id.

Why would you want to add products without product_id?
If you don't want the products displayed, turn them off or set the availability date to the one when the products would be available.

Why wouldn't you want to add new products and have them just get the next ID? I guess it's logical to just increment them manually. However, what happens if you mistakenly put in the wrong number. It will end up overwriting the wrong item.

if you put in duplicates in the xcl sheet, you will get an error. and it won't update

I have used Metty's solution to fix the Import/Export tool for Opencart 1.5.5.1, which fixed the error when Exporting the file, but now when I try to import I still get the same error:

2013-06-06 8:43:57 - PHP Warning: stream_wrapper_unregister() [<a href='function.stream-wrapper-unregister'>function.stream-wrapper-unregister</a>]: Unable to unregister protocol zip:// in /home/seedsbys/public_html/system/PHPExcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69
2013-06-06 8:43:57 - PHP Exception: ZipArchive library is not enabled in /home/seedsbys/public_html/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 240

I know for a fact everything is enabled as it is our own server, so I can't understand what is going wrong. Changing servers is not an option, so I really need some help with this one.

Just realised I replied in the wrong topic, this is the right one;

Hey there,

First and foremost, thanks a lot for this great extension, I'm using this tool for a few clients of mine.

Now I stumbled upon an error for the first time. I'm using OpenCart version 1.5.5.1 and the 1.5.5.1 version of the import / export tool.

Weirdly enough, I just copied a working opencart website to another server, copied the database too and on the older website the export goes fine but it borks on the new version.

I can't open the XLSX file when you click export and you download the XLSX file.

When I try to open it I get the following error:

Error: excel cannot open the file .xlsx because the file format or file extension is not valid, check if the file is damaged etcetc.

I CAN open it in openoffice but then I just get gibberish, I didn't change anything in the code so I'm really puzzled about this.

TriumphDesign wrote: When I try to open it I get the following error:

Error: excel cannot open the file .xlsx because the file format or file extension is not valid, check if the file is damaged etcetc.

I CAN open it in openoffice but then I just get gibberish, I didn't change anything in the code so I'm really puzzled about this.

Most likely there will be an entry in your Opencart's system/logs/error.txt, or in your server's error_log (ask your web host for the latter).

JNeuhoff wrote:

TriumphDesign wrote: When I try to open it I get the following error:

Error: excel cannot open the file .xlsx because the file format or file extension is not valid, check if the file is damaged etcetc.

I CAN open it in openoffice but then I just get gibberish, I didn't change anything in the code so I'm really puzzled about this.

Most likely there will be an entry in your Opencart's system/logs/error.txt, or in your server's error_log (ask your web host for the latter).

My error log doesn't have errors since last week, so that can't be it. What could have gone wrong by copying the website from one FTP to another?

Here's the log from the server admin, is this information you can work with? :\

Export is blank. So I cannot seem to get the format right.

When I am importing it is now telling me this message:

Fatal error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/faecaver/public_html/ocart/admin/model/tool/export.php on line 1644

That should it read so I can get it to import?

I have the following setup up and running
Opencart 1.5.5.1
vqmod - 2.3.2
Export Import - opencart-1-5-5-x-export-import-15

The export/import module works fine for importing products and categories except for related products. The strange thing is that I can set mutally related products in the excel sheet and import them. I can see on the front end the number of related products but the products themselves are not visible in the related products tab.

If I remove and add the same related products via the opencart admin console I do get to see them.

Any suggestions on why the related products are stored as part of the productinformation but not visible?

table.oc_product_related
product_id related_id
26 48
27 48
48 26
48 27

Related products tab for product 48 is showing a counted value of 2 but the actual products themselves are not shown. Only when entering the products through the admin console, which results in the same table content, are the product visible and clickable.

To TriumphDesign:

You got this error message in your server's error_log:

PHP Fatal error: Class 'PHPExcel_Writer_Excel2010' not found in /home/admincally/domains/callysta.nl/public_html/system/PHPExcel/Classes/PHPExcel/IOFactory.php on line 141

Looks like PHPExcel doesn't support Excel2010. Try Excel2007, or OpenOffice ODS file formats when saving your edited spreadsheet file.

JNeuhoff wrote:To TriumphDesign:

You got this error message in your server's error_log:

PHP Fatal error: Class 'PHPExcel_Writer_Excel2010' not found in /home/admincally/domains/callysta.nl/public_html/system/PHPExcel/Classes/PHPExcel/IOFactory.php on line 141

Looks like PHPExcel doesn't support Excel2010. Try Excel2007, or OpenOffice ODS file formats when saving your edited spreadsheet file.

Yeh I tried to change that in export.php to see if I would get different results. But it gave me those errors.

When I set it back to Excel2007 it worked again but I still get the corrupt XSlX file when I try to EXPORT ..

This is not about importing, that works

Here's the excel file I get when I try to export.

TriumphDesign wrote:
Yeh I tried to change that in export.php to see if I would get different results. But it gave me those errors.

When I set it back to Excel2007 it worked again but I still get the corrupt XSlX file when I try to EXPORT ..

This is not about importing, that works

Might be an issue with PHPExcel, try replacing the one from system/PHPExcel with the latest one from http://phpexcel.codeplex.com/ to see whether it still has the same problem.

JNeuhoff wrote:

TriumphDesign wrote:
Yeh I tried to change that in export.php to see if I would get different results. But it gave me those errors.

When I set it back to Excel2007 it worked again but I still get the corrupt XSlX file when I try to EXPORT ..

This is not about importing, that works

Might be an issue with PHPExcel, try replacing the one from system/PHPExcel with the latest one from http://phpexcel.codeplex.com/ to see whether it still has the same problem.

Just tried it, uploaded it over the old files, tried to export again, no change, still corrupt.. Any other ideas?

Could it be something IN the database that's corrupting the excel, like weird symbols who might've gotten in there... I dunno, I'm out of ideas

TriumphDesign wrote:Could it be something IN the database that's corrupting the excel, like weird symbols who might've gotten in there... I dunno, I'm out of ideas

Quite possible. Do a backup of your database, then remove some of your products and/or categories, to see whether it makes any difference.

Trying really hard here, I actually deleted all the oc_product_ tables and replaced them with tables from another database where the tool does work. (even that did not do the trick)

Could you, maybe, give me a list of all the affected tables the tool exports from, my bet is, if I empty them all, my problems might be solved, I already made a fresh opencart install with the template imusing + your tool and the export works on that copy. But I really can't be arsed (excuse my french) to redo the whole website css / php / etc wise.

TriumphDesign wrote:Trying really hard here, I actually deleted all the oc_product_ tables and replaced them with tables from another database where the tool does work. (even that did not do the trick)

Could you, maybe, give me a list of all the affected tables the tool exports from, my bet is, if I empty them all, my problems might be solved, I already made a fresh opencart install with the template imusing + your tool and the export works on that copy. But I really can't be arsed (excuse my french) to redo the whole website css / php / etc wise.

What happens if you use the default web theme?