Shopify - QuickBooks Desktop Connector - Account Mapping Issue

Shopify Discussion
1

I’m going through the painful process of migrating from QB POS to Shopify. I’m at the QB Desktop integration step using the QB Connector, and trying to map the various Chart of Accounts accounts to Sales, COGS, etc. and have hit an odd issue.

The drop-down list for selecting a mapping to COGS is empty - the connector does not seem to be able to find any of the COGS accounts in QB despite there being several active accounts there so I would expect this drop down to be populated with those. The other account types are present/selectable. Can anyone suggest what the problem might be? Without being able to make this selection, the integration cannot continue.

LakeClub_2-1697991649653.png
LakeClub_2-1697991649653.png1741×1197 158 KB

2

Hi @LakeClub [email removed]
This is Theodore from PageFly - Shopify Page Builder App.
For solving the problem about QuickBooks Desktop Connector - Account Mapping Issue, let’s try this solution:

Here are some things to check that may help resolve the issue of COGS accounts not showing up in the QB Connector mapping for Shopify:

  • Confirm the COGS accounts in QB Desktop are not subaccounts. The QB Connector can only map main parent accounts, not subaccounts. You may need to roll up subaccounts to the parent COGS account.

  • Check the account types in QB Desktop - make sure the COGS accounts are mapped as Cost of Goods Sold type accounts in QB. Other types may not sync over.

  • Review the account filters in the QB Connector settings. There may be exclusions or restrictions set that prevent COGS from syncing. Try adjusting the filters.

  • Re-authenticate and re-sync QB Desktop in the QB Connector. Sometimes refreshed connections can resolve data sync issues.

  • Ensure you are on the latest version of the QB Connector app and QB Desktop. Older versions may have sync bugs.

  • As a workaround, you can manually create the COGS account in Shopify first, then map to it from QB. Not ideal but lets the integration continue.

  • Check for errors in the QB Connector logs that may indicate why COGS is not coming across from QB.

Getting the account mappings right is crucial for the integration, so take the time to troubleshoot the COGS sync. Let me know if the issue persists after reviewing the potential causes above.

I’ll be so happy if my suggestion can help to solve your problem. If you have any further questions, please feel free to tell me.
Best regards,
Theodore | PageFly

3

I’ve managed to solve this issue by closing/restarting QB and doing a reboot of the server.

4

We have had the exact same problem…..since October 3. I am leaving Shopify.