Order-status answers with live order and 3PL data
Let the helpdesk answer “where’s my order?” from real order, carrier and warehouse data.
- Annual value
- $86K$108K$127K
- Hours a month
- 150 h180 h205 h
- Effort
- Low
- Confidence
- High
Discovery & Action Plan
Fernway Outfitters
Outdoor apparel & gear · $62M online revenue · 140 people
Chapter 00
We spent three weeks with your customer experience, catalog, fulfillment and finance teams. This plan recommends three changes to start now, four to validate first, and five to leave alone, with the evidence for each.
The short version
Fernway’s teams spend 58% of their week moving, finding and relaying information. Three changes give back about 320 hours a month.
3 changes, ready to start
Let the helpdesk answer “where’s my order?” from real order, carrier and warehouse data.
Read supplier sheets, fill your product schema and flag gaps before review instead of after.
Find stuck orders before customers do, with the fix already drafted.
Time returned, at $38/h loaded cost Other benefits
Don’t automate refunds, and don’t replace Gorgias with a custom chatbot. Defer demand forecasting until product and sales data are cleaner. In each case the cost or risk outweighs the gain today.
See the reasoningChapter 01
Three weeks inside Fernway’s operation. We interviewed the people doing the work, watched it happen, sampled the data behind it and checked every idea against the tools you already pay for.
In scope
Out of scope
3 weeks · 15 sessions
Maya Lindqvist, Chief Operating Officer · Tom Reyes, Director of Customer Experience
Priya Nair, CX Team Lead · Jordan Blake, CX Agent
Elena Ruiz, Merchandising Manager · Sam Okafor, Catalog Specialist
Marcus Chen, Operations Manager · Ava Thompson, Fulfillment Coordinator
Rachel Kim, Controller · Daniel Osei, FP&A Analyst · Grace Liu, AP Specialist
Lena Hoffman, Wholesale Coordinator
Chris Patel, IT & Systems Lead
Mia Johansson, Product Copywriter
Noah Williams, Product Lead · Hannah Moore, CX Agent, Returns
Tom Reyes, Director of Customer Experience · Priya Nair, CX Team Lead
Elena Ruiz, Merchandising Manager · Sam Okafor, Catalog Specialist
Maya Lindqvist, Chief Operating Officer · Tom Reyes, Director of Customer Experience · Marcus Chen, Operations Manager · Rachel Kim, Controller
2 need action first
ShipBob3PL & warehouse
Exceptions visible only in portal exports. One shared admin login.
AirtableProduct data
Acts as the product database; 12% of live SKUs disagree with Shopify.
NetSuiteERP
Orders sync nightly; product data is keyed in separately from Shopify.
Loop ReturnsReturns
Return reasons captured as free text and never analyzed.
Excel & SheetsUsed everywhere
Trading report, PO macro, exception tracker and launch calendar.
Shopify PlusStorefront & orders
Reliable record of orders and customers. Tags used consistently.
GorgiasHelpdesk
Current macros and tags. AI agent is included in your plan but switched off.
KlaviyoEmail & SMS
Well configured. In scope only for content generation.
ConnectedManual handoffsAction needed
Chapter 02
Fernway’s operation as it really runs, organized so leadership can absorb it in a few minutes.
58% of in-scope time goes to moving, finding and relaying information. Systems can absorb most of it. 24% is judgment that should stay with people, made faster. 18% is the work you hired them to do.
By team
ManualHandoffJudgment
As documented
As it actually runs 5 manual steps
As documented
As it actually runs 6 manual steps
As documented
As it actually runs 7 manual steps
As documented
As it actually runs 5 manual steps
As documented
As it actually runs 4 manual steps
| Exception | Per month | Resolution | Pattern | Owner |
|---|---|---|---|---|
| No carrier scan after 72 hours | 410 | 1.8 days | Repeatable | Fulfillment |
| Split shipment confusion | 260 | 0.6 days | Repeatable | CX |
| Address validation failure | 180 | 1.2 days | Repeatable | Fulfillment |
| Backorder not communicated | 140 | 2.4 days | Repeatable | CX |
| Missing attributes at review | 120 | 4.5 days | Repeatable | Catalog |
| Damaged in transit | 95 | 3.1 days | Judgment | CX |
| Invoice price mismatch | 72 | 2.0 days | Repeatable | Finance |
| Return without authorization | 64 | 1.5 days | Repeatable | Fulfillment |
| Wholesale PO line mismatch | 19 | 2.2 days | Repeatable | Fulfillment |
| Suspected fraud or chargeback | 14 | 5.0 days | Judgment | Finance |
92% of exception volume follows a repeatable pattern that a system can resolve or prepare. Damage claims and fraud stay with people.
A personal spreadsheet macro reformats every retailer PO. When its owner is out, wholesale orders wait. Nothing is documented.
62% of 3PL exceptions are first reported by a customer. First response reaches 14 hours at peak.
Attributes live in Airtable, Shopify and NetSuite. 12% of live SKUs disagree on at least one field, including 41 with wrong care instructions.
About $4,100 a month is credited without reason codes or approval limits.
Five people share one ShipBob admin account. Fix this before any automation is given access.
Finance and merchandising report different numbers for the same week, so meetings start by reconciling.
Shopify is a reliable record of orders and customers, with consistent tags.
Current Gorgias macros give an AI agent good material from day one.
Catalog already has a style guide and attribute list. Rare, and exactly what automation needs.
11 of the 16 people we interviewed asked for help with the same three tasks.
Chapter 03
Twelve opportunities, each sized from the evidence and checked against the tools you already have. Values are net of the review and exception work each change introduces.
Clear value, proven approach, ready to start.
Promising. One question to answer before building.
Not now. Revisit when the conditions change.
Little gain, or the risk belongs with people.
Today
3,720 order-status tickets a month, 38% of volume. Agents copy details from Shopify, the carrier site and the ShipBob portal. First response reaches 14 hours at peak.
Proposed
Switch on Gorgias’ AI agent for order-status questions, grounded in Shopify orders and carrier tracking. Add a small integration so it can see ShipBob exceptions, and hand anything unusual to an agent with the facts attached.
Where people stay in control
Refunds, address changes, damaged items and VIP customers always go to an agent. Your CX lead approves the answer rules before launch and reviews a weekly sample.
Approach
Live in week 5Confidence: High
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Today
2,600 new SKUs a year arrive in more than 30 supplier formats. Each takes about 42 minutes to key, check and publish; launches wait 19 days on average for product data.
Proposed
An extraction workflow that reads supplier files, maps attributes to your listing standard, drafts titles and descriptions in your voice and flags missing care, sizing or material details at intake.
Where people stay in control
Merchandisers review every record before publication. Material, sustainability and safety claims require a source document.
Approach
First category in week 9Confidence: Medium
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Today
About 1,140 orders a month hit a 3PL exception. Ops finds them by exporting reports twice a day; 62% surface only when a customer writes in.
Proposed
A daily monitor that joins ShipBob, Shopify and carrier events, classifies each exception, drafts the fix and the customer update, and posts a prioritized queue to Ops every morning.
Where people stay in control
Ops approves reships, refunds and anything over $150. Customer messages use approved templates.
Approach
Live in week 7Confidence: High
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why validate first. Two definitions of net revenue are in use. Automating now would automate the disagreement.
To validate: Finance and merchandising agree one definition of net revenue and of returns timing.
Today
The Monday report takes two days of an analyst’s time and reaches leadership on Tuesday afternoon.
Proposed
Agree metric definitions, automate the data pull and reconciliation, and draft commentary on the biggest movements with links to the underlying numbers.
Where people stay in control
The FP&A analyst edits the commentary; the Controller signs off before circulation.
Approach
4 weeks after definitionsConfidence: Medium
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why validate first. This is a solved problem. Buying beats building, if a product fits your NetSuite setup.
To validate: Confirm two shortlisted products handle your multi-currency suppliers.
Today
About 520 supplier invoices a month are matched by hand. 14% have price or quantity mismatches that take a day or more.
Proposed
Evaluate two AP automation products that integrate with NetSuite. Configure matching rules and route mismatches to the buyer with the PO and receipt attached.
Where people stay in control
AP approves every payment; buyers resolve mismatches.
Approach
6 weeks after selectionConfidence: Medium
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why validate first. The value depends on whether the free text holds a usable signal. A short pilot will tell.
To validate: A two-week tagging pilot on one season’s returns.
Today
Return reasons are free text in Loop. Nobody reads them systematically, so fit and quality issues reach product teams months late.
Proposed
Classify return reasons weekly, link them to SKUs and factories, and send a short brief to product and sourcing.
Where people stay in control
Product decides what to change; the brief only surfaces patterns.
Approach
Pilot in 2 weeksConfidence: Low
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why validate first. Modest volume today. Worth it if wholesale grows as planned; the single-person risk needs fixing either way.
To validate: Confirm the 2027 wholesale forecast. Document the macro now regardless.
Today
310 POs a month arrive as PDFs and emails. One coordinator keys them into NetSuite with a personal macro.
Proposed
Extract line items from incoming POs, check them against price lists and stock, and create draft sales orders for the coordinator to confirm.
Where people stay in control
The coordinator confirms every order and handles retailer exceptions.
Approach
6 weeksConfidence: Medium
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why defer. Eighteen months of reliable history and stockout-distorted data make a custom model unreliable today. Use NetSuite’s planning features and clean SKU data first; revisit next year.
Today
Buying uses spreadsheets and last year’s sales; frequent stockouts distort the history.
Proposed
A custom forecasting model trained on sales, traffic and seasonality.
Where people stay in control
Buyers own every purchase decision.
Approach
6+ monthsConfidence: Low
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why defer. Small time saving and real brand risk. Your creative standards for generated imagery aren’t set yet; revisit once they are.
Today
Two lifestyle shoots a season cover hero products only.
Proposed
Generate supporting lifestyle images from product photography.
Where people stay in control
Creative approves every image.
Approach
—Confidence: Low
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why defer. Not a bottleneck, and Klaviyo already includes it. Your marketing team can trial it without us.
Today
Marketing writes three to four campaigns a week with light segmentation.
Proposed
Trial Klaviyo’s built-in AI features for subject lines and variants.
Where people stay in control
Marketing approves all sends.
Approach
—Confidence: Medium
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why not recommended. Refunds are a small share of tickets but carry most of the fraud and policy risk. Keep them with agents; O1 and O3 give agents the context to decide faster.
Today
Refunds are 4% of tickets and are approved by agents within policy limits.
Proposed
Automatic approval of refunds that meet policy rules.
Where people stay in control
Agents approve all refunds today.
Approach
—Confidence: High
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Why not recommended. Gorgias’ own AI agent covers the need (O1). A custom build adds cost and maintenance with no clear gain.
Today
Gorgias handles every channel and already includes an AI agent.
Proposed
A custom assistant integrated with Shopify and ShipBob.
Where people stay in control
—
Approach
—Confidence: High
The value, worked through
Assumptions
Data it needs
Risks to manage
How we’ll measure it
Chapter 04
A 13-week plan to deliver the three recommended changes and settle the four open questions. Each phase ends with a measured result and a decision about what comes next.
Order-status answers live and measured.
Exceptions caught early; first category through the pipeline.
Your team running the pipeline; open questions answered.
Hours a month
1.92.32.7 full-time roles of net capacity. We recommend using it for peak-season cover, faster launches and supplier management rather than reducing headcount.
Net annual value
$140K$202K$269K
Conservative $140K · Upside $269K
Before build fees, which are fixed and quoted separately. Values are estimates from discovery; the plan measures each against a baseline.
Built for you
We build and launch it. Your team approves and adopts it.
Integration-heavy work with a clear outcome. We build and launch it; your CX lead and Ops manager approve the rules and review results.
Built with you
Your team builds it with us, then owns it.
Catalog work changes every season, so it should be owned in-house. Your merchandiser co-builds the first category with us, then leads the rest with our review.
Your team
Low-risk changes your team can make with our checklist.
Definitions, a product evaluation and a feature trial. We provide a short checklist and review the outcome.
| Area | Keating & Co | Fernway Outfitters |
|---|---|---|
| Answer rules and tone | Draft, test against real tickets | CX lead approves before launch |
| Integrations and access | Build, document, monitor | Grant least-privilege access; IT reviews |
| Catalog pipeline | Co-build first category, then review | Merchandiser owns from week 10 |
| Measures and reporting | Baselines and a fortnightly scorecard | COO reviews and decides next steps |
| Support after launch | 60 days of close support included | Choose: your team, a partner or us |
Complete
This document.
Proposed
Fixed scope and fee, quoted on approval. Discovery fee credited in full.
Optional
Monthly support after 60 days of close support, or a handover to your team.