Troubleshooting Inventory Sync Issues in NetSuite Connector

TL;DR

This article addresses essential aspects of troubleshooting inventory sync issues within the NetSuite Connector, emphasizing how inventory data flows between NetSuite and storefronts, the differentiation between available and on-hand quantities, and common syncing delays.

What Are the Key Points for Inventory Sync?

Understanding the dynamics of inventory synchronization is crucial for maintaining accurate stock levels across your sales channels. Here are the key takeaways:

• One-Way Sync: Inventory syncs to the storefront, not from it. Thus, while orders sent to NetSuite will adjust your inventory counts, you cannot expect inventory data to sync back to NetSuite from your storefront.
• Sync Timing: The synchronization from NetSuite is not instantaneous. While many connectors do offer real-time updates, it typically takes a few minutes for inventory data to sync. If your system does not employ real-time syncing, the default interval for synchronization is one hour.
• Available vs. On-Hand Quantity: The sync from NetSuite focuses on the available quantity at locations, which indicates stock not committed to orders. In contrast, the quantity on hand reflects total items in inventory, including those on order.

How to Troubleshoot Sync Issues?

If you encounter problems with inventory syncing, several steps can help you identify and resolve these issues. Here are some actions to consider:

1. Check Sync Status: First, confirm that your sync settings are active within the NetSuite Connector. Go to Data Flows > Manage Data Syncs after selecting the appropriate connector and account. If the sync is off, you must toggle it back on.

   • Ensure only one type of product sync (Price and Quantity or Full Product) is active at a time for any connector-account pair, as activating both can lead to complications.

2. Monitor for Mass Item Updates: Large updates to item records can significantly slow down sync processes. Check last modified dates in NetSuite to assess if frequent updates are occurring, which can lead to exceeding API limits and syncing delays.

3. Verify Inventory Types Mapped: Confirm that the proper inventory types are being tracked and that the mapping aligns with your storefront’s requirements.

By following the outlined steps and understanding how inventory syncing functions, you can more effectively manage your inventory data across platforms, ensuring accurate product availability for your customers.

Key Takeaways

• Inventory sync is unidirectional from NetSuite to the storefront.
• Sync intervals may vary, typically defaulting to hourly when not in real time.
• Track available quantity rather than total quantity on hand for accurate sales data.

Source: This article is based on Oracle's official NetSuite documentation.