How to remove all Custom option of all Products in Magento

How to remove all Custom option of all Products in Magento

August 22, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to remove all Custom option of all Products in Magento

Removing All Custom Options from Magento Products

If you find yourself in need of removing all custom options from your Magento products catalog, you’re not alone. This is a common task for stores looking to streamline their product offerings or switch to simpler configurations.

The Challenge: Thousands of Products with Custom Options

With 4000+ products and each having its own set of custom options, manually deleting them isn’t feasible. You need an automated solution that won’t break your website during the process.

Step 1: Backup Your Database

Before you begin any bulk operations in Magento, always backup your database. This ensures you can roll back changes if something goes wrong. For a complete backup guide, refer to our article on database management strategies.

Step 2: Delete Custom Options Using SQL

The most efficient way to delete custom options is by running SQL queries directly against your database. This avoids the overhead of Magento’s model loading and saves a significant amount of time.

First, log in to phpMyAdmin or use your preferred MySQL client. Then, run the following queries:

-- Delete all option values
DELETE FROM catalog_product_option_value;

-- Delete all options
DELETE FROM catalog_product_option;

These two queries will completely remove all custom options from your products. The first deletes the option values (the specific variations), and the second deletes the option definitions themselves.

Step 3: Clear Cache

After running these queries, it’s crucial to clear Magento’s cache to ensure changes are reflected immediately:

php bin/magento cache:clean

You can then verify that all custom options have been removed by checking a few products in the backend or refreshing your frontend.

Step 4: Update Product Indexes

Finally, update the catalog indexes to reflect the changes:

php bin/magento indexer:reindex

This ensures Magento’s internal search and sorting algorithms work correctly with the updated product data.

Conclusion

Removing all custom options from a large number of products in Magento is indeed possible with careful planning. By using direct SQL queries, you can delete thousands of records efficiently while minimizing server load.

Remember, always test changes on a staging environment before applying them to your live store. If anything goes wrong during the process, restoring from the backup will get you back up and running quickly.

Happy optimizing!

Catalog Database Admin Configuration

Our network