Mass Updates
You can use SuiteAnalytics Workbook to query your NetSuite data using the analytics data source, which offers advanced query capabilities. For more information about SuiteAnalytics Workbook and how you can recreate your existing saved searches to workbooks, see the following topics:
You can use the Mass Updates functionality to find multiple records, with outdated information and update all field values simultaneously of these records. If you have the Mass Updates permission, you can go to Lists > Mass Update > Mass Updates, where you can select from the mass update list to run a Mass Update page. This page is similar to a Saved Search, where you can define the:
-
Filters used to select records to be updated
-
Results columns to be displayed for an update
-
Audience for an update
-
Schedule to use for running the update (account administrators only)
-
Field values to be updated for each record
To be available for mass update, a field must meet the following criteria:
-
It must support inline editing. For more information, see Using Inline Editing.
-
It must be displayed on your preferred form for the record type being updated.
-
If it is a standard field, it must be outside of subtab lists and must not have dependencies on other fields.
-
If it is a custom field, it must be stored and must not have a sourcing relationship.
When you define a mass update, you can perform it immediately or save it for future use. If you have the Schedule Mass Updates permission, you also can schedule a mass update to run on a recurring basis.
-
When you run a mass update, processing 50 records or less begins instantly. If you are processing more than 50 records, there may be a delay of up to one minute before the job begins. When a mass update is in process, you cannot stop it or cancel it.
-
After you have saved a mass update, it is available at Lists > Mass Update > Saved Mass Updates.
-
For information about setting up a mass update, see Defining a Mass Update.
-
For information about setting up a schedule for a mass update, see Scheduling a Mass Update.
-
Be aware that only one mass update can be run at a time in your account.
Additional mass update options may be available at Lists > Mass Update, depending on the features enabled in your account.
-
For information about Lists > Mass Update > Update Prices, see Updating Item Prices.
-
For information about Lists > Mass Update > Swap Prices Between Price Levels, see Swapping Prices Between Price Levels.
-
For information about Lists > Mass Update > Mass Duplicate Record Merge, see Duplicate Record Detection.
-
For information about Lists > Mass Update > Bulk Update Translation, see Working With Multi-Language Names and Descriptions.
If the mass update you want is not available, try using the Import Assistant to update data through import of a CSV file. For information, see Importing CSV Files with the Import Assistant.
It is possible to send an email in bulk for multiple transactions at one time with the possibility to attach any message to the email and with support for scriptable templates. For the procedure for setting a mass update for sending a bulk email for transactions, see Sending Transaction Email in Bulk
Mass Updates and SuiteScripts
-
Mass Update Scripts
You can programmatically perform custom mass updates to update fields that are not available through general mass updates, using a SuiteScript action script. See SuiteScript 2.x Mass Update Script Type. If the SuiteFlow feature is enabled, you also can use the mass updates functionality to find multiple record instances associated with a single workflow, and either initiate or process all records simultaneously. See Workflow Mass Updates.
-
Mass Updates and User Event Scripts
Be aware that a record change that results from a mass update can trigger a related user event script as the same change not made through a mass update would. However, in the case of the mass update, the full record is not passed to the user event script; instead, only the field(s) changed by the mass update are passed. For details about user event scripts, see SuiteScript 2.x User Event Script Type.