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.
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.
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 !
@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,
@gaurav_harsh1 Any help thanks.
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.
SELECT * FROM eav_attribute WHERE `entity_type_id` = 4 AND `attribute_code` LIKE 'name';
@gaurav_harsh1 Yes, available
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.
@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