I've imported a whole load of products into Magento, and as required they are set as configurable or simple.

All I need to do now is tie the simple products to their configurable "parent". I have the array mapped out, so it's not a matter of logic but rather how I actually achieve this.

I tried inserting a bunch of rows into "catalog_product_super_link" and that did work, temporarily. However, as soon as you save a product, the rows disappear from the database.

Can anybody point me in the right direction? I've found a few solutions through Google that don't work, I'm not sure if something has changed between 2.0 and 2.1...


If you are importing using CSV then you need to add one column named configuration_variations and add value in it with | separation.


  • Thanks for the reply. I'm not using CSV, the data is coming from a bunch of JSON files that we've assembled by scraping an old 1990s HTML website. – Geat Nov 14 '16 at 16:29
  • 1
    Well, I bit the bullet and changed the way I approach the import by generating a simple CSV file (and then tacking on other fields programmatically in a second pass) and your approach works. – Geat Nov 14 '16 at 23:24
  • 1
    It should be noted though that the column header is actually "configurable_variations" – Geat Nov 14 '16 at 23:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.