ANS-1582 · CSV IMPORT & DATA MIGRATION
Can Customer Credit Card Sublist Data Be Updated via CSV Import in NetSuite?
NetSuite's CSV import functionality for customer records allows for adding new credit card sublist entries but does not support updating existing ones.
Short answer
When importing customer records via CSV in NetSuite, it is crucial to understand that credit card sublist information can only be added as new entries. Existing credit card details cannot be updated through this method. Therefore, ensuring data accuracy and cleanliness prior to any import is essential to prevent duplicate or incorrect records.
Scenario
Users attempting to manage customer credit card information often utilize CSV imports for efficiency. A common challenge arises when trying to modify or update existing credit card details associated with customer records through a CSV import. This limitation can lead to confusion regarding data management capabilities within NetSuite's import tools.
Solution
NetSuite's CSV import functionality for customer records is designed to add new credit card sublist information exclusively. It is important to note that existing credit card details within a customer's sublist cannot be updated through a CSV import. Consequently, users must ensure the accuracy and cleanliness of their data before initiating any import process to avoid creating redundant or erroneous entries.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support