Getting Ready for WooCommerce 2.7

WooCommerce 2.7 is getting close to final candidate release – this promises to be a major release with lots of structural changes designed to improve performance. There will also be a number of changes to the WooCommerce REST API that our fmEcommerce Link (WooCommerce Edition) FileMaker solution integrates with.

You can read about all the changes in WooCommerce 2.7 on the WooCommerce blog – at this stage it looks like they will introduce a v2 of the REST API and keep the current v1 functionality so products like fmEcommerce Link will continue to work. We’ve reported a number of bugs with v1 of the REST API which will be fixed in the v2 API – we’ll keep monitoring the status of the changes to the REST API and incorporate the changes in the v2 API in a free update to fmEcommerce Link for all our existing customers.

There will be a number of changes to the REST API endpoints with the WooCommerce 2.7 release so we’ll need to make some associated changes and do a lot of testing to make sure all the existing functionality continues to work. Most of the changes related to Products and Variations which are the most complex endpoints to integrate with, so we’re looking forward to a more simplified way of creating and updating Product Variations.

The updated version of fmEcommerce Link will then only support WooCommerce 2.7 or later going forward (v2 of the REST API) – we’ll let everyone know when the new version is available once we’ve completed our development and testing.

Mapping our Customers

Databuzz might be based in Sydney, Australia but thanks to the wonder of the Internet we have customers all around the world. Managing a diverse customer base can be a challenge at times and we’ve become experts at time zone differences and knowing when is the best time to schedule a demo for customers in Europe or North America.

We love meeting up with our customers face-to-face at the FileMaker Developer Conference every year – it’s usually the only chance we get to meet our non Australian customers in person. Every 12 months or so I like to generate a simple Google Map showing where our customers are located for our various products – it’s quite pleasing to see the pins grow every year and new locations added to the map.

Our FileMaker Xero integration solution fmAccounting Link (Xero Edition) is now into it’s fourth year of development and in that time the number of Xero subscribers has grown exponentially. Xero is now reporting a total customer base of over 862,000 subscribers (up from 284,000 in 2014) and is on track to hit the magic million mark some time in 2017. It’s four main markets remain the same:

  • Australia
  • New Zealand
  • UK
  • North America

but it is now seeing growth in new markets such as South Africa, Hong Kong and Singapore. Australia remains the largest Xero market for now, but we can expect to see North America become the largest market over time. Here’s a map showing where fmAccounting Link (Xero Edition) customers are located:

As you can see it also reflects the main Xero markets – we’re starting to see more enquiries from Canada, Asia as well as Africa, so hopefully next time we generate this map there will be some red pins in some new countries as Xero grows in other parts of the world.

fmSMS, our oldest product is a truly international product and was designed from day one to work in as many countries around the world as possible – using fmSMS you can send and receive SMS messages via one of over 75 supported SMS Gateways reaching over 860 mobile networks in more than 220 countries. We continue to add additional SMS Gateways each year and now have customers spread out all over the world – here’s a map showing their locations:

We often speak to FileMaker customers who are considering purchasing one of our products from outside of Australia and are slightly concerned that they will be the only customer from their country and will have trouble getting support. We pride ourselves and providing the same great customer service to all our customers regardless of where they are located – and as these maps demonstrate there’s a good chance you’re not our first customer from your part of the world.

fmAccounting Link (MYOB AccountRight Edition) Now Supports Jobs

We’ve just finished an update to fmAccounting Link (MYOB AccountRight Edition) which now includes examples for working with Jobs, one of the most requested features from our customers. fmAccounting Link shows you how you can use FileMaker to:

  • download Jobs from MYOB to FileMaker (all Jobs or filtered by Start Date)
  • create Jobs in FileMaker and upload them to MYOB
  • update a single Job from MYOB
  • enter a Job against an Invoice Line Item or a General Journal Item
  • download a Job Budget from MYOB to FileMaker and send an updated version back to MYOB

This is a free update for all existing customers. You can view the full release notes on our version history page. If there are other features you would like to see in the core fmAccounting Link (MYOB AccountRight Edition) file please get in touch and let us know.

New fmAccounting Link (Xero Edition) Videos

We’ve just uploaded a couple of new videos demonstrating how you can work with Prepayments and Overpayments using fmAccounting Link (Xero Edition). In each video we cover:

  • creating a new Prepayment and Overpayment from a Customer
  • allocating the Prepayment/Overpayment to an Invoice
  • refunding the balance of the Prepayment/Overpayment

You can watch these videos on the Videos page or here are the direct links:

Prepayments in fmAccounting Link

Overpayments in fmAccounting Link

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.

fmAccounting Link (Xero Edition) – Prepayments Update

Our first update to fmAccounting Link (Xero Edition) for 2017 is now out the door – this release includes a number of minor enhancements as well as a new endpoint example: Prepayments. We’ve had a number of requests for Prepayments so we’re happy to release this free update to all our existing customers.

The fmAccounting Link (Xero Edition) file has examples for:

  • downloading Prepayments from Xero (all Prepayments or between 2 dates)
  • creating a Prepayment in FileMaker and pushing to Xero
  • allocating Invoices to a Prepayment in FileMaker and pushing to Xero
  • creating a Refund for a Prepayment in FileMaker and pushing to Xero

Further details on fmAccounting Link (Xero Edition) including the full list of examples are available on the fmAccounting Link (Xero Edition) product page. 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 – we’re already working on the next round of enhancements and examples based on customer feedback.

North West Sydney FileMaker Developer Meetup Dates for 2017

The dates for the 2017 North West Sydney FileMaker Developer Meetups have been finalised so you can lock these into your diary now:

February 24th (Pennant Hills Bowling Club 12:30pm)

May 26th (Pennant Hills Bowling Club 12:30pm)

August 25th (Pennant Hills Bowling Club 12:30pm)

December 6th Xmas Meetup (Sydney CBD 7pm – location TBD – suggestions welcome)

If you would like to join the mailing list just visit the signup page at:

http://databuzz.us12.list-manage.com/subscribe?u=366d1a87399a120a9d438cb56&id=8bb1fea366

We’ll send our reminders before each meeting – anyone is welcome to attend and no RSVP is required

fmAccounting Link (MYOB AccountRight Edition) Updates – my.MYOB Login and General Journals

We’ve been busy working on some updates to fmAccounting Link (MYOB AccountRight Edition) over the past few weeks. fmAccounting Link (MYOB AccountRight Edition) was a popular item during our recent End Of Year sale and we’ve had some great feedback from customers about features they would like to see in future releases.

We’ve just released an updated version of fmAccounting Link  – v1.0.8. As well as the usual bug fixes we’ve added examples for working with the General Journals API endpoint – you can now download, create and update General Journals from FileMaker using fmAccounting Link. We’ve also added support for users that have linked their MYOB Company File User ID to their my.MYOB login – typically this is set using either of the following dialogs in AccountRight:

We couldn’t find anything about working with linked my.MYOB logins in the API documentation and after raising a ticket with MYOB developer support we were informed about the changes you need to make when working with linked my.MYOB accounts. We’ve added a new checkbox to the MYOB Company screen that allows you to flag that you’ll be using a linked my.MYOB login:

which handles the required changes automatically. For existing customers using older versions of fmAccounting Link you can simply disable a single script step to handle working with linked my.MYOB logins – see our FAQ page for details.

We’ve started working on adding examples for working with the JOBS API endpoint and hope to have this completed in the next few weeks. If there are features you would like to se in the core fmAccounting Link (MYOB AccountRight Edition) file please get in touch and let us know. You can view the full release notes on our version history page.

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.