Netsuite Integration: Transaction with Item Group
In Netsuite, Item Group can group a list of child items together. I will show you in this blog how to set/get Item Group data from an Opportunity.
Example #1: Create a Netsuite Opportunity with Item Group
There are a few things you should be aware of:
- You can’t specify a price to an Item Group. Item Group price will be automatically calculated by Netsuite using the total of all child items.
- You can specify a quantity.
- You don’t have to provide all the child items. Netsuite will handle this automatically.
Below is a sample request:
... ... 5 ... ...
Example #2: Create a Netsuite Opportunity with Item Group
Integrate Netsuite with Salesforce. Query a Netsuite Opportunity (with Item Group) and sync it over to Salesforce Opportunity.
There are a few things you should be aware of:
- All child items will be returned in the query. If the Netsuite Opportunity has 1 Item Group consisting 2 Child Items, you will get 4 line items in Netsuite Opportunity (see example below for more example)
- You will need to calculate the price properly. If not, you will get duplicate pricing.
Below is a sample response:
... ... Group 1 1 5.0 RAM - 128 MB 2 5.0 PC 100 RAM - 128 MB Base Price 39.95 199.75 DVD-R 5 pack 3 5.0 5 pack of 4.7 GB DVD-RAM discs<br>Includes 5 cases Base Price 27.95 139.75 &nbsp; 5 Base Price 339.5 ... ...
To synchronise the proper amount over to Salesforce, you may consider the following option:
- Take the price of the Forth Line Item and put it in the First Line Item. Ignore price for all the other Line Items.
- Ignore price of the Forth Line Item, use child items pricing.