Fixing Amazon FBA Orders showing as commas instead of order information in QuickBooks Desktop
This article helps Webgility Desktop users in fixing an issue where Amazon FBA orders showing as commas instead of order information in QuickBooks Desktop when synced through Webgility Desktop. The issue is caused by a corrupted customer profile in QuickBooks. The article provides a solution that involves recreating the customer profile, refreshing the sync settings, and reimporting the affected orders to ensure they display correctly.
Overview
If your Amazon FBA orders are showing up as commas or blank entries in QuickBooks Desktop, the issue is likely tied to a corrupted or misconfigured customer profile. Here’s how to resolve it quickly in Webgility Desktop.
What Causes This?
This display issue typically happens when a QuickBooks customer profile tied to Amazon FBA orders is damaged or incorrectly set up, preventing proper order data import.
How to Fix It
1. Back Up Your QuickBooks File
-
Always create a backup before making any major changes.
2. Recreate the Customer Profile in QuickBooks
-
Delete the affected customer profile from QuickBooks Desktop.
-
Re-add it with accurate information.
3. Review and Refresh Preferences
-
Go to Edit > Preferences in QuickBooks.
-
Check settings under Sales and Customers, and make sure everything looks right.
-
Save any changes.
4. Restart QuickBooks Desktop
-
Fully close and reopen the program to ensure changes apply correctly.
5. Try the FBA Sync Again
-
Return to Webgility Desktop and re-import your Amazon FBA orders.
-
The orders should now display correctly with all data fields populated.
Tips for Ongoing Accuracy
-
Regularly back up your QuickBooks data.
-
If order display issues occur again, check the related customer profile first.
-
Make sure your Webgility and QuickBooks connection are always up to date.