Thursday, November 28, 2013

How to Import Configurable Product Data into Magento

This is really part 2 of a 2 part tutorial on scraping configurable product data, which began here. For those people not interested in the scraping aspect of this project, you can download the magento sample data here. Warning, this sample data might be NSFW if you have an uptight boss.

The first thing we're going to need to do is set up our categories. Open the products spreadsheet in Excel or something similar and Highlight the _category column (column L) and copy that. Bring that into a text editor and sort the values / remove duplicates. Each unique needs to be a category in Magento or you will get an import error. When you create the the categories, set them to 'Enabled' so they show up in your storefront. Drag all your categories into the "Default Category" root category after you make them.

Next we need to set up the attributes. Copy columns _super_attribute_code and _super_attribute_option (S and T) into your text editor and sort/remove duplicates. You'll see unique values for 2 attributes, color and size. These both need to be set up in Magento.

So go to Catalog / Attributes/ Manage Attributes, create a new color attribute if it doesn't exist and set:

Scope - Global
Catalog Input Type for Store Owner - Dropdown
Use To Create Configurable Product - Yes

Next click on Manage Label / Options and add your color options. Then do the same for size.

Now you're all set for a clean import. Head over to System - Import / Export - Import, select Products, and upload the spreadsheet. If you are using Magent Go you can import the Product Images in the same way. Otherwise you'll want to ftp those to your media folder.

7 comments:

  1. Very useful!! thanks. But Image not uploaded. Please help

    ReplyDelete
  2. You can try extension http://www.mlx-store.com/magento-extensions/import-export/export-import-bulk-product-with-configurable-product-bundle-product-grouped-product-downloadable-product-tier-price-group-price-related-products-up-sells-cross-sells-product-tags-magento.html

    ReplyDelete
  3. I trying to importing configurable product with all my custom attribute which i have created but after importing not all attribute importing only one attribute import in the process. i want all attribute which on my attribute set

    ReplyDelete
  4. Hi to all
    I looked for configurable product import tool that allows to set prices for superattributes and came across this tutorial - https://www.mag-manager.com/useful-articles/how-to/how-to-import-magento-super-attribute-price/
    Seems that they have cool data importer - https://www.mag-manager.com/useful-articles/tipstricks/massively-associate-child-simple-products-to-main-configurable-via-import-to-magento/

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Great Read! I am impressed on how you make your article easy to understand. I'll come back for more :D

    Japs Buidon is a Social Media Specialist and belongs to a team of Magento Developer in Florida. For more tutorial and tips you can follow him here -> http://alwaysopencommerce.com/

    ReplyDelete