How to get the product type by the product SKU?

Question

I have some product SKUs in my custom module and I want to get just the simple products. I don't want to load each product entity by SKU in a loop to get the product type to avoid performance issues.

How could I filter these products?

Answer 1

You can use SearchCriteria to get load the product JUST if this product exists with the type that you want.

use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Model\Product\Type;
use Magento\Framework\Api\FilterBuilder;
use Magento\Framework\Api\SearchCriteriaBuilder;

---

$searchCriteria = $this->searchCriteriaBuilder
    ->addFilter('sku', $itemSku, 'eq')
    ->addFilter('type_id', Type::TYPE_SIMPLE, 'eq')
    ->create();
$productsItems  = $this->productRepository->getList($searchCriteria)->getItems();