How to connect Shopify to Quickbooks with Zapier, including product support

Chances are that you’re here because you discovered that Shopify to Quickbooks integrations are quite poor in execution or do not provide line item support. This leads to all revenue being forced into one income account and your P&L to display the wrong figures.

One of the simpler solutions is creating a custom app in Zapier, giving you control of what data actually goes in to QB (QuickBooks), including splitting the revenues between multiple products. To keep it on point, let’s get started.

1. Get Shopify Data

In Zapier, create a new Zap, selecting Shopify as the app and ‘New Paid Order’ as even trigger. Press Continue, choose account, and select the required Payment/Order/Fulfillment Status (likely Paid/Any/Any).

2. Cleanse Customer Names

(Optional Step) If you want to associate the invoices with customers and subsequently create those customers in QB, there is an issue here. QB doesn’t accept any kind of weird characters in data provided through the API. For example, trying to create a customer named O’Rourke would not be possible in QB and would return an error. Therefore, I created a mini python Script which cleanses these characters. Choose App: ‘Code by Zapier’, Action: ‘Run Python’, selecting customer first and last names from Step 1 Shopify: