Url | The Magento Expert

Finding Product URL Rewrites with SQL (Magento 2)

Mex 19. Oktober 2026 Magento Solutions

When product URLs behave unexpectedly, a direct look at Magento’s url_rewritetable can be useful. It stores public-facing paths, internal targets and redirects for product URLs. Use the following query to display URL rewrites for a specific SKU:

SELECT
    p.sku,
    u.store_id,
    s.code AS store_code,
    s.name AS store_name,
    u.request_path,
    u.target_path,
    u.redirect_type
FROM url_rewrite AS u
JOIN catalog_product_entity AS p
    ON u.entity_id = p.entity_id
LEFT JOIN store AS s
    ON s.store_id = u.store_id
WHERE u.entity_type = 'product'
  AND p.sku = 'MEINE-SKU'
ORDER BY u.store_id, u.request_path;

SELECT

p.sku,

u.store_id,

s.code AS store_code,

s.name AS store_name,

u.request_path,

u.target_path,

u.redirect_type

FROM url_rewrite AS u

JOIN catalog_product_entity AS p

ON u.entity_id = p.entity_id

LEFT JOIN store AS s

ON s.store_id = u.store_id

WHERE u.entity_type = 'product'

AND p.sku = 'MEINE-SKU'

ORDER BY u.store_id, u.request_path;

request_path contains…

View solution

Getting the current URL in a template (Magento 2)

Mex 9. Juli 2019 Magento Solutions

The following code returns the current URL in a Magento 2 template (phtml):

$currentUrl = $this->getUrl('*/*/*', ['_current' => true, '_use_rewrite' => true]);

1	$currentUrl = $this->getUrl('//*', ['_current' => true, '_use_rewrite' => true]);

View solution

Reindex URL rewrites (Magento 2)

29. Juni 2018 Magento Solutions

The URL rewrites of Magento 2 will not be reindexed when rebuilding the index via command line. I recommend using https://github.com/olegkoval/magento2-regenerate_url_rewrites to include the reindex of URL rewrites on the shell. This Magento 2 extensions allows for reindexing all URL…

View solution

Reindexing URL rewrites (Magento 2)

Mex 2. Mai 2018 Magento Solutions

Magento 2 URL rewrites are not updated simply by rebuilding the indexes. If you want to rebuild them from the command line, I recommend using https://github.com/olegkoval/magento2-regenerate_url_rewrites. This extension lets you regenerate all Magento 2 URL rewrites from the shell. Afterwards,…

View solution

Removing slash at the end of a URL (Magento 1)

Mex 1. November 2013 Magento Solutions

Open your .htaccess file in the Magento root directory and add those lines:

RewriteCond %{request_method} ^GET$
RewriteCond %{REQUEST_URI} ^(.+)/$
RewriteRule ^(.+)$ %1 [L,R=301]

RewriteCond %{request_method} ^GET$

RewriteCond %{REQUEST_URI} ^(.+)/$

RewriteRule ^(.+)$ %1 [L,R=301]

View solution

Getting URL parameters (Magento 1)

Mex 25. Juli 2013 Magento Solutions

To get a Magento URL parameter, use the following code:

// URL: http://localhost/project/index.php/admin/sales_order/index/id/123
$id = Mage::app()->getRequest()->getParam('id');

1 2	// URL: http://localhost/project/index.php/admin/sales_order/index/id/123 $id = Mage::app()->getRequest()->getParam('id');

View solution

Getting a category URL using the category id (Magento 1)

Mex 25. Juli 2013 Magento Solutions

To get a categories URL by category id, use the following code:

$categoryId = 55;
$url = Mage::getModel("catalog/category")->load($categoryId)->getUrl();

1 2	$categoryId = 55; $url = Mage::getModel("catalog/category")->load($categoryId)->getUrl();

View solution

Getting the current URL (Magento 1)

Mex 15. Juli 2013 Magento Solutions

Use the following code to get the current URL in Magento:

$currentUrl = $this->helper('core/url')->getCurrentUrl();

1	$currentUrl = $this->helper('core/url')->getCurrentUrl();

View solution

Getting the URL of a product image and display the image (Magento 1)

Mex 12. Juli 2013 Magento Solutions

Use the following code to get a Magento products URL and to display the image on a tempate page:

<img src="<?php echo $_product->getImageUrl(); ?>" alt="<?php echo $_product->getName();?>" />

1	<img src="<?php echo $_product->getImageUrl(); ?>" alt="<?php echo $_product->getName();?>" />

View solution

Reading request parameters (Magento 1)

Mex 3. April 2013 Magento Solutions

The following short snippet is sufficient to read a Magento request parameter:

// Read the ID request parameter
// URL koennte so aussehen: http://www.domain.de/index.php/irgendwas/id/251/
$id = Mage::app()->getRequest()->getParam('id');

// Read the ID request parameter

// URL koennte so aussehen: http://www.domain.de/index.php/irgendwas/id/251/

$id = Mage::app()->getRequest()->getParam('id');

View solution

« Previous