This is an example of an embedded Google Form that is revealed only on ticking a box If you agree to this, tick the box and a form appears : Loading… This is how it is done: First get your ’embed code’ from your Google Form ( Form – Send – <> Embed HTML ) [Read the full article…]
Linking WooCommerce to a Spreadsheet using Google Sheets and the REST API
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
|
1 2 3 |
body.js .genesis-nav-menu { display: none; } |
the responsive section may for instance start @media only screen and (max-width: 800px) { [Read the full article…]
Sage Business Cloud Accounting – a new name for Sage One
Sage Business Cloud Accounting is the new name for Sage One Accounting. To celebrate this, you can get a 50% discount by following this discount code link. Sage Business Cloud Accounting is an accounting and payroll solution for small businesses. Being a small business that uses an online accounting system ( not Sage ) I am [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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
<?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/ * License: GPL-3.0+ * License URI: http://www.gnu.org/licenses/gpl-3.0.txt */ function admin_email_callback( $wp_new_user_notification_email, $user, $blogname ) { $shopmanager = get_users( array( 'role' => 'shop_manager' ) ); // set the to: the first shop manager email. $wp_new_user_notification_email['to'] = $shopmanager[0]->user_email; return $wp_new_user_notification_email; } add_filter( 'wp_new_user_notification_email_admin', 'admin_email_callback', 10, 3 ); |
Download this as a plugin from fullworks -> https://fullworks.net/wp-content/uploads/2018/02/set-shop-manager-new-user.zip
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…]
