Upcoming Changes to WooCommerce

WooCommerce have announced a number of upcoming changes to their platform and we wanted to let our customers know about any potential impact on our fmEcommerce Link (WooCommerce Edition) solution.

Firstly WooCommerce put out an announcement last year about their deprecated Legacy REST API and that this was being removed from WooCommerce as of version WooCommerce 9.0, scheduled to be released in June 2024. This has NO impact on the fmEcommerce Link (WooCommerce Edition) solution as we have never used the Legacy REST API and have only ever used the newer REST API released with WooCommerce 2.6 that is based on the WordPress JSON API. You can ignore any notifications about the removal of the Legacy REST API as far as fmEcommerce Link integration is concerned.

Secondly you might have come across news about High-Performance Order Storage (HPOS), WooCommerce’s new database storage for orders to allow effortless scaling for large and high growth stores. Previously known as “Custom Order Tables” HPOS is a solution that provides an easy-to-understand and solid database structure – specifically designed for eCommerce needs. HPOS replaces the default WordPress post-based storage of orders and used dedicated custom database tables for data like orders and order addresses instead. This way is more efficient for handling large volumes of orders and eventually improving overall performance.

HPOS is enabled by default for new installations from WooCommerce 8.2 onward. You will need to ensure that all your WordPress extensions are compatible with HPOS before you upgrade to HPOS. We are waiting confirmation from WooCommerce about the impact of HPOS and their REST API which is used by fmEcommerce Link and will update this blog post once that is received.

We will also be testing fmEcommerce Link (WooCommerce Edition) with an HPOS enabled store shortly to confirm everything works as expected. You can stay up-to-date by subscribing to our newsletter or this blog.

You can read more information about HPOS at the following links:

WooCommerce Webhooks Using Claris Connect

We’ve just published a new support guide on setting up webhooks using Claris Connect with out fmEcommerce Link (WooCommerce Edition) solution. Using Claris Connect for webhooks can be a much simpler process than using the supplied PHP files for the FileMaker Data API as you don’t need to worry about hosting the php files and dealing with web servers, PHP configuration changes, port forwarding etc. You can setup a new Claris Connect Flow in a few minutes which can receive updates from WooCommerce and create new Order records or update existing customer records.

With the recent introduction of the Claris Platform Bundle and the Problem Solvers Circle which include a Claris Connect Standard license we expect to see a lot more customers be able to leverage the power that Claris Connect offers.

If you’re interested in using Claris Connect for receiving incoming webhook notifications for new WooCommerce orders please visit our WooCommerce Webhooks Using Claris Connect guide for step by step instructions. We’re pleased to report that no changes to the fmEcommerce Link file were required to support Claris Connect webhooks.

Extending Your FileMaker WooCommerce Integration

It’s been more than 5 years since we first released v1.0 of fmEcommerce Link (WooCommerce Edition), our Claris FileMaker solution for integrating with the WooCommerce eCommerce Platform. Since that first release we’ve helped hundreds of customers connect their FileMaker business apps with their online store to eliminate manual processes and double data entry, saving them time and money.

As well as the core online store functionality WooCommerce also has a marketplace that has hundreds of free and paid extensions that add features and functionality to your store. We’ve helped a number of customers and FileMaker developers integrate with many of the most popular WooCommerce extensions, many of which have their own APIs.

Here’s some of the ways in which we’ve helped customers extend their FileMaker WooCommerce integration beyond the core WooCommerce API features:

Custom Fields: we regularly encounter WooCommerce stores that contain custom fields and more often than not the store owner would like to be able to update the value in these custom fields when uploading (e.g. Products) and also download the value in these fields (e.g. Orders). There are many ways to add custom fields to your WooCommerce store, including using a WordPress plugin such as the Advanced Custom Fields plugin or modifying php files.

The easiest way to work with custom fields is via the Meta Data which is accessible using version 2 or later of the WooCommerce REST API. You can both update custom fields and retrieve them via the Meta Data, which uses a Key/Value pair system where the key is the name of the custom field and the value is the value for that custom field. We have several articles on our support site that cover working with custom fields, including:

  • Can I Update Product Custom Fields – this article demonstrates how to use the meta data to update a custom field when uploading a Product from FileMaker to WooCommerce
  • Downloading Custom Fields – this article demonstrates how to access the meta data when downloading an Order from WooCommerce to FileMaker

WooCommerce Subscriptions: one of the most popular extensions for WooCommerce is WooCommerce Subscriptions which allows customers to subscribe to your products or services and pay on a weekly, monthly or annual basis. This extension also has its own API which you can make requests to get subscription specific data that isn’t included in the core WooCommerce API. Using their API you can access subscriptions data from FileMaker and create, read, update and delete subscription data.

Shipments: this is another popular category for WooCommerce extensions. For stores that have to ship physical goods to their customers using a shipments extension can help customers track their orders and integrate with shipping carriers to print labels and assist with fulfilments. We’ve helped several customers integrate with the Shipment Tracking extension which allows you to add shipment tracking information to your orders, providing customers with an easy way to track their shipment. Once again this plugin also has it’s own API which we can make requests against, for example to create shipment tracking for an order as it is being processed.

We’ve also integrated with the AfterShip WordPress plugin which also has it’s own API and allows you to create shipment tracking for a WooCommerce Order.

Gift Cards: WooCommerce includes support for Coupons but not Gift Cards which allow customers to purchase digital gift cards that can be redeemed online in the future. We’ve recently helped a number of customers integrate with the WooCommerce Gift Cards extension to retrieve details of any gift cards used in an Order and check the balance of a gift card.

These are just some of the examples of ways in which you can extend your fmEcommerce Link (WooCommerce Edition) integration. If you would like to discuss extending your integration please get in touch for a free initial consultation to discuss your requirements.

WooCommerce REST API Now Supports Filtering by Modification Date

We’ve had many requests over the years to update our fmEcommerce Link (WooCommerce Edition) solution to allow you to just download Products that were updated recently by date range. A common use case is that you have updated a subset of products in WooCommerce and just need to get those updated products into FileMaker.

fmEcommerce Link does have the ability to update a product in FileMaker from WooCommerce, but you would need to have kept a track of the WooCommerce IDs for the products that were updated in WooCommerce and then find these in FileMaker and perform the update. Unfortunately the WooCommerce REST API didn’t support the ability to perform queries by modification date (only date published/created).

This functionality has been requested in the past for orders to save having to query for the whole set of WooCommerce orders just to retrieve the handful that were recently updated. Earlier this year I decided to also submit a feature request for the ability to query the products API endpoint using modified_before and modified_after query parameters that filtered using the date modified field. This request was well supported by other developers and I’m pleased to report that WooCommerce 5.8.0 and later now support this feature for the product, order and coupon API endpoints.

We’ve put out an update to fmEcommerce Link (WooCommerce Edition) v2 for downloading updated Products – v2.0.3 now lets you filter by date modified when downloading Products from WooCommerce:

Check out our support article here for further details. If you would also like to see this filter for downloading orders please get in touch and let us know.

fmEcommerce Link (WooCommerce Edition) Now Supports the REST API v3

Back in 2018 we wrote about the new version of the WooCommerce REST API – v3 – that was released as part of WooCommerce 3.5. We had planned to let the dust settle for a few months before switching over from v2 to v3 and make this change in 2019. Time got away from us and with WooCommerce 4.0 just around the corner we felt we should make this change now.

We’ve just released an update to fmEcommerce Link (WooCommerce Edition) – v1.65. In this version we’ve changed the version number of the API that we call from v2 to v3 in the WooCommerce_BaseURL custom function. At this stage we haven’t made any v3 specific changes as these were much smaller in scope than the jump from v1 to v2 of the REST API. The system requirements for fmEcommerce Link (WooCommerce Edition) will change slightly – you will need WooCommerce 3.5.x or later and WordPress 4.4 or later. We do plan on adding support for v3 specific changes in future updates, such as the new reviews endpoint and refunding of line items.

There are also a number of other changes in this update (full list here) including:

  • added New Customer Webhook example for automatically creating a new Customer record in the fmEcommerce Link file when a new Customer is created in WooCommerce
  • added Data API compatible versions of New Customer Webhook and New Order Webhook PHP files

The FileMaker Server Data API will replace the current XML and PHP APIs over time so we’re excited to include support for the Data API. Supporting the Data API also means you can now use Webhooks when your file is hosted by FileMaker Cloud for AWS, as well as FileMaker Server v17 or later. We’ve been testing these Data API Webhooks for the past few months with a FileMaker Cloud for AWS hosted solution and the PHP files running on Amazon Lightsail successfully.

The Data API is language agnostic – you can use whichever programming language you prefer here. We’ve gone with PHP for our examples as that is what we know best. Remember when working with the Data API you will need to enable the fmrest extended privilege for the Webhooks Privilege Set:

If you are just looking to use the Data API PHP files make sure you also update the Process Webhooks Order script as this has been updated to work with the Data API version of the Webhooks which work slightly differently to the existing PHP API ones.

Once again this is a free update to all existing customers (simply download using the same link that was on your original order email). If you’re having any issues with downloading the new version please contact us if you need the link to be reset etc.

fmEcommerce Link (WooCommerce Edition) Now Supports Media Uploads from FileMaker Container Fields

One of the limitations when it comes to uploading images for Products using the WooCommerce REST API is that you have to either include a source URL for WooCommerce to download the image from, or include the ‘ID’ for the image from the WordPress Media Library. The WooCommerce API doesn’t allow for files to be uploaded directly from a FileMaker container field, which is where you would typically store them in FileMaker.

We regularly receive requests from customers wanting to know how they can upload files that are stored in their FileMaker container fields for Product Images and have had to regularly break the bad news to them. However we are pleased that we can finally offer a solution to this problem. You can now upload a file stored in a regular FileMaker container field:

and upload it to the WordPress Media Library at the click of a button:

Once it is in the WordPress Media Library you can quickly copy/paste the WordPress ID to a WooCommerce Product Image and upload that to WooCommerce:

We’ve leverage the WordPress REST API, which the WooCommerce API is fully integrated with, as this does allow for media files to be uploaded directly to the WordPress Media Library. We’re pleased to announce that v1.6 of fmEcommerce Link (WooCommerce Edition) is now available as a free update for all existing customers – we have a page covering all the details of how to install the required WordPress plugin and setup fmEcommerce Link for uploading files directly from FileMaker container fields.

Here’s a video showing the Media file upload from a FileMaker container field in action (you can also watch it directly on  YouTube here):

fmEcommerce Link (WooCommerce Edition) Now Supports Order Uploads


Since we first released fmEcommerce Link (WooCommerce Edition) back in 2016 we’ve had a number of requests from customers asking us to include the ability to upload Orders from FileMaker to WooCommerce. fmEcommerce Link was created from a solution we built for our own business to solve a very pressing problem at the time – automate the downloading of Orders from WooCommerce into FileMaker so we didn’t have to manually enter these one-by-one.

At the time we didn’t see a huge need for having the ability to go the other way, as the whole point of WooCommerce is to handle online orders from your website. Having spoken with our customers who were requesting this and also having used fmEcommerce Link in our own business for a few years we can now see some scenarios where it would be helpful to have the ability to upload Orders entered in FileMaker to WooCommerce, including:

  • not all Orders for your products are entered directly into WooCommerce by all customers. Some customers might receive your product as part of a larger consulting project, or have to use payment methods that are not accepted on your store.
  • sometimes you just need to send the customer to your store to pay for an Order without wanting them to start from scratch and select the various products, add them to the cart and complete the checkout page. There is a way to create an Order for a customer and send them the link to the customer payment page so all they need to do is enter their credit card/payment details (see video below)
  • you might have orders from legacy systems that pre-date your WooCommerce store which you wish to upload so WooCommerce is in sync with your CRM software, allowing customers to be able to login and download updates and see their full history

Having had to enter a number of Orders manually into WooCommerce over the past few years we saw the light and started work on an update to fmEcommerce Link that includes the ability to upload Orders from FileMaker to WooCommerce. We’re pleased to announce that v1.53 of fmEcommerce Link (WooCommerce Edition) is now available as a free update for all existing customers.

When working with Order uploads to WooCommerce please be aware of the following:

  • the tax fields are “read only” in the API so when you upload an Order we then download the updated details from WooCommerce which include the tax amounts that WooCommerce calculates automatically
  • Coupons are not applied when they are included in an Order upload with the REST API v2 that we currently support, so we’ve decided not to include them to avoid any confusion. The REST API v3 that was recently released includes some changes around Automatic total calculations when applying/removing coupons, so this is something we will included when we release an update designed to work with the v3 API
  • if you want to delete an Order Line item you don’t delete the line item in FileMaker – just set the Qty to 0 and include that when uploading and WooCommerce will remove it from the Order for you

Here’s a video showing the Order upload in action, including the ability to retrieve the URL for the customer payment page if you wish to send your customer a link to pay for an Order you create in FileMaker.

 

You can view the full release notes on our version history page.

Databuzz 2018 End of Year Xmas Sale – 20% Off All Licenses

 

The Databuzz End of Year Xmas Sale is now on – all Product Licenses are now 20% off, including:

Use the coupon XMAS2018 at checkout on any purchase and the 20% discount will be applied to your order. The sale runs until the end of the day on January 04, 2019 (Australian Eastern Daylight Time). Click here to start shopping.

Free trial versions are available for all of our products – please contact us to request a trial version. We’ve updated all of our products in the past few weeks with new features, including:

All our prices are in Australian dollars – if you’re purchasing from outside of Australia you’ll also get to take advantage of the low Australian dollar (1 Australian Dollar equals approximately 0.72 US Dollars).

We also have a similar sale on fmSMS Licenses (20% off) – click here to visit the fmSMS website for further details.

WooCommerce 3.5 and the new REST API v3

Last week WooCommerce released WooCommerce v3.5 which included a new version of the REST API – v3. As with previous releases of the REST API this new version includes a number of new endpoints as well as updates to some existing endpoints. Here’s a summary of the new features in the REST API v3:

  • A reviews endpoint to list, get, create, and update product reviews.
  • Date fields are now editable on the products endpoint, and the endpoint has been updated to work with the “on backorder” stock status.
  • A series of new reports endpoints to get total counts of orders, products, customers, coupons and reviews.
  • New orderby options for the products endpoint to allow listing products by price, popularity, or rating.
  • Automatic total calculations when applying/removing coupons in the orders endpoint.
  • New data endpoints to fetch Continents, Countries and Currencies.
  • Refund line items through the API.
  • Ability to batch update settings

To use the new v3 API you will need to be running WooCommerce v3.5 or later – we plan to start adding support for some of the new endpoints and updates in a future release of fmEcommerce Link (WooCommerce Edition). It’s important to note that v1 and v2 of the REST API still work and are still included in WooCommerce 3.5 so updating won’t break any integration that uses the fmEcommerce Link (WooCommerce Edition) solution. Let us know what features from the v3 API you would like to see included first by contacting us or leave a comment below.

We’ll be taking our time with the next update to give you more time to update your site to WooCommerce 3.5. You should always follow the WooCommerce guidelines for updating your version of WooCommerce, including making backups and testing the new version for compatibility with your other plugins etc in a test environment.

We’re already working on some updates for our next release around uploading Orders from FileMaker to WooCommerce and uploading locally stored images that won’t require WooCommerce 3.5

You can get all the details for the new v3 API at the API documentation page.

Andrew Duncan from Databuzz to speak at WordCamp Brisbane 2018

WordCamp Brisbane 2018 is on 27-28 October this year at the Queensland University of Technology in Brisbane. Databuzz is pleased to announce that Andrew Duncan will be speaking this year on WooCommerce integration using the WooCommerce API.

Databuzz are big fans of WooCommerce and WordPress – we’ve been using WordPress and WooCommerce for many years to run our websites and eCommerce platforms. Our fmEcommerce Link (WooCommerce Edition) solution is one of our most popular products and we continue to update this with new features and improvements. Andrew’s presentation will cover the new v3 of the REST API that will be released with WooCommerce 3.5 later this month.

We look forward to meeting up and discussing all things WordPress – you can get tickets and more information from the WordCamp Brisbane 2018 site here:

https://2018.sydney.wordcamp.org/