Working with the Pricing Sublist on Item Records
You can create, update, and access pricing sublist (pricing matrix) data through REST web services.
The pricing sublist is available on item records, on the Sales/Pricing subtab.
The pricing sublist is supported if the following features are enabled:
-
Multiple Currencies
-
Multiple Prices
-
Quantity Pricing
For each item, you can set multiple prices based on the following:
-
Currency used for item prices. See Enabling the Multiple Currencies Feature.
-
Price levels available for the item, as defined in the price level user-defined list. See Using Multiple Pricing.
-
The quantity of items being sold, when the Quantity Pricing feature is enabled. See Using Quantity Pricing.
For general information about item pricing, see the following help topics:
In REST web services, you can create or update price values on a per-row, per-column basis by using the POST operation. You can access the price values on a per-row, per-column basis by using the GET operation.
To create or update a pricing sublist, you send a POST request similar to the following and specify the pricing sublist data in the request body in an array of items:
POST https://demo123.suitetalk.api.netsuite.com/services/rest/record/v1/inventoryitem
"price": {
"items": [
{
"currencyPage" : { "id" : "1" },
"priceLevel" : { "id" : "1" },
"quantity" : { "value" : 5 },
"price": 25.5
},
...
]
}
To access a pricing sublist, you send a GET request similar to the following:
GET https://demo123.suitetalk.api.netsuite.com/services/rest/record/v1/inventoryitem/482/price?expandSubResources=true
Related Topics
- The REST API Browser
- NetSuite Record Structure
- Using CRUD Operations on Custom Records, Custom Lists, and Custom Transactions v1
- Creating a Record Instance
- Getting a Record Instance
- Updating a Record Instance
- Using the Upsert Operation
- Deleting a Record Instance
- Accessing Subresources in REST Web Services
- Using External IDs
- Using Datetime Fields
- Executing Record Actions
- Transforming Records
- Using the REST Web Services SuiteScript Execution Context