I have created a
.csv file and then created a profile to import simple products which works absolutely fine.
However when I create a configurable product, it does not associate the simple products to the configurable products?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
The most usable way is to build a configurable in the backend, export it and look at it. Every Other approach is somewhat difficult to get the head arround.
Sadly i only have good documentation in german at hands, but the structure you need could be extracted from those sources: http://www.webguys.de/magento/turchen-19-produktimport-mit-der-importexport-schnittstelle/ http://de.meet-magento.com/wp-content/uploads/review/ImportExport_Vinai.pdf
Like @Nils says, the best way is to first create one configurable product with associated simple products in the admin panel manually and then do an export using the export function from
System > Import/Export > Export. By doing this you will have a
.csv file that is fully compatible with your Magento version.
When closely examining the file you should also see some specific columns for configurable products, for instance:
You will need to enter the correct data for each configurable product in those columns. If you do this the right way then the simple products should be associated to the configurable products automatically.
I found this article with guide on how to import configurable product and simple product in Magento, you can use Migami or some 3rd party Magento extension for configurable product import in Magento Magmi is the most powerful tool to import both simple and configurable product in Magento. If you want to Migami, click on this link to download Migami: http://sourceforge.net/projects/magmi/
You should try Magmi. I think it is the most powerful import tool. You can import configurable products and associate simple products: http://wiki.magmi.org/index.php?title=Configurable_Item_processor
For importing the configurable product along with its associated (simple) product. In the product CSV you will have to add extra attribute which are not mentioned in above comments. Also after exporting CSV magento will not add the attributes in CSV.
In the End of CSV file add these attributes these two attributes:
Uses of the attributes:
Now when the the CSV will uploaded the configurable product will get uploaded with its configurable option(color, size etc) and all the associated(simple) products will be added.
This document helped me to execute this import.