Update – Magento 1.4.1.1 – 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 [...]

Read this article…

Codeigniter – Sending Emails using Gmail’s SMTP Server

Sending emails and attaching files along with them are super easy! Just create a file called email.php in the config folder of your application. This file will contain the details of your Gmail SMTP server. In your Email controller, create a function with the following code… The above example is very basic, but explains how [...]

Read this article…

Stunning Product Images for eCommerce Websites

To persuade your consumers to buy your products over the internet is not an easy task. The consumer is on their own, without help from your sales staff, trying to make a buying choice. Product imagery plays a crucial role in eCommerce. When a consumer buys a product, without touching and feeling it, detailed product [...]

Read this article…

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 [...]

Read this article…

2011 UK VAT Rate Increase to 20%

The standard rate of VAT in the UK increases from 17.5% to 20% for all invoices raised on or after the 4th of January 2011. Unlike previous VAT changes this does not happen on the first of the month. Note: For companies outside the UK, this VAT change program does not need to be run. [...]

Read this article…

Open PDF Files using Google Chrome – Farewell, Adobe Acrobat Reader

Today, Google released a new version of their Google Chrome web browser. Chrome is probably the fastest and most secure web browser and it supports all the latest HTML and web standards. With the new version, Google Chrome 9, Google have added PDF support to the browser. This means, you can double click a PDF [...]

Read this article…

Google Instant – Killer of Poor & Mediocre Websites

Google recently launched a new feature called Google Instant to its search results. This feature offers searchers, using Google, a preview of the websites before they click the link. The snapshot of the webpage can help the Google user make a better judgement before visiting any website. The Ever Changing Google Businesses spend hundreds and [...]

Read this article…

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 [...]

Read this article…

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 [...]

Read this article…

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 [...]

Read this article…