To get all products that do not have custom options, simply run the following SQL query:
WHERE entity_id NOT IN (SELECT DISTINCT
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
You want or need help implementing this solution? Maybe you did not find what you were looking for? Contact me and I will assist you with whatever Magento problem troubles you!