Product and Price/Quantity Sync Configuration in NetSuite

Enable product and price/qty sync in NetSuite to ensure accurate inventory and pricing across marketplaces. Follow best practices for setup.

·3 min read·View Oracle Docs

Enabling product and price/quantity sync in NetSuite is crucial for maintaining consistency across your marketplace and cart. Proper configuration allows for accurate inventory management and pricing updates. Here’s a comprehensive guide on how to ensure your sync operates correctly.

How to Prepare for Product or Price/Qty Sync?

Before enabling the synchronization, it's recommended to test a small number of SKUs with your connected marketplace or cart to confirm they post accurately. The NetSuite Connector relies on a flag field within NetSuite to manage the data that is synchronized. Proper setup and verification are key steps in the process.

Best Practices for Syncing Products

To ensure successful synchronization, consider the following best practices:

  • Flag Items Properly: Ensure all items are properly flagged within NetSuite, and verify the flag field mapping in the NetSuite Connector is configured correctly.
  • Accurate Product Information: Confirm that the product details being synced from NetSuite to the connector are complete and accurate, covering all necessary details.
  • Validation in Marketplace: After syncing, check that the posted data appears correctly on the selected marketplace or cart.
  • Populate Inventory First: It is essential that your inventory in NetSuite is fully populated prior to enabling product or price/quantity syncing.

Note: When utilizing CSV imports for product updates in NetSuite, ensure you do not check the Run Server SuiteScript and Trigger Workflows option unless you wish to forego the real-time sync provided by the NetSuite Connector.

Enabling Product or Price/Qty Sync

Follow these steps to enable product or price/qty synchronization effectively:

  1. Flag 100 items you wish to sync.
  2. Enable product or price/qty sync in the NetSuite Connector.
  3. Wait for the 100 flagged items to sync.
  4. Confirm the data for a selection of these items is displayed correctly on the marketplace or cart.
  5. If successful, flag an additional 1000 items.
  6. Allow the 1000 items to sync.
  7. Again, verify that data for several of these items appears correctly.
  8. Finally, flag any remaining items for sync once you've confirmed the processes work correctly for earlier batches.

Managing Flag Fields

The NetSuite Connector requires that each account have a custom field that serves as a storefront flag for syncing products. This field controls how items are processed. Here’s a summary of potential flag field values you can set:

Field ValueDefinitionNotes
(blank)Ignored by NetSuite ConnectorNo data loaded if blank
1Add/Update ItemSyncs product data to the storefront
2Remove ItemStops syncing item; does not delete it
3Ignore ItemCompletely ignored in sync
4Post Children as Stand-AlonePosts child items independently from parent
5Post Inventory OnlyFor eBay, syncs only inventory updates
6Post Price OnlyFor eBay, syncs only price updates
7Post Price/Inventory OnlyFor eBay, syncs both price and inventory updates

By following these guidelines and verifying your synchronization settings, you can ensure a smooth integration of inventory and pricing across various online marketplaces.

Frequently Asked Questions (4)

What prerequisites should I complete before enabling product or price/quantity sync in NetSuite?
Before enabling product or price/quantity sync, ensure that your inventory is fully populated in NetSuite and test the sync process with a small number of SKUs to confirm accuracy. Also, check the flag field mapping in the NetSuite Connector.
How can I manage the flag fields that control product syncing in NetSuite?
Each account needs a custom field that acts as a storefront flag. This field controls product syncing, with values ranging from adding or updating items to ignoring them completely. Setting the field correctly is crucial for accurate synchronization.
Is it necessary to verify synced data on the marketplace after initiating the NetSuite sync process?
Yes, after syncing, it is important to verify that the data appears correctly on the selected marketplace or cart to ensure the sync process was successful.
What should I do if I am using CSV imports for product updates and want to maintain real-time sync with NetSuite?
When using CSV imports, do not check the 'Run Server SuiteScript and Trigger Workflows' option if you wish to preserve the real-time sync provided by the NetSuite Connector.
Source: Product or Price/Qty Sync 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 →