)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
NetSuite’s native bulk update methods often overwrite or clear custom field data when updating item prices, especially with CSV imports that don’t include all custom fields.
Here’s how to preserve your valuable custom field data while making bulk price changes safely.
Maintain custom field integrity with comprehensive field access using Coefficient
Coefficient provides comprehensive custom field support that preserves existing data during bulk price updates. You get complete visibility into all custom fields and precise control over which fields to modify, leaving other custom data untouched.
How to make it work
Step 1. Import items with all custom fields visible.
Use Records & Lists import method to pull in your NetSuite item records with all custom fields displayed. This shows you exactly what custom field data exists and ensures you don’t accidentally overwrite fields you can’t see in standard bulk edit interfaces.
Step 2. Use field selection to control exactly what gets updated.
Choose exactly which fields to import and modify, leaving other custom fields untouched. The field selection control lets you focus on price-related fields while maintaining all your custom field data that took time and effort to populate.
Step 3. Validate custom field relationships before making changes.
Use SuiteQL Query to validate custom field relationships before and after bulk updates. This ensures that complex custom field dependencies remain intact when you modify pricing data in NetSuite .
Step 4. Preview changes to confirm custom field preservation.
Use the data preview feature to confirm that custom field data remains intact during price modifications. The real-time API connection validates custom field data types and required field constraints before committing changes.
Update prices without losing valuable data
This approach ensures custom field data integrity during bulk price updates, unlike NetSuite’s native methods that risk overwriting custom field values not explicitly included in the bulk operation. Your custom data stays safe while prices get updated efficiently. Protect your custom field data today.
