How to Fix Missing COGS, Shipping, or Fee Data in Webgility Analytics Reports
This article helps Webgility Desktop users in resolving issues where Webgility analytics data such as COGS, shipping fees, or selling fees is missing from Shopify–QuickBooks Desktop reports. These gaps are commonly caused by sync errors, integration issues, or incorrect report settings. The article offers a step-by-step approach to identify the root cause and restore complete, accurate reporting.
Step 1: Confirm Data Sync Status
- Check Integration Dashboard: Log into Webgility and check the QuickBooks Connection under Connection and go to Accounting, click on Edit Connection and Test QuickBooks Connection.
Step 2: Review Configuration Settings.
- Item Mapping: In Webgility Desktop under Products, verify that specific fields (COGS, shipping, selling fees) are mapped correctly between the Sales Channel and QuickBooks.
Step 3: Test Order and Data Refresh.
- Manual Sync/Test: Run a manual sync if available, and review the reports.
- Test Order: Create/test an order (e.g., order with shipping and fees) and retry refreshing the report.