Troubleshooting QuickBooks Order Posting Errors and SKU Mismatches
This article helps Webgility Desktop users resolve order posting errors, payment reference mismatches, and SKU mapping issues. It is intended for those experiencing disruptions caused by QuickBooks Desktop file switches or product mapping errors.
Overview
This article addresses the resolution process for QuickBooks order posting errors, payment reference mismatches, and SKU mapping issues. It’s intended for those who experience disruptions due to QuickBooks (QB) file switches or product mapping errors.
Step-by-Step Troubleshooting
1. Investigate QuickBooks Connection Status
- Confirm which QuickBooks company file is currently active.
- Navigate to Connections > Accounting/POS/ERP > Edit Connection and verify the integration is connected and stable.
- Check the scheduler logs for the timestamp and nature of the connection interruption.
2. Identify Stuck or Failed Orders
- In Webgility, look for the specific error message in the History tab of the orders in the Error tab.
- Note any common factors, such as time of failure, involved products, or missing references.
3. Review SKU and Payment Field Mappings
- Compare the SKU values and payment references recorded in QuickBooks with those expected from the e-commerce source.
- Look for discrepancies due to recent changes or misconfigured mappings.
4. Advise Temporary Manual Remediation
If immediate resolution is needed before re-testing the connection, try the following manual actions:
- Manually post or re-enter any stuck orders into QuickBooks.
- Directly correct mismatched payment references or SKUs within the respective orders.
- Document which orders were manually edited for audit purposes.
5. Restore and Test Sync Operations
- Re-establish the intended QuickBooks company file connection.
- Run the scheduled sync or posting process manually to verify that errors no longer occur.
- Confirm that new orders and payments process with correct references and SKU mappings.