search

royalwholesalecandy / core

A custom module for royalwholesalecandy.com (Magento 2)
https://upwork.com/fl/mage2pro
0 stars 0 forks source link

«Duplicated url for store ID 2, product 1616 (S79363) - URL key for specified store already exists» #116

Closed dmitrii-fediuk closed 4 years ago

dmitrii-fediuk commented 4 years ago

Related to https://github.com/royalwholesalecandy/core/issues/5

dmitrii-fediuk commented 4 years ago 
bin/magento regenerate:product:url 1616
dmitrii-fediuk commented 4 years ago

2020-01-02_2-09-46

dmitrii-fediuk commented 4 years ago 
DELETE FROM catalog_product_entity_varchar WHERE 127 = attribute_id AND entity_id IN (3825);
DELETE FROM catalog_product_entity_varchar WHERE 126 = attribute_id AND entity_id IN (3825) AND 0 <> store_id;
DELETE FROM url_rewrite WHERE 3825 = entity_id AND 'product' = entity_type;
DELETE FROM url_rewrite WHERE 1616 = entity_id AND 'product' = entity_type;
bin/magento regenerate:product:url 3825
bin/magento regenerate:product:url 1616