Set stored address as default for Shipping or Billing in Magento

A current project I’m working on with a client required to import 20k customers with address, contacts and profile data – a tricky task in itself. I managed it import this successfully, but noted that the addresses were set to Shipping and not Billing.  This meant that customers could not be searched or filtered from … Continued

Add new admin user in WordPress from PHPMyAdmin

Similar to another post which does the same thing in OpenCart, here’s how to add a new admin-level user to WordPress – without any access to the wp-admin area. I find this useful when I’m called in to finish off an abandoned website and have no idea what the login credentials are – I’ll simply … Continued

Check WordPress Database Queries

Here’s a little snippet which I sometimes use in my footer during development. It basically checks how many db queries are made when the page loads and how long those queries took to retrieve and display. Very handy if you are performance-oriented and need to check performance of 3rd-party plugins. Once added, refresh the page … Continued