search_products
Search and filter Finland's Alko alcohol catalog by name, type, country, price, alcohol percentage, and other attributes to find specific products.
Instructions
Search Finnish Alko alcohol catalog (~12,000 products). Filter by name, type, country, price, alcohol%. Returns: id, name, price, type, country, alcohol%, producer.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | Text search query for product name, producer, or description | |
| type | No | Product type (e.g., "punaviinit", "oluet", "viskit") | |
| country | No | Country of origin (e.g., "Ranska", "Italia", "Suomi") | |
| region | No | Region within country (e.g., "Bordeaux", "Toscana") | |
| minPrice | No | Minimum price in EUR | |
| maxPrice | No | Maximum price in EUR | |
| minAlcohol | No | Minimum alcohol percentage | |
| maxAlcohol | No | Maximum alcohol percentage | |
| assortment | No | Assortment type: vakiovalikoima (in stores), tilausvalikoima (order only) | |
| specialGroup | No | Special group (e.g., "Luomu", "Vegaaneille soveltuva tuote") | |
| beerType | No | Beer type for beer products (e.g., "ipa", "lager", "stout & porter") | |
| isNew | No | Filter for new products only | |
| isOrganic | No | Filter for organic products only | |
| isVegan | No | Filter for vegan-suitable products only | |
| minSmokiness | No | Minimum smokiness level (0-4, for whiskeys: 0=ei savuinen, 4=voimakkaan savuinen) | |
| maxSmokiness | No | Maximum smokiness level (0-4, for whiskeys: 0=ei savuinen, 4=voimakkaan savuinen) | |
| sortBy | No | Field to sort by | name |
| sortOrder | No | Sort order | asc |
| limit | No | Maximum number of results to return | |
| offset | No | Number of results to skip for pagination |