Same Product sales on different Shopify stores are not importing to the correct sales account in QBO

Consider having a paid connector to reconcile your Shopify transactions into QBO.

Thanks for posting here in the QuickBooks support page, Dave.

I want to make sure you're able to sync your payments into QuickBooks Online.

For now, we need to make sure Shopify is connected correctly to our program to ensure the entries sync successfully. See this link to establish connection between Shopify and QuickBooks: Shopify for QuickBooks Online

You can also go to this link to look for Shopify connectors: QBO Apps. Change the country flag to Canada to update the apps available for your country.

Please post here again if you have other concerns with QuickBooks and Shopify payments. I'll be right here to help you out any time. Have a nice day.

Thanks for the feedback received thus far.

We are using a connector and the synch is fine for payouts, sales, deposits, product creation etc, BUT in reaching out both to QBO and the app provider (Quickbooks bridge by Parex) they have informed that when the product is first created, it is associated to a specific sales account, and therefore any subsequent sale of this product in any shopify store will appear in this same sales account rather in the account where it actually occurred.   

I'm not sure if I am being clear enough. If not, let me know and I'll share a few screen shots of the set up and erroneous sales accounts within QBO.

In short, how do I get QBO to recognize where the same SKU sale is coming from given that the product exists in QBO and has already been associated with a different sales account?

Hi Dave986,

Thanks for reaching back out.  QuickBooks Online has a great feature for managing your products and services.  I can see how time consuming this can be when transactions aren't being aligned properly when syncing with Shopify.  I'll be happy to provide more insight here!

In addition to the information given in the previous post, I recommend taking a look at the product and associated SKU# in QuickBooks, to ensure the correct account is applied.  Here's how:

1. Click on the Gear in the top right and open Products and Services

2. Search for the SKU# or Product and then hit Edit in the Action column

3. Check the associated Income and Expense accounts and make any necessary changes

4. Hit Save and Close when finished

That should do it!

For your reference, here's an Integration guide for Shopify and QuickBooks Online.

If the issue persists, feel free to contact us.  It would be our pleasure to work with you in real time and ensure you're able to get back to business as soon as  possible.

Schedule a Callback or start a Chat: click (?) Help in the upper right in QuickBooks Online > enter "Contact support" > hit Contact Us > provide a brief summary of your situation > hit Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook, Twitter, and Instagram.
Support hours are from Monday to Friday between 9 a.m. and 8 p.m. ET.

Please reach back out with other questions.  We'd love to help!

Thanks for responding quickly. 

As i know how to manually attribute a sales channel to specific product, I think there is a key feature you may not be reading or understanding correctly:

We have the same SKU's in every location. Therefore choosing one sales account for one SKU does not help me differentiate sales per location when we have sales from the same product in each location.

Am i making sense? If it still is not clear, let's go ahead and schedule a meeting for us to explore this further.

David

Hi Dave986,

I appreciate the additional information for your completing your QuickBooks goals.  For further assistance with managing the settings for the sales being imported from Shopify, I suggest reaching out to them directly.  They'll work with you to ensure the mapping is correct for a smooth transition of your sales with QuickBooks Online.

I hope this helps!  We're here for you, if you have any other questions!

OK I've spoken to 5 different professionals and they all have the same answer. The is no way in QBO to associate a sale of the same product in two different sales accounts ;(

I have an idea that I think you can help me with to resolve this issue. Seeing as each sale order # has a prefix associated to the correct market (CA, EU, UK, US etc..) can I sort all of my sales by order # and then do a bulk edit to then associate these product manually to the correct sales account? For example, I would select all invoices starting with EU and would switch these in bulk from the main sales account to the EU Sales account.

It would be a bit more work, but it would give me really clean numbers to work with :) I hope this feature is doable as a bulk action!

Thanks again for you help. 

I see what you're saying. I highly encourage you to give this a try on our test drive account using this link here. The test account is a free account that already has data on it and it can be used  to try different methods for achieving your accounting goals. Let me know if you have additional questions, I'll be on standby.