...
Parameter (Query Param) | Details | Required | Example | ||
|---|---|---|---|---|---|
response_type | JSON OR XML are permitted, default response is 'JSON'. | Optional | JSON | ||
product_codes | Comma separated value list of product codes, if not provided then all products will be returned.
| Optional | BAROLO,CHABLIS |
Output
Field Name | Type | Length | Unique | Comments |
|---|---|---|---|---|
PUID | AN | 12 | Y | Unique product number |
ProductCode | AN | 20 | Y | Unique Product Code |
EANCase | AN | 18 | EAN Barcode Number - normally numerical only. | |
EANSubCase | AN | 18 | EAN Barcode Number - normally numerical only. | |
ProductDescription | AN | 50 | ||
ProductDescription2 | AN | 50 | This field is no longer being used for documents or any output layouts. | |
Vintage | AN | 4 | Will be either a 4 digit year YYYY or NA or NV | |
SPC | Integer | 6 | Singles per Case | |
SS | Decimal | 8.5 | Single Size in centiliters | |
ABV | Decimal | 3.5 | Stength Strength in % | |
TSinglesAvailable | Int | 12 | The total stock in bottles available to sell. (Available to sell = STOCK - Orders not yet completed (orders held will be included)) | |
TCaseAvailable | Int | 12 | This is the total available singles / Singles per case (rounded down) | |
OptionExclude | Bit | Exclude from Web option | ||
OptionSingles | Bit | Do you sell single bottles of this product | ||
OptionSellZero | Bit | Sell even if no stock (for EP) | ||
OptionRetail | Bit | Is this a Retail Product | ||
AvailableFrom | Date | dd/mm/yy When this product is available from. | ||
Product_CaseDP | Decimal | 8.5 | Product Sales Price Duty Paid for a Case | |
Product_SingleDP | Decimal | 8.5 | Product Sales Price Duty Paid for a Bottle | |
Producer | ||||
Producer_Name | ||||
COO | AN | 6 | ||
COO_Name | ||||
Region | ||||
Region_Name | ||||
Group | ||||
Group_Name | ||||
Style | ||||
Style_Name | ||||
Type | ||||
Type_Name | ||||
ProdAnal6 | ||||
ProdAnal6_Name | ||||
UDF_Prod_Anal1 | ||||
UDF_Prod_Anal1_Name | ||||
UDF_Prod_Anal2 | ||||
UDF_Prod_Anal2_Name | ||||
UDF_Prod_Anal3 | ||||
UDF_Prod_Anal3_Name | ||||
UDF_Prod_Anal4 | ||||
UDF_Prod_Anal4_Name | ||||
UDF_Prod_Anal5 | ||||
UDF_Prod_Anal5_Name | ||||
UDF_Prod_Anal6 | ||||
UDF_Prod_Anal6_Name | ||||
DutyPerSingle | Decimal | 8.5 | The duty amount per single bottle. | |
Weight | Decimal | 8.5 | GrossWeight per case | |
Product_CaseUB | Decimal | 8.5 | Product Sales Price Under Bond for a Case | |
Product_SingleUB | Decimal | 8.5 | Product Sales Price Under Bond for a Bottle |
...