Search

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 nameDescriptionPossible valueRequired
productIDInteger yes
productIDsMultiple product IDs, separated by commas, such as: 1,2,3,4,5String
activeSpecify 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
changedSinceGet only prices that have been added or modified since the specified timestamp.Integer (Unix timestamp)
langRetrieve 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 nameTypeDescription
productIDIntegerProduct ID.
pricelistIDIntegerPrice list ID.
pricelistNameStringPrice list name.
priceDecimalNet sales price
amountIntegerAvailable only if Quantity discounts module has been enabled on your account. The quantity threshold from which the specified price will apply.