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

Read this article…

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. [sql] — here are the tables modified for 1.5.0.1 SET FOREIGN_KEY_CHECKS=0; TRUNCATE `sales_flat_order`; TRUNCATE `sales_flat_order_address`; TRUNCATE `sales_flat_order_grid`; TRUNCATE `sales_flat_order_item`; TRUNCATE `sales_flat_order_status_history`; TRUNCATE `sales_flat_quote`; TRUNCATE `sales_flat_quote_address`; […]

Read this article…

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; […]

Read this article…

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

Read this article…

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

Read this article…

A Helping Hand for Optimise Users

Many users are not aware that there is documented help on-line for the Optimise System. To access it, choose Help – Search Help from the Optimise menu or go to http://oltd.co.uk/Help on your web browser. A Table of Contents is shown first. If you want to search by keyword, choose Keyword Index at the top […]

Read this article…

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

Read this article…

Increase Maximum File Upload Size in WordPress

In some cases the file you are trying to upload into the Media Library in your WordPress installation may be bigger than the maximum allowed size. This is a common problem, but it is easy to fix. At Optimise Web our web servers have a maximum upload limit of 2MB. Occasionally we have clients who […]

Read this article…

Hide Pages from a Menu in WordPress 3.x

If you have a page in WordPress you do not want to appear on a menu — for example, say you have created a static Home page, but don’t want it to be shown on the main menu, you can add an exclude argument in the menu function. Find the function which calls your menu, […]

Read this article…

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

Read this article…