Archives

 
 

Useful WooCommerce MySQL Queries

Get all WooCommerce orders. select p.ID as order_id, p.post_date, pm.* from wp_posts p join wp_postmeta pm on p.ID = pm.post_id join wp_woocommerce_order_items oi on p.ID = oi.order_id where post_type = ‘shop_order’ and p.ID = 14223 Get all Users, billing and shipping information from the Woocommerce tables. SELECT u.id, u.user_login, u.user_email, max( CASE WHEN m.meta_key = […]

 March 3rd, 2017  mike  0

How to Setup the WooCommerce Core Plugin

First of all to setup WooCommerce core plugin you need to install the WooCommerce plugin from the WordPress plugins.  Prior to install there are 3 pre-requisites you need to do, these are:- Your e-commerce site must be on https so your users payment information is encrypted and kept private. To accept Credit or Debit cards […]

 March 3rd, 2017  mike  0

WordPress Yoast SEO

The WordPress Yoast SEO is a critical plugin your website needs in order to obtain a high google search ranking.  Due to this plugin being a free to use software, it has now become the Worlds most valuable tool for marketing WordPress websites.  This plugin can save you so much time and gives you a […]

 January 13th, 2017  mike  0

WordPress Security

Due to the world becoming a more insecure place, many websites are at risk of becoming hacked.  Consequently this is bad news for website owners because hackers can steal sensitive customer and company information.  Therefore understanding WordPress Security is vital for a secure website to ensure your customer and company information is safe. So there […]

 January 13th, 2017  mike  0

WordPress Caching with WPSuperCache

WordPress renders each web page request by processing PHP code, additionally it retrieves each page from the database.  Therefore each web page request a user makes to your website can take longer than a static HTML page.  A HTML page can be much faster to return back to the user due to less processing power […]

 January 12th, 2017  mike  0

The WordPress User Guide – Media 5/5

This WordPress User Guide Media blog post will help you understand how the Media manager in WordPress works.  While the media manager allows you to upload your media into an organised folder structure on your web server.  When images are uploaded they are converted into smaller images so you can embed them into your web […]

 January 11th, 2017  mike  0

The WordPress User Guide – Editor 4/5

This WordPress User Guide Editor blog post will guide you on how to use the Editor in the WordPress portal. The Editor is the back-end to your web pages and is the common to both Pages and Posts where all your text and configurations is stored in the database.  Furthermore, the Editor has many cool […]

 January 11th, 2017  mike  0

The WordPress User Guide – Posts vs Pages 3/5

This WordPress User Guide Posts vs Pages will explain what the difference between WordPress Posts and Pages. While pages are web pages that are static in nature. Things like your services and web pages that serve as a marketing function would best describe this.  Because pages usually don’t have any page comments like posts, they […]

 January 11th, 2017  mike  0

The WordPress User Guide – Appearance 2/5

This WordPress User Guide Appearance blog post will show you how the appearance section works in the WordPress portal.   While the appearance section allows you to choose between different WordPress themes.  The theme itself can therefore be managed through the Customiser, Widgets and Menus options.  The Customiser option allows you to manage parts of […]

 January 11th, 2017  mike  0

The WordPress User Guide – Getting Started 1/5

This WordPress User Guide getting started blog post will point you in the right direction.  WordPress is a Content Management system that uses a database to store all your data.  This data would be like your page and blog posts text.  The database would also store things like your website settings like  categories and tags. […]

 January 10th, 2017  mike  0

How to test your WordPress site performance

These days it is very important that your WordPress website has good performance.  WordPress performance is crucial in order to obtain a good google SEO score.  Therefore, the best tool to check whether or nor your website is fast, is to use a monitoring tool called Pingdom.  Because many WordPress themes use more Javascript and CSS […]

 January 8th, 2017  mike  0

WooCommerce Subscriptions

Since WooCommerce released the WooCommerce Subscriptions extension users are gradually moving to this plugin for their website subscription management.  Also, this WooCommerce extension brings you subscriptions to physical and virtual products, create product of the month clubs, weekly and monthly billing packages.  Futhermore you can add sign-up frees, provide free trials or define exppiration perdiods. In […]

 December 7th, 2016  mike  0

Creating Contracts with WooCommerce

Do your customers need to sign a contract to purchase or download one of your products.  Seems like this Contracts plugin is probably by far the most popular on the market today.  First of all this WordPress plugin can automate the whole contract process for you. Furthermore WooCommerce contracts can collect signatures electronically saving you time and […]

 December 6th, 2016  mike  0

WooCommerce Memberships

WooCommerce Memberships allows your WordPress website to restrict content to your members and also supports payment plan collections.  In addition, this WooCommerce extension is easy to use and brings together your content, shop and memberships in one place.  You can drip content over time to schedule when members have access. There are several types of […]

 December 2nd, 2016  mike  0

Using WooCommerce Bookings

The process of managing appointments and taking payments can be a time consuming task.  So the easiest solution to your booking scheduling is through a WooCommerce extension,  WooCommerce Bookings.  This extension sits on top of WooCommerce core platform which means all your e-commerce payment configurations stay the same.  You can create fixed time slots when […]

 December 2nd, 2016  mike  0

Choosing your WordPress Theme

You should think very carefully when choosing your WordPress theme.  There are many WordPress Theme considerations to think about from functionality to usability.  There are many themes providers you can go to choose your ideal WordPress theme WordPress.org Themes, Woo Themes, Template Monster, WpmuDev, Theme Forest, Elegant Themes and Nexus Themes.  WordPress Theme Considerations Clean Simple Design – You should focus your theme choice […]

 September 11th, 2016  mike  0

Choosing your WordPress Plugin

WordPress is renowned for being a truly versatile open source platform and has extensible capabilities.  Most business owners looking for an enterprise web application platform. Will most likely consider using WordPress as their main tool for their content marketing strategy. So being popular means there is a huge WordPress following, many people in the community […]

 September 2nd, 2016  mike  0

Clone your WordPress site to a test environment

Follow the step by step instructions blow to help you in Clone your WordPress site to a test environment. This setup guide will show you to create a new test website on your existing web hosting account, like mine as an example http://test.joebloggs.com/.   Follow the steps below and replace your website details with the example. 1. Create […]

 July 7th, 2016  mike  0

Turn your PC into a web server – Port Forwarding

When you are hosting a website from your machine at home, your home network needs to know where to route traffic from the outside world to the taraget machine on your network.  You probably have several machines including wireless devices connected to the home router.  This is the concept of port forwarding, the following steps […]

 May 28th, 2016  mike  0

Choosing your Web Domain Name

Your website domain name is probably the most important decision you will need to make when setting up your website. If your business is new I would consider having the same business name as your website domain name. For example Joe Bloggs Ltd = joebloggs.com. You get the idea. From my experience and what I […]

 May 28th, 2016  mike  0

How to setup a WAMP stack to run a WordPress Website

In this blog I will show you how to setup a WordPress environment locally on your Windows PC, so you can develop websites locally on your machine without the danger of breaking anything in a live environment.  Most websites in the world sit on a Linux web server, the set of technologies WordPress uses are commonly […]

 May 16th, 2016  mike  0

How to Backup your WordPress Website

This guide will provide you with a step by step instructions, on how to backup your WordPress website. When you want to backup your WordPress site. There are two things you need to backup. 1. Files – e.g. Images, Plugins, Themes, Website Config, WordPress PHP code 2. Database – All the text, layout, content maps […]

 February 22nd, 2016  mike  0

How to Remove Malware from your Windows PC

If you think you have malware or a computer virus. You will have symptoms like popups or sidebars advertising something.  This guide will show you how to remove malware and virus from your Windows PC. Sometimes you get a PC repair checker web page comes up. Do not touch the website at all.   Follow […]

 February 19th, 2016  mike  0

Dev Notes – Design Patterns

Creational Abstract Factory Builder Factory Method (Virtual Constructor) Prototype Singleton Structural Adapter (Wrapper) Decorator Proxy Façade Flyweight Bridge Composite Behavioural Mediator Strategy (Policy) Template Method Chain of Responsibility Command Memento Interpreter Iterator Observer State   Creational Abstract Factory Provide an interface for creating families of related or dependent objects without specifying their concrete classes. Builder […]

 April 27th, 2013  mike  0