Item prices or quantity breaks cannot be imported
Check the starting price, price level, and existing matrix before deciding how the pricing should change.
Choose the message that matches your import.
A quantity price break has no starting price
Message looks like
Please Enter Missing Price(s)
What it means
Quantity pricing is being imported without a price for quantity zero, which NetSuite requires before the other quantity breaks.
Import context: Item records.
Check this first
Include the quantity zero price in the same import or load it before the other prices.
Show the steps
Steps for this error
- This appears when quantity pricing is imported without pricing for quantity 0.
- Include the quantity 0 price, either before or in the same import as the other quantity prices.
- Retry one item.
Documentation checked September 16, 2026.
A pricing update introduces a new matrix header
Message looks like
If you are not replacing the entire matrix you may only update existing headers. X is not in the existing matrix
What it means
The import adds quantity pricing that is not in the item's existing matrix headers, and only existing headers can be updated unless the whole matrix is replaced.
Import context: Item records.
Check this first
Compare the imported quantities with the item's existing pricing headers before changing any replacement settings.
Show the steps
Check the price structure
- Establish whether the change is to a price, a quantity break, a price level, or the entire structure.
- Compare the existing item pricing with the proposed rows.
- Keep every price and quantity break that is meant to remain.
- Check the missing-base-price case separately from the new-matrix-header case.
- If the change would replace pricing, ask the account administrator to review the pricing setup and the conflicting Oracle guidance before proceeding.
This is a check of the intended price structure, not an instruction to enable sublist replacement.
If that looks right
Oracle’s error article and general sublist guidance disagree about replacing item pricing. Ask the administrator to verify the relevant pricing setup before replacing the matrix. Read the sublist option guidance.
Documentation checked September 16, 2026.
The price level cannot be matched
Message looks like
Invalid price level reference key XXX
What it means
The price level on the row is not an active, exactly spelled entry in the account's Price Level list.
Import context: Item records.
Check this first
Check the Price Level list under Accounting Lists for the value, including spelling and active state.
Show the steps
Steps for this error
- Check the price level under Setup > Accounting > Accounting Lists with Type set to Price Level: it must be active and spelled exactly as in the file.
- Or map Item Pricing 1 to Price Level on the Field Mapping page and pick the level with the edit icon.
- Retry one item.
If that looks right
Documentation checked September 16, 2026.
Related errors
- NetSuite cannot read the date or posting period
- Event dates or times are missing or invalid
- Numbers or identifiers changed in the CSV
- NetSuite CSV import says an amount is missing
Book a free 30-minute look at your import error
Bring the error and your file to a screen share and I will dig into it live. Thirty minutes is usually enough to find what is wrong and tell you what fixing it takes. Sometimes that settles it on the call; when it does not, you leave with a straight answer instead of a mystery. No cost and no obligation.
An import that keeps failing is often the first visible sign of a larger setup problem. Most of my client work starts exactly here: somebody mid-import, a file that will not load, and nobody on their side to email. If a migration or implementation sits behind this error, that is the work I do every week.