getProductPricesInPriceLists

Retrieve a product's net sales price in price lists.

This API call does not use result paging; all results are returned.

You can query prices for a single product (by supplying parameter productID) or multiple products at a time (by supplying parameter productIDs).

Note that price lists can cumulate or override each other (price lists can apply to locations, as well as customers and customer groups), and price lists can also specify discount percentages for certain product groups. Therefore this API call does not help you to find the current appropriate sales price for an item. For that purpose, use calculateShoppingCart. If you only need to apply price lists, not promotions, you may also use getProductPrices.

API call getProducts can also provide a list price for a specific customer and location, along with other product information.

To retrieve price lists together with all their contents, see getPriceLists.

Input parameters

Parameter name Description Possible value Required
priceListProductID integer
productID integer
productIDs Multiple product IDs, separated by commas, such as: 1,2,3,4,5 string
active Specify active = 0 to retrieve net sales prices in all price lists. Specify active = 1 to retrieve net sales prices in active price lists. By default 1. 0 or 1
changedSince Get only prices that have been added or modified since the specified timestamp. Integer (Unix timestamp)
lang Retrieve item names in a specific language. If omitted, API will return item names in the default language of your Erply account.
Possible values:
  • 'eng' - English
  • 'spa' - Spanish
  • 'ger' - German
  • 'swe' - Swedish
  • 'fin' - Finnish
  • 'rus' - Russian
  • 'est' - Estonian
  • 'lat' - Latvian
  • 'lit' - Lithuanian
  • 'gre' - Greek
 string

Response

Field name Type Description
priceListProductID integer Price list row ID.
productID integer Product ID.
pricelistID integer Price list ID.
pricelistName string Price list name.
price number Net sales price
amount integer Available only if Quantity discounts module has been enabled on your account. The quantity threshold from which the specified price will apply.