Skip to content
  • There are no suggestions because the search field is empty.

Resolving Item Mapping and Inventory Sync Issues Between BigCommerce and QuickBooks

This article helps Webgility Desktop users identify and resolve item mapping and inventory synchronization issues between BigCommerce and QuickBooks Desktop. It guides users through operational steps to correct inconsistent product quantities, fix download errors, and ensure accurate item records across both systems.

Step-by-Step Resolution Guide

1. Review and Correct Item Mappings

  • View all mappings via Products > All Products > Filter: Mapped.

  • If mappings appear in red, they are invalid. Use the Remove Mapping option and re-map correctly. 

Action Steps:

  • Use Unmatch or Delete Mapping options to remove incorrect mappings.

  • Manually remap products to ensure accurate alignment between BigCommerce and QuickBooks records.

2. Update Synchronization Preferences

  • Go to Products > Settings > Sync Settings > Automation rules.

  • Update inventory synchronization mode:

    • Change from Available Quantity to On-Hand Quantity to reflect real-time stock.

  • Save changes and reinitialize the sync process.

3. Troubleshoot Order Sync 

  • Trigger a Manual Sync from the Home or Error tab

  • Review activity logs for:

    • Product download failures

    • API errors

    • Mapping validation issues

If errors persist:

  • Confirm API credentials and platform connection settings.

  • Reauthenticate or refresh connections if needed.