Richy's Random Ramblings

Here’s a quick reference list of online/cloud/SAAS support/helpdesk/CRM systems that I’m aware and pricing for 2 full time and 1 part time (10 hours month: 1 hour per day) helpdesk agent/staff with a custom URL/domain mapping (such as http://company.example.com), knowledge base feature and, ideally, Twitter and/or Facebook interactions. Pricing is given on a “per month” payment plan.

Sirportly – £44.97/month

Unlimited staff at £14.99 each per month. Integrates with Twitter and Facebook

FreshDesk – $58/month

Unlimited staff at $19/month per full time staff and $2/per day for additional part-time agents. Unlimited Twitter accounts and multiple Facebook accounts

Desk.com – $59/month

Unlimited staff at $49/month per full time staff (1st one free) and $1/per hour for additional part-time agents. 2 Twitter accounts and 2 Facebook pages included by default: can add extras for a fee

Kayako Resolve OnDemand – $87/month

Unlimited staff at $29 each per month. No interactions with Twitter or Facebook

ZenDesk – $87/month

Unlimited staff at $29/month (3 staff included on $20/year “Starter” package, but no custom URL). Unlimited Twitter accounts and 2 Facebook pages

HappyFox – $99/month

Up to 5 staff (3 staff on $39/month package, but no custom URL). No interactions with Twitter or Facebook

I’m aware that a few people are looking for jobs at the moment, so here’s a list of jobs I’m currently aware of.

All jobs are full time (unless noted) and are “on site” [no remote working] (unless noted). Jobs are current, to the best of my knowledge at 17th July 2012.

Memset, Guildford, Surrey

Multiple positions available:

• Python Software Developer
• Web Designer/Graphic Designer (Part time/flexible hours)
• Junior Systems Administrator
• Sales Administration Assistant

BBC, Salford Quays, Manchester

Web Developer

BBC, London

Software Engineer (Team Leader)

Get Extra, Hull

WordPress/PHP developer

The company I work for, and in fact 50% own, Bairwell Web Development isn’t currently looking for full time staff, but we are continually on the lookout for UK based freelance PHP/Perch/Wordpress developers we can either refer people to or to forward work to. If this includes you, please get in contact with your rates!

NEW FOR 23rd July

University of Bradford, Bradford

Clerical Assistant

Queen Mary, University of London, London

Recruitment and Outreach manager

We’re just experimenting with TrustPilot at the moment, but we needed to be able to import the customer name, order id and customer email address from our Magento shopping cart system into their system for population. Here’s the simple MySQL query we used to extract these details of all completed orders (i.e. not pending/processing ones) placed in the last two months:

SELECT
sales_flat_order.increment_id,
CONCAT(sales_flat_order.customer_firstname,' ',sales_flat_order.customer_lastname),
sales_flat_order.customer_email
FROM sales_flat_order
WHERE
sales_flat_order.state='complete' AND
sales_flat_order.created_at>(CURDATE()-INTERVAL 2 MONTH)