Magento 2.3 - Multi store Product Name duplicates error

[Aveeva]

I have migrated Magento from 1.9.2.3 to 2.3.4, if i try to change the product details i am getting error like product name isn't unique. I am using multi-Store so that the same product name available in all stores How to handle this issue? I can't able to import the product images.

[gaurav_harsh1]

Hello @Aveeva 

you can check if you are able to change it from admin in :

Store > Attributes > Product > Edit Name Attribute

if you are not able to change the property of attribute to non-unique, you can run database query like below :

UPDATE 'eav_attribute' SET is_unique = 0 WHERE `entity_type_id` = 4 and  `attribute_code` like 'name'

Hope it helps !

[Aveeva]

@gaurav_harsh1 After run the command 

UPDATE 'eav_attribute' SET is_unique = 0 WHERE `entity_type_id` = 4 AND  `attribute_code` LIKE 'name'

Still, i am getting error,

The value of the "Product Name" attribute isn't unique. Set a unique value and try again.

[Aveeva]

@gaurav_harsh1  Any help thanks.

[gaurav_harsh1]

@Aveeva 

Did you check before updating the attribute if any attribute is there ?
please check if that attribute is there or not by :

SELECT * from 'eav_attribute' WHERE `entity_type_id` = 4 AND  `attribute_code` LIKE 'name'

please share the whole row data, if the row has "is_unique" and it's value should be 0.

after checking or confirming.

run below command :

php bin/magento indexer:reindex
php bin/magento cache:flush

Let me know if you still getting the same error.

[Aveeva]

@gaurav_harsh1  There is no file in DB 

Screenshot : https://snipboard.io/rZ931q.jpg

[gaurav_harsh1]

@Aveeva 

SELECT * FROM eav_attribute  WHERE `entity_type_id` = 4 AND `attribute_code` LIKE 'name';

[Aveeva]

@gaurav_harsh1  Yes, available 

https://snipboard.io/aXB9Cg.jpg

[gaurav_harsh1 · Accepted solution]

set it to 0 by command :

UPDATE eav_attribute SET is_unique = 0  WHERE `entity_type_id` = 4 AND `attribute_code` LIKE 'name';

if doesn't let you update, update it with ID.

[Aveeva]

@gaurav_harsh1  During image import why i am getting this error 

Imported resource (image) could not be downloaded from external resource due to timeout or access permissions