SuiteAnswer ID: 10915
Access Level: Administrator, System Integrator
Overview
This article explains NetSuite’s CSV import capabilities, including file limitations, field formatting rules, and workarounds for importing attachments. Use this guide to:
✔ Avoid common import failures
✔ Structure files correctly for transactions/records
✔ Implement solutions for advanced needs (e.g., attachments)
1. File Size & Row Limits
Hard Limits
Import Type Max File Size Max Rows
Standard CSV Import 50 MB 100,000
SuiteScript API Calls 10 MB Varies
Notes:
- Larger files require chunking (split into multiple files).
- For >100K rows, use SuiteScript or SOAP API.
Performance Tips
- Compress files (ZIP) to reduce size.
- Disable “Validate Only” mode for faster imports.
2. Required Field Formats
Key Formatting Rules
Record Type Critical Fields Format Example
Customers entityid, subsidiary ABC_Corp (text)
Items itemid, type NV-100 (text)
Transactions tranid, trandate SO-1001, 03/25/2025
Common Pitfalls:
❌ Date Fields: Must match company format (MM/DD/YYYY or DD/MM/YYYY).
❌ Numbers: Avoid commas (e.g., 1000.00 vs. 1,000.00).
3. Troubleshooting Failed Imports
Error Solution
“Invalid field value” Check dropdown options (e.g., itemtype).
“Row limit exceeded” Split file into smaller chunks.
“Duplicate external ID” Use update mode instead of create
Debugging Tools:
- Download error logs after import.
- Use “Validate Only” mode to test before full import.
4. Best Practices
- Backup Data: Test imports in Sandbox first.
- Use Templates: Download NetSuite’s predefined CSV templates.
- Map Internal IDs: For custom fields, use custitem_xyz format.
FAQ
Q: Can I import multi-select fields?
A: Yes—use pipe separators (e.g., Value1|Value2).
Q: Why does my date field fail?
A: Match the format under Setup > Company > General Preferences.
Q: How to import >50MB files?
A: Use SuiteScript or third-party ETL tools like Celigo.
Conclusion
Understanding these limitations prevents 90% of import failures. For complex needs (attachments/large files), leverage SuiteScript or partner solutions.