ProductPrices
This returns the selling prices of your products. A price is returned for each price band associated with a product. A price band is simply a price list. The price a customer receives for a product depends on the price band their account is linked to. The 'Standard' price band is the default. The prices returned here do not include any customer specific discounts. The default sort (orderby) field is by 'product_code' ascending.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM ProductPriceViews WHERE ProductPriceId = 34760 SELECT * FROM ProductPriceViews WHERE ProductId = 34751 SELECT * FROM ProductPriceViews WHERE ProductCode = 'BOARD001' SELECT * FROM ProductPriceViews WHERE ProductName = 'Whiteboard - Drywipe (900 x 1200)' SELECT * FROM ProductPriceViews WHERE ProductStockUnitName = 'Each' SELECT * FROM ProductPriceViews WHERE PriceBandId = 1064 SELECT * FROM ProductPriceViews WHERE PriceBandName = 'Standard' SELECT * FROM ProductPriceViews WHERE ProductPriceUseStandard = true SELECT * FROM ProductPriceViews WHERE ProductPricePrice = 20 SELECT * FROM ProductPriceViews WHERE CurrencyId = 2103 SELECT * FROM ProductPriceViews WHERE CurrencyName = 'Pound Sterling' SELECT * FROM ProductPriceViews WHERE CurrencySymbol = '£' SELECT * FROM ProductPriceViews WHERE DateTimeUpdated = '2018-02-28T15:23:46.787+01:00'
Columns
| Name | Type | References | Description |
| ProductPriceId | Long | Product price record Id. | |
| ProductId | Long | Product record Id. See products | |
| ProductCode [KEY] | String | Product code. | |
| ProductName | String | Product name. | |
| ProductStockUnitName | String | The name of the unit the product is sold in. For example box, crate, bottle. The default unit is each. | |
| PriceBandId | Long | Price band record Id. | |
| PriceBandName | String | The name of the price band. | |
| ProductPriceUseStandard | Bool | 'True' if uses the price from the standard price band is used otherwise 'False' The price of a product can be linked to the price set in the standard price band. This is used when only some product prices are different to the standard price. | |
| ProductPricePrice | Decimal | The selling price for the shown product and price band. | |
| CurrencyId | Long | Currency record Id. See currencies | |
| CurrencyName | String | The name of the currency used for the price. | |
| CurrencySymbol | String | The symbol of the currency used for the price. | |
| DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |