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.
| Tool | Job | Used by | Connects to | How data moves |
|---|---|---|---|---|
| Shopify | Storefront, orders, products, refunds | Founder, ops lead, CS agents | 3PL, Klaviyo, Gorgias | Orders 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 receipts | Ops lead | Shopify | Tracking flows back to Shopify. Return receipts and stock counts come as an emailed CSV. |
| Klaviyo | Email and SMS flows, campaigns | Founder | Shopify | Native Shopify integration. Campaign numbers are copied into the weekly report by hand. |
| Gorgias | Customer service inbox | CS agents | Shopify | Shows order details next to each ticket. Agents check 3PL status in a second tab. |
| Google Sheets | Weekly report, returns log, stock reconciliation | Ops lead, founder | Nothing directly | Copy 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.
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
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
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
“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
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.
| Tool | Who holds admin | Exports | Keys and connections | Action |
|---|---|---|---|---|
| Shopify | Owner 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 portal | The 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. |
| Klaviyo | Created 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. |
| Gorgias | Founder 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 Sheets | The 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.
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.
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.
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
- Fix account ownership. The actions in section 4, done by your team, whoever builds next.
- Pick the first fix. Each quote is fixed and written; nothing starts until you approve the scope.
- 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.