Tag: sql

3 posts   See also:  product

Undo Order Cancel in Magento

If you want to restore canceled order, rollback order cancellation and undo order cancel action in Magento and Magento 2 use the following SQL query...

 1 comment   2019   magento 1   magento 2   magento2   mysql   order   sql

Find Products Without Images

SELECT `p`.`sku` FROM `catalog_product_entity` AS `p`...

 No comments   2019   gallery   images   product   sql

Hide all categories without products and show categories with products

Reindex category products index at first and then execute following sql-script

 No comments   2016   category   product   sql