fmEcommerce Link (WooCommerce Edition) Update

We’ve just released our first update to fmEcommerce Link (WooCommerce Edition) for 2017 – this release provides an alternative method for handling authentication for some servers that may not parse the Authorization header correctly, as well as making the process of working with Product Variations much easier.

The WooCommerce REST API docs mention that some servers may not parse the Authorization header correctly – we’ve never encountered this during the testing and development of fmEcommerce Link but recently a customer contacted us after having trouble getting started with fmEcommerce Link (WooCommerce Edition). Upon further investigation we noticed that were receiving the same error each time they attempted to download data from WooCommerce:

{
 "code": "woocommerce_rest_cannot_view", 
 "data": {
 "status": 401
 }, 
 "message": "Sorry, you cannot list resources."
}

After many hours of frustration we stumbled across the suggestion to switch from using HTTP Basic Auth and implemented a change to test this and had immediate success. We’ve decided to add a toggle that users can switch on/off in case anyone else in the future encounters this issue:

We’ve also made it easier to download, update, create and view Product Variations in the fmEcommerce Link (WooCommerce Edition) file:

and also show which variations were selected when viewing an Order:

This is a free update to all our existing customers – we have a number of items on the list to add, including Refunds (create a Refund in FileMaker and upload to WooCommerce) and download Reviews. If there’s any examples that we don’t currently have that you would like to see please get in touch and let us know.

fmEcommerce Link (WooCommerce Edition) and Webhooks

When we released fmEcommerce Link (WooCommerce Edition) last week there was one feature that we wanted to include that wasn’t quite ready: Order Webhooks. The initial release of fmEcommerce Link lets you download orders from WooCommerce, either all at once or within a specified date range. For many users that will be sufficient as they might only need to download all orders from the previous day.

Some customers would prefer to be notified immediately the order was placed and have it automatically download into FileMaker – you could setup a server side schedule that ran every x minutes that checked for new orders since a specified timestamp, but it’s much more efficient to leverage Webhooks if they are available. A Webhook is simply a way of having WooCommerce send a notification to another service at a nominated URL when a particular event is triggered.

Webhooks were introduced in WooCommerce 2.2 and can trigger events each time you add, edit or delete orders, products, coupons or customers. New orders seemed the logical place to start – wouldn’t it be great if upon receiving a new order in WooCommerce it could be pushed to the fmAccounting Link FileMaker file automatically without you having to do anything?

We’ll be releasing a free update to fmEcommerce Link (WooCommerce Edition) in the next couple of days which will include support for Webhooks when a new Order is created. You will need to setup a Webhook and install the supplied PHP file on your FileMaker Server (you will need to enable Custom Web Publishing/PHP in your FileMaker Server Admin Console), and once this in place anytime a new Order is received in WooCommerce it will automatically be pushed to the fmEcommerce Link file, typically within a few seconds.

This was a feature that we wanted for ourselves to completely streamline the order entry process for our business – there’s nothing better than waking up in the morning and seeing new overnight orders already in the fmEcommerce Link file. Here’s a short video demonstrating this in action (you can also watch this on YouTube here):

 

 

Databuzz releases fmEcommerce Link (WooCommerce Edition) – Integrate FileMaker Pro and WooCommerce

Sydney, Australia – December 14, 2016 – Databuzz today announced fmEcommerce Link (WooCommerce Edition), a FileMaker solution that integrates with the WooCommerce eCommerce platform.

fmEcommerce Link (WooCommerce Edition) allows you to upload and download data between your FileMaker solution and WooCommerce, the popular plugin for WordPress that powers over 39% of all online stores. fmEcommerce Link (WooCommerce Edition) removes double data entry and human errors saving your company significant time, money and hassle by automating the exchange of data between FileMaker and WooCommerce.

fmEcommerce Link (WooCommerce Edition) is completely unlocked allowing you to integrate it into your FileMaker solution. You can copy and paste examples showing you how to authenticate with the WooCommerce API and download Customers, Orders, Products, Coupons and more at the click of a button.

fmEcommerce Link (WooCommerce Edition) features include:

  • works with FileMaker Pro v12, v13, v14 and v15
  • works with Macintosh and Windows
  • completely unlocked
  • can be hosted by FileMaker Pro or FileMaker Server
  • works with WooCommerce v2.6 or later (HTTPS required)

“Like many of our customers we use FileMaker Pro to run our business and WooCommerce for our eCommerce platform,” said Andrew Duncan, CEO of Databuzz. “We didn’t want to have to manually re-enter Customers and Orders in FileMaker, so we built fmEcommerce Link (WooCommerce Edition) to streamline our business and now we’re making it available for everyone. With fmEcommerce Link (WooCommerce Edition) you can push and pull data between FileMaker and WooCommerce at the click of a button.”

fmEcommerce Link (WooCommerce Edition) includes examples for the following WooCommerce API endpoints:

  • Customers: download and upload Customers
  • Products: download and upload Products
  • Orders: download Orders from WooCommerce (including Order line items)
  • Coupons: download and upload Coupons
  • Tax Rates: download Tax Rates from WooCommerce
  • Tax Classes: download Tax Classes from WooCommerce
  • Categories: download Categories from WooCommerce
  • Attributes: download Product Attributes from WooCommerce
  • Shipping Classes: download Product Shipping Classes from WooCommerce
  • Tags: download Product Tags from WooCommerce

 Availability, Pricing, and Compatibility

fmEcommerce Link (WooCommerce Edition) is available in a number of licenses: Company, Vertical Solution and Developer. It is available now from the Databuzz website at http://www.databuzz.com.au/fmecommerce-link-woocommerce-edition/. As part of the Databuzz End of Year Xmas Sale all Licenses are 20% until December 31, 2016. Company Licenses start at AUD $495.00. fmEcommerce Link (WooCommerce Edition) requires FileMaker Pro v12, v13, v14 or v15 and WooCommerce v2.6 or later using HTTPS.

Media/Customer Contact:

Andrew Duncan

Phone: +61 418 468 103

sales@databuzz.com.au

http://www.databuzz.com.au

About Databuzz: Databuzz is a long standing member of the FileMaker Business Alliance. We have been developing and deploying FileMaker solutions for clients in Australia and internationally since 1999. Our clients are individuals, small-medium businesses, government agencies and multi-national corporations. Databuzz was founded by Andrew Duncan, a Certified FileMaker 15 Developer. For more information please visit our website at http://www.databuzz.com.au.

###

FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners.

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

databuzz-xmas-sale-2016

It’s time for the Databuzz End of Year Xmas Sale – All Product Licenses are now 20% Off, including:

The sale runs until the end of the day on the 31st December, 2016 (Australian Eastern Daylight Time).

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 Australia dollar (1 Australian Dollar equals approximately 0.74 US Dollars).

Discounts are applied automatically – no coupons required! Click here to start shopping.

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

fmEcommerce Link (WooCommerce Edition) Preview Video

Last week we announced the upcoming release of our latest FileMaker integration solution – fmEcommerce Link (WooCommerce Edition) – and included some screenshots. We’re in the final stages of testing and working on the website product pages etc but I can confirm that v1.0 will have the following features:

  • download Customers, Products, Orders, Tax Rates, Tax Classes, Categories, Attributes, Shipping Classes and Tags from WooCommerce
  • download all Product Details, including Images
  • update existing Customer, Product and Order records from WooCommerce to FileMaker
  • download Orders between 2 dates
  • create/update a Customer record from FileMaker to WooCommerce

Like our other products it will also have these features:

  • will work with FileMaker Pro v12, 13, 14 and 15
  • can be hosted by FileMaker Pro or FileMaker Server
  • works with Macintosh and Windows
  • 100% unlocked for you to integrate into your own FileMaker solution

I’ve put together a short preview video showing fmEcommerce Link (WooCommerce Edition) in action downloading Products, Orders and Customer data from WooCommerce to FileMaker. You can watch this below or via this link on YouTube:

Coming Soon – fmEcommerce Link (WooCommerce Edition)

Earlier this year we published a series of articles about FileMaker and eCommerce Integration, highlighting our use of External SQL Data Sources (ESS) to make our online store orders visible in our internal FileMaker CRM. We’ve been using this method of integration successfully for many years and it has saved us countless hours by not having to manually re-enter online orders in our main FileMaker business app and our accounting software (Xero).

That was until recently when we started getting this error message every time we navigated to the online orders layouts:odbc-error

Suddenly we could no longer see our online order records! Everything was still working on the website and orders were still being submitted successfully (we receive an email for each order) so we started troubleshooting this to try and get to the bottom of it. After many frustrating hours we still could not establish the ODBC connection to our server, so we made contact with our web host and opened a ticket explaining our issue and describing how this had previously worked fine for many years. We were then informed that they had disabled remote MySQL access for security reasons and there were no exceptions – talk about a great way to annoy your customers by switching off access and not informing your customers about this!

It was still possible to connect but you had to create an SSH tunnel first – we then wasted another couple of days setting up the SSH tunnel which would work but then drop out, and we had issues with automating this so it could run when the server wasn’t logged in. After many days of frustration and lost productivity I decided to abandon the SSH tunnel efforts as it was proving too unreliable and too look at other options. Databuzz specialises in FileMaker integration and having recently written an article on working with eCommerce APIs and Webhooks I revisited my article and knew what needed to be done.

Our website stores are built with WooCommerce, a popular plugin for WordPress that powers over 39% of all online stores. WooCommerce offer both a push and pull API so you can have new orders automatically pushed to a server, and also download new orders on demand (e.g. get all new Orders today). The push option is the more complicated of the two options as it requires FileMaker Server, Customer Web Publishing, PHP pages and Webhooks to be setup, so we decided to focus initially on the WooCommerce REST API as that allows us to query WooCommerce for any new Orders and download the data directly into FileMaker. This can be run regardless of whether the file is hosted with FileMaker Server or just using FileMaker Pro, and we can also setup server side schedules to run each night and download new data. The REST API also allows us to push data from FileMaker to WooCommerce, such as Product updates, which is something customers have requested in the past.

Fast forward a few months and we are in the final stages of development and testing of our latest product – fmEcommerce Link (WooCommerce Edition):

preview-home

fmEcommerce Link is our solution to connecting FileMaker to WooCommerce when you can’t make a direct ESS/ODBC connection – you use the fmEcommerce Link file to query your WooCommerce store for new orders, product inventory changes, new customers and also to push data back to WooCommerce such as new Products. You can link the fmEcommerce Link file to your existing FileMaker solution to push orders from WooCommerce into your main FileMaker business app, or recreate the same functionality inside your FileMaker business app as the fmEcommerce Link will be 100% unlocked for you to explore.

Here’s some screenshots showing data that we have downloaded from our test WooCommerce site:

preview-order-details

preview-orders-list

preview-products-list

I’ll be posting some videos demonstrating the core functionality of fmEcommerce Link over the coming days and would love to hear any feedback from existing FileMaker/WooCommerce users about any features you would like to see in the product – just leave a comment below.