Usually when I upload pricing it looks like this:
Pricing: Item | Unit Price | Price Level | Quantity Range |
|---|
11K760-300 | 1144.44 | 1. Catalogue Price | 0 |
11K760-300 | 1144.44 | 1. Catalogue Price | 1 |
11K760-300 | 1144.44 | 2. Multi Pricing | 1 |
11K760-300 | 1144.44 | 2. Multi Pricing | 0 |
11K760-300 | 824 | Online Price | 0 |
11K760-300 | 824 | Online Price | 1 |
With the quantity range being the integer of the list, not the actual quantity.
On my recent upload, I was having some issue that kept returning:
"If you are not replacing the entire matrix you may only update existing headers. 1 is not in the existing matrix."
It said that the way to get past this error was to check 'overwrite sublist data'.
This might not have been the actual cause, but what's happened is the quantity was treated as an actual value and all of my items instead of being 0-10, 11+ or 1, 2+ are now 0, 1 or 0, 1.
How did this happen?
I've always used 0 and 1 and an integer of the list value, not the quantity of the items. Was there a change to NetSuite or what might have I changed in my upload settings to cause this?
I have an old CSV that contains all of the quantities, so I'm going to reupload that to fix the quantities with the new prices.