Is it possible to update more than one record at a time with a netsuite import? I am currently getting an error that my import is failing because more than one match is found, however I want to update all of the matches with this import. I can’t seem to find a config in the setup to allow this.
A mapping error occurred. More than one match for "["custrecord_pkg_track_number","is","410009699"]" for the record type "customrecord_package_tracking".
Hi Eric, NetSuite imports in Celigo integrator.io are designed to update a single record that matches your specified criteria in the “How can we find existing records?” field. If multiple records are matched, only the first record found is updated, additional matches are ignored. This behavior is standard for NetSuite imports.
If your use case requires updating multiple records at once, we recommend modifying your flow logic so that each update action targets a uniquely identifiable record, or redesigning the export step to iterate over each intended record separately.
Another option as well is if this is a one-time data correction scenario, it may be cleaner to use a NetSuite Mass Update (Outside Celigo)
Build a Saved Search
Use NetSuite Mass Update or a small SuiteScript
You’d need to do a lookup step before the import that gets all IDs for the records you want for that record. Map the array of results back. Then, on your import, use a one-to-many pointing to the array of IDs.
