Mapping Inventory Fields for NetSuite Connector Setup

TL;DR Opening

Mapping inventory fields is crucial for proper product synchronization between NetSuite and various marketplaces using the NetSuite Connector. This guide details the necessary steps and considerations for setting up your inventory field mappings effectively.

What is Inventory Field Mapping?

Inventory field mapping involves defining how inventory data in NetSuite corresponds to the fields required by various sales platforms, such as eCommerce marketplaces. This step is essential for synchronizing product quantities and availability between your NetSuite account and external platforms effectively.

Preparing for Inventory Field Mapping

Before you begin mapping inventory fields, ensure that you have completed the product sync setup within your NetSuite Connector. This setup includes ensuring that your SKU field is appropriately mapped and creating a custom storefront flag for each connector account. Refer to relevant documentation for detailed instructions on product sync configuration.

Choosing the Right Sync Type

When configuring your product sync, you need to decide between two primary types:

• Full Product Sync: This allows you to sync all item fields through the API.
• Price/Quantity Sync: Syncs either price, quantity, or both for existing items only.

You can run only one type of sync per connector/account combination, allowing different settings across multiple accounts or connectors.

Steps for Mapping Inventory Fields

1. Identify Required Fields: Determine which fields your chosen marketplace requires for inventory mapping. Common fields typically include SKU, quantity available, and stock status.
2. Access Mapping Settings: Navigate to the NetSuite Connector's mapping settings to configure the required fields.
   • For specific instructions, consult the documentation on Mapping Inventories in NetSuite Connector.
3. Map Your Fields: Align your NetSuite fields with those required by the marketplace, ensuring that the data reflects accurately.
4. Test the Mapping: After mapping your inventory fields, it's vital to run tests to ensure that the sync operates as expected. Select a test item that exists in your marketplace and verify that the data syncs correctly.

Additional Considerations

• For marketplaces like eBay, no manual category mapping is required; products are automatically categorized based on their variations.
• For other platforms such as Walmart and NewEgg, consult NetSuite Customer Support to navigate specific mapping requirements.
• Remember that improper mapping can lead to discrepancies and operational inefficiencies, so thorough verification is essential.

Related Topics

• Mapping Price Fields: In addition to inventory mapping, price field mapping is also critical for product sync. Refer to the documentation for details on Mapping Prices in NetSuite Connector.
• Product Sync Activation: Once inventory and price fields are mapped, you can activate the product sync process. Detailed instructions can be found in the Activating NetSuite Connector Product Sync.

Key Takeaways

• Ensure thorough preparation before mapping inventory fields in NetSuite Connector.
• Choose between Full Product or Price/Quantity sync based on your needs.
• Test the sync with test items to validate correct data flow.

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