Price Data Mapping in NetSuite Connector for eCommerce

TL;DR Opening

Syncing price data during product synchronization in the NetSuite Connector optimizes your eCommerce operations. By mapping prices accurately, your products maintain consistent pricing across platforms, ensuring user satisfaction and compliance.

How to Create a Price Mapping

Creating a mapping for prices within the NetSuite Connector is essential for accurate product sync. Here's a step-by-step guide:

1. Log in to app.farapp.com.
2. Select the connector and the relevant account.
3. Navigate to Mappings > Products.
4. Depending on the context:
   • For marketplace connectors (e.g., Amazon or Walmart), select the appropriate category from the Category list.
   • For other connectors, choose Price/Quantity Only or Full Product in the Select Sync Type field.
5. From the product mappings list, find the price mapping and click Special Mapping - Click to Edit. This will open the price Mapping window.
   • Note: If the price field is missing, click Add Mapping to include it.
6. In the Map Price from the Following Price Level list, select the corresponding price level.
7. Click Save Changes.
8. Finally, click Save.

Best Practices for Mapping Prices

When working with price mappings, consider the following best practices:

• Identify Field Names: The field names for prices in marketplaces may vary (e.g., price, regular_price, or item-price). If uncertain, hover over a field to see its tooltip for hints about its use.
• Avoid Arithmetic Operations: It is recommended to map prices directly from a price level in NetSuite. Arithmetic operations with pricing could lead to discrepancies between NetSuite and storefront prices. If adjustments are necessary (like applying a discount), it is better to use custom fields within NetSuite.

Additional Operations on Price

If you need to perform math on prices prior to syncing, you can follow these steps:

1. Log in to app.farapp.com and select the connector and account.
2. Go to Mappings > Products.
3. Each marketplace connector may require a specific category selection from the Category list.
4. Locate the price mapping and click Special Mapping - Click to Edit.
5. Select a price level from the Map Price from the Following Price Level list.
6. Click Add Operation Row and choose Multiply from the Operations list.
7. Enter .9 in the Value field to reduce the price by 10%. Additional operations can be added by repeating the previous two steps.
8. Save your changes before exiting.

Who This Affects

• Developers: Those implementing the NetSuite Connector will benefit greatly from understanding price mapping.
• Administrators: System Administrators responsible for maintaining accurate data across platforms will find this essential.
• E-commerce Managers: Managers overseeing pricing strategies in marketplaces can improve pricing consistency.

Key Takeaways

• Mapping prices accurately in the NetSuite Connector ensures consistent pricing across platforms.
• Awareness of varying field names for prices is crucial when working with different marketplaces.
• Direct mapping is preferable to avoid discrepancies; arithmetic operations should be handled with caution.

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