Track inventory on variations of the same product

[Walters_Camp]

Hello all, hopefully there is some experience on this front.  I thank you in advance for the help.

We are a small convenience store and bar and would like to start tracking our beer inventory.  Due to our size and storage limitations we only purchase beer in 12 pack cans which is then sold as either bar (singles), 6, 12 or 24 packs.  In an effort to make things simple for our employee who had never used an Ipad before we set up categories for bar, 6, 12 an 24 packs.  Using one brand as an example Coors.  Coors is an individual item 4 times corresponding to each category.  The employee is now comfortable using the Ipad and we want to start tracking our inventory, however it appears that our current set up won't work.  All sales are drawn from the same bulk pool of inventory and we are hoping to find a way to track the inventory so our raw can count is reflected across the 4 variations of sales.

Does anyone know of a way to set up the system to be able to track the inventory on a per can basis?  I've looked at creating an item; "Coors" and adding 4 price variations for; singles, 6, 12, 24 packs.  However it appears that if we sold a 12 pack of Coors, Square (from an inventory perspective) only recognizes that as a single can sale not 12 cans sold.  

We are at a loss on how to go about tracking inventory of our fixed pool of product sold 4 different ways.  Maybe there is a way to set up quantity discounts that are preset so square sees it as a sale of a single product at $3.00 however if someone buys 12 of that product the price is $10.00?  

Thank you again for your time. 

[RHatch]

I would think that 6, 12, and 24 come packaged that way?  I would inventory them that way.  You can also use the UPC on the package and then scan them.  The singles are then the only issue.  I would break a case and move the inventory from case to singles.  This should work for you.

I wouldn't use the discount to do this, it could lead to theft and will not allow you to easily track what you are selling, singles vs 6 pack, etc.

The best way would be to actually have separate stock.

Another way is with a spreadsheet,  I do this for a friend that has a smoothie bar,  This allows him to check his inventory of ingredients every week or whenever he does it.  He enters the total number of sales for each smoothy and it calculates how much he used.  You could do the same.  1 single is one single, 1 -6 pack is 6 singles so a total of 7 sold.  Just depends on how you are tracking your inventory.

[Walters_Camp]

Thank you for the reply.  Yes, typical stores stock 6, 12, 24, 36 packs of beer however we are located over an hour from any civilization, 7 miles down a dirt road on a popular river.  Most of our customer traffic is via boat and rarely do we get asked for large quantity boxes of beer.  It is generally people looking for 12 packs to "top off" their coolers.

I've been chewing on the idea of a spreadsheet to track inventory but was hoping that square would be able to handle it somehow so I didn't have two seperate points of data to connect.  However, our volume is low so doing it that way isn't the end of the world.  

Thank you again for the reply and your time.  

[LRDovers]

I need to track the inventory of the amount of a product based on the variation selected. Example: small pork Gyoza is 3 dumplings and large is 6. How do I get each variation to pull out the correct amount of dumplings from the inventory?

[ashc]

Hey @LRDovers,

I moved your post to an existing thread where another seller had a similar question. 

One of our Super Sellers @RHatch detailed how he does his that you might find helpful here.