Item and Product Syncs
NetSuite uses Item records for inventory management. Salesforce uses Product objects for maintaining the Sales Catalogs for the sales teams. The Salesforce Connector supports the exchange of data between NetSuite and Salesforce. The NetSuite inventory and the Salesforce product catalog are always in sync.
The Salesforce Connector synchronizes the changes made in NetSuite, and the changes made in Salesforce, so that both the Sales team and the Finance team are always working with the same information.
Supported Item Types
The following NetSuite item types are supported by Salesforce Connector:
-
Inventory Items, including:
-
Standard Inventory Items
-
Serialized Inventory Items
-
Lot Numbered Inventory Items
-
-
Non-Inventory Items, including:
-
Non-Inventory Items for Sale
-
Non-Inventory Items for Resale
-
-
Service Items, including:
-
Service Items for Sale
-
Service Items for Resale
-
Item and Product Sync Prerequisites
For an Inventory Item sync, ensure that values are defined in NetSuite for the fields Default COGS Account and Default Assets Account. In NetSuite, go to Setup > Accounting > Preferences > Accounting Preferences Click the Items/Transactions subtab to select the values for these fields.
Item and Product Lookups
For information about Lookups for Items and Products, see Manage Lookups.
Item to Product Mapping Tables
The following table shows the mapping between NetSuite Items and Salesforce Products to ensure that identical sales catalogs are maintained in both applications.
Standard Field Mappings
|
NetSuite Item |
Salesforce Product |
|---|---|
|
Item Name and Number |
Product Code |
|
Display Name and Code (Item) ItemCode (Inventory, Non-Inventory, and Service Items) |
Product Name |
|
isInactive |
IsActive |
|
includeChildren |
- |
|
Tax Schedule |
- |
|
UnitsType |
Units of Measure |
|
ItemType |
Custom Field: Oracle_Product_Type__c |
|
InternalId |
Custom Field: Oracle_NetSuiteId__c |
Custom Field Mappings
|
NetSuite Item |
Salesforce Product |
|---|---|
|
Custom Field |
- |
|
ItemType |
Custom Field: Oracle_Product_Type__c |
|
InternalId |
Custom Field: Oracle_NetSuiteId__c |
|
Custom Field: Salesforce_Product_Status__c |
Custom Field: Oracle_Product_Status_c |
|
Custom Field: Item_Syncronization_message__c |
Custom Field: Oracle_Synchronization_message__c |
|
Custom Field: NS_Item_Sync_Timestamp__c |
Custom Field: Oracle_TimeStamp_of_last_update__c |
|
Custom Field: Salesforce_Product_ID__c |
- |