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.

thanks. that's helpful.

Can you suggest any third-party apps that will help me track inventory?

Chiming in on this thread to guide you in selecting the most suitable third-party app you can integrate with QuickBooks Online (QBO) so you can track inventory between QBO and Shopify.

QBO offers an extensive selection of tools and add-ons that seamlessly integrate to automate bookkeeping, invoicing, inventory, data entry, and more. These simple interfaces simplify operations to help small and medium-sized businesses run smoothly. 

Since we're unable to specify an application that can help you in accomplishing your task, here's how to search for a third-party app in QBO:

1. Go to Apps and select Find Apps.
2. Search for a keyword in the search bar and press Enter.
3. Select an app and click Get app now to integrate.

Additionally, utilize reports in QBO to gain valuable insights into the things you buy and sell, as well as your inventory status.

Let me know whenever you have more questions about the Shopify and QBO integration. I'm here to lend you a hand. Keep safe and have a good one!

@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

@piercew 

Have you explored the inventory management app as I mentioned earlier?

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?

@Ovvel 

Consider having a 3rd party app as the connector to avoid duplication.

do you suggest a third party app to accomplish this?

Joining the thread to help you select third party applications that can integrate and track inventories on both parties, smallbiz0331.

Since linking Shopify and QuickBooks Online (QBO) exclusively supports summarized sales data based on Payouts from Shopify Payments or ShopPay, we're unable to provide specific application that can suffice this feature. 

For now, you may consider visiting our app market or follow these steps in finding third-party apps within your account:

1. Sign in to your QBO account.
2. Select Apps from the sidebar menu, then go to the Find Apps tab.
3. Enter a keyword in the search bar or click the Browse category button to filter the results.

In addition to this, feel free to utilize this reference to guide you in reviewing your QuickBooks overall data: Run reports in QBO.

I'm always available on this forum if there's anything else you require further assistance managing integrations and inventories in your account. Keep safe and have a good one!

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/