How to Fix Product Sync Issues Between Walmart and QuickBooks Desktop in Webgility Desktop
This article helps Webgility Desktop users in troubleshooting product synchronization issues between Walmart and QuickBooks Desktop that may cause discrepancies in inventory levels and order records. It outlines clear steps to identify, diagnose, and resolve sync problems, ensuring accurate and consistent data across platforms.
Overview
Product synchronization issues between Walmart and QuickBooks can lead to discrepancies in inventory and order records. This article outlines troubleshooting steps for users when addressing similar issues.
Symptoms
- Some items not syncing between Walmart and QuickBooks
- Inventory counts or product details do not align
- Sync scheduler not updating all items as expected
Initial Actions
- Confirm the Issue
- Review the report of specific items failing to sync.
- Check error messages or logs, if available.
- Check Sync Settings
- Ensure Walmart and QuickBooks integrations are active.
- Confirm valid credentials/API access on both platforms.
Data Review
- Download Product Lists
- Download the current item list from both:
- Walmart Seller Center: Export products as a CSV/XLS file.
- QuickBooks (Desktop/Online): Export item/inventory list.
- Download the current item list from both:
- Compare Item Lists
- Use a spreadsheet tool to match SKUs or product names.
- Note missing or mismatched items.
Sync Troubleshooting Steps
- Manual Item Sync
- Perform a manual sync for problematic items using the integration platform or middleware.
- Verify if affected items now appear on both platforms.
- Restart Sync Scheduler
- Restart the sync scheduler (if applicable):
- Locate the scheduler settings or controls.
- Click Restart or Reschedule.
- Monitor for successful sync completion.
- Restart the sync scheduler (if applicable):
Monitoring & Follow-up
- Monitor sync status for the next 24–48 hours.