Skip to content

Instantly share code, notes, and snippets.

@0-Sony

0-Sony/reset_all_products.sql

Created April 16, 2019 13:10
Show Gist options
  • Save 0-Sony/00549a3c71c72bf8b38e59a575aee36b to your computer and use it in GitHub Desktop.
Save 0-Sony/00549a3c71c72bf8b38e59a575aee36b to your computer and use it in GitHub Desktop.
Download ZIP
Magento 2 : Reset all products data and use the default config value
Raw
reset_all_products.sql
DELETE FROM `catalog_product_entity_text` where store_id <> 0;
DELETE FROM `catalog_product_entity_datetime` where store_id <> 0;
DELETE FROM `catalog_product_entity_decimal` where store_id <> 0;
DELETE FROM `catalog_product_entity_int` where store_id <> 0;
DELETE FROM `catalog_product_entity_varchar` where store_id <> 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment