Magento Design UK – PSD to HTML Magento Template

Thursday, 8. September 2011

Zone-Connect specialise in Magento Design, PSD to HTML implementation. We are experienced in Magento Design implementation normally from PSD to amazing HTML templates that will look and feel exactly like the way the designer intended.

If you want us to help implement a Design into Magento templates or you simply need advice on Magento implementation, please get in touch with us through one of our contact details today.

Looking forward to hearing from you!

Can’t Select Payment Option on IE9 Magento Onepage Checkout

Thursday, 8. September 2011

My client reported this strange behaviour on IE9 that happens when a customer tries to checkout using onepage checkout on Magento.

What was happening in this case was when a customer is going through the checkout steps, they select the shipping method fine but when they click to go to choose the payment method, IE9 was automatically refreshing the page and take them back to the first step again!

After a bit of head scratching and testing, came to realise two issues where noticeable on this case:

1) There was a Javascript error in one of old files. So I fixed that

2) The always saviour boiler plate stuff! I noticed the site was missing the compatible quirk so I thought I should give it a try..

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=8"/>
<meta http-equiv="X-UA-Compatible" content="IE=7"/>

3) Finally, cleared Magento cache, tried the checkout again.. and Whallah! it fixed it!

It worked for me and if you are experiencing the same problem you may want to give it a try.

Let us know if this helped you.

Magento Africa : Taking Magento To Afrikans!

Wednesday, 7. September 2011

Well, we are starting something great in Africa and Magento Africa is definitely some project to be involved with!

It has been in my mind for sometime now and I think it’s about time to get things rolling. Africa as we know is one of them places slowly getting up to speed and despite all the odds, e-commerce is another new big things that’s slowly but surely getting into the area.

In my opinion, this could not come at a better time when Magento platform is still free, widely available and supported. There are many things to be done to get the entire nation on song with things online, but I am convinced now is the time to get the point across.

Magento Africa is still at early stages and contributions, ideas and any support in relation to the subject is definitely welcome so if you are reading this and want to get involved, please drop a comment or contact me today to discuss further.

Many thanks for reading..

Fatal error: Failed opening required ../includes/downloader/pearlib/php/PEAR.php

Sunday, 4. September 2011

Fatal error: Failed opening required ../includes/downloader/pearlib/php/PEAR.php

If you have suddenly starting to see this error when accessing your Magento connect page, it’s more likely you have recently enabled the compilation mode.

You will notice that the downloader path has suddenly change to webroot/includes/downloader which is a clue the compiler is currently running.

Two ways to solve this:

1) Either temporarily disable the compiler while you are installing the extension:
System > Tools > Compilation > Disable

2) If you have access to FTP or Control Panel, upload the downloder folder to the webroot/includes folder

Integrity constraint violation: 1052 Column ‘position’ in order clause is ambiguous

Tuesday, 30. August 2011

This is a small bug on core file located here:


The error will usually happen when you perform a simple search on your Magento site. To locate and fix the bug do the following:

Search for method getFilterableAttributes() and look for something relating to the code below.

public function getFilterableAttributes() {
            ->setOrder('position', 'ASC');

The setOrder needs to look something like code below:

public function getFilterableAttributes() {
            ->setOrder('main_table.position', 'ASC');


I would NEVER recommend you edit core files directly. If you can not create a custom extension to override this method you should at least copy and edit this file in your local Mage folder.

So you should have something like:


Then do the changes here as explained above.

Magento Grouped Products | HowTo Get Associated Grouped Products

Thursday, 25. August 2011

If you are working with Magento Grouped Products and want to list all its associated products (links) here is a snippet script on how to do just that:

if ($_product->isGrouped()) {
  foreach ($_product->getGroupedLinkCollection() as $linkprod) {
    ......Your implementation here

Locale Mage en_GB | Magento Local Module For GB

Tuesday, 23. August 2011

In order to install the Locale_Mage_community_en_GB you will need this module here:



Ogone Payment | Detected an illegal character in input string in

Tuesday, 23. August 2011

For Ogone Payment users, If you have ever come across such error during checkout process the issue is actually really simple:

Basically, you have an illegal/invalid character on your Product name somewhere and since the product name is also posted to Ogone for payment processing, this will cause an error:

To fix it: as you may already guessed, please remove the bad character and try again!

Magento SagePay Orphaned Transactions : What are they and What do They Mean?

Monday, 22. August 2011

Magento SagePay Orphaned Transactions:

what are they and why are they there in the first place? You may learn something from this post!

I have always wondered myself why and what these messages do mean and most importantly, do they have any negative effect on client’s sites?

After a bit of digging, I came to narrow it down to a number of points:

1) This seems to be (but not limited to) SagePay Direct protocol.

2) These are simply informational reports rather than errors on your page or SagePay. It simply SagePay trying to be useful and informational to you by being causing a little confusion!

The reason why this happens in the first place is that by default all transactional requests to SagePay (especially with SagePay Direct protocol) will always return an OK response on the very first attempt.

Locally, SagePay will create and hold an orphan child and wait for the final order completion to process the final payments and then update this orphan record to complete or processing etc.

Now if for any reason the customer did not complete the order successfully, these orphan records remains on the system and SagePay will then notify you about them suggesting there is transactions happened but there is no order associated with them.

So, personally I will probably not loose any sleep on these but rather on finding our why customers choose not to complete their order and how to minimize shopping cart abandonment.

Drop a comment if you have any more insights on this and/or if you would like to suggest something more interesting!

Magento vs Persistent Shopping Cart – Magento Supported Feature out of the box!

Saturday, 20. August 2011

If you have been following the various stages of Magento release you would have noticed that from now, Magento do support Persistent Shopping Cart out of the box!

To most store owners Persistent Shopping Cart will bring smile to their faces and if you have been wondering how on earth this was not supported much earlier, wonder no more!

Persistent Shopping Cart.

what is it after all?

Well, to answer this shortly, Persistent Shopping Cart allows customer’s shopping carts to be persisted or saved across sessions.

What this means is that, Imagine a customer has added a few items in the shopping cart and then gets an emergency to attend to before finishing her checkout process. Under the current settings the session will preserve her contents for a short period of time before it expires and looses all the cart settings.

When the customer returns the next day for example, she will have to add the items to the cart all over again and usually while cursing your system, a lot!! (We have all done this!)

With Persistent Shopping Cart, when she returns tomorrow to her laptop and goes to your website again, all her contents will be right there waiting for her to finalize the checkout process. In fact, Magento will support persistence for customers across user sessions, browsers and devices.

I think this is fantastic! Can you imagine how many happy customers you will make and most importantly how many abandoned shopping carts you are going to save?

Obviously this is not the ultimate solution to your shopping cart abandonment issues (Yes, I am sure you have them!) but it can help save those few ones which were abandoned simply because a customer was pissed off and couldn’t be asked to “re-fill” the cart again.

Persistent Shopping Cart by diagram

Magento Persistent Shopping Cart
Note: The user must log in once per browser/device combination to establish persistent shopping

Quoting MagentoThe user will not be able to complete the checkout process or access account information unless they are officially logged in. Persistent shopping cart is completely configurable by merchants, provides an additional way for the merchant to strengthen customer satisfaction and loyalty and helps increase conversion rates.

Drop us a comment if you found this helpful and/or you want to add your experience or views on this topic.