1 reply [Last post]
grobot's picture
Offline
Joined: 04/12/2008
Juice: 289
Was this information Helpful?

Is there a guide to importing products into the system?

I know I need to generate an XML file, but not what specific format. I'm hoping that the importer will work something like node_import.

Customer is using Microsoft Office, so will need him to be easily able to import directly into the system an updated stock listing.

Any pointers welcome - would be happy to help in writing this document:
* http://www.ubercart.org/docs/user/3369/importing_and_exporting_products

This one is very specific, but doesn't really document the process of how to turn a spreadsheet of product details into a complete store:
* http://www.ubercart.org/docs/user/354/importing_data

Giant Robot - for campaign, charity, ngo & online store solutions - www.giantrobot.co.nz

cdiggity's picture
Offline
Bug Finder
Joined: 09/14/2007
Juice: 40
Re: Import products HOWTO

The second link details the XML format so you know exactly what format the XML data needs to be in. You can always make some example products with the properties you want and then export them to get a sample XML file.

You can search for the CSV importer in the forums but I don't know how well it works if it does at all. You may have to write a bit of code in your favourite language to convert the flat file (ie your spreadsheet or CSV file) into an XML file. My weapon of choice would be Perl. The database and XML file have lots of one to many relationships that will be represented differently in everyone's CSV files hence the general difficulty in making a CSV to xml converter.