Custom Quickbooks – Shopify Interface

After updating an existing project in python (django) to synchronize products to shopify for one of my shopify plus clients, I was asked if I was interested in creating a new custom interface between Quickbooks and shopify / shipstation, the customer was already using unify, to import orders from shipstationinto quickbooks, but unify did not offer a method to link a sales receipt to the correct location the order was fulfilled from.

so for the past couple of weeks I have remotely collaborated with the client (who is located in the United States), and created:

  • Laravel webapplication that receives order data from shipstation
  • c# console application that fetched new order data  from my laravel webapplication through an ssh tunnel, and inserts the orders into quickbooks, with the correct fulfillmentlocation.

Rough Sketch

diagram

 

We decided to create a laravel webapplication to have an easy way of adding datasources if needed, the webbapplication is used for mapping order fields for any new datasources / creating bundle & product mappings. and seing an activity log from the consoleapplication.
This way I could keep the console application relatively simple, and I could make sure to keep the laravel data universal for every datasource.