e-commerce

Magento SSH maintenance

Posted by | Reference | No Comments

What’s this all about? Well there’s various forum posts and great tips out there for maintaining your Magento installs. I’ve collated some of these together below for my own purposes and ease of access:


rm -rf downloader/pearlib/cache/*
rm -rf downloader/pearlib/download/*
rm -rf var/cache/*
rm -rf var/session/*
rm -rf var/report/*
rm -rf var/tmp/*


TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_event;
TRUNCATE catalogsearch_fulltext;
TRUNCATE catalogsearch_query;
TRUNCATE catalog_compare_item;


chmod -R 777 lib/PEAR
./pear mage-setup
./pear upgrade -f magento-core/Mage_All_Latest-stable
chmod 550 ./mage
./mage mage-setup .
./mage sync
./mage list-upgrades
./mage config-set preferred_state stable
./mage upgrade-all --force


find . -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \;

php -f index.php

Magento Upgrade 1.3.x to 1.4.x Custom Theme Issues Fix

Posted by | Reference | No Comments

From reading through the blogosphere and all the varying Magento forums its obvious lots of people are having issues in upgrading from Magento 1.3.x to 1.4.x due to custom theme problems and errors. I was no different! Who would have thought these things could be so difficult!?

After several attempts at upgrading Magento to 1.4.x failing dismally I set about toying with a development site until I could figure out what was what?! Its detailed everywhere that your 1.3.x theme will have to be re-written to work with 1.4.x but I’ve managed to get a simple enough process working for me in upgrading Magento 1.3.x to 1.4.x and keeping my custom 1.3.x theme working in 1.4.x without any re-development at all! So here goes:

  1. Log into the Magento Backend Admin Panel and remove products that you have placed in more than one category. Just have your products in one category otherwise these cause errors after the upgrade.
  2. Turn off SEO url rewrites (System >> Configuration >> Web >> Search Engines Optimization)
  3. Turn off cache management (System >> Cache Management)

The following from CrucialWebHost’s help site is perfect:
A little cleanup first:

rm -rf downloader/pearlib/cache/* downloader/pearlib/download/*

Set the permissions on the pear file so we can run it:

chmod 550 pear
I then cleaned out the cache myself manually to be sure:
rm -Rf var/cache/*
and again from the CrucialWebHost:
Initialize the PEAR channel just in case:

./pear mage-setup .

And then we can upgrade:

./pear upgrade-all

If it tells you that there's Nothing to upgrade, you'll need to do this instead:

./pear install magento-core/Mage_All_Latest

Lastly, we need to clear out any temporary and cached data. These commands will be done via SSH in the staging directory.

rm -rf downloader/pearlib/cache/* downloader/pearlib/download/*
rm -rf var/cache/ var/session/ var/report/ media/tmp/

And then reset our file and directory permissions:

find . -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \;
chmod 550 pear

After this point delete everything in the following to clean out the backend cache (you need to do this or you will get errors when saving new configurations and probably logging into magento admin after upgrade too)
rm -Rf app/code/core/Zend/Cache/*
Log into your new 1.4.x Magento Backend Admin Panel from index.php/admin/

  1. ReIndex Data on everything (System >> Index Management)
  2. Turn on SEO rewrites  (System >> Configuration >> Web >> Search Engines Optimization)
  3. Turn on Cache Management (System >> Cache Management)

From this process you have theoretically upgraded your Magento installation to the latest 1.4.x version of Magento and have your custom theme working fine. Or at least I have, I can’t guarantee that this process will work for everyone out there?!

Good luck.

International collaboration helps local business conquer web

Posted by | Project | No Comments

The Camera Centre – Reboot!

Visit www.thecameracentre.net

The Camera Centre website’s last incarnation had been turning over since 2004 and it was time to launch into the 2010 new year with a vibrant and easy to use system not only for members but for administration also. Tieing more succinctly with back-end shop operations the new website cuts out tedious stock filling across multiple systems whilst providing an easy to use interface for not only members but for guest shoppers also.

An easy to use one click shopping basket facility provides users the ability to choose and purchase items without getting bogged down in multiple pages of payment processing. This simple feature provides a substantial reduction in abandoned shopping baskets and invertly an increase in sales; what everyone want’s! With several successful Search Engine Optimisation techniques running throughout the site, The Camera Centre is now even easier to find.

Press Release

Local Shetland retailer The Camera Centre has just launched a new internet store with some international help.

Owner Cecil Hughson and Manager, Ben Mullay knew that to extend their business a fresh online initiative was needed. This was especially important as many of the Camera Centre’s customers are in the outer islands and don’t travel into Lerwick often. There is also a large expat community who like to order photos for delivery to relatives in Shetland.

Working with New Zealand based marketing strategists, First Retail Ltd, Canadian software developers Dakis Decision Systems Inc and Cecil’s son in law John Smith, owner of yadUK, The Camera Centre has developed a product range that includes home-wear, gifts and décor – all created using customer’s own photos.

First Retail’s Director, Chris Wilkinson knew the Camera Centre’s dilemma well. With clients in many island territories including the Channel Islands, The Cook Islands, French Polynesia and Fiji the web has been a key element in helping these businesses engage with their community.

Up until recently, many of the products needed to be sent away for production. New technology has allowed stores in remote areas to create these on-site. The Camera Centre has invested in equipment, systems and training that will ensure work can stay within the Islands. In the future it is hoped the store will also develop export markets to the mainland and beyond.

Timed to launch in the key gift giving period leading up to Christmas, the site has already proven popular. Within hours of going live, orders began to arrive. Most popular lines so far have included photo collages, coasters, placemats and mousemats.

Launched on December 4th 2009
PHP, MySQL, e-commerce, SEO

First published on yadUK on Dec 28, 2009

Ben Mullay – Shetland Photography

Posted by | Project | No Comments

Ben Mullay is a professionally qualified photographer having gained his Licentiate of the Society of Wedding and Portrait Photographers (LSWPP).

Clients can choose from a range of packages to suit all budgets with a pre-wedding meeting to discuss requirements. Ultimately, Ben believes that the special day is for the happy couple and not for the photographer, so carefully pre-planning and an unobtrusive style on the day helps achieve this.

Ben Mullay Photography specialises in digital wedding album design, creating seamless double-page spreads to tell the story of your big day in one beautiful album. Smaller albums are also available for parents and other family members. Canvas Gallery Wraps make a stunning piece of décor for the home and, with their reasonable prices and sizes to suit all budgets, are a big favourite at Ben Mullay Photography. Ben is also the Managing Director of The Camera Centre in Lerwick.

Ben Mullay is continually looking to create eye-catching and striking images to convey what is viewed through the lens. Ben’s home village of Bigton, Shetland, is the site of the famous St Ninian’s Isle, reputably the largest tombolo in Europe.

 
XHTML, CSS, PHP, MySQL
Hosted by yadUKHosting
goto site http://www.benmullay.com/

First published on yadUK on: May 3, 2009