Magento – Cannot remove “.html” from URL in Magento 2

magento2seourl-rewrite

I am trying to remove ".html" from the URL. Attached are my catalog SEO setting in the Magento 2. As you can see I have remove the ".html" from both Category URL Suffix and Product URL Suffix.
enter image description here
I'm stumped as to why it still shows the .html at the end. I have cleared all caches and reindexed all indexes.

Best Answer

This worked for me:

UPDATE `url_rewrite` SET `request_path` = REPLACE(`request_path`, ".html", "")

It simply removes the .html suffix from the URL rewrites table. You then need to reindex after.

Related Topic