To get all products that do not have custom options, simply run the following SQL query:
SELECT
*
FROM catalog_product_entity
WHERE entity_id NOT IN (SELECT DISTINCT
product_id
FROM catalog_product_option);
To get all products that do have custom options, remove the “NOT” from the above query.
Getting products with or 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.