Skip to main content
D
Dave986
February 11, 2022
Question

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

  • February 11, 2022
  • 3 replies
  • 0 views

Good day.. and I hope someone can help me!

 

We have about 400 active SKU's and most of our sales are coming from 4 different Shopify stores, who all share the same product descriptions and SKU, but the stores are dedicated to different regions and warehouses (CAN, USA, EU and Wholseale).  Every store has been configured to import sales in the correct QBO account (CAN, USA, EU and Wholesale), yet QBO associates a specific SKU/product to the sales account where the SKU was first created/imported. We therefore have sales being attributed to wrong sales accounts and none of our reports are lining up.  

 

Where/how can i change settings so that the sales imported from each distinct Shopify store (with the same product SKU and description)  be matched to the correct sales account in QBO (CAN, USA' EU and Wholesale)? Can I do this retroactively as well?

3 replies

Fiat Lux - ASIA
Fiat Lux - ASIA
February 11, 2022

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

Jen_D
Jen_D
February 11, 2022

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.

D
Dave986Author
February 11, 2022

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?

T
Trish_T
February 11, 2022

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!

T
Trish_T
February 11, 2022

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!

 

D
Dave986Author
February 12, 2022

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. 

J
JamesM4
February 14, 2022

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. 

Terms & ConditionsAccessibility statement