The Role of Square POS in Effective Menu Management

How to use Square sales data to engineer a menu that is both popular and profitable, step by step.

Square POS plays a central role in menu management because it records exactly what sells, when and with which modifiers. That sales data lets you practice menu engineering: keeping the items that are both popular and profitable, fixing the ones that are not, and cutting the dead weight. The menu stops being a guess and becomes something you review and improve on a schedule.

This guide focuses on using Square's sales data to decide what belongs on your menu. If you are still building items, modifiers and variations, start with customizing your restaurant's menu on Square first.

What menu engineering is

Menu engineering scores each item on two measures:

  • Popularity: how many you sell compared with other items in the same category.
  • Profitability: how much you keep per sale after ingredient cost (the contribution margin, which is price minus food cost).

Plot every item on those two axes and you get four groups:

GroupPopularityMarginWhat to do
StarsHighHighProtect them. Keep quality consistent and feature them prominently.
PlowhorsesHighLowAdjust the recipe, portion or price carefully, since guests already love them.
PuzzlesLowHighImprove visibility, rename, add a photo or train staff to recommend them.
DogsLowLowRework or remove them to simplify prep and the menu.

Step 1: Clean up your item library first

Menu engineering only works if your sales data is clean. Before you analyze anything, check that:

  • Every dish is a real item in Square, not rung up as a custom amount.
  • Items sit in sensible categories (espresso drinks, pastries, mains, sides), because you compare items within a category.
  • Sizes are set up as variations and add-ons as modifiers, so one latte does not show up as five separate items.
  • You avoid renaming items mid-period. In Square reporting, a renamed item can show up as a separate line, which splits its history.

Our guide to accurate sales reporting with Square POS covers these data hygiene habits in more detail.

Step 2: Pull your sales data

In Square Dashboard, the Reports section includes item sales, category sales and modifier sales reports. For menu engineering, use a period long enough to smooth out odd days, such as the last 8 to 12 weeks, and export the item sales report so you can work with it in a spreadsheet. Note the quantity sold and net sales for each item.

Review modifier sales too. If oat milk or an extra shot is added to a large share of drinks, that tells you something about pricing and what to stock.

Step 3: Add your food cost

Square tells you what sold. You need to add what each item costs to make. For each item, total the ingredient cost of one portion from your recipe and current supplier invoices. Then calculate:

  • Contribution margin = menu price minus ingredient cost.
  • Total contribution = contribution margin times quantity sold.

For a deeper look at cost and pricing math, see managing food costs and pricing using Square analytics.

Step 4: Sort items into the four groups

Within each category, compare each item's quantity sold to the category average, and its contribution margin to the category's average margin. Above average on both is a Star, and so on.

Example: a small coffee shop pastry case

Imagine a cafe selling six pastries. Over ten weeks, the almond croissant sells the most and has a healthy margin, so it is a Star. Plain muffins sell well but are bought in at a cost close to their price, so they are a Plowhorse: the owner tests a small price increase. A seasonal scone has a strong margin but low sales because it sits at the back of the case, so it is a Puzzle: it moves to the front and gets a photo on the online menu. A slow, costly tart is a Dog and is dropped, which also frees up oven time.

Step 5: Make one change at a time, then measure

  • Placement: list Stars and Puzzles first in each category on your POS, printed and online menus.
  • Descriptions and photos: a clear photo and a short, specific description often help Puzzles more than a price cut.
  • Pricing: change prices in Square so every channel updates together, then compare quantity sold in the following weeks.
  • Removal: before cutting a Dog, check whether it drives larger orders or is a loyal regular's favorite.

Re-run the analysis monthly or quarterly. Seasons, supplier prices and trends shift what counts as a Star.

Common mistakes

  • Judging on revenue alone. A best seller with a thin margin can earn less than a quieter, high margin item.
  • Comparing across categories. Compare drinks with drinks and mains with mains, or every drink will look like a Star.
  • Using stale costs. Update ingredient costs when supplier prices change.
  • Changing everything at once. If you move, rename and reprice an item in the same week, you will not know which change worked.
  • Ignoring off-premise channels. Online and app orders often have a different mix than counter sales. Check items across all of them.

Where Orda fits

Your online menu is one more place to apply what you learn. Orda's web ordering and branded mobile apps sync the menu from Square, so a price change, new photo or removed item in Square shows up in your app and on your ordering site. Orders flow back into Square POS, which keeps your app and web sales in the same reports you use for menu engineering. Orda Express self-ordering kiosks work the same way for in-store orders.

Ready to
Launch Orda?

Connect your store
Launch in 5 minutes