Analyzes Easy All plans Not yet verified on a live store

Yesterday's Sales Snapshot

/yesterday-sales  Yesterday's sales, orders, AOV and top products in five lines, compared with the same weekday last week.

Add to Sidekick

Add opens your Shopify admin with the skill prefilled; review it there and click Add. If nothing appears, use Copy and follow the steps below.

The skill

Suggested shortcut: /yesterday-sales
Give me yesterday's sales snapshot, in the shop's timezone.

## Steps
1. Pull yesterday's total sales, order count, average order value and sessions.
2. Pull the same four numbers for the same weekday one week earlier, so Monday compares with Monday.
3. List the top 3 products by revenue yesterday with units sold.
4. Note anything unusual: a refund larger than the average order, a product that sold out, or a traffic spike from one source.

## Output
Five lines maximum: one line per metric with the week-ago comparison in brackets, then one line for the top 3 products, then one line for anything unusual or "Nothing unusual." No headings, no chart.

If yesterday had zero orders, say so and stop. Do not make recommendations in this skill.
How to add it to Sidekick
  1. Click Add to Sidekick above. Your Shopify admin opens with the skill ready to review. Click Add. Done.
  2. If the button does nothing in your store: click Copy skill, open Sidekick in your admin, type /, choose Create new skill, name the shortcut yesterday-sales, paste the text as the instructions, and save.
  3. To run it, type /yesterday-sales in Sidekick. Sidekick keeps up to 25 skills; manage yours from the skills menu.

What you get

A five-line text message you can read in ten seconds, for example: “Sales 612 (vs 540 last Tuesday, +13%) · Orders 14 (vs 13) · AOV 43.70 (vs 41.50) · Sessions 388 (vs 402) · Top 3: Classic Tee ×6, Tote ×4, Mug ×3 · Unusual: one refund of 96.”

When to use it

Every morning with coffee. It is deliberately short so you will actually run it.

Variations

  • “Also show new versus returning customers” adds one line.
  • Ask for “the last 3 days as three rows” after a weekend.

Limits

Sessions and conversion depend on Shopify’s analytics tracking. Stores with heavy bot traffic will see inflated session counts; the order numbers are the reliable part.

Status: Written for Sidekick but not yet run on a live store. Results may need a second prompt. Time saved: about 5 min / day.

Author: MerchantSkill · License: CC0, no attribution needed · Updated: 19 Sept 2026 · Raw markdown

Report a problem or suggest an edit

Related skills

/weekly-review Analyzes Easy

Weekly Sales Review

One-screen weekly review: revenue, orders, AOV, top and declining products, and three actions for the week.

Analytics Not yet verified
/orders-today Analyzes Easy

Daily Orders Brief

A morning brief of what needs doing in orders: new, to fulfil, on hold, returns pending, and anything odd.

Orders Not yet verified
Add to Sidekick