Mapping Inventory and Price Fields in NetSuite Connector

To effectively manage product information in e-commerce, it is essential to correctly map inventory and price fields in the NetSuite Connector. This article outlines the steps and considerations for mapping these critical fields for optimal data synchronization between NetSuite and various marketplaces or shopping carts.

How to Map Inventory Fields

To begin mapping inventory fields, it’s essential to note that this task is frequently performed across various connectors, as it plays a crucial role in inventory management.

Steps to Create a Standard Inventory Mapping:

1. Log in to app.farapp.com.
2. Select the appropriate connector and account.
3. Navigate to Mappings > Products.
4. Choose the correct category from the Category list for marketplace connectors like Amazon or Walmart, or select the sync type (either Price/Quantity Only or Full Product) for others.
5. Locate the inventory mapping in the product mappings list and click Special Mapping - Click to Edit to access the inventory mapping window.
6. If the inventory field used by the storefront is not visible, click Add Mapping to include it.
7. To sync inventory from multiple locations, use the Sum Quantity from the Following Locations list, holding down Ctrl (or Command for Mac) to make multiple selections.
8. Click Save Changes, then Save to finalize the mapping.

Important Notes:

• Key Terms for Inventory Fields: When mapping, familiarize yourself with common terms such as quantity, inventory, or abbreviations like qty. Hovering over field names may provide useful tooltips.
• Special Cases: Note that standard inventory mapping may not apply if you are using connectors like Shopify with a multi-location setup or Magento2 with multi-warehouse configurations.

How to Map Price Fields

Similar to inventory mapping, price field mapping is essential for synchronizing correct pricing information during product sync. This step is crucial for ensuring that price adjustments in NetSuite reflect accurately across selling platforms.

Steps to Create Price Mapping:

1. Log in to app.farapp.com.
2. Select the connector and relevant account.
3. Navigate to Mappings > Products.
4. Choose the category or sync type according to the connector specifics as noted above.
5. Find the price mapping in the product mappings list and click Special Mapping - Click to Edit.
6. If the price field is not visible, use Add Mapping to include it in your configuration.
7. From the Map Price from the Following Price Level list, select the specific price level to synchronize.
8. Click Save Changes, followed by Save.

Key Terms for Price Fields:

When creating price mappings, look for terminology including price, regular_price, or item-price. Again, tooltips may indicate the field's purpose during mapping.

Who This Affects

• Administrators managing product sync configurations.
• Developers that implement and troubleshoot inventory and price mappings.
• E-commerce managers seeking accurate inventory and pricing data integration.

Key Takeaways

• Proper mapping of inventory and price fields enhances product sync efficiency in NetSuite Connector.
• Familiarity with marketplace-specific terms is crucial for successful sync configurations.
• The mapping process involves clear steps to ensure accurate data reflects across channels.

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