Category Archives: Web Project Management

To move a wordpress site from one domain to another, you need to execute the following SQL scripts on the database:
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

This works as of WordPress 2.8.

There are increasingly a range of acronyms being thrown around in web marketing that sometimes slip out when interacting with clients. Here’s a brief overview of some of the more common e-marketing acronyms to ease the conversation.

• SEM
  Search Engine Marketing
  SEM is a broad term covering the range of activities you might engage in to improve the extent to which you generate revenue via search engines

I first delved into javascript frameworks with Prototype, but I quickly realised that the Prototype+Script.aculo.us combination, even in Protocoluous or Protopackt form, was never going to work – it was just too slow.

I moved to MooTools, and for a while was pretty happy – load times were quicker, effects smoother.

But having recently tried to build sorting and filtering functionality into an HTML table of 200+ rows, I’ve been forced to take a closer look at how different browsers execute javascript, and at where the bottlenecks are. Here I’m going to promote a few best practices, largely via Julien LeComte at Yahoo.

There are a real plethora of eCommerce solutions out there now, making it difficult to isolate which solution is best for you. Some solutions are free and open-source, some licensed or bought off the shelf, and others custom-built – each has it’s advantages and disadvantages. This post is an outline of what your decision-making process with your IT consultant should look like.

1. Will you be marketing your products to the search engines? If so, you need, at a minimum, a solution with 301 Redirect Management, keyword-rich URLs, and management facilities for title and meta-tags. This will rule out a sleuth of options.
2. What is your estimated annual turnover, average transaction value, and average unit price? Payment gateways (i.e. PayPal, Google Checkout, Protx, ChronoPay, etc.) differ in their charges, and you should choose to minimise your costs.