Magento themes and extensions

Copy SQL Server database on same server

Posted on November 21st, 2012 | Posted by admin

Use the following instructions when you need to create a copy of an existing database on the same server.

- Create a backup of the existing database.
- Create the new database and select the task ‘Restore’
- Select the db backup file to restore, however as the backup is for another database on the existing server the option ‘Overwrite the existing database (WITH REPLACE)’ must be selected
- Before restoring the database, just check the filepaths where the database is being restored too!

How to configure Magento Full Page Cache

Posted on November 20th, 2012 | Posted by admin

Here we present an answer to this big question and a headache for many.
Can I configure the Full Page Cache to refresh a specific block content automatically without cleaning the Magento cache from the admin?
Well, you can:

Setting the Page Cache:

First, create a new configuration file with the name cache.xml within the etc folder of your extension, which will contain the following structure:

Magento Website – Restricting Admin Access to Specific System Configuration Fields.

Posted on November 19th, 2012 | Posted by admin

Magento enterprise has some amazing features out of the box that allow you to restrict roles to specific web sites and sections. Unfortinately the system out of the box doesn’t let you micro manage the configuration fields. Imagine that you have a senario where you want an admin user to be able to edit certain configuration fields, but not all of them. Out of the box magento lets you limit the roles to certain sections like “Store Email Addresses” or “Contacts” but it doesn’t let you limit each individual item.

For example, I want an admin group to be able to go into the backend and edit the “Store E-mail Addresses” but I don’t want them to be able to edit anything but the fields “Custom E-mail 1″ and “Custom Email 2″. Well I have down and dirty way to limit fields from your admin users. Follow my steps and you will be able to limit the system configuration on your admin web site past the out of the box norm.  This tutorial requires you to know a bit about css and php.

Adding New Regions/States to your Magento Installation

Posted on November 18th, 2012 | Posted by admin

You may have noticed that Magento doesn’t include the Region/State information for a lot of countries. This can be particularly frustrating if you’re trying to set up your shipping rules and would rather use states than postal codes or if you just want to show a nice drop down on the front end of Magento for your customers.

There is a solution, to manually add the information to  the tables in your database. The tables are directory_country_region and directory_country_region_name.  The table directory_country_region holds the region codes and region id and then the directory_country_region_name provides the translation for you locale by using the region id  and the locale you want to provide the translation for. Magento will then pick up on this and populate a drop down list.

I’ve already done this for the UK (translated to English only). Please find the CSV files at the below links which you can upload via phpMyAdmin. Don’t forget to change the delimiter to comma rather than semi-colon as it is by default.  These are provided as is and can be freely edited.

Adding Pinterest Button to Magento Product Page

Posted on November 17th, 2012 | Posted by admin

Pinterest looks like it is going to be the next big thing to hit the internet. It has grown massively in a short amount of time and is a very effective marketing tool for e-commerce websites, providing you have good quality images.

I have recently added the “Pin-It” button to FOODO, my Australian food website. I tried to play with adding to to every page of the website but it wouldn’t work, so I had to settle adding it only to the product pages.

The page you want to add the code to is called view.phtml located within your theme at/app/design/frontend/theme/theme/template/catalog/product/.