Andrew McCombe


Full Stack Web Developer

How to import a Google Sitemap into a MySQL table

Here’s a quick snippet showing how to import a Google Sitemap file into a MySQL table. This is useful if you need to do anything with the urls such as scrape the pages or check for 301/302/404 results.


Magento Admin Invalid Form Key

I Recently came across a situation where I couldn’t log in to the Magento admin area, getting ‘invalid form key on admin’. Here’s how to fix it.


How To Clear Google Chrome’s 301 Redirect Cache

Ever had a dev site set up and had it 301 redirect to ‘https’, only to find that Google Chrome caches this and you can’t get the ‘http://’ version after?


Google Analytics WordPress Plugin

This is a very basic WordPress plugin that adds Google Analytics tracking code to your WordPress Site.  It doesn’t have any advanced features like many other plugins.   Download & Installation You can get the plugin from the Github repository page here. Simply extract the zip file in your wp-content/plugins directory.  Then go to your WordPress […]


How to use htaccess to password protect your website

There are many reasons why you would want to password protect your website, or a section of your website. Here’s how to setup a .htaccess file to password protect your website.


Magento: remove admin mass action for specific role

I had a use case where a Magento admin user was limited to viewing the orders only. They should be able to view orders but not perform any actions on an order. The best way to do this with Magento is to remove admin mass actions for a specific user role.


Magento: Remove specific tabs from product edit in admin

Here’s how to remove specific tabs from Magento’s admin product edit pages.


How to upgrade Magento 2 to a later version

Here’s how to upgrade Magento 2 to a later version. For example, if you are currently running 2.1.6 and you need to upgrade to 2.1.7.


How to get the URL of a CMS page or a static block in Magento

Here’s how to get the URL of a CMS page or a static block in Magento.


How to use a different SSH port with rsync

I’m forever forgetting how to use a different ssh port with rsync, so here’s how to do it.