OptimiseBlog

How to remove Recurring Profiles & Billing Agreements links from customer account navigation menu in Magento

I spent quite a while trying to work out how to remove the Recurring Profile and Billing Agreements links from the Customer Account navigation menu in Magento. There are plenty of blog posts and Magento forum topics describing how to comment out or even delete the appropriate lines in the billing_agreement.xml or recurring_profile.xml files like [...]

Continue reading...

Update – Magento 1.5.1.0 – Delete Test Orders & Customers using SQL

As always, please backup your database and files before running raw SQL queries against your Magento database. I’ve tested this on a Magento CE 1.5.1.0 site today and it works. Source : http://www.magentocommerce.com/boards/viewthread/2960/P15/#t348791

Continue reading...

Magento – Newsletter Subscribe Form in Footer or Header

It used to be the case that to move your Newsletter Subcribe form, or other Magento blocks, from their original position in your Magento template you would need to go and find the relevant lines in the layout XML files and modify them to show in a new postition. This however was a tedious process; [...]

Continue reading...

Add a link to the product on the admin order page

We recently had a client who asked to have a link added to the magento admin order page so they could easily see what the product was. It requires a core hack so isn’t recommended. If you want to go ahead here’s the code: Open app/design/adminhtml/default/default/template/sales/order/view/items/renderer/default.phtml at look and at ~ line 68 until you [...]

Continue reading...

Fix: Magento Catalog Search Broken / Not Working

We recently updated a Magento install from 1.3.2.4 to 1.5.1.0. Everything worked fine, expect the search function. Whatever we searched for, the site returned just one result. This seems to be a problem with upgrades and even some fresh installs of Magneto 1.4.1.1, 1.4.2, 1.5.1.0, etc. The following is the fix. This will require fixing [...]

Continue reading...

Magento Upgrade from 1.4.X.X to 1.5.X.X via SSH

Since Magento 1.5.0.0 the SSH upgrade command has been changed to ./mage instead of ./pear. If you have used ./pear upgrade-all in the past, you will now have to use the ./mage version. I was upgrading from Magento 1.4.2.1 to Magento 1.5.1.0. I’m using the Community Edition. For ./mage to work you need to CHMOD [...]

Continue reading...

Magento Delete All ‘Url Rewrite Management’ URLs in the Database

To delete all the URL rewrites from the Magento admin backend, you can do the following: Using your favourite database browser, connect to your Magento database Go to the table named ‘core_url_rewrite’ Empty this table Log back in to the Magento backend and reindex all This action will clear out all manually and system created [...]

Continue reading...

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

Continue reading...

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

Continue reading...

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