Skip to main content

How to Update Existing Opportunities

ExtendInsights Data Management | Update NetSuite Opportunities in Excel

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.

Did this answer your question?