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
productID    Integer  yes  
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
productID  Integer  Product ID.  
pricelistID  Integer  Price list ID.  
pricelistName  String  Price list name.  
price  Decimal  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.