Finding products with and without custom options using SQL

To find all products that have keine no custom options, run this query:

SELECT
  *
FROM catalog_product_entity
WHERE entity_id NOT IN (SELECT DISTINCT
    product_id
  FROM catalog_product_option);

SELECT

FROM catalog_product_entity

WHERE entity_id NOT IN (SELECT DISTINCT

product_id

FROM catalog_product_option);

To find all products that do have custom options, simply remove “NOT” from the query above.

Finding products with and without custom options using SQL

Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.

Tags: custom options product SQL

The Magento Expert