One of our Magento clients uses different customer groups to offer different price discounts on orders. When customers buy $100 worth of products within a year they become bronze member with 5% discount on future orders and Silver member if $200 or over and Gold if $300 and over and they get discount accordingly.
Magento is an awesome ecommerce web application but sometimes it gives a real headache. As I am creating mobile theme, the requirement was, it should load desktop version theme on everything other than mobile devices. But the real challenge was when user decides to load desktop version even on mobile devices it should load desktop version not mobile template.
/*run these if exists*/
ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_2` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_3` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_4` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_2` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_3` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_4` ENGINE=InnoDB;
/*below table exists in enterprise version. tested on 1.12.0.2*/