Welcome To Snipplr


Everyone's Recent MySQL Snippets Tagged magento



« Prev 1 Next »
  1. FAV

    Average discount in magento 1.4.1

    MySQL 5 views posted 8 years ago by simsevu
  2. FAV

    Truncate Magento logs

    MySQL 5 views posted 8 years ago by hotdiggity
  3. FAV

    Restoring a backup in Magento

    Wrap these two sets of commands around your sql backup if it hasn't come from a backup from the Magento admin interface (Magento adds this). This stops foreign key checks and then restarts them. The /*!40101 ---- */ code around the SET command...
    MySQL 5 views posted 9 years ago by TheJasonParker
  4. FAV

    Cleanly delete all categories

    MySQL 5 views posted 9 years ago by TheJasonParker
  5. FAV

    Disable products by category

    After the MySQL above has run – you’ll need to let Magento take the reigns back a little to update the category indexes, this is quite straightforward, but a little time consuming. Login to your admin and go to System > Cache Management, the s...
    MySQL 5 views posted 9 years ago by TheJasonParker
  6. FAV

    Disable products by sku

    You'll first need to find the attribute_id value for 'status' for your Magento installation and replace 273 in this example. The easiest way to tell is if you go into: Admin > Catalog > Attributes > Manage Attributes Then in the “Attribute...
    MySQL 10 views posted 9 years ago by TheJasonParker
« Prev 1 Next »