Shopify Order Not Posting to QuickBooks Due to Incorrect Product Mapping
This guide explains how to troubleshoot Shopify orders that are downloaded into Webgility Desktop but do not post to QuickBooks Desktop. The primary focus is verifying the affected order and correcting any incorrect or missing product mappings caused by SKU mismatches. After updating the mapping, repost the order and verify that it appears correctly in QuickBooks.
If a Shopify order is downloaded into Webgility Desktop but fails to post to QuickBooks Desktop, the issue is often caused by missing or incorrect product mapping. Before adjusting product mappings, refresh your product data so Webgility has the latest item information from both platforms:
- Download Latest Product Data: Refresh product data from both QuickBooks Desktop and Shopify within Webgility Desktop. (Download Items from Scratch from Both QuickBooks & Sales Channel)
- Verify Item Availability: Confirm that the target item exists and is active in QuickBooks Desktop.
Step-by-Step Instructions
Step 1: Correct the Product Mapping
- In Webgility Desktop, navigate to Products > All Products.
- Search for the affected Shopify product or SKU.
- If an incorrect mapping exists, clear or remove it.
- Select the correct QuickBooks item to pair with the Shopify product using manual search, one-click mapping, or recommended mapping.
- Save your changes to update the mapping rule.
For detailed screenshot walkthroughs on mapping products, refer to the Webgility Product Mapping Guide.
Step 2: Repost the Affected Order
- If the order previously failed or needs to be refreshed, locate it in the Errors tab or New Orders tab.
- Select the order and click Post to QuickBooks.
- Open QuickBooks Desktop to verify that the transaction posted successfully.
Note: If the order was previously posted with incorrect data, unpost or undo sync on the order first before reposting. See the How to Unpost Transactions Guide for detailed steps.