Updating records through the NetSuite interface can involve navigating multiple screens. ExtendInsights lets you retrieve Opportunities into Excel, make changes, and upload them to NetSuite.
Walkthrough Video
Watch the video for a walkthrough of updating Opportunities with ExtendInsights.
Prepare Your Template
Before building a template, review the Opportunity form in NetSuite and identify the header fields, line-level fields, and required fields for your process.
In the NetSuite Classic interface, go to Transactions → Sales → Create Opportunities → List.
A template for updating Opportunities may include:
Field | Purpose |
Tran Date | Opportunity date |
Tran ID | Identifies the Opportunity |
Entity | Opportunity entity |
Status | Opportunity status |
Item List: Item | Item on the opportunity line |
Item List: Quantity | Quantity on the line |
Item List: Price | Price level for the line |
Item List: Rate | Rate for the line |
Item List: Customer | Customer value for the line |
Item List: Replace All | Controls how existing sublist lines are handled during an update |
💡 Tip: Confirm the field names and required fields on your NetSuite form before building the template. The fields you need may depend on your account’s configuration.
Retrieve the Opportunities
Retrieve the Opportunities you want to update before making changes in Excel. ExtendInsights offers several ways to retrieve records.
➡️ See the Retrieve Data guide collection for the available options.
Choose How to Handle Existing Opportunity Lines
The Replace All field controls how NetSuite handles existing sublist data, such as opportunity line items, when you upload an update. NetSuite sets this field to TRUE by default.
Replace All value | What happens |
TRUE | Existing sublist data is replaced with the data in your upload. Use this when you intend to replace the full set of lines. |
FALSE | Existing lines are retained while the specified lines are updated. Use this when changing selected line details, such as quantity or pricing, without removing other lines. |
For updates to specific lines, set Replace All to FALSE so existing lines that aren’t part of the update are retained.
