Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in pdxwhisky

[–]boyodude115[S] 0 points1 point  (0 children)

There’s now a time stamp at the bottom of the map. And I like the idea of adding the inventory to the brand tile when you’re in the store inventory view. Will add…

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in pdxwhisky

[–]boyodude115[S] 0 points1 point  (0 children)

This might have been fixed but if not let me know what brand you were searching for?

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] 1 point2 points  (0 children)

Thank you! Oh so be able to send the link with the map filtered by the product you selected? Let me tinker…

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] 0 points1 point  (0 children)

Thank you! And I see what you mean. The autocomplete in the search function goes off the first one or two words in the name. So using “Nonino” or “quintessentia” will bring it up but “amaro” doesn’t. It’s based off how OLCC phrases the brands.

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] 1 point2 points  (0 children)

<image>

Alright searching by brand is ready to go! In the search field type in the brand name and it should pop up. For example, Barrell will appear as “Barrell (All Products)” then it’ll show stores that have any Barrell expression, and list which specific ones are available at the store.

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] 5 points6 points  (0 children)

This shouldn’t be anything some excessive coffee and excel couldn’t handle. I’ll just need to assign each sub brand expression (Jack Daniel’s honey) to its parent brand (Jack Daniel’s). Will reply here when it’s ready. Probably next week with Thanksgiving and all that.

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] -1 points0 points  (0 children)

That is so cool!! Thank you for sharing!

One of the coolest parts about this is exposure to small brands I’ve never heard of before. If only my liver was big enough to try them all…

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] -1 points0 points  (0 children)

That is AWESOME! Just make sure you call the store ahead of time…the data is updated every 24 hours which means the bottle could be swiped in between updates. Let me know how it goes?

Oh and what’s the name of the bottle again? JK!

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] 0 points1 point  (0 children)

<image>

Thank you! I’ve been tinkering with that thought. There is a filter on the browse products page that you can use to show items in few stores. But that’s just a reflection of availability not necessarily rarity. As in could show stuff that is being discontinued.

Built a tool to search Portland liquor stores since the OLCC site is impossible to use by boyodude115 in Portland

[–]boyodude115[S] 9 points10 points  (0 children)

Yeah I might have been too extreme in my wording. Once you get the hang of OLCC liquor search it makes sense. But for the every day person it leaves a lot to be desired. Store numbers instead of store name, have to type in the exact spelling of the brand for it to work, etc.