# LCBO Scraper — Products, Prices, Sales Ranks & Store Stock (`yugenox/lcbo-products-scraper`) Actor

Scrape the full LCBO (Ontario) catalogue: prices, sales and promos, Aeroplan offers, monthly and yearly sales ranks, UPC, ABV, taste profile, ratings, online stock, and quantity on hand at any LCBO store. Search, category, whole-store and per-product store availability modes. No login.

- **URL**: https://apify.com/yugenox/lcbo-products-scraper.md
- **Developed by:** [Yugenox Corp](https://apify.com/yugenox) (community)
- **Categories:** E-commerce, Automation, Integrations
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $1.50 / 1,000 products

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

## LCBO Scraper: Products, Prices, Sales Ranks & Store Stock

Get product data from the **LCBO** (Liquor Control Board of Ontario) as clean JSON, CSV or Excel. You can search it, pull whole categories or the **entire catalogue (about 21,000 products, in under two minutes)**, and see **how many units each LCBO store has on hand**.

It covers what the lcbo.com product pages show plus data you won't find elsewhere:

- **Monthly and yearly sales ranks, and page-view ranks.** These show what actually sells in Ontario.
- **Per-store quantity on hand** for any of the ~680 LCBO stores, either for every product in a store at once or for every store carrying a product.
- **Current price, regular price, sale price and savings.** Clearance and "On Sale" flags, Aeroplan bonus points with offer dates, and case prices.
- **UPC barcode, ABV, container and pack size, volume, sugar (g/L), VQA and kosher flags.** Wine also gets **varietal, region/sub-region and a taste profile** (sweetness, body, flavour intensity, acidity, tannins).
- **Ratings and review counts, online stock, and the date each product was listed.** Also the category path, Vintages and other program tags, and collections.

No account or login needed.

### What you can do with it

| Mode | You give | You get |
|---|---|---|
| **Products** | Search terms, categories, SKUs, or nothing (full catalogue) | One row per product |
| **Store inventory** | Store numbers (plus optional search terms, categories or SKUs) | One row per product per store, with **quantity on hand** |
| **Product availability** | SKUs | One row per store carrying the product: store name, address, city, phone, quantity |

Filters work in every mode: price range, on sale only, countries, categories. Sort options: best-selling this month or year, most viewed, price, newest, top rated, most reviewed, relevance.

### Use cases

- **Wine agents, importers and brand managers**: track your products' sales rank against competitors, find out which stores carry you and how deep their stock is, and watch new listings in your category.
- **Price and deal trackers**: take daily snapshots of every price, sale, clearance item and Aeroplan offer across the whole catalogue.
- **Bars, restaurants and retailers**: find which nearby stores have a product in stock and how many units they hold.
- **Market research**: see what sells in Ontario by category, country, price band or ABV.
- **Apps and marketplaces**: build a product database with UPCs, images, descriptions and taste profiles.

### Input examples

**Search** (the prefilled example, done in seconds):

```json
{ "searchTerms": ["vodka", "pinot noir"], "maxItemsPerSearch": 25 }
```

**Top 500 best-selling red wines under $20:**

```json
{ "categories": ["Red Wine"], "maxPrice": 20, "sortBy": "bestSelling", "maxItems": 500 }
```

**The entire catalogue** (about 21,000 products). Leave everything empty and set no limit:

```json
{}
```

**Everything on sale right now:**

```json
{ "onSaleOnly": true }
```

**Everything in stock at two stores, with quantities:**

```json
{ "mode": "storeInventory", "storeIds": ["388", "https://www.lcbo.com/en/stores/king-west-victoria-43"] }
```

**Which stores have these products, and how many units:**

```json
{ "mode": "productAvailability", "skus": ["521963", "https://www.lcbo.com/en/bask-pinot-noir-16779"] }
```

#### Categories

Use names as they appear on lcbo.com, for example `Wine`, `Red Wine`, `Spirits > Whisky`, `Beer`, `Cider`, `Ready to Drink`, `Non-Alcoholic`. Collections work too: `Vintages`, `Promotions > Clearance`. If a name isn't recognised, the run log suggests the closest matches.

#### Store numbers

A store's number is at the end of its page URL on lcbo.com, e.g. `https://www.lcbo.com/en/stores/robertson-stafford-388` is store **388**. You can paste the URL directly.

### Output

#### Product row

```json
{
  "sku": "16779",
  "name": "Bask Pinot Noir",
  "brand": "Bask",
  "url": "https://www.lcbo.com/en/bask-pinot-noir-16779",
  "imageUrl": "https://aem.lcbo.com/content/dam/lcbo/products/0/1/6/7/016779.jpg.thumb.319.319.png",
  "price": 13.95,
  "regularPrice": 13.95,
  "promoPrice": null,
  "onSale": false,
  "savings": null,
  "currentOffers": [],
  "aeroplanBonusPoints": null,
  "casePrice": 167.4,
  "primaryCategory": "Wine",
  "category": "Red Wine",
  "categoryPath": "Wine > Red Wine",
  "collections": ["Collections > Low Sugar Wines", "Collections > Shop Red Wines by Price > Under $15"],
  "programs": [],
  "size": "750",
  "unitVolumeMl": 750,
  "totalVolumeMl": 750,
  "unitsPerPack": 1,
  "unitsPerCase": 12,
  "container": "bottle",
  "abv": 13,
  "country": "Canada",
  "region": "Ontario",
  "subregion": null,
  "varietal": "Pinot Noir",
  "isVqa": false,
  "isKosher": false,
  "sugarGramsPerLitre": 3,
  "tasteProfile": { "sweetness": 1, "body": 3, "flavourIntensity": 3, "acidity": 3, "tannins": 2 },
  "upc": "063657042045",
  "rating": 3.5,
  "reviewCount": 39,
  "sellRankMonthly": 338,
  "sellRankYearly": 399,
  "viewRankMonthly": 1436,
  "viewRankYearly": 2582,
  "onlineInventory": 12,
  "buyableOnline": true,
  "listedAt": "2022-01-19T19:51:40.000Z",
  "description": "This dry and soft-textured pinot is low in sugar and loaded with dark berries…",
  "tastingKeywords": ["grilled salmon", "dark berries", "spice aromas"],
  "searchTerm": "pinot noir",
  "language": "en",
  "scrapedAt": "2026-09-24T02:48:58.390Z"
}
```

**Store inventory** rows are the same, plus `storeId`, `storeQuantity`, `inStockAtStore` and `lowStockAtStore`.

**Product availability** rows look like this:

```json
{
  "sku": "521963",
  "productName": "Chopin Potato Vodka",
  "price": 53.15,
  "size": "750 ml bottle",
  "storeId": "388",
  "storeName": "Robertson & Stafford",
  "city": "Ottawa",
  "address": "1811 Robertson Road",
  "phone": "(613) 828-5714",
  "quantity": 28,
  "storeUrl": "https://www.lcbo.com/en/stores/robertson-stafford-388",
  "storesWithStock": 214,
  "totalUnitsInStores": 2540
}
```

### FAQ

**How fast is it?** A search of a few dozen products finishes in a few seconds. The full catalogue (about 21,000 products) takes about 1–2 minutes, and a whole store's inventory takes seconds.

**What do the sales ranks mean?** `sellRankMonthly` = 1 is the best-selling product at the LCBO this month. Lower is better. Products with no recent sales have no rank (`null`).

**Is `price` the sale price?** Yes. `price` is what you pay today. `regularPrice` is the usual price. `promoPrice`, `onSale` and `savings` are set when a reduction is running.

**Are the sort orders exact for very large result sets?** Up to 5,000 results per search follow the sort you choose. Anything beyond that is still returned in full, in price order.

**Store quantities: how fresh are they?** They are the same numbers lcbo.com shows on its store availability pages at the time of the run.

**French?** Set `language` to `fr` to get French names, descriptions and categories.

**Can I schedule it?** Yes. Use an Apify schedule for daily price, promo or stock snapshots, and compare runs to track changes.

**Something missing or wrong?** Open an issue on the Issues tab with the input you used, and it will be looked at quickly.

**Is it legal to scrape LCBO?** This Actor only collects publicly available data: product listings, prices, sales ranks, product descriptions, stock levels and LCBO store addresses and phone numbers that LCBO's website serves to any visitor without an account. Collecting publicly available data is generally legal, but you're responsible for how you use it. Product descriptions can include the names of wine critics whose reviews LCBO quotes, and that counts as personal data. You must follow privacy laws such as GDPR, PIPEDA and CCPA, as well as LCBO's terms. If you're unsure, check with a lawyer. More on this: [Is web scraping legal?](https://blog.apify.com/is-web-scraping-legal/)

**Does it access any private data?** No. Everything comes from LCBO's public website, the same product and store data lcbo.com loads for any visitor without logging in. It never uses a login, never touches private or restricted accounts, and never reaches password-protected areas.

# Actor input Schema

## `mode` (type: `string`):

Products: one row per product (search terms, categories, SKUs, or the whole catalogue when all are empty). Store inventory: one row per product per store, with the quantity on hand at each store in "Store IDs". Product availability: for each SKU, every LCBO store that has it, with address, phone and quantity.

## `searchTerms` (type: `array`):

Keywords, searched the same way as the lcbo.com search box, each as its own search. Leave empty (with no SKUs) to scrape everything that matches your categories and filters, or the entire catalogue.

## `categories` (type: `array`):

Limit to categories, e.g. "Wine", "Red Wine", "Spirits > Whisky", "Beer", "Ready to Drink", or collections like "Vintages" and "Promotions > Clearance". Several categories are combined (any of them). Unknown names are reported with suggestions.

## `skus` (type: `array`):

LCBO item numbers (e.g. 521963) or product page URLs. Products mode: returns these products. Store inventory mode: only these products at your stores. Product availability mode: required — one row per store carrying each SKU.

## `storeIds` (type: `array`):

Required for Store inventory mode. The LCBO store number (e.g. 388) or the store page URL (https://www.lcbo.com/en/stores/robertson-stafford-388). Each store is scraped separately.

## `inStockOnly` (type: `boolean`):

Store inventory mode: only return products with at least one unit on hand. Turn off to also get products the store carries but has sold out of (quantity 0).

## `minPrice` (type: `integer`):

Only products at or above this price (current price, in dollars).

## `maxPrice` (type: `integer`):

Only products at or below this price (current price, in dollars).

## `onSaleOnly` (type: `boolean`):

Only products with a reduced price right now (sales and clearance).

## `countries` (type: `array`):

Only products made in these countries, e.g. "France", "Italy", "Canada".

## `sortBy` (type: `string`):

Order of results. Auto = most relevant for search terms, best-selling otherwise. Up to 5,000 results per search follow this order; beyond that, results continue in price order.

## `maxItems` (type: `integer`):

Maximum rows for the whole run. Leave empty for no limit (the full catalogue is about 21,000 products).

## `maxItemsPerSearch` (type: `integer`):

Cap for each search term, category crawl or store. Leave empty for no limit.

## `language` (type: `string`):

Language of names, descriptions and categories (English or French). With French, write categories in French too (e.g. "Vin rouge").

## `includeDescription` (type: `boolean`):

Add the tasting note / product description and its keywords to each product.

## `maxConcurrency` (type: `integer`):

Parallel requests. The default is fast (the full catalogue takes about 1–2 minutes); raising it rarely helps.

## `proxyConfiguration` (type: `object`):

Apify Proxy is required. Datacenter proxies are used by default; residential (Canada) is used automatically where needed.

## Actor input object example

```json
{
  "mode": "products",
  "searchTerms": [
    "vodka",
    "pinot noir"
  ],
  "inStockOnly": true,
  "onSaleOnly": false,
  "sortBy": "auto",
  "maxItems": 50,
  "maxItemsPerSearch": 25,
  "language": "en",
  "includeDescription": true,
  "maxConcurrency": 3,
  "proxyConfiguration": {
    "useApifyProxy": true
  }
}
```

# Actor output Schema

## `results` (type: `string`):

All scraped rows.

## `run` (type: `string`):

Status and statistics for this run.

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "searchTerms": [
        "vodka",
        "pinot noir"
    ],
    "maxItems": 50,
    "maxItemsPerSearch": 25,
    "proxyConfiguration": {
        "useApifyProxy": true
    }
};

// Run the Actor and wait for it to finish
const run = await client.actor("yugenox/lcbo-products-scraper").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "searchTerms": [
        "vodka",
        "pinot noir",
    ],
    "maxItems": 50,
    "maxItemsPerSearch": 25,
    "proxyConfiguration": { "useApifyProxy": True },
}

# Run the Actor and wait for it to finish
run = client.actor("yugenox/lcbo-products-scraper").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "searchTerms": [
    "vodka",
    "pinot noir"
  ],
  "maxItems": 50,
  "maxItemsPerSearch": 25,
  "proxyConfiguration": {
    "useApifyProxy": true
  }
}' |
apify call yugenox/lcbo-products-scraper --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,yugenox/lcbo-products-scraper"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/xWYM3WotIUFna1Wct/builds/7lYmJCoegG2HETBBF/openapi.json