Mapping Inventories in NetSuite Connector for eCommerce

TL;DR

This article explains how to sync inventory data in the NetSuite Connector during product integrations for eCommerce platforms. Understanding the inventory field mappings is crucial for seamless operations, especially when using connectors like Shopify and Magento.

What Are Inventory Mappings in NetSuite Connector?

Inventory mappings are vital for syncing stock levels between NetSuite and eCommerce platforms. Inventory field names differ across marketplaces and may include terms like quantity, inventory, qoh (quantity on hand), or qty (abbreviation for quantity). If the specific field for inventory isn't obvious, hovering over the field name within the mappings interface can provide further details.

When to Use Standard Inventory Mapping

The standard inventory mapping is applicable in most scenarios, except for:

• Shopify Connector with a multi-location setup. For more in-depth guidance, refer to the section on Mapping Shopify Multilocation Inventory in NetSuite Connector.
• Magento 2 with a multi-warehouse configuration (important for versions 2.3X and later).

Steps to Create a Standard Inventory Mapping

1. Log in to app.farapp.com.
2. Choose the appropriate connector and account to work with.
3. Navigate to Mappings > Products.
4. Select an action:
   • For marketplace connectors like Amazon or Walmart, select the corresponding category from the Category list.
   • For others, choose Price/Quantity Only or Full Product from the Select Sync Type field.
5. In the product mappings list, find the inventory mapping and click Special Mapping - Click to Edit.
6. If the inventory field does not appear, select Add Mapping to include it.
7. Choose one or multiple locations to sync inventory from the Sum Quantity from the Following Locations list. Hold Ctrl (or Command for Mac) to select multiple locations.
8. Click Save Changes and then Save to finalize the mapping.

Important Considerations

• Make sure to verify the specific location IDs in Shopify if using multi-location mapping.
• Previous inventory mappings in Shopify may need removal before applying a multi-location configuration.

Key Takeaways

• Syncing inventory correctly depends on understanding how each marketplace defines its inventory fields.
• Standard mappings can be modified for specific platforms like Shopify and Magento.
• Proper setup is crucial for ensuring accurate inventory reflects in the eCommerce storefront.

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