Mapping Inventory and Price in NetSuite Connector Setup

TL;DR

Mapping inventory and price fields for products in the NetSuite Connector is crucial for maintaining accurate data synchronization across platforms. This guide explains how to set up the necessary mappings effectively.

What Is Product Sync in NetSuite?

Before initiating product synchronization, you need to prepare your NetSuite product sync settings. This includes understanding the types of sync available, namely Full Product sync and Price/Quantity sync.

Types of Product Sync

You have two distinct options for syncing your products:

• Full Product Sync: Syncs all item fields available via the API, allowing comprehensive product management.
• Price/Quantity Sync: Synchronizes either price, quantity, or both. Only items with a valid flag field are included. You can implement real-time sync for immediate updates on supported connectors.

Setting Up Category Mappings

The mapping category determines which fields are utilized for your products in NetSuite Connector. You will need to create and configure a category mapping specific to your marketplace and cart. Additionally, you can only use one sync type per connector or account at a time, though different connectors or accounts can utilize different types.
For instance, an Amazon connector may have varying sync types across its different accounts.

Synchronization Process

When you choose which sync type to implement, follow these steps specific to your platform:

• For eCommerce platforms like Shopify or Magento, refer to the Mapping Cart Categories in NetSuite Connector.
• For Walmart or NewEgg configurations, it's best to consult with NetSuite Customer Support for tailored guidance.
• eBay automatically categorizes products based on variations, so no category mapping is required for this platform.

Mapping Inventory Fields

For effective management of inventory, you will need to map your inventory fields appropriately. Refer to the Mapping Inventories in NetSuite Connector for detailed procedures. After mapping inventory, proceed with price mapping to align your pricing strategy.

Mapping Price Fields

Similar to inventory mapping, price fields also require careful attention. Detailed instructions can be found in Mapping Prices in NetSuite Connector. Once price mapping is complete, you can activate your product sync.

Key Considerations

When setting up your sync, keep in mind:

• The test item must match across your marketplace or cart and in NetSuite.
• Ensure price and quantity data differs on the item in the cart compared to that in the order for verification.
• Full Product sync should be used if you want to send price or quantity values comprehensively.

By adhering to these guidelines, you can ensure that your NetSuite Connector product sync functions smoothly and efficiently.