Skip to main content
All CollectionsExtendInsights for Data Management NetSuiteHow-To'sManage Records
Manage Records: How to update 1 row, multiple rows, or all rows using ExtendInsights for Data Management NetSuite
Manage Records: How to update 1 row, multiple rows, or all rows using ExtendInsights for Data Management NetSuite

ExtendInsights Data Management | With ExtendInsights you can upsert 1 or more rows from Excel back to NetSuite

Updated over a week ago

ExtendInsights allows you to push updates from Excel to NetSuite based on the internal ID or external ID. This article covers how to push changes based on the internal ID. Check out this article if you need to update based on external ID.

  • If the internal ID is present ExtendInsights will perform an update on the NetSuite record. 

  • If the internal ID is not present ExtendInsights will create a new NetSuite record. 


Update 1 row at a time

by clicking on 1 of the cells within that row, the whole record for that set will be updated when Records on Selected Rows only is enabled.

Update multiple rows at a time

by highlighting the cells within those rows and when Records on Selected Rows only is enabled.

Update all rows at once

by checking off Records on Selected rows only.

⚠️ WARNING: If you hide rows, they WILL still be updated.


Global Setting for Selected Rows

We have added a global setting called Use selected rows only in Settings which you can access from the left menu of the app.

Step 1: Click the Menu Options > Settings

Step 2: Use Selected Rows Only (toggle on or off)


See also this article to learn more.

Choose your update method

ExtendInsights offers two upsert options, Real-Time and Background.

Typically users that are updating small data sets would use the Standard Upload. Users processing large data sets or who need to submit multiple uploads simultaneously would benefit from the Background Upload Process.

📘Learn more about Background Upload here.

Did this answer your question?