Skip to content

Instantly share code, notes, and snippets.

@SchumacherFM
Last active January 15, 2023 15:41
Show Gist options
  • Save SchumacherFM/103ec1482060ec93a481 to your computer and use it in GitHub Desktop.
Save SchumacherFM/103ec1482060ec93a481 to your computer and use it in GitHub Desktop.
Magento: Remove all NULL values from catalog_*_entity_* tables
DELETE FROM catalog_category_entity_datetime WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_decimal WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_int WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_text WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_varchar WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_datetime WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_decimal WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_gallery WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_group_price WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_int WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_media_gallery WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_media_gallery_value WHERE `label` IS NULL;
DELETE FROM catalog_product_entity_text WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_tier_price WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_varchar WHERE `value` IS NULL;
--then run reindexer
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment