- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
There was duplication in my QB products data so I purged my QBO a/c. Now my Shopify orders
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Suppliers and Expenses
Greetings, Nasir.
I appreciate the detailed reply and giving the exact error messages. I'll take it from here and ensure you'll be able to sync your Shopify data.
The Invalid Reference Id error (Line.SalesItemLineDetail.ItemRef and Accounts element id 65) suggests that there is an inactivated item or account.
Did you do the purge by inactivating those products or accounts? In this case, make sure to reactivate those non-duplicated items and accounts. A few of them might still be inactive, which is why you're getting those errors.
Here's how to do it:
Reactivate products or services:
- Go to the Gear icon menu, then select Products and services.
- Click the Filter button.
- Set the Status to Inactive.
- Click Apply.
- Check those items with the (deleted) tag, then click Make active.
Reactivate accounts:
- Go to Accounting, then go to the Chart of Accounts tab.
- Click the small gear icon right above the Action column.
- Check Include inactive.
- Review the accounts and compare them with your Shopify mapping.
- Click the Make active button on the inactive accounts.
If you've completely purged your company, then this might be related to your sync settings in your Shopify account.
I would recommend checking it and see what's causing the errors. You'll want to contact Shopify's support if you need help with this.
If you also need to connect your bank account to match or categorize your transactions, you can check this article for a guide: Connect bank and credit card accounts to QuickBooks Online.
I'm here to help if you have more questions about syncing your data in QuickBooks Online. If you have any other concerns, please add them to your reply.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Suppliers and Expenses
Dear jamespaul
Thanks for your elaborate feedback
There are no products and services marked as inactive
The products and services list is empty after purge
All the accounts used in Shopify mapping are appearing under Chart Of Accounts.
None of the accounts under Chart Of Account are marked with Inactive Status
I would be willing to grant access to the Quickbooks technical team and Shopify technical team to my QBO account to fix this problem
I hope I don't need to create a new QBO account using a different email address to make Shopify integration work again. I'm currently on the 70% off for 3 months promotion. I won't get this promotion if I create a new QBO account
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Suppliers and Expenses
These error symbols are appearing under Connection column under Data tab of the QB - Shopify Connector by Intuit
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Manage Suppliers and Expenses
Thank you for the screenshot, nasir_m.
I would recommend contacting OneSaas about this matter since they are providing a connection between QuickBooks and Shopify.
- Please click this link: https://intuit.me/3wdbc1b
- Check the contact information on the right.
If you have questions about QuickBooks, feel free to go back to this thread.