Price and Quantity Sync Configuration in NetSuite Connector

Configure Price and Quantity Sync in NetSuite Connector to synchronize product data effectively across your marketplace and cart.

·3 min read·View Oracle Docs

Price and Quantity Sync in NetSuite Connector allows for seamless synchronization of product data, specifically price and quantity information, between NetSuite and your chosen marketplace or cart. Setting this up correctly ensures that your item details reflect current market conditions without impacting your live sales.

How Does Price and Quantity Sync Work?

To successfully configure price and quantity sync, certain prerequisites must be met. You must use test items that exist in both NetSuite and your marketplace. This process focuses on items that you can afford to test without affecting your actual sales. Here are the key requirements you need to follow:

  • SKU Matching: The SKU in NetSuite should exactly match the SKU in the marketplace or cart. This ensures accurate mapping between the two systems.
  • Price Availability: If syncing prices, ensure that a price value is entered in at least one of the available price levels for your test item in NetSuite.
  • Quantity Availability: For quantity synchronization, verify that there is available quantity specified at one of your item locations in NetSuite. Alternatively, if you prefer to sync quantity from a custom field, that field must have a value defined.

Setting Up Full Product Sync

If you are considering a full product sync instead, you need to determine if your items are variations. The following guidelines are applicable:

  • Matrix Item Type: Use the NetSuite matrix item type for your variation products. Define your parent items, child items, and variation fields (like size and color).
  • Testing Sample: Create a matrix item family in NetSuite to serve as your test set, ensuring that you keep the number of subitems under five for effective management.
  • Standalone Items: For standalone items, just one sample product will suffice for initial testing.

Required Item Fields for Sync

When you configure your test items in NetSuite, make sure to fill out these essential fields:

Field NameTypeDescription
Flag fieldBOOLEANIdentifies items to sync
Product titleTEXTTitle of the product
Product descriptionTEXTDetailed description of the product
PriceCURRENCYPrice of the product
QuantityINTEGERAvailable stock of the product
ImageIMAGEVisual representation of the item
Item options (size, color)TEXTOptions for variation items

Note: Additional fields may be required depending on the marketplace, such as Amazon or eBay, which can have unique requirements.

Flagging Products for Sync

Once you have designated your test items, flag them for synchronization. It is important not to flag all items to sync right away, even if you plan to sync more later. This practice ensures that only your test products are targeted in the initial phase, minimizing risks.

Key Takeaways

  • Ensure that the SKU in NetSuite matches the SKU in your marketplace for successful sync operations.
  • Use test items wisely to prevent disruptions to live sales during the synchronization process.
  • Flag products before syncing to manage which items should be updated in your marketplace effectively.

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

Frequently Asked Questions (4)

What prerequisites must be met before configuring price and quantity sync in NetSuite Connector?
Before configuring price and quantity sync, ensure you are using test items that exist in both NetSuite and your marketplace, with matching SKUs to guarantee accurate mapping.
How can I ensure accurate quantity sync between NetSuite and my marketplace?
To ensure accurate quantity sync, verify that there is available quantity specified at one of your item locations in NetSuite or use a custom field with a defined value for quantity synchronization.
Are there specific NetSuite item types or structures required for syncing variation products?
Yes, for syncing variation products, you should use the NetSuite matrix item type and structure your parent and child items accordingly, keeping variations like size and color in mind.
What strategy should be used when flagging products for synchronization?
Initially, only designate test items by flagging them for synchronization. This cautious approach prevents disruptions to live sales and ensures controlled sync operations.
Source: Price and Quantity 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 →