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.
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.