cancel
Showing results for 
Search instead for 
Did you mean: 

Search configurable product by a child SKU

Search configurable product by a child SKU

Hi to all, I need to search for a configurable product by a child SKU (without make visible on search each simple product)... How it's possibile? Any idea?

 

Thanks a lot!

Stefano

3 REPLIES

Re: Search configurable product by a child SKU

@stefx

 

First of all, search the Child Products By Sku and from that list you find the configurable product of that child Product.

Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html

Re: Search configurable product by a child SKU

 

$products = Mage::getModel('catalog/products')
->getCollection()
->addAttributeToFilter('sku', YOUR_SIMPLE_SKU);

then join $products with catalog_product_link, catalog_product_link_type to find the parent products

Re: Search configurable product by a child SKU

if you are talking about the search box in front page, then you will have to rewrite fulltext indexer engine.