I am trying to get rewrite product url from the load product in custom module. I am getting url in http://localhost/m2/catalog/product/view/id/1401/category/23/ format .

But I want http://localhost/m2/juno-jacket.html

Here is the code

in constructor

public function __construct(
    \Magento\Catalog\Helper\Product $catalogProductHelper,
) {
    $this->catalogProductHelper = $catalogProductHelper;

Custom function

public function abc(){
    $product_id = '123';
    return  $this->catalogProductHelper->getProductUrl($product_id);

abc() method return url like http://localhost/m2/catalog/product/view/id/1401/category/23/

  • rebuild your indexes – Marius Mar 17 '16 at 14:30
  • @Marius : i have rebuild too. It is not returning product rewrite url. – zed Blackbeard Mar 17 '16 at 15:01
  • is your product associated to any website? – Marius Mar 17 '16 at 15:05
  • I have assigned product in main website – zed Blackbeard Mar 17 '16 at 15:09
  • getProductUrl() is supposed to return the rewritten URL if the entry exist in url_rewrite. Did you delete records from this table manually? – musicliftsme Mar 17 '16 at 15:12

Here is the method I used to get the product url.

It is definitely not optimal as I have to load the entire product to get it so very bad in terms of performance.

First you need to inject a Magento\Catalog\Model\ProductRepository in your constructor:

use Magento\Catalog\Model\ProductRepository;
public function __construct(
    ProductRepository $productRepository
) {
    $this->_productRepository = $productRepository;

Then you load the product based on the product id:

$product = $this->_productRepository->getById($productId);

Finally you can get the URL model to retrieve the rewritten URL:

return $product->getUrlModel()->getUrl($product);
  • The double comma at the end isn't intended, isn't it? – Max Oct 19 '16 at 11:31
  • @Max yeah totally, I removed it – Raphael at Digital Pianism Oct 19 '16 at 11:38
  • 5
    I am facing the same and I have tried your code but still the urls are incorrect for me. Please advise. – Anshu Mishra Feb 7 '17 at 7:36
  • Another way (and less perf-killer) may be to force the addition of URL rewrites on product collection load. See my answer. – Hervé Guétin May 26 '17 at 11:25
  • same error can you please tell me where i can put this code ? – Rahul Katoch Jul 22 '17 at 10:51

This may not really answer the question but chances are that, if you are missing the URL rewrite, you may be getting your product out of a product collection. And adding URL rewrite info is not automatic as you can see in \Magento\Catalog\Model\ResourceModel\Product\Collection::$_addUrlRewrite.

The way I managed forcing the addition of URL rewrites is by creating a plugin on the create() method of \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory. And as soon as your code (or Magento's core code) uses this factory for instanciating a product collection (and it should as of best practices), this plugin forces the \Magento\Catalog\Model\ResourceModel\Product\Collection::$_addUrlRewrite to true.

Then, products URL rewrites are successfully added to the products without the need to loop on them and reload them. It thus fixes the perf downside that @Raphael spoke about.

Here is the plugin XML definition (in your di.xml file):

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <type name="Magento\Catalog\Model\ResourceModel\Product\CollectionFactory">
        <plugin name="your_plugin_unique_nane" type="Your\Plugin\Namespace\Plugin" />

And the plugin code:

namespace Your\Plugin\Namespace;

use Magento\Catalog\Model\ResourceModel\Product\Collection;
use Magento\Catalog\Model\ResourceModel\Product\CollectionFactory as CoreCollectionFactory;

class Plugin
     * @param CoreCollectionFactory $subject
     * @param Collection $collection
     * @return Collection
    public function afterCreate(CoreCollectionFactory $subject, Collection $collection)

        return $collection;
  • I tried this way, but plugin class is not executing. Do you know why? – Deeps May 24 '18 at 11:23

Export your products to a csv file

from the csv file in Excel use this formula for the url_key column


where "P103" is the url_key column

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.