Shopify inventory synced with Quickbooks online

Hello there. I appreciate you taking the time to come by here in the Community forum. I've got a few pieces of information for you about how QuickBooks Online and Shopify integration works.

Integrating Shopify with QuickBooks Online (QBO) does not import inventory and only supports summarized sales data based on Payouts from Shopify Payments or ShopPay. These are broken down into the following categories; sales, shipping income, discount, selling fees, reserved balance, pending balance, and sales tax payable.

You may refer to this article for more information and go to the FAQs section: How Shopify works with QuickBooks Online. 

With this, you can consider looking for a supported third-party application that enables you to track your inventory from both parties. I'll be glad to provide this link so you can explore our Appstore: Apps help QuickBooks run better. You can maximize the results by typing some keywords and reading some reviews for better recommendations.

Additionally, feel free to utilize this article in case you'll encounter the most common Shopify issues which we've highlighted: Troubleshoot Shopify issues.

Drop a reply anytime if you still have questions or concerns about QuickBooks Online and Shopify integration. I'll be here to assist you further and ensure to provide an extra hand in accomplishing all your QuickBooks-related tasks. Take care and have a nice day ahead.

@Maison Bonesaw 

You can explore an inventory management app as the connector.

https://go.zoho.com/H3R

I am having the exact same issue. Did you land on a resolution? Any apps that can accomplish this? Thanks

Hi, I am having a couple of issues. Quickbooks sync the shopify transactions, but it doesn't create an invoice.  When the orders are from my wholesale customers, I must attach the invoice to that customer. Since it doesn't, I have to manually enter the entire invoice into quickbooks under that customers name. That will duplicate the items that are taken out of inventory. Once on the website, and a second time when I enter the invoice.

Also, I  switched to shopify credit card processing only from the very costly credit card processing that I used to have. I used to get charged monthly for the fees, so the amount that funded, was the amount I charged and it matched the transaction. It was a pleasure, it was quick.

Shopify payouts totals are the amounts I charged minus what they are charging me for the transaction. That means I can't match the transaction. Sometimes it gets complicated knowing to which transaction it belongs to, because the numbers are not the original amounts I charged.

Can anyone help me out with these issues?

Hello!

It looks like QuickBooks Online doesn’t automatically sync inventory changes in real-time between QuickBooks and Shopify. Unfortunately, the built-in connector might not handle this as smoothly as expected. A good workaround would be to use a third-party app that specifically manages this sync. You could try using an app like TradeGecko (now QuickBooks Commerce), or Stocky for inventory management. These can help automate the process and ensure your stock levels are updated on both platforms.

If you'd like a more hands-on solution with mobile devices, you could also consider Cleverence Warehouse 15. It integrates directly with QuickBooks and allows you to track inventory in real-time with barcode scanning and mobile devices. You can manage stock take, transfers, and shipments, and the app ensures that QuickBooks always has the most accurate inventory picture.

Learn more about Cleverence Warehouse 15 here:
https://www.cleverence.com/solutions/quickbooks-warehouse-15/