Page 1 of 3

Updated Bulk Export/Import module

Posted: Mon Feb 18, 2008 8:27 pm
by JNeuhoff
I have updated the Export/Import module for OpenCart 0.7.7, see http://www.opencart.com/contribution/in ... tion_id/34 for more details.

It now provides better support for optional category descriptions.

Daniel, can you remove the previous versions which are now obsolete? Thanks.

Re: Updated Bulk Export/Import module

Posted: Thu Feb 21, 2008 6:45 pm
by bruce
Might have to do more than that.

The latest version is suffering the same fate as most recent contributions. The downloaded file appears to be corrupted though in my case, it was actually not on the server at all.

Best bet is to mail the latest version to Daniel webmaster@opencart.com and ask him to place it on the server for you.

Re: Updated Bulk Export/Import module

Posted: Fri Feb 22, 2008 3:34 am
by JNeuhoff
Thanks Bruce, just sent an e-mail to Daniel.

Re: Updated Bulk Export/Import module

Posted: Fri Feb 22, 2008 5:38 pm
by JNeuhoff
Try the download now, Daniel has fixed the server.

Re: Updated Bulk Export/Import module

Posted: Sat Feb 23, 2008 7:15 am
by bruce
I am loving this contribution... well done and thank you for it.

Re: Updated Bulk Export/Import module

Posted: Mon Feb 25, 2008 11:31 pm
by JNeuhoff
I have uploaded another update of the Export/Import module for OpenCart 0.7.7. Thanks to Bruce's fixes, it doesn't impose the 255 characters-limit for the description fields anymore and it also makes better use of the memory.

It is now also compatible with the following contributions:

Category Descriptions
(http://www.opencart.com/contribution/in ... tion_id/36)

Featured/Special Offer/Latest Products
(http://www.opencart.com/contribution/in ... tion_id/26)



Hopefully the next release will support the upcoming OpenCart 0.8 version, if I can find the time to do another upgrade.

Re: Updated Bulk Export/Import module

Posted: Mon Mar 03, 2008 5:59 am
by fisher318
Hey Guys, I followed the export mod instructions exactly. Even went back and re-uploaded the files and followed the steps exactly a second time just to be sure. But when I select export/import option, i have the choice to either select the browse button, or an export button. When I click on "export", i get an error, page cannot be displayed deal. It's an http 500 error, and this is the page it's trying to go to. Any thoughts or help would be appreciated!

http://www.tbflashlights.com/admin/inde ... n=download

Re: Updated Bulk Export/Import module

Posted: Mon Mar 03, 2008 11:26 pm
by JNeuhoff
This is a 'catch-all' error generated by your Web server. Basically something has gone wrong, but the server can not be more specific about the error condition in its response to the client. In addition to the 500 error notified back to the client, the Web server should generate some kind of internal error log which gives more details of what went wrong. See my private message to you a few minutes ago.

J.Neuhoff

Re: Updated Bulk Export/Import module

Posted: Wed Mar 05, 2008 8:45 pm
by JNeuhoff
I found a patch.

See

http://pear.php.net/bugs/bug.php?id=12693

for more details.

It is now working. This error only showed up in the very latest PHP versions.

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 12:37 am
by fisher318
Yes, it works awesome! Thank you so much!!!

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 12:38 am
by fisher318
Can this feature upload NEW products as well? Or just edited ones?

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 8:24 am
by bruce
When you upload, it completely replaces your catalog with the contents of the spreadsheet. To add new items later, you would first export your catalog to a spreadsheet, add the new values to the spreadsheet and upload that.

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 8:42 am
by fisher318
Thanks for always being there with the answers Bruce. I exported my products, but no descriptions seemed to download. So when I upload these products, will I lose the descriptions? or the formatting of the descriptions or whatever?

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 11:25 am
by bruce
yep, you will lose the lot.

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 1:14 pm
by fisher318
Ok, that's good to know. That's a scary thing. So I guess then the only primary benefit to this module then is the export feature into a spreadshoot to upload into like Froogle or Yahoo product type search engines and stuff which require a spreadsheet upload.

Re: Updated Bulk Export/Import module

Posted: Thu Mar 06, 2008 1:52 pm
by bruce
I don't know about Froogle or Yahoo but it is perfect for...
  • migrating to OpenCart from an existing datastore
  • doing global updates on pricing
  • a complete refresh from an accounting system where you maintain your inventory, descriptions and pricing.
I loaded and exported (before the latest patch) a test system with thousands of products and hundreds of categories for a demonstration and it was working fine.

Re: Updated Bulk Export/Import module

Posted: Fri Mar 07, 2008 12:05 am
by jmigsanchez
Hi!
How can I apply the patch? The module has been updated?

Thanks!

Re: Updated Bulk Export/Import module

Posted: Fri Mar 07, 2008 11:59 pm
by JNeuhoff
Thanks for always being there with the answers Bruce. I exported my products, but no descriptions seemed to download. So when I upload these products, will I lose the descriptions? or the formatting of the descriptions or whatever?
You should always do an export first, then edit the products offline, finally re-import them. During an Import, all the previous products, categories, and options are deleted and completely replaced with the ones from the spreadsheet.

Re: Updated Bulk Export/Import module

Posted: Mon Mar 10, 2008 8:47 pm
by jmigsanchez
I received an error message saying PEAR.php was not found. In "Writer.php" the line 35 says: "require_once 'PEAR.php';"

So I dowloaded PEAR.php from http://pear.php.net/package/PEAR/download, put in the "admin" folder and it works for me now.

I love this module! Thank you!

Re: Updated Bulk Export/Import module

Posted: Wed Mar 12, 2008 7:44 pm
by ocw
I am running the standard dummy version 077 with the following language packs installed: (English), German, Dutch, Hungarian.
There was no error at all when I tried to Export, just a blank page, so I installed the pear module which enabled the Export function and allowed me to download the file backup_categories_products.xls.
I am very impressed by the output because this would make handling the shop as an administrator a quick and pleasant task.
After some editing I tried to Import but the following error halted the process:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error No: 1064
INSERT INTO `product_to_category` (`product_id`,`category_id`) VALUES ;

I checked the Products and Categories in the Administration Panel and noticed that only product_1 (MINIMOTO1)was visible - with all descriptions in other languages intact.
In the database only MINIMOTO1 was available, but all categories and product descriptions were unaltered, available in all languages.
You'll have to insert a scan the TABLE `language` for languages and produce the corresponding columns, like seen in TABLE `product_description`.