Skip to content


Subversion checkout URL

You can clone with
Download ZIP
A web interface and API for searching the OLCC price list.
Python HTML CSS JavaScript
Fetching latest commit...
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.

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

OLCC Excel files


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 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 with the following contents:

DEBUG = True

To run the local development server you should first install the Heroku toolbelt. You should then be able to start up the Gunicorn server by running foreman start in the src directory. Make sure you run $ pip install requirements.txt in your virtualenv first. Alternatively, simply run the following from within your virtualenv:

$ python run_gunicorn

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

$ python syncdb

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

$ python loaddata olccdev

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

$ python olccfetch

Potential Features

  • 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.
  • Price intelligence: Analyze historical price changes to predict future sales.
Something went wrong with that request. Please try again.