twaddington / django-olcc

A web interface and API for searching the OLCC price list.

This project represents a Django site built for the sole purpose of displaying Oregon Liquor Control Commission (OLCC) product, price and store data.

The models are designed to easily import product data directly from the OLCC and include enhanced functionality for interacting with the original data set.

The project was born simply because the data existed and was freely available.

You can view the live site at oregonliquorprices.com.

OLCC CSV files

• http://www.olcc.state.or.us/pdfs/NumericPriceListNextMonth.csv
• http://www.olcc.state.or.us/pdfs/NumericPriceListCurrentMonth.csv (out of date)
• http://www.olcc.state.or.us/pdfs/PriceHistory_CSV.csv (out of date)

Contributors

You are encouraged to fork the project and add new functionality. We'd love to see your pull requests! Please make sure to run tests before submitting a patch.

$ python manage.py test olcc

Please make sure your editor is configured to use the proper indentation style with 4-spaces and no tab characters.

Getting Started

After cloning the project into your python virtualenv, you'll first need to create a basic settings_local.py with the following contents:

DEBUG = True
TEMPLATE_DEBUG = True

Active your virtualenv and install the project dependencies:

$ pip install -r requirements.txt

To start the local development server simply run:

$ python manage.py run_gunicorn

You'll then need to create your local development database by running:

$ python manage.py syncdb

A development fixture has been provided to get you up and running quickly. You can import this fixture by running:

$ python manage.py loaddata olccdev

You can import fresh product data into your database by running:

$ python manage.py olccfetch

Potential Features

• Price calculator: Per shot, oz, ml, 2oz bar pour.
• Collapse product sizes onto a single detail page. This could potentially be done using the product code, which seem to have a common prefix for product type.
• Find stores by proximity to the visitor's current location.
• Parse the store hours into a machine readable format. Display stores as currently open/closed.
• Product images: Scrape Creative Commons licensed photos or accept submissions.
• Price monitoring: Get notified when your favorite item drops in price or is about to go up in price.
• Price intelligence: Analyze historical price changes to predict future sales.

django-olcc's Issues

At which stores is this product sold?

Add tidy middleware to format HTML

https://pypi.python.org/pypi/html5tidy/1.0

Oregon Liquor Prices (monthly pricing suggestions)

So I've been using www.oregonliquorprices.com, and I thought of a cool new feature after a recent liquor purchase.

The other day, I went and got myself some bourbon: http://www.oregonliquorprices.com/products/8189h/

I paid $43.95, the October price, and afterwards, I wanted to come on here and check to see which months it might possibly go on sale, only to see it's already going to go up in price next month, and likely for the next three, which gave me a new feature idea.

In addition to showcasing liquors currently on sale, what if there were a way to show liquors that were set to change in price the next month, once the next month's prices were available. For something like this bourbon, it might include a suggestion to buy now before the price increase at the end of the month. For other liquors going to go down in price, the website could suggest holding off until the next month.

It's just an idea, but I figured it wouldn't hurt to suggest it. Thanks for your work, and have a gone one!

Whats new?

Hey there, not sure if you're still interested in developing this site further, but one thing I would love to see is new entries to the price sheet, or items that are listed with a price this month but were unlisted the month before. Also, I'm sure it would be difficult to get location specific inventory data from OLCC if it isn't available already but even just aggregate OLCC purchase volume could help locate good deals on rare bottles. Cheers!

Price API doesnt provide latest pricing

I could be misunderstanding how to look up a price via the API, but when I use http://www.oregonliquorprices.com/api/v1/price/ID/?format=json i.e. http://www.oregonliquorprices.com/api/v1/price/1883/?format=json

I get an old price compared to what is being displayed on the website.

Excel file links are broken

For example, http://www.olcc.state.or.us/pdfs/Numeric_Price_List_Next_Month.xls leads to a Not Found On WebProd error message.

website doesn't work

website seems to not have any prices. Is this not being maintained anymore? it was a cool site

New layout

• Mobile friendly responsive layout.
• Full-width search bar on mobile.
• Fixed position header and search on desktop.
• Big chunky sections on desktop for homepage.
• Large background images to add color to product detail pages.

Upgrade Django

Migrate age field to an integer field.

The age field is currently a DecimalField. This should be migrated to an IntegerField.

on sale in my store

Is it possible to get all the liquors on sale which are available at my specific store?

Add a store locator

We should use HTML5 geolocation APIs to get the current location and find nearby stores. This should only happen when the user requests it so they don't get an unexpected location request.

Create a portable OLCC app

• Models
• Management commands
• Utility methods

Add homepage meta description and keywords.

• oregon, olcc, liquor, alcohol, prices, oregon liquor control commission