ANS-1425 · CSV IMPORT & DATA MIGRATION

How to Process Item Group Components with User Event Scripts During CSV Import

User event scripts can interact with item group components as line items during CSV imports, provided the necessary NetSuite preferences are enabled.

Short answer

Yes, user event scripts with a beforeSubmit trigger can process item group components during CSV imports. These components appear as line items, allowing custom logic to be applied. Crucially, the 'Run Server SuiteScript and Trigger Workflows' preference must be enabled in CSV Import Preferences for scripts to execute.

Scenario

Organizations often need to import item groups via CSV and require custom logic to be applied to the individual components of these groups. A common question arises whether user event scripts can effectively capture and process these components during the import process, specifically when using the beforeSubmit trigger.

Solution

  1. To ensure user event scripts trigger during CSV imports, navigate to Setup > Import/Export > CSV Import Preferences and enable the 'Run Server SuiteScript and Trigger Workflows' option. This setting is critical for beforeSubmit triggers to execute.

  2. When importing item groups via CSV, the beforeSubmit trigger of a user event script will execute. Within this script, the individual components of the item group are accessible and appear as line items. This allows for custom logic to be performed on each component during the import process.

Expert NetSuite Support

Need help with this NetSuite issue?

CSV Import & Data Migration consulting and configuration support

Talk to a consultant