Updating Pricing for Netsuite Items

[vincentnero]

I have been trying to get Flowbuilder to successfully update my items' multi-tier pricing... specifically, the issue comes when trying to update a product that is changing quantity tiers, and it doesn't seem to understand that it needs to null out values/tiers.

Current Item in Netsuite Pricing:

Celigo Mapping that Made the Item Originally and is used to Update Items as well:

Values:
"Min Quantity": "240",
"Price USD": "27.77",
"Qty Break 2 (USD)": "480",
"Qty Break Price 2 (USD)": "33.75",
"Qty Break 3 (USD)": null,
"Qty Break Price 3 (USD)": null,
"Qty Break 4 (USD)": null,
"Qty Break Price 4 (USD)": null,
"Qty Break 5 (USD)": null,
"Qty Break Price 5 (USD)": null,
"Qty Break 6 (USD)": null,
"Qty Break Price 6 (USD)": null,

Error in Flow:
Failed to save record because Please enter missing quantity level(s)

[kevinshah]

Thanks for reaching out, Vincent! As we discussed yesterday, let’s connect during our scheduled call on Monday to dive deeper into the issue and work toward a resolution.

[kevinshah]

Thanks Vincent for meeting today! When we replicated the scenario in NetSuite, we confirmed the error is caused by NetSuite’s default behavior. Quantity-pricing levels fail to save when either the quantity or corresponding price fields aren’t fully cleared during product updates. NetSuite requires both the quantity breaks and their prices to be cleared before it will save the record.

As a resolution, We can either update the integration mappings to explicitly clear all the required fields, or reconsider using the dynamic pricing fields.