Following on from my previous tutorials on Google Sheets and WordPress Rest API some people have asked me if you can do the same with WooCommerce. Indeed you can. WooCommerce has REST API that provides access to any data you need. You can find the technical documents here. One of the main differences is that [Read the full article…]
WordPress REST API retrieve data and email it as an xls using Google Sheets
Google Script to read a WordPress REST API endpoint into a Google Sheet and then email it ( no titles in this one, see other tutorials for titles )
Stopping Genesis Full menu loading momentarily before the responsive menu
Many, if not all of StudioPress’s older themes flash up the full menu for a glimpse before the responsive hamburger comes in. This doesn’t look great but is easy to fix in 2 steps. First, tweak the CSS so that the start of the responsive section reads body.js .genesis-nav-menu { display: none; } the responsive [Read the full article…]
Code snippet to change notification of new users
Example plugin to set admin notification of new users. In this case it uses the first user defined as shop_manager role <?php /* * * Plugin Name: Notify New Users to Shop Manager * Plugin URI: https://fullworks.net/products/custom-plugin-development/ * Description: Needs Woo Commerce of Course * Version: 1.0 * Author: Fullworks * Author URI: http://fullworks.net/ * [Read the full article…]
Putting it all together – authenticate, read and update WordPress from a spreadsheet
This is my fourth post in my series of how to build a script to manage WordPress data via the API and a spreadsheet. If you have arrived here without looking at the others you probably should start at the beginning here. In this tutorial I’m going to handle updating and then pull it all [Read the full article…]
How to authenticate WordPress Rest API from Google Sheets / Scripts
This is the third tutorial in my series relating to integrating Google Sheets and WordPress using the REST API. The first post covered reading basic post information into a spreadsheet. The second post was about getting meta data from the REST API, which can be a little tricky. This one covers authentication. Basically as an [Read the full article…]
Getting post meta via WordPress REST API
This the second post post in my series about getting and updating WordPress data via a spreadsheet. The first post focused on the basics of Google Apps Scripting and the API call to the WP REST API – if you haven’t seen it you can read it here. This post is about meta data. In [Read the full article…]
Linking WordPress to a Spreadsheet using WP REST API and Google Sheets scripts
This post shows you how you can link a Google Spreadsheet to a WordPress website to extract data. I will write some further posts covering authentication and updating too. However a little warning, this is a programming task and a basic understanding of javascript is really required to follow what is going on. WordPress is [Read the full article…]
Problem with WordPress 4.8 screwing up your website layout?
WordPress 4.8 has just been released, and many web designers have reported that their layout have been mucked up with this release. *** UPDATE *** Since writing this blog post I have written a plugin – https://wordpress.org/plugins/add-paragraphs-option-to-text-widget/ – that solves this problem in a very neat way. *** There could be multiple reasons for this, but [Read the full article…]
Google Compute Engine Snapshot automation
Google Compute Engine comes with an incremental snapshot capability. The product doesn’t have a specific automated method to take snapshots and to tidy them up either, but scripting using the gcloud command line is fairly straight forward, once you understand the power of the command line. I have seen many attempts at automating this using [Read the full article…]
