ANS-1182 · INVENTORY & ITEM MANAGEMENT
Updating NetSuite Item Quantity Pricing: CSV Import Best Practices
Learn the critical considerations for structuring your CSV file when modifying item quantity pricing in NetSuite, including important import settings.
Short answer
When updating NetSuite item quantity pricing via CSV import, avoid using 'Overwrite Sublists' as it can cause errors. Instead, focus on correctly structuring your import file. For single-file imports, all price levels for an item are typically on one line. However, for quantity pricing schedules with multiple files, each price level requires its own row.
Scenario
Users often need to adjust existing quantity pricing schedules for items in NetSuite, such as changing the number of quantity tiers or modifying prices for specific levels. The challenge lies in performing these updates efficiently and accurately using CSV imports, especially when dealing with multiple price levels and ensuring data integrity.
Solution
When updating item quantity pricing in NetSuite via CSV import, it is crucial to understand the correct approach to avoid data corruption.
Important Note on Import Settings:
NetSuite documentation explicitly advises against enabling 'Overwrite Sublists' for item pricing imports, as this setting can lead to errors.
CSV File Structure for Price Levels:
Careful attention to the CSV file structure is required, especially when managing multiple price levels.
For single-file imports, all price levels for an item typically need to be on the same .csv line.
However, for imports involving quantity pricing schedules with multiple files, a separate row is required for each price level.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support