Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 22, 2024
Question

Connecting Quickbooks and Shopify

  • October 22, 2024
  • 2 replies
  • 0 views

So I have connected my quickbooks and Shopify store through the app quickbooks online global. My products on shopify are hampers made up of a bunch of products. When uploading my stock onto quickbooks I have created bundles for them (which are my hampers on my store). I want to be able to automatically reduce my stock on quickbooks, when I sell a hamper on shopify, so every item in that hamper will be reduced by 1 on quickbooks. How do I connect my shopify and quickbooks to be able to do this? I am unsure if i have used the correct app in connecting the two sites. 

2 replies

Level 2
October 22, 2024

I appreciate the detailed information regarding Shopify and QuickBooks Online (QBO), ElJB. Let me walk you through this process. 

 

Before we proceed, please know that deducting the product automatically is not possible through QBO as it is primarily designed for recording purposes. Although QBO can categorize your transactions from Shopify, it cannot automatically deduct products/services. As a result, you will need to create the transaction manually within QBO by selecting the appropriate entry in the +New button.

 

Since you mentioned connecting your Shopify to QBO, this should automatically bring in your orders, refunds and payouts. To check if you connect the right application, let's navigate to the Apps menu.  Afterward, follow these steps:

 

  1. Go to the Apps menu, then choose Find Apps.
  2. From the Search bar, enter Shopify.
  3. From the results, click the Shopify.
  4. See if you already integrate this to QBO. If you haven't, you can click the Get app now.

 

You can also view this article for more details regarding the integration between QBO and Shopify: Shopify for QuickBooks Online. 
 

Please let me know if you have additional questions regarding with the connectivity between QBO and Shopify, ElJB. We'll be around to help you. 

August 4, 2025

Getting QuickBooks to talk smoothly with Shopify isn’t always straightforward. Some people just export CSVs and upload them manually, while others automate the process with tools like Zapier. I’ve had solid results with Skyvia – it works in the background and handles complex mappings better than the basic options. Another option is to bring in a QuickBooks ProAdvisor who can set up a custom API link tailored to your workflow.