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 WooCommerce comes [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 )
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
function onOpen() { // setup a custom menu SpreadsheetApp.getUi() .createMenu('Barcodes') .addItem('Get Data', 'getPosts') .addToUi(); setupSheet(); } function setupSheet() { // just clear sheet and set & style headings var ss = SpreadsheetApp.getActiveSpreadsheet(); // set the tab name - just for neatness var sheetname = ss.getSheets()[0].setName('Data'); // clear the sheet var range = ss.getDataRange(); range.clear(); } function getPosts(){ setupSheet(); // loop here as we need get back posts in chunks, Rest API max is 100 post offset = 0; per_page = 10; while ( (got=getPage(offset,per_page)) > 0 ) { offset+=got; } SpreadsheetApp.flush(); sendGoogleSpreadsheetAsExcel(); } function getPage(offset,per_page) { // gets posts in chunks of per_page var ui = SpreadsheetApp.getUi(); // used for error messages var ss = SpreadsheetApp.getActiveSpreadsheet(); var options = { 'method': 'get', "contentType" : "application/json", 'muteHttpExceptions': true } var apiHost = 'https://YOURDOMAIN/wp-json'; // set to your own domain url = apiHost + '/wp/v2/ENDPOINT?per_page='+per_page+'&offset='+offset; // set to appropriate END POINT try { var response = UrlFetchApp.fetch(url, options); var data = JSON.parse(response) // loop through the map and output to sheet for (i = 0; i < data.length; i++) { row=offset+i+1; ss.getRange('A'+row).setValue(data[i].title.rendered); // work out the data structure by looking at the JSON ss.getRange('B'+row).setValue(data[i].barcode_id); // work out the data structure by looking at the JSON } return data.length; } catch(error) { var result = ui.alert( error.toString()); } return 0; } function sendGoogleSpreadsheetAsExcel(){ try { var ss = SpreadsheetApp.getActiveSpreadsheet(); var url = "https://docs.google.com/feeds/download/spreadsheets/Export?key=" + ss.getId() + "&exportFormat=xlsx"; var params = { method : "get", headers : {"Authorization": "Bearer " + ScriptApp.getOAuthToken()}, muteHttpExceptions: true }; var blob = UrlFetchApp.fetch(url, params).getBlob(); blob.setName(ss.getName() + ".xlsx"); // change the EMAIL address MailApp.sendEmail("youremail@example.com", "Google Sheet to Excel", "The XLSX file is attached", {attachments: [blob]}); } catch (f) { Logger.log(f.toString()); } } |
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…]
DezRez XML import into WordPress
I am about to embark on some custom work on a DezRez XML import into WordPress, and want to gauge if there is any interest in this as a plugin, please use the comments to express issues and thoughts. My plan is, rather like my Rightmove XML converter, is to let WP All Import ( [Read the full article…]
- 1
- 2
- 3
- …
- 14
- Next Page »
