x

Linking items for quantity sold

How do you link products that are sold as both items and add on modifiers to one quantity on hand item - for example we sell lots of Salmon, but as dinners, sandwiches and add on options for salads and pastas. I want all of those to combine to give me a quantity of salmon sold daily without having to dig through modifiers.  Thanks!

561 Views
Message 1 of 6
Report
1 Best Answer
Square Champion

Best Answer

@MayaP  and @Cabley ;

I am not sure which Square Pos system @Cabley is using, Square Pos, Square For Resturants or Square for Retail.  To me it sounds like Square for Resturants but I do not use that system and know very little about how Modifers operate or are counted.  Yes the Bundle Feature could work as the smallest amount of Salmon might be 1/16 of a lb so when in inventory you receive 50 lbs.  The problem as was mentioned is this is a Retail only feature.  In retail I use Variations, Could you create a sandwich with Salad and Salmon option?  Yea, but then you would have a huge library and alot of time creating all these different bundles plus in the Bundle you would have to assign how Much salamon goes in as a Modifier for a salad or a Pasta in each bundle, Dish or sandwich for example.  The bundles were created for Retailers mainly to group individual items together to sell at a Bundled Price.  Now some sellers figured out ways to use bundles for Ingredients to keep stock of materials to make an Item.  For example 1 Jar, 1 lid, 2 wicks, 1 lb wax, .25 lb of scent and 1/32 lb of dye to make candle A.  But the bundles were designed more for retailers selling 1 Bar Mango Soap, 1-10oz Bottle Mango Conditioner, 1 mango Masage Oil, and 1 Bottle Mango Lotion Pomade and 1- Large Basket ; all for the Price of $XX.XX.  By doing this it would reduce the inventory count of each item in the bundle.  The problem for me started with people asking to mix and Match this soap instead of the Mango soap for example, which as far as I know is still a feature request.  

 

As far as I know a modifier does not reduce stock which would not help in this case.  Here is a link to the difference between Modifiers and Variations are :Food-and-Beverage/What-is-the-difference-between-item-options-and-item-modifiers/td-p/176258  read the best answer for the differences.  From the best answer "Item modifiers allow you to sell items that are customizable, or offer additional choices, and are not directly tied to your item stock."

 

So back to the Bundle option which can track stock but then you would also need to factor in the Sell By Units : 7237-stock-conversion-sell-by   

What is Stock Conversion Sell By Units?

From the link:

With stock conversion, you can manage inventory when selling items in different units of measure. For example, if your retail business sells wine by the bottle and by the glass, you can track all of your inventory on a single item variation so that whether you sell it by the bottle or by the glass, the inventory is reduced. Stock conversion allows you to:

  • Break stock of an item into smaller components to allow for easier tracking and management.

  • Save time in receiving and stock tracking by using units of measure that match how you receive and count items.

  • Supports those who sell an item by multiple units (i.e. 6 ounces, bottle) and want to use a single source of inventory to generate different views of that inventory.

What I use the Sell by units for is I order Cases of Taper Candles 144 in a Case.  The case hase 12 Packs of 12 or a Dozen to a Pack, But I also sell Tapers as 1.  So I sell 1 Taper for say $2.00 each but sell a Pack for $20, and a Case for $200; so the more people buy at once a better deal they get.  But when I sell 12 or 144 at a time this is reduced from my overall Inventory witch I put in Square as 144 times the number of cases I order.  

 

I know this is long but what your trying to do is Link a non quantity item Modifier to a Stock Counted Quantity of Salmon which would not be able to be done directly and may have to mix and match components to get your end result.  I am not saying its not possible, but is it Practical is the question?  For example when I make a Pink candle.  I make batches of about 80.  I use a Dash of red for 80 candles, now break that down to how many Lbs or Grams is used per candle.  It ends up being so little weight that it messes my inventory up.  But if once a week I weigh my Red dye and see I have 1 lb left, I know that will last X amount of weeks depending what season is approaching.  Red goes faster from September through December.  So I do not track inventory by use of the red but when I should reorder it to make more candles.  I know with your situation with perishables its not as easy and where you may think Salmon Steaks I need to inventory but when used as a Modifier to a side salad is not as important.  Can you see in reports which Modifiers are requested more or less?  How can you account for different chefs using 1/4 lb as a modifer as another may use 1/3 lb for example?  Maybe calculate how much Salmon you use for main items, Dinners, Sandwiches etc.  But then take a Small % to use for modifiers only and then when you run out for the modifers, take more salmon and weigh it to reduce the amount used for main items.  This will help you see how much is being used for the Modifiers and only tracking your main amount.  I am not sure if this could work or not for you, its the best I can come up with, not knowing how everything is calculated in a Restaurant situation.

Keith
Owner
Pocono Candle

Mark as Best Answer if this Helped you solve an issue or give it a thumbs up if you like the answer.
Square Support Number 855-700-6000.
Make Sure App and OS is up to date on your Device.

View Best Answer >

510 Views
Message 3 of 6
Report
5 REPLIES 5
Square Community Moderator

Hey there @Cabley ,

 

Thanks for getting in touch!

 

Square does have a bundle feature but that is only available under our Retail Plus subcription. Would that work for you? 

 

I am going to tag some super sellers who can provide their insight @Candlestore @Twpchair @Donnie-M!

 

 

 

 

MayaP
Square Community Moderator
Sign in and click Mark as Best Answer if my reply answers your question
516 Views
Message 2 of 6
Report
Square Champion

Best Answer

@MayaP  and @Cabley ;

I am not sure which Square Pos system @Cabley is using, Square Pos, Square For Resturants or Square for Retail.  To me it sounds like Square for Resturants but I do not use that system and know very little about how Modifers operate or are counted.  Yes the Bundle Feature could work as the smallest amount of Salmon might be 1/16 of a lb so when in inventory you receive 50 lbs.  The problem as was mentioned is this is a Retail only feature.  In retail I use Variations, Could you create a sandwich with Salad and Salmon option?  Yea, but then you would have a huge library and alot of time creating all these different bundles plus in the Bundle you would have to assign how Much salamon goes in as a Modifier for a salad or a Pasta in each bundle, Dish or sandwich for example.  The bundles were created for Retailers mainly to group individual items together to sell at a Bundled Price.  Now some sellers figured out ways to use bundles for Ingredients to keep stock of materials to make an Item.  For example 1 Jar, 1 lid, 2 wicks, 1 lb wax, .25 lb of scent and 1/32 lb of dye to make candle A.  But the bundles were designed more for retailers selling 1 Bar Mango Soap, 1-10oz Bottle Mango Conditioner, 1 mango Masage Oil, and 1 Bottle Mango Lotion Pomade and 1- Large Basket ; all for the Price of $XX.XX.  By doing this it would reduce the inventory count of each item in the bundle.  The problem for me started with people asking to mix and Match this soap instead of the Mango soap for example, which as far as I know is still a feature request.  

 

As far as I know a modifier does not reduce stock which would not help in this case.  Here is a link to the difference between Modifiers and Variations are :Food-and-Beverage/What-is-the-difference-between-item-options-and-item-modifiers/td-p/176258  read the best answer for the differences.  From the best answer "Item modifiers allow you to sell items that are customizable, or offer additional choices, and are not directly tied to your item stock."

 

So back to the Bundle option which can track stock but then you would also need to factor in the Sell By Units : 7237-stock-conversion-sell-by   

What is Stock Conversion Sell By Units?

From the link:

With stock conversion, you can manage inventory when selling items in different units of measure. For example, if your retail business sells wine by the bottle and by the glass, you can track all of your inventory on a single item variation so that whether you sell it by the bottle or by the glass, the inventory is reduced. Stock conversion allows you to:

  • Break stock of an item into smaller components to allow for easier tracking and management.

  • Save time in receiving and stock tracking by using units of measure that match how you receive and count items.

  • Supports those who sell an item by multiple units (i.e. 6 ounces, bottle) and want to use a single source of inventory to generate different views of that inventory.

What I use the Sell by units for is I order Cases of Taper Candles 144 in a Case.  The case hase 12 Packs of 12 or a Dozen to a Pack, But I also sell Tapers as 1.  So I sell 1 Taper for say $2.00 each but sell a Pack for $20, and a Case for $200; so the more people buy at once a better deal they get.  But when I sell 12 or 144 at a time this is reduced from my overall Inventory witch I put in Square as 144 times the number of cases I order.  

 

I know this is long but what your trying to do is Link a non quantity item Modifier to a Stock Counted Quantity of Salmon which would not be able to be done directly and may have to mix and match components to get your end result.  I am not saying its not possible, but is it Practical is the question?  For example when I make a Pink candle.  I make batches of about 80.  I use a Dash of red for 80 candles, now break that down to how many Lbs or Grams is used per candle.  It ends up being so little weight that it messes my inventory up.  But if once a week I weigh my Red dye and see I have 1 lb left, I know that will last X amount of weeks depending what season is approaching.  Red goes faster from September through December.  So I do not track inventory by use of the red but when I should reorder it to make more candles.  I know with your situation with perishables its not as easy and where you may think Salmon Steaks I need to inventory but when used as a Modifier to a side salad is not as important.  Can you see in reports which Modifiers are requested more or less?  How can you account for different chefs using 1/4 lb as a modifer as another may use 1/3 lb for example?  Maybe calculate how much Salmon you use for main items, Dinners, Sandwiches etc.  But then take a Small % to use for modifiers only and then when you run out for the modifers, take more salmon and weigh it to reduce the amount used for main items.  This will help you see how much is being used for the Modifiers and only tracking your main amount.  I am not sure if this could work or not for you, its the best I can come up with, not knowing how everything is calculated in a Restaurant situation.

Keith
Owner
Pocono Candle

Mark as Best Answer if this Helped you solve an issue or give it a thumbs up if you like the answer.
Square Support Number 855-700-6000.
Make Sure App and OS is up to date on your Device.
511 Views
Message 3 of 6
Report
Square Community Moderator

Thank you, @Candlestore , for sharing your insights! While you're not in the restaurant space, your expertise in inventory management is invaluable.

 

If you have any frurther questions or concerns @Cabley don't hesitate to reach out! 

 

 

MayaP
Square Community Moderator
Sign in and click Mark as Best Answer if my reply answers your question
504 Views
Message 4 of 6
Report

Thank you @Candlestore and @MayaP  for that very detailed response.

We use the same portion of salmon across the board, from entrees to add ons to salads.  I just want to be able to pull some sort of number that connects all the ways we sell it at the end of the day/week.  Would it be possible to do a custom report that is a combination of entrees and all the add ons?? 

490 Views
Message 5 of 6
Report
Square Champion

You could but like @Candlestore stated it would be a long process. I am also a retail furniture store and it is amazing to keep track of every item sold, the color the size the list goes on. With you order a certain amount of say salmon and then pork chops. I would say with time of course I couldn't see why you couldn't use almost the same system as I do. This is just a rough thought or idea. I just got home to pull up my actual screen I could tomorrow sometimes looking at something visually and then brainstorm for a second and adjust it to fit your needs. 

1. 50 couches style # 674587

 A. 25 grayscale 

 B. 15 tans to beige

 C. 5 black shades

 D. 5 multi-medium tones

 

If those you converted to your main food orders are fish, beef, pork, etc.

Under each main category, I have

A. 25 grays

 1. 10 sold 1 week (trending each week)

I would think you could convert your extras like that. I am not a technical person and my son does websites for a big firm and sat down with me on a Sunday and told me what to do but made me do it. I'm very visual and show me 1 or 2 times and boom I have got it. But it's all about being able for you to convert it so you understand it and it's right for when you order. I added multiple subtitles for decor, rugs, and lamps and it is dead on accurate. It will come down to you just changing up how you word it and the categories you need to make it work. I'm in the downtown district and my neighbor has a coffee shop and light breakfast and lunch store. She uses square as well I will ask her tomorrow what she is using. I know my receipt is detailed to the point! 

Large frozen mocha-caramel

No whip

No cherry 

No drizzle

 

 

$4.95

Tax

Total 

Pretty similar but detailed. Same if I get a sandwich and it's a Reuben on sourdough, not rye, with extra dressing on the side. You can do this and keep it as simple as possible! 

Square Champion, Square Champion Innoventor, Square Champion Expert, Square Champion
Advisor.
468 Views
Message 6 of 6
Report