# Alcohol Pricing & Promotions

Access real-time competitor pricing and promotions for beer, wine, and spirits — automated insights with zero manual effort

Archived sample configuration. Sample data is illustrative, not live data.

Build this in Jsonify: https://factory.jsonify.com/setup?q=i+want+to+get+granular%2C+real-time+retail+pricing%2C+promotional+offer+details%2C+and+new+price+pack+introductions+for+all+major+competitor+beer%2C+wine%2C+and+spirits+products+from+national+and+regional+e-commerce+grocery+and+liquor+store+websites

## Goal

i want to get granular, real-time retail pricing, promotional offer details, and new price pack introductions for all major competitor beer, wine, and spirits products from national and regional e-commerce grocery and liquor store websites

## Sources

- walmart.com

- target.com

- totalwine.com

- bevmo.com

- liquor.com

- instacart.com

- shoprite.com

- safeway.com

- costco.com

- albertsons.com

- vons.com

## Sample data

id | Source | Product | Size | Price | UnitPrice | Promotion

1 | https://walmart.com/surfside-lemonade-vodka | Surfside Lemonade Vodka Variety Pack | 8 x 12 fl oz cans | 17.73 | 0.185 | 

2 | https://walmart.com/cutwater-tiki-rum-mai-tai | Cutwater Spirits Tiki Rum Mai Tai | 4 x 12 fl oz cans | 12.16 | 0.253 | 

3 | https://walmart.com/titos-handmade-vodka | Tito's Handmade Vodka | 750 ml | 16.84 | 0.663 | 

4 | https://walmart.com/smirnoff-no21-vodka | Smirnoff No. 21 Vodka | 750 ml | 10.17 | 0.4 | 

5 | https://walmart.com/svedka-vodka-175L | Svedka Vodka | 1.75 L | 15.27 | 0.258 | Rollback (was $17.12)

6 | https://walmart.com/svedka-vodka-750ml | Svedka Vodka | 750 ml | 8.47 | 0.333 | 

7 | https://walmart.com/grey-goose-vodka | Grey Goose Vodka | 750 ml | 29.28 | 1.153 | 

8 | https://target.com/titos-handmade-vodka-175L | Tito's Handmade Vodka | 1.75 L | 29.99 | 0.506 | 

9 | https://target.com/titos-handmade-vodka-750ml | Tito's Handmade Vodka | 750 ml | 17.99 | 0.709 | Sale (reg $18.99)

10 | https://target.com/jack-daniels-old-no7 | Jack Daniel's Old No. 7 Tennessee Whiskey | 750 ml | 17.99 | 0.709 | 

11 | https://target.com/svedka-vodka-175L | SVEDKA Vodka | 1.75 L | 15.99 | 0.27 | 

12 | https://target.com/espolon-tequila-blanco | Espolòn Tequila Blanco | 750 ml | 25.99 | 1.03 | 

13 | https://target.com/clase-azul-reposado-tequila | Clase Azul Reposado Tequila | 750 ml | 181.99 | 7.182 | 

14 | https://target.com/don-julio-1942-tequila | Don Julio 1942 Tequila | 750 ml | 171.99 | 6.772 | 

15 | https://target.com/new-amsterdam-pink-whitney-vodka | New Amsterdam Pink Whitney Vodka | 750 ml | 11.99 | 0.472 | 

16 | https://target.com/svedka-vodka-750ml | SVEDKA Vodka | 750 ml | 12.99 | 0.511 | 

17 | https://totalwine.com/tanqueray-london-dry-gin | Tanqueray London Dry Gin | 1.75 L | 25.99 | 0.441 | 

18 | https://totalwine.com/white-claw-hard-seltzer-variety-pack | White Claw Hard Seltzer Variety Pack | 24 x 12 fl oz cans | 29.19 | 0.101 | 

19 | https://totalwine.com/josh-cellars-chardonnay | Josh Cellars Chardonnay | 750 ml | 11.47 | 0.451 | 

20 | https://totalwine.com/titos-handmade-vodka-750ml | Tito's Handmade Vodka | 750 ml | 14.99 | 0.59 | 

21 | https://totalwine.com/titos-handmade-vodka-1L | Tito's Handmade Vodka | 1 L | 21.99 | 0.65 | 

22 | https://totalwine.com/chateau-desclans-whispering-angel-rose | Chateau d'Esclans Whispering Angel Rosé | 750 ml | 16.97 | 0.668 | 

23 | https://totalwine.com/johnnie-walker-black-label | Johnnie Walker Black Label | 1.75 L | 42.99 | 0.726 | 

24 | https://totalwine.com/whitehaven-sauvignon-blanc-2023 | Whitehaven Sauvignon Blanc 2023 | 750 ml | 12.49 | 0.492 | Mix 6 for $11.24 each

25 | https://totalwine.com/crown-royal-canadian-whisky | Crown Royal Canadian Whisky | 1.75 L | 38.99 | 0.659 | 

26 | https://shoprite.com/modelo-especial-beer | Modelo Especial Beer | 12 x 12 fl oz cans | 16.99 | 0.118 | 

27 | https://shoprite.com/coronita-extra-beer | Coronita Extra Beer | 24 x 7 fl oz bottles | 25.99 | 0.155 | 

28 | https://shoprite.com/grey-goose-vodka-175L | Grey Goose Vodka | 1.75 L | 42.99 | 0.726 | 

29 | https://shoprite.com/titos-handmade-vodka-175L | Tito's Handmade Vodka | 1.75 L | 32.99 | 0.558 | 

30 | https://shoprite.com/budweiser-lager-beer | Budweiser Lager Beer | 12 x 12 fl oz cans | 12.99 | 0.09 | 

## Additional fields

## Dashboard widgets

- {"id": "b41237a6", "size": "small", "type": "metric", "title": "Total Products Tracked"}

- {"id": "f4a27310", "size": "small", "type": "metric", "title": "Current Promotions Active"}

- {"id": "3acace7d", "size": "large", "type": "line", "title": "Average Price Over Time"}

- {"id": "874a7926", "size": "medium", "type": "bar", "title": "Competitor Price Comparison"}

- {"id": "d74bd612", "size": "medium", "type": "horizontal_bar", "title": "Top 10 Best Prices for Beer"}

- {"id": "75e6b565", "size": "medium", "type": "pie", "title": "Market Share by Competitor"}

- {"id": "f6cf217a", "size": "medium", "type": "donut", "title": "Product Category Distribution"}

- {"id": "e21fde55", "size": "large", "type": "table", "title": "Latest Promotional Offers"}

- {"id": "86a2631b", "size": "large", "type": "table", "title": "New Price Pack Introductions"}

- {"id": "32881628", "size": "large", "type": "area", "title": "Price Change Trends by Category"}

- {"id": "5a74c7c1", "size": "medium", "type": "insights", "title": "Price Analysis Insights"}

- {"id": "2dc5bd82", "size": "medium", "type": "insights", "title": "Key Observations on Competitor Activity"}

## Alerts

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Budweiser 12-pack", "title": "Price Change Detected", "source": "walmart.com", "enabled": true, "send_to": "email", "severity": "warning", "subtitle": "is now $14.99 (+$2.00)"}

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "Sierra Nevada Pale Ale", "title": "New Listing Appears", "source": "totalwine.com", "enabled": false, "send_to": "slack", "severity": "success", "subtitle": "now available in 6-pack"}

- {"id": "availability_change", "icon": "bi-exclamation-triangle-fill", "item": "Grey Goose Vodka 1L", "title": "Product Unavailable", "source": "liquor.com", "enabled": false, "send_to": "teams", "severity": "danger", "subtitle": "is now out of stock"}

- {"id": "new_price_pack", "icon": "bi-box-seam", "item": "Jack Daniel's 1.75L", "title": "New Price Pack Introduced", "source": "bevmo.com", "enabled": false, "send_to": "webhook", "severity": "success", "subtitle": "now available in family pack"}

- {"id": "menu_updated", "icon": "bi-shop", "item": "Woodford Reserve Bourbon", "title": "Menu or Listing Updated", "source": "costco.com", "enabled": false, "send_to": "email", "severity": "info", "subtitle": "price updated to $39.99"}

## Integrations

- api

- snowflake

- email