18 Jun

Quickly associate images to your Magento products without using dataflow

Dataflow is great and does allow the association of multiple images natively, but upon wanting to add around 2,500 product images to a catalogue in Magento 1.5.0.1 - we noticed that they have broke the core support in dataflow for this,great! So instead, we just knocked up a quick script which would associate images to … Continue reading

3 Dec

Automatically change the VAT rate on 4th January

Unless you are lucky enough to have a development agency that is willing to make changes to your store just after New Years Day, you might benefit from running this little script. With the proposed change to 20% on January 4th 2011, you can automate the rate change in your Magento installation. You'll need to … Continue reading

11 Nov

Controlling the cache size when using database as a backend Magento

If you have been using the database as a cache storage mechanism (Eg. <slow_backend>) and you have a large number of SKUs, you will start to see a database that increases in size by quite a measure. A customer of ours with around 160k SKUs, had a "core_cache" table that had grown to just under … Continue reading

4 Nov

Amasty multiple coupons bug fix for Magento 1.4.0.x

We installed the Amasty Mutiple Coupons extension for a client recently, but ran into a few hiccups immediately after installation. Fortunately, it is quickly fixed. In Amasty_Coupons_Model_Rewrite_Mysql4_Rule_Collection on line +62 + if (version_compare(Mage::getVersion(), '1.4.1.0', '>=')) $this->getSelect()->where('main_table.coupon_type = ?', Mage_SalesRule_Model_Rule::COUPON_TYPE_NO_COUPON); [syntaxhighlighter]

4 Nov

How to fix PaymentSense's gateway "orderStatus" error

We recently integrated the PaymentSense's gateway for one of our customers. While making some test transactions, we noticed the extension raised a basic PHP error on the callback: Undefined variable: orderState in /http/app/code/local/Paymentsense/Paymentsensegateway/controllers/PaymentController.php on line 812 Hopefully, this error will be fixed in their new release. Undefined variable: orderState The following fix removed the error … Continue reading

1 Oct

Yoast landing pages module with layered navigation

First, a thanks to the team at Yoast for a handy little module. We needed to add layered navigation to the result pane, but it appears others were struggling with a solution - so here's the answer! Create your CMS brand/focus page as normal, then add the Yoast_Filter block: <reference name="content"> <block type="Yoast_Filter/Result" name="filter_result" template="catalog/product/list.phtml"> … Continue reading

15 Sep

How to attach files using dataflow product import for Magento Aitoc Useful Downloads

Thanks to Aitoc for a handy extension, Useful Downloads, which allows downloads/attachments to be added to a normal simple product. We recently implemented this for a client but realised it lacked a little in functionality. We wanted to import a batch of new products, and add attachments at the same time (much like you would … Continue reading

13 Sep

Remove "Gift Message for this Order" from Magento emails

In Magento 1.4.1.0 the new gift message facility appears to be missing some relevant lines from the templates to be able to disable the "Gift Message for this Order" area from the email template. Thankfully, its an extremely quick fix. Open up ./app/design/frontend/base/default/template/email/order/items.phtml and wrap the final table with a conditional statement. <?php if(Mage::getStoreConfig('sales/gift_messages/allow_items')): ?> … Continue reading

2 Sep

Magento Sagepay Extension Ebizmarts faults and fixes

A client of ours needed to upgrade to a direct payment method for SagePay, so with Ebizmart's Sagepay approved extension, we grabbed a copy and popped it on. Unfortunately, it wasn't long before we started experiencing problems. We have contacted Pablo @ Ebizmarts who was relatively receptive about the issues, hopefully, they will be fixed … Continue reading

24 Aug

MySQL Limitations on the Flat Catalogue in Magento

We recently came across this problem with a customer who had painstakingly created every attribute possible for all his products. The result, a brilliantly user-friendly store, the downside, flat-catalogue product won't work! The error you are likely to see in Magento is as vague as Can't initialize indexer process. A table in MySQL has a … Continue reading