Merchanter API v1.1 - Product Prices
Discover how to access and manage product pricing using the Merchanter API v1.1 for efficient inventory control.
Written by Ian Oldrey
Updated at June 18th, 2026
-
/ProductPrices – Retrieve pricing information for products under the current user account’s ledger
-
Parameters
- HTTP header type
-
Parameters
-
If-Modified-Since – a UTC timestamp (format ‘yyyy-MM-dd HH:mm:ss’). Only products that have been created or modified since this timestamp will be returned
- Query type
-
Where – a filter expression string with ANDed filters. Available filters are
- IsSpecial – is the product a special? true/false
- SellOnline – is this an ecommerce product? true/false
E.g. Where=IsSpecial==false&&SellOnline==true
-
page – page number. Up to 100 products will be returned per call when the page parameter is used e.g. page=1.
- Response schema & body (JSON)
| Attribute Name | Data Type | Max Length | Notes | Response Body (JSON) |
| Code | String | 20 | Product code |
[ { "Code": "", "BasePrice": 0.00, "VATRate": 0.00, "ProductPrices": [ { "PriceBandCode": "", "Price": 0.00 } ] } ]
|
| BasePrice | Decimal | Base selling price (per stock unit of measure) | ||
| VATRate | Decimal | VAT rate percentage | ||
| ProductPrices (array) | ||||
| - PriceBandCode | String | 2 | Price band code | |
| - Price | Decimal | Nett price (per stock unit of measure) for price band |