Sid Kathirvel
How I Taught Myself SEO and How You Can Too
SEO (Search Engine Optimisation) has evolved through the years and is now accepted as a legitimate job description. I believe that we are at a stage in time where business owners have a good understanding of what SEO is and the ‘snake oil salesmen’ tag has been vanquished. I hope! My SEO journey started a…
The Night Eats the World (2018)
Sam (Anders Danielsen Lie) falls asleep in his ex-girlfriend’s apartment in Paris. He wakes up to find the city infested with zombies. Alone and cooped up in the apartment building, he embraces and adapts to the new reality. He turns to foraging, stockpiling, rationing, and even relishes lockdown life. Time seems endless – days become…
How To Write A Mission Statement In 4 Easy Steps
The mission or vision statement should be the beacon that guides your business. It should communicate to customers, employees, and other stakeholders what your business is about. The statement should be motivational and also display a shared sense of purpose. We Shall Build Good Ships Here; At A Profit If We Can, At A Loss…
WordPress Comment Form – Remove Website Field
Are you getting comment spammed by link building bots? Pull off the ‘website’ field from the form by adding this to your functions.php file.
Python Google Analytics Reporting API v4 – ModuleNotFoundError: No module named ‘oauth2client’
Following the guide at https://developers.google.com/analytics/devguides/reporting/core/v4/quickstart/service-py and getting the below error? Traceback (most recent call last):File “HelloAnalytics.py”, line 4, infrom oauth2client.service_account import ServiceAccountCredentialsModuleNotFoundError: No module named ‘oauth2client’ The solution is to upgrade your Python oauth2client library. See below: pip install –upgrade oauth2client
Digital Adoption and Transformation During the COVID-19 Crisis
The financial and economic crisis of 2008 was a challenging time for businesses. I remember how quickly businesses adapted by taking their businesses online – the eCommerce boom. July 2008, the company I worked for was at a trade show and the warning signs were clear. We had to adapt, or get left behind. We…
The Vanishing (2018)
Three lighthouse keepers on the remote Flannan Isles find a hidden trunk of gold, leading to their mysterious disappearance. The Vanishing (2018) – IMDb I came across this movie in a Facebook Scottish Filmmakers group and was looking forward to it. ‘Lighthouse keepers on an isolated Scottish island battling greed and paranoia’ sounded like a…
Finding, Deleting and Cleaning Orphaned Post Meta in WordPress
NOTE: Please remember to backup your database before doing any SQL level deletes. Over time, the wp_postmeta table can get littered with a number of records. These linked meta data rows are not always removed when posts from the wp_posts table are deleted. While WordPress has well optimised the wp_postmeta table, it might be wise…
Which mode of MySQL WEEK() complies with ISO 8601 and matches PHP’s DATE function
To mix MySQL week numbers with PHP, can be a bit confusing. The best way to get a relevant match is to use mode 3 in the MySQL WEEK() function. For example, in PHP: [php] date(‘W’, strtotime(‘2019-12-31’)); Returns: 01 date(‘W’, strtotime(‘2020-12-31’)); Returns: 53 date(‘W’, strtotime(‘2021-12-31’)); Returns: 52 [/php] The same in MySQL: [sql] SELECT WEEK(‘2019-12-31’,…
SugarCRM / SuiteCRM – Adding created_by and modified_user_id using SugarBean
If you are a big fan of using SugarBean to handle CRUD (Create Read Update Delete) operations, you might have noticed that the created_by and modified_user_id values are automatically provided by the underlying code logic. You can bypass this logic and override the UserIDs. Below is the example PHP code: [php] $bean->set_created_by = false; $bean->update_modified_by =…
Designing the Perfect Customer Journey for your High-Converting eCommerce Website
WordCamp Manchester 2017 The above is the slidedeck from my talk (Designing the Perfect Customer Journey for your High-Converting eCommerce Website) at the WordCamp Manchester 2017. #wcmcr Here’s a PDF copy if you would prefer downloading the slides. I am happy to share the wireframe PDFs of the product, category and checkout pages. Connect with…
