See where your cut-cheese weight is shrinking
Every Monday, WebRun opens ShelfPerks to read the weight cut and received per cheese, pulls the weight actually sold from Square, calculates the shrink gap for each item, and logs a ranked variance report to Google Sheets so you can spot the biggest losses.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I calculate cheese shrink from cut weight and sales automatically?
WebRun compares your cut cheese against your sales every Monday. It reads the weight cut and received in ShelfPerks, pulls the weight actually sold from Square, computes the shrink gap per cheese, values it in dollars, and logs a ranked variance report to Google Sheets, so you see exactly where product is disappearing.
- The biggest weekly shrink shows up ranked in dollars, not guesswork
- Cut versus sold weight is reconciled every single week
- Unmatched items are surfaced once so mapping stays clean
Built for cheese shop owners · specialty food retailers · deli managers · grocery cheese buyers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.shelfperks.comin a real browser with your saved login - no setup, no API keys. -
1
ShelfPerks - read weight cut and received
shelfperks.com How to Automate ShelfPerks
WebRun opens ShelfPerks to read weight cut and received. - Open ShelfPerks and go to the weight-based inventory view
- Read the total weight cut and weight received for each cheese over the past week
- Capture the opening and closing weight on hand per item
- Note the unit cost per pound so shrink can be valued in dollars
Done when Every weight-based cheese has its cut, received, and on-hand weight captured for the week.
-
2
Square - read weight actually sold
squareup.com How to Automate Square
WebRun opens Square to read weight actually sold. - Open Square and pull the item sales report for the same week
- Read the weight sold for each weight-priced cheese at the counter
- Match each Square item to its ShelfPerks cheese by name or SKU
- Total the weight sold per matched item
Done when Each cheese has its weight sold in Square matched to its ShelfPerks record.
-
3
Google Sheets - log the shrink variance report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the shrink variance report. - Open the Cheese Shrink Report sheet
- For each cheese, compute expected weight sold from opening plus received minus closing, then subtract the weight Square actually sold to get the shrink gap
- Value each gap in dollars using the unit cost per pound
- Sort the rows by dollar shrink, largest first, and add the weekly total
Done when The report sheet shows this week's shrink per cheese, ranked by dollar loss.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change any inventory counts in ShelfPerks or Square?
No. WebRun only reads from ShelfPerks and Square and writes the results to your own Google Sheet. It never edits stock counts or prices in either system, so nothing is altered on your behalf.
How does it match a Square item to a ShelfPerks cheese?
By SKU first, then by item name when no SKU is set. Any item it cannot confidently match is listed separately in the sheet so you can map it once and it sticks.
What counts as shrink here?
Shrink is the gap between the weight that should have sold and the weight Square recorded as sold. It captures rind loss, cutting waste, sampling, and theft together, valued in dollars so the biggest leaks stand out.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.