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.
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 Name | Type | Description |
|---|---|---|
| Flag field | BOOLEAN | Identifies items to sync |
| Product title | TEXT | Title of the product |
| Product description | TEXT | Detailed description of the product |
| Price | CURRENCY | Price of the product |
| Quantity | INTEGER | Available stock of the product |
| Image | IMAGE | Visual representation of the item |
| Item options (size, color) | TEXT | Options 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?
How can I ensure accurate quantity sync between NetSuite and my marketplace?
Are there specific NetSuite item types or structures required for syncing variation products?
What strategy should be used when flagging products for synchronization?
Was this article helpful?
More in Commerce
- Available Items Only Feature in NetSuite 2026.1
Available items only filtering boosts sales efficiency in NetSuite 2026.1 with Intelligent Item Recommendations.
- Commerce Extensions in NetSuite 2026.1
Commerce Extensions in NetSuite 2026.1 enhance performance and user experience in eCommerce.
- Convert Multiple Transaction Line Items into Configured Items in
Enhance transaction processing in NetSuite by converting multiple line items into configured items with improved session handling.
- New SuiteCommerce Features in NetSuite 2026.1
New SuiteCommerce features in NetSuite 2026.1 enhance user experience and improve eCommerce efficiency.
