Product Mapping Setup for Inventory Sync in NetSuite Connector

The Product Mapping page in NetSuite Connector allows you to establish item mappings from your NetSuite account to various storefronts and marketplace channels. Efficient setup ensures smooth synchronization of inventory and product data, crucial for maintaining accurate listings and stock levels across platforms.

How to Map Product or Inventory Sync Data?

Follow these steps to effectively map your product data:

1. Login to NetSuite Connector.
2. Select a connector.
3. Navigate to Mappings > Products.
4. Click Add Mapping.
5. In the Add Field Mapping window, complete the following:
   • On the Required row, select either Category or SKU.
   • On the Standard row, choose a relevant NetSuite field.
6. Click Add Mapping.
7. Select the newly added mapping at the bottom of the table.
8. Complete the Mapping window as detailed below:

Category Mapping

• NetSuite Field ID: Enter the relevant NetSuite Field ID.
• Value: Enter a defining value.

Note:
NetSuite Connector utilizes the Category mapping to ascertain if a specific item should be categorized. Typically, items are categorized based on whether a field is populated. For instance, using 'ShopifyPriceQty' as a category can depend on the presence of a value in the chosen field. To implement this, place a value in the NetSuite Field ID box and keep the Value blank, or input a specific value to restrict categorization.

SKU Mapping

1. Mapping Type: Select either Item Field, Item Field Translation, or Logic.

If Item Field is selected:

• Enter a corresponding value in the NetSuite Field ID column.

If Item Field Translation is selected:

• Click Translation Mapping - Click to Edit.
• For the NetSuite Value, enter the value to be used for translation.
• Enable the On/Off switch and add the NetSuite Field value.
• Click Save Changes.

If Logic is selected:

• Click Logic Mapping - Click to Edit to define conditions:
  • Choose how to evaluate values such as Order Header Value, Fixed Value, or Computed Value.
  • Input necessary comparisons and conditions in the provided fields, and finalize your mapping with Save Changes.

Note:
In both category and SKU mappings, the condition driven by the mapping dictates how values are set when conditions are true or false. Always ensure to check the settings thoroughly to avoid mismappings.

Key Takeaways

• Mapping product data helps in effective inventory synchronization across platforms.
• Clear categorization leverages existing NetSuite fields for accurate product representation.
• Logic-based mappings add significant customization for business needs.

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