Importing Products using Feeds
The wonderful Commerce Feeds module, with its parent Feeds allow you to import various kinds of feeds as products and/or as product reference nodes. Edit: You may be also be interested in Commerce Migrate and this screencast on how to use it to import Ubercart stores.]
In this example we'll be bringing in a CSV feed and turning it into both products and product reference nodes in two separate operations.
Our CSV has just a few fields and the first couple of lines look like this:
"SKU","Title","Price","Image","Description"<br>"0023548568","Computer Graphics Using Open GL (2nd Edition)","11000","http://ecx.images-amazon.com/images/I/51JQbhO0MmL.jpg","Great book blah blah..."
The SKU is the unique identifier for the product, and of course the other items are self-descriptive. The Image is a URL to an image.
You can view and explore the feed at http://d7.randyfay.com/books/feed. Note that this is just an example feed - it could be something other than CSV, the fields could be named differently, etc. We do need a unique identifier (the SKU), which we'll also use to map the product reference nodes to products.
- Install and enable feeds and commerce_feeds
- Create a new feed importer named "Product Importer" at Administration -> Structure -> Feeds
- Change the parser to "CSV Parser"
- Change processor to "Commerce Product Processor"
- In "Commerce Product Processor" settings use product type "product" (or whatever your product is) and change the "Author" to your username.
- In "mapping", map
- SKU -> Product SKU
- Title -> Product Title
- Price -> Price: Amount
- Image -> Image
- Set ID as unique target.
- Visit /import, use the Product Importer.
- Use http://d7.randyfay.com/books/feed for the URL
- Import your products
- Visit the products page (admin/commerce/products) to view your new products
- Note that you can delete items using the feed or with commerce_vbo
- Now we'll import the same data again, but this time we'll turn it into product display nodes.
- Go to admin/structure/feeds and create a new feeds importer
- Change the parser to CSV
- Change the processor to Node Processor
- Choose the "Product Display" node type
- Set the author to yourself
- Under mappings
- SKU -> GUID (and set unique target)
- Title -> Title
- Description -> Body
- SKU -> Product SKU
- Visit /import
- Use the Product Reference Importer
- Use the same feed URL: http://d7.randyfay.com/books/feed
- Now you have 100 shiny new product reference nodes, pointing to products.
If you need to import products with additional attributes or other fields, that works fine too; you'll need the "Feeds Tamper" module for it.
Here's the screencast demonstrating it, followed by the recipe.
Update 26 Sept 2011: The "Feeds Tamper" tab is now an Operation as "Tamper" in Feeds
- Add your attribute to the product type
- Add the attribute to your csv file
- Change the mappings in the product importer to add the attribute
- Create a node import CSV file that has the list of products as comma-separated within the quotes: "SKU1,SKU2,SKU3"
- Create a node import feeds importer (or just use the standard one from commerce_feeds_example)
- Create a feeds tamper rule at admin/structure/feeds tamper that explodes the SKU field in the node as it imports.
- Import your nodes.
If you need to import prices that are not in minor units (they're $1.50 instead of 150) then this screencast explains how to use Feeds Tamper to transform them on import: