cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2.3 - Multi store Product Name duplicates error

SOLVED
Highlighted

Magento 2.3 - Multi store Product Name duplicates error

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

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.

 

Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !

View solution in original post

9 REPLIES 9
Highlighted

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 !

Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !
Highlighted

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,

 

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

 

 

Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

@gaurav_harsh1  Any help thanks.

Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

@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.

 

Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !
Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

@gaurav_harsh1  There is no file in DB 

 

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

Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

@Aveeva 

 

SELECT * FROM eav_attribute  WHERE `entity_type_id` = 4 AND `attribute_code` LIKE 'name';
Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !
Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

Highlighted

Re: Magento 2.3 - Multi store Product Name duplicates error

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.

 

Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !

View solution in original post

Highlighted

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