To create, update, and maintain NetSuite records efficiently using ExtendInsights, we recommend following the best practices below. These guidelines help improve performance, reduce errors, and ensure a smooth experience when working with NetSuite data in Excel.
✅ Tip 1: Review NetSuite Permissions and Prerequisites
Before users begin working in ExtendInsights, confirm that their NetSuite roles are configured correctly.
In NetSuite, go to Setup → Users/Roles → Manage Roles.
Edit the role used with ExtendInsights.
Ensure the following permissions are enabled and set appropriately:
SOAP Web Services
User Access Tokens
➡️ Refer to the setup guide to confirm all required permissions are in place.
✅ Tip 2 - Install the performance bundle in NetSuite
Install the CloudExtend Excel Data Management for NetSuite bundle to unlock advanced features and configuration options.
The bundle enables customization through NetSuite custom records and settings.
It also supports performance optimizations and additional capabilities.
➡️ Learn how to install the ExtendInsights NetSuite bundle and why it’s important.
✅ Tip 3: Build a Well-Structured Template
Good templates lead to faster uploads and fewer errors.
Template design best practices:
Review the NetSuite form for the record type you’re working with.
Understand which fields are header-level and line-level.
Include all mandatory fields.
Use NetSuite field IDs when building templates.
Ensure user roles have permission to view any custom fields.
💡 Tip:
Place all header fields at the top of the template and line-level fields below.
When creating records with multiple lines, rows with identical header fields will be treated as a single record.
✅ Tip 4: Validate Data Before Uploading
Recommended practices:
Use Cell Operations (Picklists) for NetSuite list fields.
This inserts the NetSuite internal ID automatically behind the scenes.When possible, use internal IDs directly in the format:
[[12345]]If using formulas or copied data, ensure the result includes the internal ID in the same format.
Check mandatory fields for missing values.
Do not hide rows or columns in the active worksheet—hidden data is still processed during uploads.
✅ Tip 5: Test a Small Batch First
Before processing a large dataset, test the template and data with a small number of records.
Select a few representative rows.
Run the intended create, update, delete, or reload operation.
Review the row-level results in Excel.
Confirm the resulting records in NetSuite.
Correct any template, permission, or data issues before processing the remaining rows.
A small test can reveal missing mandatory fields, invalid internal IDs, permission problems, and unexpected NetSuite workflow behavior.
For bulk updates or deletions, consider downloading the current NetSuite data first so your team has a reference for the original values.
✅ Tip 6: Share Standardized Templates with Your Team
Each user does not need to rebuild the same templates.
Recommended practices include:
Have an administrator or experienced user create standardized templates.
Create separate templates for common record types and business processes.
Use clear names and descriptions.
Share templates with the appropriate ExtendInsights users.
Maintain a central collection of approved templates for reuse.
Review shared templates when NetSuite forms, custom fields, or business processes change.
✅ Tip 7: Use Background Upload for Large Data Sets (Enterprise Only)
Use Background Upload, also known as burst mode, when processing large datasets or running multiple ExtendInsights jobs.
Background Upload is useful when:
Uploading thousands of records or lines
Processing large transactions, such as a 5,000-line sales order or 10,000-line journal entry
Running multiple ExtendInsights jobs at the same time
With Background Upload, you can:
Continue working in Excel while the upload runs
Close Excel without interrupting the upload
Review the upload status when you reopen the workbook
➡️ Learn more about Real-time and Background Upload
✅ Tip 8: Review NetSuite Scripts and Workflows
NetSuite scripts and workflows can affect upload performance.
Some workflows are designed to run only in the NetSuite user interface. If they also run in the SOAP Web Services context, they may execute for every record processed through ExtendInsights. This can slow down large uploads.
Work with your NetSuite administrator or developer to:
Identify scripts and workflows triggered during web services operations.
Determine whether they need to run for records processed through ExtendInsights.
Exclude the SOAP Web Services execution context when appropriate.
Test changes before applying them to production processes.💡 Best practice:
Work with your NetSuite Admin or developer to determine whether workflows or scripts can exclude SOAP Web Services execution when appropriate.
✅ Tip 9: Track NetSuite Usage Metrics
You can track ExtendInsights activity in NetSuite by creating saved searches that report on:
Number of records created
Number of records updated
Number of records deleted
These metrics help measure adoption and audit data changes.
Key Takeaways
Following these practices can help your team:
Improve upload performance
Reduce data and permission errors
Create consistent, reusable templates
Validate changes before processing large datasets
Manage bulk data operations more reliably
Monitor ExtendInsights usage
Need Help?
If you have questions about templates, permissions, or performance:
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com
📎 Screenshots and template examples are always helpful when contacting Support.