- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
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 !

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
@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,
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
@gaurav_harsh1 Any help thanks.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
SELECT * FROM eav_attribute WHERE `entity_type_id` = 4 AND `attribute_code` LIKE 'name';

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
@gaurav_harsh1 Yes, available
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3 - Multi store Product Name duplicates error
@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