Magento – Invalid value for Attribute Set column (set does not exists?) in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,

importexportmagento-1.9migration

I have a products exported file from Magento 1.14 EE and I want it to import in magento 1.9 CE.

When I am trying to upload that I'm getting following error:

Invalid value for Attribute Set column (set does not exists?) in rows:
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44,
45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61,
62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78,
79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95,
96, 97, 98, 99, 100 Orphan rows that will be skipped due default row
errors in rows: 26, 27, 28, 29, 30, 31, 32

Best Answer

Naveen, when you import products using a csv Magento checks the value you used in the _attribute_set column. If there isn't an attribute set with that name in your CE instance then it will show that error. Go to Catalog > Attributes > Manage Attribute sets to see what this value should be. If it is a brand new CE installation it will probably be called Default.

Note, that when you fix this issue you may find you have problems with attribute names if you haven't recreated those in your CE installation to match the ones in your EE.