OptimiseBlog

Magento Tax Rates – Import / Export

With the UK VAT rate going up to 20% from 17.5%, many Magento users might be wanting to know how to change the tax rates in the backend of Magento. If you cater to many countries and wish to mass edit the tax rates, using the Import/Export feature is the best option. The following image [...]

Continue reading...

Magento : Delete Test Orders & Customers using SQL

When moving a Magento development site to live or cleaning up dummy orders and customers, you might want to wipe out all test customers and orders from the Magento database / backend. The following SQL queries can be run on the database. Be careful: make a backup of the database before doing this. I’ve run [...]

Continue reading...

Magento with GetClicky & Analytics : Campaign Revenue Tracking

With Analytics, GetClicky and other tracking tools, you can setup campaigns and the revenue associated with it. To track the revenue of all orders in Magento, you will have to include a bit of Javascript code on the checkout success page. Edit the checkout/success.phtml file inside your template folder. In case of GetClicky, the campaign [...]

Continue reading...

Secure GetClicky Tracking Code on Magento Website

To use GetClicky analytics / tracking codes with Magento’s SSL (HTTPS) protected pages, you have two options. One is to use GetClicky’s HTTPS code throughout the website or use it within an IF clause. The following demonstrates an inbuilt Magento funtion to check if the visitor is on a HTTPS or HTTP page. The above [...]

Continue reading...

Replace Links with Images in a Magento 1.4 Menu

Here’s how to replace the text links with images in the top level of your Magento menu (tested on Magento 1.4.1.1)… First, make a copy the following file… app/code/core/Mage/Catalog/Block/Navigation.php Place the file in folder… app/code/local/Mage/Catalog/Block/ – if this folder doesn’t exist, create it (This process creates a version of the Navigation.php which will over-ride the [...]

Continue reading...

Magento Catalog Images Dissappear When You Refresh Cache

Recently we encountered a problem with Magento, where all our product catalogue images vanished from the page when we refreshed the Images cache in the Magento backend (System -> Cache Management). After hours of scouring the internet we discovered that, because PHP Safe Mode was enabled on our server configuration, the images were not auto-resizing. [...]

Continue reading...

Magento Tip : Get Grouped Product’s Associated Simple Products on Category Page

Here is a simple trick to get the sub-products of a grouped product on the category products listing page. Add the following code to the products list.phtml file. $_associatedProducts = array(); if ($_product->getTypeId() == 'grouped') { $_associatedProducts = $_product->getTypeInstance(true)->getAssociatedProducts($_product); } Once you collect all simple product data associated with the grouped product, you can loop [...]

Continue reading...

Change the Number of Columns in Product Grid – Magento 1.4

In Magento the default number of columns in the Product Grid view is 3. This is fine for a 3 column layout. If you creating a custom layout, however, you may need to change the number of columns (or Column Count). This is how you do it. In the catalog.xml file in your skin’s Layout [...]

Continue reading...

Fixed Magento Checkout : Set ‘Ship to This Address’ as Default

How often would you buy from an online shop and ship the goods to an address that is different from your billing address? Sometimes, I do use the card that is registered with my home address, but use my office address for delivery. This might not be the same case with about 80% of online [...]

Continue reading...

Internet Explorer Adds Twice the Quantity to Cart

We all like to style our Magento add to cart button as an image button. The problem is that IE 8 (Internet Explorer 8) will add the product twice and cause the quantity of that product in the cart to double up. There is an easy fix to this problem.

Continue reading...