Sample deliverable. Illustrative sample for a fictional brand. Not a client, not real data.

Sample Systems Diagnostic: What the Written Plan Looks Like

This is the document a Systems Diagnostic produces, written for Fernhollow Supply Co., a brand we made up. The sections match what the pricing page says the diagnostic includes. Every number is a sample, worked out with the same formula as the ops cost calculator. There is also a sample for a service business.

Prepared for
Fernhollow Supply Co. (fictional)
Prepared by
Cadence Ridge
Diagnostic fee (sample)
$3,000 typical range $2,500–$4,000
Timeline and access
about 2 weeks read-only access, no passwords
Status
Illustrative sample, not real data

1. Summary

Fernhollow Supply Co. sells outdoor and home goods on Shopify at about $150,000 a month, around 2,500 orders. The team is a founder, an ops lead, and two part-time customer service agents. A 3PL ships the orders, Klaviyo sends email and SMS, Gorgias handles support, and Google Sheets holds everything in between.

Manual work found
102 h/month
Cost per year at $32/h
$39,104
Fixes worth building now
3 of 5
Ownership actions, no build
4

What we recommend: fix account ownership this week (it costs nothing), then build the 3 fixes in section 5 in order, each as a separate Workflow Quick Win so you can stop after any one. Start with order edits to the 3PL: it removes the most re-typing and the most shipping mistakes. Two other leaks have a cheaper answer than a build, and section 6 says which.

Sample numbers. Hours come from the inputs shown with each finding, at a sample loaded cost of $32/hour. In a real diagnostic they come from your own counts, exports, and time estimates, and we say which is which.

2. Stack and workflow map

Every tool, what it does, who touches it, and how data gets from one to the next. The gaps are where the hours go.

Sample stack map for the fictional brand Fernhollow Supply Co. (illustrative, not a client). Shopify sits in the center. Automatic syncs: Shopify sends orders to the 3PL and gets tracking back, syncs natively with Klaviyo, and sends order details to Gorgias. Five manual handoffs are numbered: 1, order edits re-typed into the 3PL (about 27 hours a month); 2, return receipts moved by CSV from the 3PL to Google Sheets (about 27); 3, the Monday report built in Sheets from Shopify, Klaviyo and the 3PL (about 22); 4, where-is-my-order lookups between Gorgias and the 3PL (about 20); 5, stock reconciliation between the 3PL and Sheets (about 6.5). Ownership risks are flagged: the 3PL admin is on a contractor's email, the agency owns Klaviyo, and the report lives in a personal Drive with an API token in a script.
Stack and workflow map for the fictional brand: each tool, its job, who uses it, what it connects to, and how data moves
ToolJobUsed byConnects toHow data moves
ShopifyStorefront, orders, products, refundsFounder, ops lead, CS agents3PL, Klaviyo, GorgiasOrders go to the 3PL through its app. Order edits after that are re-typed in the 3PL portal.
3PL (warehouse and shipping)Picking, packing, shipping, return receiptsOps leadShopifyTracking flows back to Shopify. Return receipts and stock counts come as an emailed CSV.
KlaviyoEmail and SMS flows, campaignsFounderShopifyNative Shopify integration. Campaign numbers are copied into the weekly report by hand.
GorgiasCustomer service inboxCS agentsShopifyShows order details next to each ticket. Agents check 3PL status in a second tab.
Google SheetsWeekly report, returns log, stock reconciliationOps lead, founderNothing directlyCopy and paste from Shopify, Klaviyo, the 3PL CSVs, and ad dashboards.

3. Where time and money leak

5 findings, largest first by cost. Hours use the calculator's formula: count × minutes ÷ 60 for per-order and per-return work, hours per week × 52 ÷ 12 for weekly work, then × 12 for a year and × $32/hour for cost.

  1. Returns checked across three tools

    Gorgias → 3PL CSV → Shopify → Sheets

    For each return, an agent checks eligibility in Shopify, waits for the 3PL receipt CSV, matches it by hand, issues the refund, and logs it in the returns sheet.

    Sample inputs
    180 returns × 9 min ÷ 60
    Hours
    27 h/month · 324 h/year
    Cost per year
    $10,368
  2. Order exceptions re-typed into the 3PL portal

    Shopify → 3PL

    Address fixes, item swaps, and holds made in Shopify after an order reaches the 3PL do not sync. The ops lead re-types each one in the 3PL portal and checks it went through.

    Sample inputs
    2,500 orders × 8% need a touch × 8 min ÷ 60
    Hours
    26.7 h/month · 320 h/year
    Cost per year
    $10,240
  3. The Monday report is built by hand

    Shopify, Klaviyo, 3PL, ad dashboards → Sheets

    Every Monday the ops lead copies sales, refunds, email revenue, shipping times, and ad spend into one sheet. Two of the formulas break when a column moves.

    Sample inputs
    5 h/week × 52 ÷ 12
    Hours
    21.7 h/month · 260 h/year
    Cost per year
    $8,320
  4. “Where is my order?” tickets answered by lookup

    Gorgias ↔ 3PL

    Agents open the 3PL portal to find a status the customer could have seen in the shipping confirmation. Most of these tickets get the same three answers.

    Sample inputs
    2,500 orders × 16% open a ticket × 3 min ÷ 60
    Hours
    20 h/month · 240 h/year
    Cost per year
    $7,680
  5. Stock counts reconciled in a spreadsheet

    3PL CSV ↔ Shopify ↔ Sheets

    Twice a week the ops lead compares the 3PL stock CSV with Shopify inventory and fixes differences by hand. Most weeks fewer than ten SKUs differ.

    Sample inputs
    1.5 h/week × 52 ÷ 12
    Hours
    6.5 h/month · 78 h/year
    Cost per year
    $2,496

Total: 101.8 hours a month, 1,222 hours a year, $39,104 a year at $32/hour. Sample numbers, not a benchmark. Errors, refunds sent by mistake, and late shipments are left out, the same as in the calculator.

4. Vendor and data-ownership risks

Who holds admin on each tool, whether the brand could get its data out today, and which keys and connections exist. Most of the fixes here are an email or an afternoon, not a build.

Vendor and data-ownership risks for each tool in the fictional brand's stack
ToolWho holds adminExportsKeys and connectionsAction
ShopifyOwner account on the founder's brand email. Good.Products, customers, and orders can be exported from the admin. No copy has been taken.A custom app made by a former developer still has write access to orders and products. Nobody knows what uses it.Find what calls that app, then remove it or cut its access to what it needs.
3PL portalThe only admin login is a former contractor's personal email.Stock and return CSVs arrive by email to that same address, forwarded by a rule.Shopify connection set up under the contractor's login.Ask the 3PL to make a brand email the admin and move the CSV emails to a shared inbox. No build needed.
KlaviyoCreated by a former email agency. The brand has a user seat, not the owner role.Profiles and lists have never been exported.Agency still has an active login.Request the owner role, export profiles, and remove the agency login once that's done.
GorgiasFounder is the account owner. Good.Ticket history not exported. Low risk while the account is in the brand's name.No custom keys found.None now. Recheck if a build connects to it.
Google SheetsThe weekly report lives in a former freelancer's personal Google Drive, shared with the team.If the freelancer deletes it or leaves Google, the report and its history go too.A script in the sheet holds a Shopify API token in plain text.Copy the file to a brand-owned Drive, revoke that token, and keep keys out of the sheet.

For the full account-by-account list, see the vendor exit checklist. For how Cadence Ridge asks for and returns access during a diagnostic or build, see security and data handling.

5. Prioritized roadmap

The top 3 fixes, in the order we would build them. Each has a fixed quote inside the Workflow Quick Win range on the pricing page ($3,500–$7,500), and a payback worked out with the calculator's formula. Tool and running costs are billed to the brand directly and are not in the quote.

  1. Fix 1

    Sync order edits to the 3PL, with an exception queue

    Finding: Order exceptions re-typed into the 3PL portal

    Scope

    • Address, item, and hold changes in Shopify pushed to the 3PL automatically
    • Anything the 3PL rejects lands in one review queue with the reason
    • A daily summary of what synced and what didn't
    Fixed quote (sample)
    $5,500 Workflow Quick Win
    Assumed share automated
    60% of 26.7 h/month
    Value after running costs
    $452/month after $60/month in tools
    Estimated payback
    12.2 months

    Working: $10,240 a year ÷ 12 × 60% − $60 = $452/month. $5,500 ÷ $452 = 12.2 months.

    What stays human

    Orders already picked, split shipments, and anything the 3PL rejects. The ops lead decides each one.

  2. Fix 2

    Build the Monday report automatically

    Finding: The Monday report is built by hand

    Scope

    • Shopify, Klaviyo, 3PL, and ad numbers pulled into the existing sheet layout
    • Checks that flag a missing source or a number that moved more than expected
    • The sheet moved to a brand-owned Drive
    Fixed quote (sample)
    $4,500 Workflow Quick Win
    Assumed share automated
    70% of 21.7 h/month
    Value after running costs
    $455/month after $30/month in tools
    Estimated payback
    9.9 months

    Working: $8,320 a year ÷ 12 × 70% − $30 = $455/month. $4,500 ÷ $455 = 9.9 months.

    What stays human

    Reading the numbers, writing the comments, and deciding what to change that week.

  3. Fix 3

    Match returns and draft refunds for approval

    Finding: Returns checked across three tools

    Scope

    • Eligibility checked against the return policy when the request comes in
    • 3PL receipts matched to the return automatically
    • A refund prepared for an agent to approve in one step
    Fixed quote (sample)
    $6,500 Workflow Quick Win
    Assumed share automated
    50% of 27 h/month
    Value after running costs
    $392/month after $40/month in tools
    Estimated payback
    16.6 months

    Working: $10,368 a year ÷ 12 × 50% − $40 = $392/month. $6,500 ÷ $392 = 16.6 months.

    What stays human

    Every refund is approved by a person. Damaged items, exceptions to the policy, and unhappy customers stay with an agent.

All 3 fixes: $16,500 in fixed quotes, bought one at a time. The share automated and the running costs are sample assumptions; in a real diagnostic they are checked against your workflow before the quote is final.

6. What we don't recommend yet

A diagnostic should also say what not to pay for. For this brand:

  • Don't build a custom order-status bot yet

    Most “where is my order?” tickets ask for something the customer already has. Start by putting the tracking link up front in the shipping confirmation and using Gorgias's Shopify integration and macros (saved replies) you already pay for. Recheck the ticket count after a month before paying for a build.

  • Keep the stock check manual for now

    At about 1.5 hours a week, this work costs less a year than the starting price of a Workflow Quick Win, so the calculator says it is not worth automating yet. Ask the 3PL whether its existing Shopify connection can sync stock, keep using Shopify Flow for the low-stock alert you already have, and revisit when the catalog grows.

  • No AI agent replying to customers on its own

    The ticket volume doesn't justify it, and refunds and complaints need a person. Drafts that an agent approves, as in fix 3, are enough.

  • Don't replace Google Sheets

    The team knows it and the report works once it fills itself. A dashboard tool would add a subscription and a new thing to learn without saving more hours.

  • Fix the account ownership first

    The ownership actions in section 4 cost nothing but an email or an afternoon. Do them before any build, whoever builds it.

When a workflow lives mostly inside Shopify, read Shopify Flow vs. custom automation before paying for a build.

7. Next steps

How the diagnostic fee is credited

The Systems Diagnostic starts at $2,500 (typical range $2,500–$4,000). The fee is credited toward your first build if it starts within 30 days. What the Systems Diagnostic includes.

In this sample: the diagnostic fee was $3,000. If fix 1 ($5,500) starts within 30 days, the $3,000 is credited toward it. After 30 days the quote still stands as written, without the credit.

What happens next

  1. Fix account ownership. The actions in section 4, done by your team, whoever builds next.
  2. Pick the first fix. Each quote is fixed and written; nothing starts until you approve the scope.
  3. Or stop here. The written plan is yours to keep and act on at your own pace.

Illustrative sample for a fictional brand. Not a client, not real data. Fernhollow Supply Co. is an invented brand; any resemblance to a real company is accidental. Tool names are used only to describe a typical stack and do not imply endorsement.

Ask About a Diagnostic