How can I get the Url of a product from its SKU in Magento

How can I get the Url of a product from its SKU in Magento

August 25, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How can I get the Url of a product from its SKU in Magento

Retrieving Product URLs by SKU in Magento: A Comprehensive Guide

In many e-commerce scenarios, you may find yourself needing to retrieve the URL of a product using only its SKU, especially when dealing with third-party integrations or search functionalities. Magento, being a robust e-commerce platform, provides several ways to achieve this. Let’s dive into the best practices for getting a product URL by SKU.

Understanding the Magento Product Model

The core of Magento’s product management lies within the catalog_product table and its corresponding model class Magento\Catalog\Model\Product. The SKU is stored as a unique identifier in this table, which we can use to fetch relevant product information.

use Magento\Framework\App\Bootstrap;
require __DIR__ . '/app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$obj = $bootstrap->getObjectManager();
$state = $obj->get('Magento\Framework\App\State');
$state->setAreaCode('frontend');

$productSku = '24-MB01';
$product = $obj->create('\Magento\Catalog\Model\Product')->loadByAttribute('sku', $productSku);

if ($product) {
    echo "Product Found: " . $product->getName() . "\n";
} else {
    echo "No product found with SKU: " . $productSku;
}

In this example, we are using Magento’s built-in Bootstrap system to initialize the application context. We then use the loadByAttribute method of the Magento\Catalog\Model\Product class to fetch a product by its SKU attribute.

Getting the Product URL

Once you have loaded the product successfully, you can access its URL using the getUrlPath method provided by the model.

$productUrl = $product->getUrlPath();
echo "Product URL: " . $productUrl;

The getUrlPath method returns a relative URL path for the current product. To get the full URL, you may need to integrate it with your site’s base URL or use Magento’s URL generation components.

Best Practices and Performance Considerations

While this approach works well in small-scale applications or development environments, it is essential to consider performance optimizations for larger stores:

  1. Caching: Implement caching mechanisms for repeated product lookups using technologies like Redis or Memcached.
  2. Indexing: Ensure the catalog_product_index_eav index is enabled and up-to-date to speed up attribute lookups.
  3. Avoid Direct Object References: Rather than directly loading objects by ID, consider using Magento’s search functionality for better performance.

When to Use Third-Party Libraries

In some advanced scenarios, you might opt for a dedicated library like Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection or Magento\Framework\Indexer\BatchInterface to handle complex product searches more efficiently. However, these options may require a deeper understanding of Magento’s architecture and indexing systems.

Conclusion

Retrieving a product URL by SKU in Magento is a common requirement for e-commerce developers. By leveraging the built-in Product model and its loadByAttribute method, you can quickly fetch products based on their unique identifiers.

Remember to optimize your code for performance, especially in high-traffic environments, by implementing caching strategies and ensuring proper indexing of product data.

As a seasoned developer at Laravel Company, I’ve found these techniques invaluable for integrating Magento with third-party systems or enhancing the user experience through intuitive search functionalities.

Catalog Database

Our network