Back to All

Shopify Integration with Filemaker

March 6, 2020 |

Shopify is rapidly becoming the go-to platform for e-commerce, and with good reason – it’s rates are reasonable, and the tools provided to sellers are second to none. Amongst these tools is an extensive suite of integration options. Recently we did some work for a client using the Shopify REST API, and it worked a treat.

 

Shopify does what it’s designed to do very well – namely, provide a platform for you to sell stuff on. You can show your products, take payments, and do loads of other cool stuff around getting to know your customers. But you’re probably not going to find that Shopify will run your whole business for you. You’re going to need to run some accountancy software to tally up all those figures and keep the taxman happy, and if you’re doing any kind of actual processing of orders (think boxing stuff up, arranging shipping, or just generally making stuff that people order), then you’ll probably need to use some other tools.

 

Case in point – a recent client sells custom stickers. Customers interact with Shopify to place orders, and these come through via email to the client, and they then have to print, package, and ship the stickers. This process involves lots of bespoke steps – so they turned to the Claris Filemaker platform to help them track, and automate this stuff. Replacing paper job bags with a software based tracking system with barcodes and a Kanban style UI was great, but they also didn’t want to have to waste time copying job info back and forwards between Filemaker and Shopify.

The Shopify REST API is very full featured, allowing you to control almost every aspect of your Shopify account, and store:

And this means that in a couple of days, we’d built a system that allowed the user’s to build custom jobs using a industry specific quoting system in Filemaker, push these jobs to Shopify as ‘Draft Orders’ via the REST API, and once they’d been paid for by customers, import the final Order data back into filemaker to be managed by a custom built Kanban style job process management UI:

Kanban Style Filemaker UI

The end result here is an automated workflow, which removes tedious and fault-encouraging manual data entry, and allows the staff to concentrate on actually creating the great products that they sell.

If you’d like to get your Filemaker solution talking to your e-Commerce platform, or any other service with an API, then get in touch, we’d love to hear from you!