Troubleshooting Product Sync Issues in NetSuite Connector

Resolve product sync issues in NetSuite Connector. Check sync status, SKU errors, and storefront flags.

·2 min read·View Oracle Docs

If you're experiencing delays or issues during product synchronization with NetSuite Connector, this guide will help you troubleshoot effectively. Continuous updates of large quantities of items can disrupt your sync, especially if the API limits for your endpoints are exceeded. Below are the steps to diagnose and resolve common product sync issues.

How to Diagnose Product Sync Issues

Check the Sync Status

Ensure the following when verifying your sync status:

  • Navigate to Data Flows > Manage Data Syncs to check if the sync is active.
  • Ensure only one sync type is enabled per connector-account pair to prevent conflicts, i.e., you cannot run a Price and Quantity sync simultaneously with a Full Product sync.
  • If both sync types are off, enable only the one you have tested.

Verify the SKU

Follow these steps to check the status of a specific SKU:

  • Go to Data Flows > Products and enter the SKU in the search box.
  • Pending Posting: If the SKU is pending, wait for the scheduled sync to run.
  • Synced: If the SKU status indicates synced, check the marketplace to confirm its presence.
  • Error: Hover over the SKU for the error message. This can guide you in resolving the issue. Keep in mind that multiple errors can stall other items from syncing.
  • Excluded: Check the reason for exclusion and take necessary actions. If unable to locate the SKU, validate you are in the correct connector-account.

Examine the Storefront Flag Field

If you have created a list-based storefront flag field,

  • Confirm the values and order are accurate as outlined in the creation process for flag fields.

Review Item Categories

Confirm the categories on the Product Dashboard:

  • If using Price and Quantity sync, categories should reflect names like PriceQty, corresponding to your connector.
  • For Full Product sync, the category should align with your connector's requirements (e.g., Shopify for Shopify Full Product sync).
  • Be aware of special cases for eBay, where the category always shows eBayVariations or eBayFixedPrice.

If Issues Persist

Should none of the above steps resolve your issue, reach out to NetSuite Customer Support for assistance.

Key Considerations

  • NetSuite Connector treats NetSuite as the primary record for items, synchronizing updates automatically to marketplaces.
  • Maintain clarity on the flag fields' configuration as their settings directly influence what gets synchronized to your marketplace.

Following these troubleshooting steps will facilitate smoother product sync operations and help you manage your item updates more effectively in NetSuite Connector.

Frequently Asked Questions (4)

What should I do if both Price and Quantity sync and Full Product sync are off?
Enable only the sync type that you have tested to avoid conflicts, as running multiple sync types simultaneously can create issues.
How can I diagnose issues with a specific SKU during product sync?
Search for the SKU under Data Flows > Products and check its status: pending, synced, error, or excluded. Each status has different troubleshooting steps, such as waiting for a pending sync or addressing any error messages.
What should I verify if my storefront flag field isn't working as expected?
Ensure the values and order in your list-based storefront flag field align with the creation process for flag fields. Incorrect settings can disrupt synchronizations.
How can the item categories affect the sync process?
The categories should correspond to your connector's requirements, like 'PriceQty' for Price and Quantity sync or 'Shopify' for Full Product sync. Misconfigured categories can prevent proper synchronization.
Source: Troubleshooting Product Sync Issues Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Commerce

View all Commerce articles →