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 communityI 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?
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
_super
. Please find more details in my answer.
Dec 15, 2014 at 15:01
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:
_super_products_sku
,
_super_attribute_code
,
_super_attribute_option
, and
_super_attribute_price_corr
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.
.csv
file. What Magento version are you using? This may be different for older versions, I don't know. Please also read this info carefully. It is for Magento Go but also applies to CE.
Dec 15, 2014 at 15:59
System > Import/Export > Export
feature to see the correct columns.
Jan 31, 2017 at 20:30
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.
Thanks!
This document helped me to execute this import.
https://www.lexiconn.com/blog/2016/01/magento-2-import-configurable-products/