Magento 2 Product Import Problem

Question

I got an Error on Magento 2 Product Import - which says:

Value for 'visibility' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1
Invalid value in Store column (store doesn't exist?) in row(s): 1

But in the Store column I has the value 0 and in the visibility, the value 4 for Catalog, search so I don't know why that's wrong ?!

Does any have an idea?

if any need to see the import csv -> dropbox.com/s/gftdjgtaaipru2k/abc-import-products.csv?dl=0 — FullSystem
– FullSystem, Commented Aug 13, 2018 at 9:57
add one of the products from the backend manually and export it, analyze exported sheet. — Yash Bhayani
– Yash Bhayani, Commented Mar 7, 2022 at 10:23

Rv Singh · Accepted Answer · 2018-08-13 09:43:32Z

In Magento 2 product can't be imported if attribute set is absent in system.

You will receive next error after Data Validation:

Invalid value for Attribute Set column (set doesn't exist?) in row(s): x

You have to create attribute set manually in Admin Panel or via API request.

the Attribute Set "Default" in my import csv is also available in admin panel — FullSystem
– FullSystem, Commented Aug 13, 2018 at 9:48

elburro1887 · Accepted Answer · 2019-09-17 11:53:58Z

You can't use the integer values, you need to use the text values, which are dependent on the locale.

2 Answers 2