Anse Anse - 1 year ago 86
MySQL Question

No INSERTs on catalog_product_super_link when using simple_skus column

My CSV file works fine with Magmi for most things, except one: Adding a comma separated list of skus in the "simple_skus" column of a configurable product won't insert rows into either of the tables

. I have another script which relies on rows in these both tables, which now does not work on such imported products.

Using the option "auto match simples skus before configurable" would insert rows here, but using the simple_skus column does not. I cannot use matchable skus because I must follow another pattern for skus.

Shouldn't Magmi insert rows in both of these tables?

Answer Source

Got it: The CSV file needs to have empty configurable_attributes values for the simple products. So, my working CSV file looks like this:

06964615_DBT,Apple pie creme,simple,base,admin,myattributes,0,1,1,1000,3.19,4.41,apple-pie-06964615,1,1,1,,,,apple-pie-creme-06964615.png,,100 ml,
06964621_DBT,Apple pie creme,simple,base,admin,myattributes,0,1,1,1000,5.75,7.77,apple-pie-06964621,1,1,1,,,,apple-pie-creme-06964621.png,,200 ml,
06964615_06964621_DBT,Apple pie creme,configurable,base,admin,myattributes,0,1,4,0,0,0,apple-pie,1,1,1,,,,apple-pie-creme-06964621.png,06964615_DBT,06964621_DBT,,size
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download