Bottle Stock management for wine by glass

Hi,

We use lightspeed in our wine bar.

we would like to know if it is possible to manage properly our bottle stock?

Basically, when we sell 6 glasses (125ml) or 1.75 carafe (500ml) we need to remove a bottle (750ml) from the stock. Is it any way to do that?

“ingredients” doesn’t work in this case as we sell glass and carafe (and cannot add value with decimal)

please help!

5 comments

  • VintageWineGuyVintageWineGuy Member Posts: 120 ✭

    Hello fellow wine person! You could probably use the Box item type in Inventory. I admit, we aren't doing by the glass inventory now, we just count the bottles, but I have looked at it and looked at Box. (Item, and change the item Type field to Box). https://retail-support.lightspeedhq.com/hc/en-us/articles/229130088-Creating-boxes

    We use box for six packs of beer that we sell by the pack or singles. "Breaking" a box is an administrative step that people are constantly skipping, but it works. I looked at doing this for by the glass as well, basically setting up the bottles behind the bar as Boxes with 5 glasses and managing them that way, but we ended up just tracking it at the whole bottle - we just remove the bottle when it is empty or aged out. But we are small, don't have big worries about the staff messing with the margins, so we are pretty loose.

  • Katherine_WelfordKatherine_Welford Moderator, Lightspeed Staff Posts: 77 moderator
    edited January 2020

    Hello @RolK,


    Alas, there's is no way to create such relationships in Lightspeed's stock management, ie: for Lightspeed to know that 6 glasses = 1 bottle. As per VintageWineGuy's comment, you'd have to do the calculations manually and adjust your bottle stock for every 6 bottles sold.

    We do integrate with companies that are specialist in stock management. You can find a list of these partners here:

    https://www.lightspeedhq.com/integrations/?category=inventory-management

    Post edited by Heather on

    Lightspeed Restaurant tech support

    Lightspeed HQ


    Visit our Help Center

    Toll-free: 866-932-1801 | Montréal 514-907-1801

    Australia: +61-2-8488-3146 | United Kingdom +44-20-3695-9599

  • Samir ShashaSamir Shasha Member Posts: 1

    I am just starting and using the trial I assume it has full functionality

    I think the issue is unit type. If you actually create a wine as an ingredient and use grams instead of liters (since LS doesn’t do fractions and doesn’t have ml) then you can set a bottle to equal 750 grams and a glass to 750/6 or and a carafe at 500 of that wine as an ingredient.

    I still haven’t figured out how to put the stock of ingredients into LS

  • Katherine_WelfordKatherine_Welford Moderator, Lightspeed Staff Posts: 77 moderator

    Hi gang, Samir has it right.


    Stock management is primarily for items sold as a unit, ie: bottle of beer, bottle of wine, etc. Stock management does not take into account fractions, so for instance has no idea how many glasses of wine equal a bottle.


    For situations such as this, is is best to set up ingredients and create these at the smallest amount you'd sale, say 1oz of rum. Then map these to both your glass and bottle products (for those products that are sold by the glass or bottle) then you can track how many ounces of rum you've sold for a given time frame. You can then divide this number by how many ounces fit in a bottle , and that will give you an accurate count of how many bottles you've gone through and are currently going through.


    This would be the best way to tackle this.


    Hope that helps!

    Lightspeed Restaurant tech support

    Lightspeed HQ


    Visit our Help Center

    Toll-free: 866-932-1801 | Montréal 514-907-1801

    Australia: +61-2-8488-3146 | United Kingdom +44-20-3695-9599

  • Katherine_WelfordKatherine_Welford Moderator, Lightspeed Staff Posts: 77 moderator

    HI again,


    Also, please note that you can create units when creating your ingredients. You can type in the dropdown box for unit type.


    Cheers,

    Lightspeed Restaurant tech support

    Lightspeed HQ


    Visit our Help Center

    Toll-free: 866-932-1801 | Montréal 514-907-1801

    Australia: +61-2-8488-3146 | United Kingdom +44-20-3695-9599

Sign In or Register to comment.