LCBO Product Search Scraper: Extract Wine & Alcohol Data Instantly

---

What Is LCBO.com?

LCBO.com is the official e-commerce platform of the Liquor Control Board of Ontario, Canada's largest alcohol retailer. It hosts thousands of wine, spirits, beer, and cider products with detailed product pages, real-time inventory data, and customer ratings. Manually searching and collecting product information across price ranges, alcohol content, ratings, and regional availability is time-intensive — the LCBO Product Search Scraper automates this, delivering structured, searchable product datasets instantly.

---

Overview

The LCBO Product Search Scraper extracts comprehensive product data from LCBO search results and detail pages, supporting two flexible input modes:

1. URL-based scraping — Paste pre-built search URLs directly
2. Filter-based search — Define product criteria and let the scraper build the query

The scraper is ideal for:

• Wine retailers & sommeliers tracking product availability and pricing
• Market researchers analyzing alcohol product trends and pricing strategies
• Data analysts building alcohol industry datasets
• E-commerce teams aggregating competitor product catalogs
• Inventory managers monitoring stock levels across Ontario stores

Key features include dual input modes, configurable filters (price, rating, alcohol %, sugar content), and access to 80+ product fields including wine-specific attributes.

---

Input Format

The scraper accepts configuration via two independent modes:

Mode 1: URL-Based Scraping

{
  "urls": [
    "https://www.lcbo.com/en/products/wine/red-wine#t=clp-products-wine-red_wine&sort=relevancy&layout=card",
    "https://www.lcbo.com/en/catalogsearch/result/#q=red&t=Products&sort=relevancy&layout=card&f:@lcbo_current_offer=[On%20Sale]&f:@ec_rating=[4..4.9inc]&f:ec_price:range=[5,50]"
  ],
  "max_items_per_url": 200,
  "ignore_url_failures": true
}

Field	Description
urls	Direct links to LCBO product search or category pages with pre-built filters
max_items_per_url	Maximum products collected per URL (e.g., 200)
ignore_url_failures	If true, skips failed URLs instead of halting the run

Mode 2: Search Filter-Based

{
  "keyword": "red",
  "sort_by": "relevancy",
  "on_sale": true,
  "price_range": "5-50",
  "rating": "4",
  "size": "",
  "alcoholic": "7-30",
  "sugar": "5-30",
  "max_items_per_url": 100
}

Field	Description	Example
keyword	Product name or type to search	red, malbec, pinot noir
sort_by	Sort order for results	relevancy, @ec_final_price ascending, @ec_rating descending
on_sale	Include only discounted items	true or false
price_range	Price filter in CAD (format: min-max)	5-50, 10-200
rating	Minimum customer rating filter	1, 2, 3, 4, 5
size	Bottle volume filter in mL (min-max)	750-1000
alcoholic	Alcohol content % (min-max)	7-30, 12-15
sugar	Sugar content per liter (min-max)	5-30

Tip: Use Mode 1 (URLs) for complex, multi-filter searches; use Mode 2 (search filters) for simple, repeatable queries.

---

Output Format

Sample output

{
  "view_rank_monthly": 606,
  "systitle": "Julia Florista Red ",
  "lcbo_region_name": "Other",
  "created_at": 1642640672000,
  "is_buyable": "true",
  "sysurihash": "evMC2safpeZGdRaw",
  "urihash": "evMC2safpeZGdRaw",
  "sysuri": "https://www.lcbo.com/en/julia-florista-red-532358",
  "lcbo_stock_type": "1",
  "commontabs": "Products",
  "lcbo_vqa_code": "false",
  "systransactionid": 619801,
  "ec_rating": 4.4,
  "ec_final_price": 11.0,
  "stores_low_stock_combined": "false",
  "min_cart_qty": 1,
  "ec_skus": [
    "532358"
  ],
  "cp_add_to_cart_deny": [
    "allow"
  ],
  "sysconcepts": "easy-drinking charmer ; blood orange ; highlighting vanilla ; famed flower ; variety of dishes ; beef ; burgers ; nuts",
  "sell_rank_yearly": 730,
  "concepts": "easy-drinking charmer ; blood orange ; highlighting vanilla ; famed flower ; variety of dishes ; beef ; burgers ; nuts",
  "sysindexeddate": 1789384588000,
  "out_of_stock_threshold": 0,
  "permanentid": "532358",
  "lcbo_bintag_wine_acidity": 3,
  "syslanguage": [
    "English"
  ],
  "transactionid": 619801,
  "title": "Julia Florista Red ",
  "date": 1789384588000,
  "objecttype": "Product",
  "stores_stock": "true",
  "cp_browsing_category_deny": [
    "allow"
  ],
  "view_rank_yearly": 369,
  "low_stock_threshold": 12,
  "lcbo_program": null,
  "country_of_manufacture": "Portugal",
  "upc_number": "5601996273895",
  "loyalty_points": 0,
  "lcbo_kosher": "false",
  "online_inventory": 43,
  "rowid": 1789384588053705437,
  "stores_stock_combined": "true",
  "ec_visibility": 4,
  "ec_shortdesc": "Named after the famed flower girl of Fado, this red is an elegant rendition highlighting vanilla, bright red plum, nuts and hint of blood orange. Truly a soft and easy-drinking charmer that is ideal for a variety of dishes from burgers to rare beef.",
  "size": 5415,
  "ec_name": "Julia Florista Red",
  "lcbo_bintag_wine_sweetness": 2,
  "clickableuri": "https://www.lcbo.com/en/julia-florista-red-532358",
  "avg_reviews": 30,
  "syssource": "ProductsEN",
  "orderingid": 1789384526208,
  "lcbo_bintag_wine_body": 3,
  "syssize": 5415,
  "sysdate": 1789384588000,
  "lcbo_alcohol_percent": 13.0,
  "ec_thumbnails": "https://aem.lcbo.com/content/dam/lcbo/products/5/3/2/3/532358.jpg.thumb.319.319.png",
  "stores_low_stock": "false",
  "lcbo_bottles_per_pack": 1,
  "out_of_stock": "false",
  "lcbo_unit_volume": "750",
  "lcbo_tastingnotes": "Named after the famed flower girl of Fado, this red is an elegant rendition highlighting vanilla, bright red plum, nuts and hint of blood orange. Truly a soft and easy-drinking charmer that is ideal for a variety of dishes from burgers to rare beef.",
  "lcbo_bintag_wine_flavor_intensity": 3,
  "primaryid": "MV3E2QZSONQWM4DFLJDWIUTBO4XDMNRQGEXGIZLGMF2WY5A",
  "lcbo_selling_package_name": "bottle",
  "enabled": "true",
  "wordcount": 39,
  "ec_category": [
    "Promotions",
    "Collections",
    "Promotions|Top 200",
    "Collections|Top Picks",
    "Collections|Great Wines",
    "Collections|Wines of Portugal",
    "Collections|Red Wines on Bonus",
    "Collections|Top Picks|Red Wine",
    "Collections|Red Wine Best Sellers",
    "Collections|Value Wines under $15",
    "Collections|Shop Red Wines by Price",
    "Collections|Shop Red Wines by Price|Under $15",
    "Products",
    "Products|Wine",
    "Products|Wine|Red Wine"
  ],
  "source": "ProductsEN",
  "ec_price": 11.0,
  "ec_category_filter": [
    "Products|Wine|Red Wine"
  ],
  "sell_rank_monthly": 491,
  "ec_description": "Named after the famed flower girl of Fado, this red is an elegant rendition highlighting vanilla, bright red plum, nuts and hint of blood orange. Truly a soft and easy-drinking charmer that is ideal for a variety of dishes from burgers to rare beef.",
  "cp_display_product_prices_deny": [
    "allow"
  ],
  "collection": "default",
  "qty_increments": 1,
  "indexeddate": 1789384588000,
  "lcbo_bintag_wine_tannins": 3,
  "filetype": "txt",
  "default_low_stock": "false",
  "sysclickableuri": "https://www.lcbo.com/en/julia-florista-red-532358",
  "sysfiletype": "txt",
  "language": [
    "English"
  ],
  "lcbo_total_volume": 750,
  "identifiableuri": "https://www.lcbo.com/en/julia-florista-red-532358",
  "default_stock": "true",
  "stores_inventory": "14",
  "lcbo_unit_volume_int": 750,
  "sysrowid": 1789384588053705437,
  "uri": "https://www.lcbo.com/en/julia-florista-red-532358",
  "lcbo_sugar_gm_per_ltr": 11.0,
  "syscollection": "default",
  "max_cart_qty": 9999,
  "lcbo_bottles_per_case": 12,
  "ec_overall_price": 132.0,
  "from_url": "https://www.lcbo.com/en/catalogsearch/result/#q=red&sort=relevancy&f:ec_price:range=[5,50]&f:@ec_rating=[4..4.9inc]&f:lcbo_alcohol_percent:range=[7,30]&f:lcbo_sugar_gm_per_ltr:range=[5,30]&f:@lcbo_current_offer=[On Sale]"
}

Each product record contains 80+ fields across multiple categories:

Product Identification

Field	Meaning
System Title	Official LCBO product name
Title	Display title (may differ from system title)
EC Name	E-commerce platform product name
Permanent ID	Unique LCBO product identifier
Primary ID	Primary database record ID
UPC Number	Universal Product Code for retail identification
System URI	Internal system URL for the product
Clickable URI	Publicly accessible product page URL
URI	Full product page web address

Pricing & Monetary

Field	Meaning
Final Price	Current purchase price in CAD
EC Price	E-commerce display price
EC Overall Price	Normalized price across all SKUs
Price Range	Inferred min-max pricing (if applicable)
Loyalty Points	LCBO rewards points earned on purchase

Ratings & Popularity

Field	Meaning
EC Rating	Customer review rating (1-5 stars)
Average Reviews	Mean of all customer reviews
View Rank Monthly	Monthly popularity ranking
View Rank Yearly	Annual popularity ranking
Sell Rank Monthly	Monthly sales ranking
Sell Rank Yearly	Annual sales ranking

Wine-Specific Attributes

Field	Meaning	Example
LCBO Wine Acidity	Acidity level (low to high)	Medium, High
LCBO Wine Sweetness	Sweetness profile	Dry, Off-Dry, Semi-Sweet
LCBO Wine Body	Wine body classification	Light, Medium, Full
LCBO Wine Flavor Intensity	Intensity of flavors	Delicate, Medium, Powerful
LCBO Wine Tannins	Tannin structure (for red wines)	Soft, Balanced, Firm
LCBO Tasting Notes	Flavor descriptors and notes	"Cherry, oak, spice"

Product Specifications

Field	Meaning
LCBO Alcohol Percentage	Alcohol by volume (ABV %)
LCBO Sugar Grams Per Liter	Sugar content (residual sugar)
LCBO Unit Volume	Volume per single unit (e.g., 750 mL)
LCBO Unit Volume Integer	Volume as numeric value
LCBO Total Volume	Total volume if multi-pack
LCBO Bottles Per Pack	Units per package
LCBO Bottles Per Case	Units per case
LCBO Selling Package Name	Package description
Size	Standard size label (e.g., 750ml, 1.5L)
System Size	Internal size classification

Inventory & Availability

Field	Meaning
Online Inventory	Quantity available for online purchase
Stores Inventory	Quantity across Ontario retail stores
Stores Stock	Store-level stock availability
Stores Stock Combined	Aggregated store inventory count
Stores Low Stock	Flagged if below low-stock threshold
Stores Low Stock Combined	Combined low-stock indicator
Out of Stock	Boolean: product is unavailable
Out of Stock Threshold	Quantity at which item is marked out-of-stock
Low Stock Threshold	Quantity at which low-stock flag triggers
Default Stock	System-default stock value
Default Low Stock	System-default low-stock threshold
Is Buyable	Can the product be purchased online?
LCBO Stock Type	Inventory classification (e.g., permanent, seasonal)

Categories & Classification

Field	Meaning
EC Category	E-commerce category path
EC Category Filter	Faceted category filter tags
LCBO VQA Code	VQA (Vintners Quality Alliance) certification code
LCBO Program	Product program or initiative
LCBO Region Name	Geographic origin region
Country of Manufacture	Product source country
Concepts	Associated product concepts/themes
System Concepts	Internal concept classifications
Common Tabs	Product tab groupings
Collection	Collection or series grouping

Operational & Technical

Field	Meaning
Created At	Record creation timestamp
Date	Product availability date
System Date	System-recorded date
Indexed Date	Search index last updated
System Indexed Date	System index update timestamp
Transaction ID	Sales transaction identifier
System Transaction ID	Internal transaction tracking ID
Ordering ID	Customer order identifier
Minimum Cart Quantity	Minimum units required per order
Quantity Increments	Allowed purchase quantity steps
Maximum Cart Quantity	Maximum units allowed per order

Content & Descriptions

Field	Meaning
Short Description	Brief product summary
EC Description	E-commerce platform description
EC Description	Full product description
Sanitized Description	Cleaned HTML description text
Word Count	Total words in description
LCBO Kosher	Boolean: product is Kosher-certified

System & Metadata

Field	Meaning
Language	Content language code
System Language	System language setting
Object Type	Data record type
Source	Data source indicator
System Source	Internal data source
Enabled	Is the product actively listed?
EC Visibility	E-commerce visibility status
File Type	Data format classification
System File Type	Internal file type
Row ID	Database row identifier
System Row ID	Internal row tracking ID
System URI Hash	Hashed URI for deduplication
URI Hash	Public URI hash identifier

---

How to Use

Method 1: Scrape by URLs

1. Find search URLs — Navigate to LCBO.com, apply your desired filters (price, rating, alcohol %, etc.), and copy the full URL from your browser.
2. Paste URLs — Add one or more URLs to the urls array in your input configuration.
3. Set limits — Adjust max_items_per_url (e.g., 200 for comprehensive results).
4. Enable failover — Set ignore_url_failures: true for multi-URL runs.
5. Run — Start the scraper and monitor progress in the logs.

Method 2: Search by Filters

1. Enter a keyword — Specify a product type (e.g., red, malbec, spirits).
2. Apply filters — Set price range, minimum rating, alcohol %, sugar content, bottle size.
3. Choose sort order — Select relevancy, price, rating, or trending.
4. Set item limit — Define max_items_per_url for the search results.
5. Run — Execute the scraper; it will build and paginate the search automatically.

Best practices:

• For large datasets, use max_items_per_url: 200 with ignore_url_failures: true
• Filter by price or rating to reduce noise and improve relevance
• Wine-specific searches: combine keyword with alcohol % and sugar content filters for precise results

---

Use Cases & Business Value

• Competitive pricing: Track how competitors price similar wines and spirits
• Market trends: Identify popular products by region and category
• Inventory insights: Monitor stock availability across Ontario
• Product recommendations: Build datasets for recommendation engines
• Wine analysis: Extract tasting notes and characteristics for sommelier tools
• Sales forecasting: Analyze ratings and popularity trends to predict demand

The LCBO Product Search Scraper transforms unstructured product pages into queryable, actionable datasets that power business intelligence, retail analytics, and product discovery platforms.

---

Conclusion

The LCBO Product Search Scraper delivers comprehensive product intelligence from Canada's largest alcohol retailer. With flexible search modes, advanced filtering, and access to 80+ rich data fields — including wine-specific attributes like acidity, tannins, and tasting notes — it's the fastest way to build alcohol product datasets. Start scraping today and unlock insights that manual browsing cannot provide.