Mapping Price Fields for NetSuite Connector Integration

TL;DR

Mapping price fields is essential for accurate data synchronization between NetSuite and eCommerce platforms. Properly linking these fields ensures that pricing information is consistent and up-to-date across different sales channels.

How to Map Price Fields

Price and inventory fields are among the most commonly mapped across NetSuite Connectors, as they directly affect how businesses manage their pricing and stock levels. Here’s an overview of how to successfully map price fields.

Steps to Create a Price Mapping

To set up price mappings in the NetSuite Connector, follow these steps:

1. Log in to the NetSuite Connector at app.farapp.com.

2. Select the relevant connector and account you wish to work with.

3. Navigate to Mappings > Products.

4. Choose one of the following actions:

   • For marketplace connectors like Amazon or Walmart, select the respective category for inventory mapping.
   • For other connectors, choose the Select Sync Type field and decide between Price/Quantity Only or Full Product._

5. From the list of product mappings, locate the price mapping and click on Special Mapping - Click to Edit.
   The price mapping window will open.

   Note: If the price field you need isn’t visible, click Add Mapping to incorporate it into your settings.

6. In the Map Price from the Following Price Level dropdown, select the appropriate price level to use for synchronization.

7. Click Save Changes to preserve your updates.

8. Finally, remember to click Save to complete the mapping process.

Important Considerations

• Ensure that the field names for prices can vary significantly among different marketplaces and platforms. Common terms for price fields include price, regular_price, or item-price. If uncertain, hover over the field names in your mappings for tooltips that may clarify their use.
• Always verify that the mappings align with your business's pricing strategy and the specific configurations of the marketplaces used.

This systematic approach to price mapping will enhance product synchronization and ensure accurate pricing presentation across platforms.

Who This Affects

• Administrators: Responsible for overseeing connector mappings and ensuring data fidelity.
• Developers: Implementing and maintaining product sync configurations.
• eCommerce Managers: Monitoring pricing strategies and compliance across sales channels.

Key Takeaways:

• Mapping price fields is critical for effective ecommerce synchronization.
• Use specific terminology to ensure clarity during the mapping process.
• Regularly review and update mappings to align with changing business needs.

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