Skip import row, the value "" is invalid for field "attribute_set"

[marktecke]

Hello all,

so im trying to upload a list with ~300 items.

As soon as i hit the ''import profile'' i get tons of the error: Skip import row, the value "" is invalid for field "attribute_set".

The table is pretty much filled in as always and how it worked the last years for me. The attribute_set column is filled in, with an attributeset thats in Magento, too.

So what could cause the problem, anyone had something similar or knows how to fix it?

Thanks in advance!

[gelanivishal]

Hello @marktecke,

Apparently it was a matter of having the required columns + a few extras. Magento requires these 10 columns to be present in the CSV file, otherwise the import won't be valid:

1. type
2. attribute_set
3. tax_class_id
4. status
5. weight
6. sku
7. name
8. price
9. description
10. short_description

So please add column attribute_set in sheet and add it's value in it.

--
If my answer is useful, please Accept as Solution & give Kudos