Home » Forums » Ubercart » Support
8 replies [Last post]
Thu, 12/13/2007 - 19:22
Jmmb
Jmmb's picture
Offline
Joined: 08/23/2007
Juice: 301
Was this information Helpful?

Hello,

One of our clients (http://e3living.com/) wants to export his product data to be imported at shopping.com. Apparently it also needs to be a comma-delimited file. I was reading the thread about import-export, but it mostly covered importing.... So I'm wondering if Ubercart can export in such a file format, and how to do it.

Thanks for any information,

Jim

(Drupal^Ubercart) * (Design^Development^Hosting) = Sundays Energy

Top
Fri, 12/14/2007 - 02:04
#1 View page
TechMosaic
TechMosaic's picture
Offline
Joined: 12/12/2007
Juice: 13
Use Excel...

You can use the export utility to create the xml data you need, then use excel to open it up, and then resave it as a csv file.

Excel is VERY finicky, you may need to edit the xml file to take out characters it does not like - but if it fails to open, it does tell you what row and column the offending character was in. After a few dozen edits, it should open fine. I just went through this and it worked well for me.

Top
Fri, 12/14/2007 - 14:04
#2 View page
Jmmb
Jmmb's picture
Offline
Joined: 08/23/2007
Juice: 301
Re: Use Excel...

Thanks for your response - it's very helpful. I do have one follow-up question:

I can't seem to find much in the forum or Ubercart admin about a specific export utility. Is it part of the Ubercart core, a contributed module, or something else? If you could point me to where this utility is (either for download or in Ubercart) that'd be much appreciated.

Thanks,

Jim

(Drupal^Ubercart) * (Design^Development^Hosting) = Sundays Energy

Top
Sat, 12/15/2007 - 00:09
#3 View page
JonW
JonW's picture
Offline
Joined: 12/05/2007
Juice: 94
Import location

The import export utility is located with the products.

http://yoursite.com/admin/store/products

You may have to enable it by going into the modules (http://yoursite.com/admin/build/modules) and enabling IMPORTER in the "Ubercart Extras" section

Top
Sat, 12/15/2007 - 01:03
#4 View page
mimetic2
mimetic2's picture
Offline
Joined: 08/07/2007
Juice: 478
Re: Import location

I also comissioned a CSV Generator. While it might not work for shopping.com it iwll be a close start. I will upload it for the weekend.

Top
Mon, 12/17/2007 - 17:15
#5 View page
Jmmb
Jmmb's picture
Offline
Joined: 08/23/2007
Juice: 301
Re: Re: Import location

Thank you for your responses - now I see what's going on!

Also, I appreciate your work on a CSV generator. Do let us know when you've uploaded that and we'll try it out with Shopping.com....

Regards,

Jim

(Drupal^Ubercart) * (Design^Development^Hosting) = Sundays Energy

Top
Wed, 08/20/2008 - 03:25
#6 View page
oliver coleman
oliver coleman's picture
Offline
Bug Finder
Joined: 01/09/2008
Juice: 212
Patch for uc_importer for CSV export

I've just submitted a patch for uc_importer at http://www.ubercart.org/issue/6129/extend_uc_importer_export_csv that allows exporting products (nothing else yet) in CSV format. The format is compatible with that used in http://www.ubercart.org/contrib/5221 . It adds a select box on the product export page to allow choosing between xml and csv.

Top
Thu, 09/25/2008 - 04:18
#7 View page
svihel
svihel's picture
Offline
Joined: 05/29/2008
Juice: 140
Re: Patch for uc_importer for CSV export

Is there a chance to export all products in whole? I maybe misslooking something but I'm unable to export products other way than by selecting each one of them in exporting page. This seems to be impossible to do if you have like 1000+ products Sad

Top
Sat, 10/25/2008 - 00:07
#8 View page
armyofda12mnkey...
armyofda12mnkeys@drupal.org's picture
Offline
Joined: 10/20/2008
Juice: 43
Re: Re: Patch for uc_importer for CSV export

yes i would also like to know how to do this. i dont mind setting php time limit to 2hrs or however long it will take Smiling, i just dont want to spend a long time exporting many items, but i'm a lil' lazy. Is there anyway it can export the images as well?

Top