Some products have catalog/product/view/id/2221/name-of-the-product from product URL magento 2?

Question

In the Site, product URL is like this: http://www.test.com/product-url-key

But when I searching the product then some product URLs are showing like this:

http://www.test.com/catalog/product/view/id/2221/product-url-key

This is not for all products.

i want to url like this type http://www.test.com/product-url-key.html

Answer 1

Note: Please take a backup of the database

To resolve this issue first delete the rows from the "url_rewrite" table which has 'product' as 'entity_type'. You can use below query

DELETE FROM `url_rewrite` where entity_type='product'

Then install below the extension

https://github.com/olegkoval/magento2-regenerate_url_rewrites

and run the below command.

php bin/magento ok:urlrewrites:regenerate --entity-type=product

This solution is worked for me, Hopefully, this will help you.

Answer 2

You can try/use Regenerate a Url rewrites extension.

The extension allows you to regenerate a Url rewrites of products and categories.

1 > Run command to re-generate Url rewrites for all categories/products for all stores:

php bin/magento ok:urlrewrites:regenerate

2 > To regenerate Url rewrites for specific store view (e.g.: store view id is "1"):

php bin/magento ok:urlrewrites:regenerate 1

Answer 3

Try this

Marketing > url rewrite > new url rewirte

Request Path "product-url-key"

Target Path "catalog/product/view/id/2221"

Redirect Type "no"

Save and flush cache

Or

Marketing > url rewrite

search with the "product-url-key" in Request path there you will get some idea.

Hope it might help

Answer 4

Try this:-

Solution 1-

• Marketing->URL Rewrite search the URL and edit the Request Path. OR you also can do this from database
• Go to the database select the url_rewrite table search with the "product-url-key" in and change the request_path of the product.

Solution 2-

• Go to the database select the url_rewrite table search with the "product-url-key" in and delete the URL then go to the product and save, it will auto-generate the product URL.

Answer 5

You can just use default magento feature URL rewrites for your concern

Marketing->SEO & Search->URL rewite

here you can create new rule for your particular URL. eg:

1. request path->http://www.test.com/product-url-key.html
2. target path->http://www.test.com/catalog/product/view/id/2221/product-url-key

and you will good to go.

dont forget to reindex and flush.