What changed
We work with a four-person fashion boutique where the owner counted sell-through by hand every Sunday to decide what to reorder. A report built from the shop's Square sales now lists what sold, what sits, and suggested reorders each week. The Sunday stocktake is gone, and the buying decisions stay with the owner.
Get your AI Starter Plan
A stocktake every Sunday
We work with a four-person fashion boutique. Every Sunday, the owner worked out what had sold that week, what was sitting on the racks, and what to reorder from suppliers. Most of that meant counting sell-through by hand and comparing it with the sales in Square.
It was the owner’s main day off, and the count took a big part of it.
What we set up
We set up a report that writes itself (the industry calls it automated reporting). Each week, a link between the shop’s tools (the industry calls it a data pipeline) pulls the week’s sales out of Square and into a Google Sheet. The sheet lists what sold, what’s sitting, and how each piece is tracking against the stock on hand.
On top of that, the AI reads the sheet and writes a short summary at the top, with a suggested reorder list. The report is ready on Monday morning.
What didn’t work the first time
Our first version counted markdown sales the same as full-price sales. So it suggested reordering pieces that had only moved because they were on sale at the end of a season. We split markdown sales into their own section, and the reorder list now only looks at full-price sell-through.
What changed, and what still needs a person
The Sunday stocktake is gone. The owner reads the report on Monday instead.
The buying decisions stay with the owner. The report suggests, and the owner decides, because buying depends on taste, the season ahead, and supplier minimums the report doesn’t know about.
Where this fits
This is one of our reports that write themselves. If you spend a day off counting stock, get your AI Starter Plan and tell it where your week goes.
What changed
No more Sunday stocktake
The owner no longer counts sell-through by hand on Sundays. The report is ready on Monday morning.
What sold, what sits, what to reorder
Each week the report shows the best sellers, the slow movers, and a suggested reorder list.
The owner does the buying
The suggestions are a starting point. The owner makes every buying decision.
This story uses our Reports that write themselves service, set up mainly in Square , for a business in fashion.
Other tools: Google Sheets, Claude.
Read more: Reports that write themselves for Fashion , or Reports that write themselves with Square.
More stories like this
How Marlow & Thread gets a new drop live in 2 days instead of 6
How a community food relief charity cut its quarterly grant report from a week to about a day
How a four-person social media agency cut 18 monthly client reports from two days to half a day
Common questions
Does the report place orders with suppliers?
How does it handle sale items?
What does the boutique need to run it?
Get your Sundays back
Tell the AI about your business, your goals, and where your week goes, and you'll get a plan for where to start.
Get your AI Starter Plan