The Company

Wayfaren is a family owned E-commerce company that specializes in building high quality customized keepsake boxes and Custom Push Pin Travel Maps. All the boxes and maps are assembled in their workshop in the Dallas region, Texas. 

The challenge

When Abby reached out to me initially she was looking for someone to push automatically their orders from Shopify and Etsy into the google sheets they were using for their operations.  

Their set-up in Google Sheets was overly complicated, hard to use and nearly impossible to automate as is. It was taking too much time for their operations manager to enter each new order and manage existing orders. Spreadsheets are awesome, we love them @Wiseflow, they are easy and cheap to set-up. But when the data structure is complex their limitations can hold a business back. 

The solution

After talking a couple of hours with Wayfaren production team I convinced them that instead of spending a lot of time trying to fix the existing spreadsheets to be able to push data from their online stores we would be better off building a custom app designed for their specific needs: 

  • Affordable

  • Simple to use

  • Able to handle complex product customization 

  • No more data entry

We decided to build their new app with Knack and to use Integromat to push orders from Shopify & Etsy to their new app.  For an equivalent order the data arriving in totally different format depending on if the order was coming from Etsy or Shopify. That was a challenge that was fairly easily tackled with the power of Integromat. We built a datastructure that allowed us to automate some processes that were 100% manual before like Engraving Proof Approval. Now all their production has access to the required information, and only the required information when needed. Wayfaren management team can easily access key business metrics with their manager dashboard. 

Apps used

Knack no-code app builder
Integromat Shopify Automation
Shopify & Etsy Integrations

From Abby, Owner of Wayfaren

"Can't recommend working with Loic enough! He is very professional, skilled, and knowledgable. Communication was reliable and prompt. He was able to assist us in building a custom system for our business that has greatly increased productivity and smoothness of our operations."