Using the Index Management feature of your Magento website can solve various problems related to products or categories not appearing as they should on your site. It is also the solution to fixing a broken site search function. Here’s how… The Search Has Stopped Working on my Magento Website Is the Search function on your […]
Continue reading...27 February 2012
Do you need to put some content on the Home page of your Magento site, but not on others? Here’s how: Open the relevant .phtml template file which contains the code you want to show on the Home page. Then add the code below depending on which version of Magento you are using… In Magento version 1.4.x […]
Continue reading...30 September 2011
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...23 September 2011
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`; […]
Continue reading...3 August 2011
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...1 August 2011
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...27 June 2011
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...25 May 2011
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...4 April 2011
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...10 March 2011
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...
28 December 2012
0 Comments