Magento Coupons insert

Experimenting with inserting magento coupon codes directly into the db ive found you need to run the following two inserts   INSERT INTO `mg_salesrule` (`rule_id`, `name`, `description`, `from_date`, `to_date`, `uses_per_customer`, `is_active`, `conditions_serialized`, `actions_serialized`, `stop_rules_processing`, `is_advanced`, `product_ids`, `sort_order`, `simple_action`, `discount_amount`, `discount_qty`, `discount_step`, `simple_free_shipping`, `apply_to_shipping`, `times_used`, `is_rss`, `coupon_type`, `use_auto_generation`, `uses_per_coupon`, `promo_sku`) VALUES (181, ‘Wills Test’, NULL, NULL, […]

Magento Remove Sidebar Cart and Compare

To remove the Cart and compare products from the sidebar within magento go to customer.xml in your themes layout and comment out the following couple of lines <block type=”checkout/cart_sidebar” name=”cart_sidebar” template=”checkout/cart/sidebar.phtml”> <action method=”addItemRender”><type>simple</type><block>checkout/cart_item_renderer</block><template>checkout/cart/sidebar/default.phtml</template></action> <action method=”addItemRender”><type>grouped</type><block>checkout/cart_item_renderer_grouped</block><template>checkout/cart/sidebar/default.phtml</template></action> <action method=”addItemRender”><type>configurable</type><block>checkout/cart_item_renderer_configurable</block><template>checkout/cart/sidebar/default.phtml</template></action> </block> <block type=”catalog/product_compare_sidebar” name=”catalog.compare.sidebar” template=”catalog/product/compare/sidebar.phtml”/>