How to manage Inventory Management with Modifiers ?

Hi,

I'm starting using Inventory management. Just to try to have a clarification and be sure i'm not missing something, here's the situation:

I'm running a tipical pizzeria here in Mexico City with loyverse under Android, using KDS.. The products all have different sizes and extra ingredients.

Let's take one example: Pizza Margarita.

The pizza has 3 sizes, and about 20 extra ingredients possible.

1) The natural set up to have a quick entry is this way:

Category: Pizza

Item: PIzza Margarita:

  • Modifier 1: Size
  • Modifier 2: Extra ingredients

The inventory is only at item level, so it cannot count both size and ingredients

2) So we need to divide the item by size

Category: Small Pizza

Item: PIzza Margarita

  • Modifier 2: Extra ingredients

So if I have a menu with 15 pizzas, I now have 45 items. Still the stock of my extra ingredients (which are the same than the pizzas) are still not manage, and represent 5% of my total volume.

3) So i decide to make the extra ingredients as a category. The extra ingredients of course have  different prices per size. So i need 3 categories to have it clear:

Category: Extra ingredients Pizza Small

Item 1: Extra Mozzarella small

Item 2: Extra Pepperoni small

Item 3:....

Category: Extra ingredients Pizza Big

Item 1: Extra Mozzarella big

Item 2: Extra Pepperoni big

Item 3:....

Now I have  105 items to choose from to sell one pizza. But everything is managed in inventory.But it appears difficult to read in the KDS, because the extra ingredients are not included in the pizza.

Taking into account that I sell salads and pastas the same way, I will easily reach the 200 items. It makes a lot of reports useless. I've developped a script (GAS) so i can parse the receipt reports to have the answer to all the questions i need to run the business.

But wait: 15% of my pizza sales are half/half: So my question is the following: A customer order one pizza half margarita/half 4 cheeses with extra pepperoni and extra mushrooms on the margarita side, and extra mozzarella and without goat cheese on the 4 chesses side. What is the best setup of Loyverse for that ?

For the ones interested, i draw a quick scheme of what could be our product structure.

Thanks for the future inputs to my question.

Sincerely,

Marc

480º

 

Answers

Your explanation was just great, thanks for all the details.

It's true that it gets complicated when it comes to use modifiers and invenotry management.

Honestly, I would keep it simple.

Yes you need to create separate items for each size, but when it comes to the extra ingredients I would let them as modifiers.

It's true that you cannot track their stock. But you have a report, the "sales by modifier report".

So I suggest you to, based on such report, adjust all your inventory levels afterwards, perhaps at the end of the day, by using the feature "Sotck adjustments", recording it as an "inventory count", setting the right stock of all the ingredients.

More about stock adjustments here: https://help.loyverse.com/help/how-work-stock-adjustments

Yes it's extra work that at first it seems unnecessary, but I believe it will actually make it more easy to speed up sales and keep clean reports.

What do you think?