Importing Products to Ubercart from CSV
Here's a step-by-step guide on how to import products to Ubercart from CSV. First, you'll need a suitable CSV of your products. We use this products CSV as a base to work from - it contains columns for these product details: SKU, Name, Category, Cost Price, Sell Price, Weight, Description, Features. You'll also need to install the node_import module from Drupal.org.
If your Ubercart configuration differs from the one documented here, you may need to modify your import file and process accordingly - but the basics should still hold true.
New Import
Access the first page of your product importer at admin/content/node_import and load your CSV file into the file upload dialogue. If you've kept the CSV settings from the file attached above, you can leave all the other settings the same. Click "Next (mapping)" to move on to the next stage.
Mapping
Use the select boxes to choose the correct fields to match each column of your import file. You will probably only need to do this the first time around; after that the importer should remember the correct mapping. If you see both "Description" and "Product: Description", you probably want to choose "Description".
Options
There are some advanced options available on this screen, but you probably don't need to use them at all. (See the node_import documentation for more detail about this screen.)
Preview
On this screen you can check that your products will be correctly imported. By default you'll see the first five products, or you can review more if you like by changing the selector at the bottom and pressing "reload". Check that the details look correct before hitting "Appy (import nodes)".
Import Nodes
You're done! Review any error messages - you might need to tweak the CSV file (for example, if your category names in the CSV didn't exactly match the categories in your site).
More clues ...
Please do read the comments below for a few extra clues added after this was written!
Comments
where is the file download
where is the file download link?
There is no spoon
Multiple attributes
We are using multiple attributes for each product entry. How can we import these?
Re: Multiple attributes
Do you mean attributes which can have multiple entries? You could try importing several columns into the same field - otherwise you might need to do that separately post-import.
You might also find that, like taxonomy entries, you can import multiple values by separating them with a pipe character.
Please do post back if you find a solution which works for you!
Updates ...
I've been doing some more Ubercart setups (with more recent UC releases) and there are a couple of additional clues which might help people.
First of all, you may want to add the Ubercart import functionality to node_import. In the node_import folder, there is a subfolder called "supported". Download the most recent uc_import.inc from http://www.ubercart.org/contrib/5221 and install that into this folder to have Ubercart-specific features added to node_import.
Also, if you have multiple categories per-product, you can import them now! The default method is to use a pipe character - | - to separate the taxonomy ID(s) or taxonomy name(s) for each row.
Happy Ubercarting!
Ubercart 2 / Drupal 6 support?
Is this working correctly with UC2 and D6 at this point?
I haven't tested it
I haven't tested it extensively, but the fact that uc_product.inc for D6/UC2 is available at http://www.ubercart.org/contrib/5221 indicates that some people are already doing so.
We'll be rolling out a few carts on D6/UC2 soon, so are looking forward to finding out!
How about sharing your csv template?
Could you share your csv template?
Post new comment