x
Super Seller Alumni

How I Revamped My Business Thanks to Square Data

I’ve been running Pesso’s Ices & Ice Cream, my small ice cream shop in suburban New York, with my father since 2004. For the first 8 years, we were using a standard CASIO cash register, and we were basically running blind. It was incredibly hard to program and make changes, and even harder to track any actual sales data. While we could see how much money we made, we couldn’t see or track any sales trends. We couldn’t tell what were our best sellers, which sizes we were selling the most and least of, if we were selling more Sundaes or Milkshakes year after year, or any other figures we could use to make educated business decisions.

 

We were cash only for those years, since we always thought that taking credit cards was too complicated, too expensive, and too far out of reach for us. In 2012, more and more customers were asking to use credit cards, and we knew we had to do something. So we took a leap and set up an iPad with the Square POS app. It was incredibly easy to set up and program, taking less than 30 minutes to input our entire Item library. And as soon as we were live, we immediately started to get data we could use to track our cash and credit sales.

 

I started tracking all of that sales data that we finally started collecting thanks to Square, and organized it into my own spreadsheets to find trends. This was the beginning of sweeping changes for us to become the efficient and modern shop we are today.

 

June 17, 2018 at 01_48PM - Happy Father’s Day to all the dads out there, especially to Mr. Pesso himself! Enjoy your day!.jpg

 

 

 

Making the Menu

 

Although it only took me 30 minutes to set up, the most important step was really setting up our Square Item Library. It had to be organized in a way that not only got us good usable data, but also allowed our servers to ring up customers quickly and efficiently.

 

We quickly realized that our ever changing lineup of 100+ Flavors was way too much to track on the Register, being too complex and taking too much time to update and ring up. Even though it would be an incredible trove of data, we resigned to the fact that we’re better off having an efficient system and not gather that bit of data that we could still track by the number of tubs we use.

 

So we decided to have our Menu Categories align with our Product Categories (Ice Cream, Gelato, Italian Ice, Shakes, Sundaes, etc.), with each separate Item being based on each size. This sped up our line since our servers only had to tap a single button for each item rung up, rather than tapping through Modifiers or Variants to get to the correct size. It also allowed us to more easily track Size Sales by the item, rather than by Variants or Modifiers.

 

We also made Cones and Toppings separate Items, and saved Modifiers for tracking less frequently sold items. We do use Modifiers for changes that don’t affect price (just in case an employee skips through the popup) but that are still nice to track, like which one of our Signature Sundaes was sold, or whether the Milkshake was made with Ice Cream or Gelato.

2013-01-21 09.58.20-1.JPG

 

 

A Small by Any Other Name

 

At our peak, we had 5 sizes for each of our Categories: Kid’s, Small, Medium, Large, Pint, and Quart. We noticed customer transactions were taking a long time because of this. Customers were confused by the sizes, and ended up asking our Servers every time just how big each of the sizes were. We had to explain to almost every customer that the Kid’s was 1 Scoop, Small was 2 Scoops, and so on.

 

After seeing the Data from our original naming system, I tested re-naming our sizes to a simple “By the Scoop” system: 1 Scoop, 2 Scoop, 3 Scoop, 4 Scoop. This simple rebranding had two huge impacts on our sales: First, it sped up all of our transactions. Customers instantly knew how our sizes worked, and knew what to get. Second, customers started getting our smaller, more profitable sizes.

 

This change ended up doubling the sales of our smallest size, and by the second year with this sizing model the 1 Scoop became our top selling item. As a result, sales of two of our largest and least profitable sizes dropped tremendously, so it only made sense to drop them from our Menu. The same thing happened with our Milkshakes and Sundaes, so we also dropped them down to just a single size.


All of this, again, improved our customer experience by making our sizes clearer and easier to navigate, which sped up ordering and increased our profit along the way.October 27, 2018 at 01_08PM.jpg

 

 

 

Cutting Categories

 

Another big trend we found was that our Frozen Yogurt sales were dropping dramatically year over year, both in quantity and in percentage of sales, while every other item and category increased tremendously. Meanwhile, the expenses for froyo were only increasing with all of the extra labor involved, as well as rising costs of utilities like electric and water since we used water-cooled machines. When our machines started breaking down, the reduced demand along with the extremely high cost of repairing or replacing the machines made the decision for us. As each of our 3 machines broke down over the course of 2 years, we dropped Frozen Yogurt from our offerings.

 

While sales dropped somewhat as a result, our profit margin rose tremendously. The Pareto Principle was completely at play here: a huge chunk of our problems and expenses came from Frozen Yogurt which made up less than 10% of our Sales.


And all of that savings was all thanks to the data from Square. If we weren’t tracking our data and didn’t have access to the data and tracking sales as we did, we would have kept pumping in money and losing it all into the flailing Frozen Yogurt. We saved money, time, effort, and frustration, all because of this data.2019-01-31 15.44.34.png

 

 

 

A Page Out of the Register

 

When I first set up our Item Library on Square, we started with 5 full pages of menu items, and some of the sizes in the same category didn’t even fit on the same page. It took a lot of time to flip through all 5 pages, because it was impossible to try and remember which page the right items were. This led to longer customer interactions and checkout, fewer customers served, and longer lines.

 

Because we cut down on our number of Categories and Sizes thanks to insights from our real sales data, we ended up with fewer buttons on our register. Fewer buttons took up fewer pages, and without as many pages to fumble and tap through, our checkout process took up a whole lot less time. After all of these changes, with our new menu and pricing model, we managed to drop down to just a single 1 full page. Our transaction times dropped, and our customers were happier.

 

How to Do it Yourself

 

All of this together makes Square an absolutely indispensable reason for how my business has grown and simplified.

 

But how can you do this yourself? Want to learn exactly what steps to take to make to your Square Data work for you? Just Click here to read Part 2 of this series!

 

Hope this helps,
Aylon Pesso

 

Pesso's Ices & Ice Cream

www.pessosices.com

Pesso - he/him
Pesso's Ices & Ice Cream
Square Super Seller - I'm here to help!
5,959 Views
Message 1 of 3
Report
2 REPLIES 2
Super Seller

Very informative post, lots of good insights from real-world experience. 👍 👍

 

Also, I love the name dropping of the Pareto Principle.  That principle is something every business owner, and honestly anyone, should learn about and practice.  For those that don't know the Pareto Principle is named after the economist Vilfredo Pareto. This principle is often called the 80/20 rule.  In business, its often theorized (and often observed) that 80% of your problems come from 20% of your business.  So by reducing or eliminating that 20% of your business you are eliminating 80% of your problems freeing you up to focus even greater on that remaining 80% making it grow even more. 

 

In this case, you eliminated 10% of the problem area of your business but yet your profits and sales of the other items grew tremendously.  Eliminating an income stream or part of your service offerings is often scary for a business owner to do but it can be the step that saves a business that was on the edge of failing or takes an ok business into a thriving business.  This principle can be applied to almost everything in business and life and it isn't always exactly an 80/20 rule.  It can be a 90/10 or 70/30 rule, but the point remains about finding the weakness and eliminating it to make the strong part even stronger.

 

looking forward to your next article.  🖖

5,679 Views
Message 2 of 3
Report
Super Seller Alumni

Thanks so much @VanKalkerFarms !!

 

And thank you for explaining out the Pareto Principle for everyone on here-


It was absolutely incredibly scary to just drop a decent income stream like that. Luckily I had a grasp on the numbers and spotted the trend, and ended up saving a lot of money and increasing my profit overall, rather than sinking more money and investing into a failing product line. Sure, we may have lost some customers, but what we gained and didn't lose was so much more!

Thanks again for reading and commenting!

Pesso - he/him
Pesso's Ices & Ice Cream
Square Super Seller - I'm here to help!
5,026 Views
Message 3 of 3
Report