The Real Problem
You run a lifestyle retail store with both a physical shop in Mt Eden and a Shopify online store. Last month you turned over $38,000. Sounds good. But which products actually made you money after shipping, returns, and the 15% Trade Me commission? Which channel is worth your time — your own website, Trade Me, or the pop-up market you did in Parnell?
You don't know. Because the data lives in five different places.
Your sales are in Shopify. Your accounting is in Xero. Your Trade Me sales are in a separate seller dashboard. Your Instagram ad spend is in Meta. Your supplier invoices are in your email. To answer a simple question like "what was my actual margin on the ceramic range last month?" you'd need to open four tabs, export three spreadsheets, and spend two hours cross-referencing.
Research shows NZ owner-operators spend 36% of their work week on administrative tasks — over 16 hours. Much of that time is spent switching between systems, manually compiling information that should be at your fingertips. You're drowning in data but starving for insight.
So you make decisions on gut feel. You reorder the products that feel like they're selling well. You keep running the Instagram ads because they seem to be working. You don't cut the underperformers because you can't actually prove they're underperforming.
Why Existing Tools Don't Solve This
Shopify has built-in analytics, but it only sees Shopify data. It doesn't know your cost of goods (that's in Xero), your Trade Me performance, or your marketing spend. Shopify reports tell you what sold — not what was profitable.
Xero shows your finances but doesn't break down profitability by product or channel. You can see total revenue and total expenses, but not "the ceramic mugs had a 62% margin in-store and a 31% margin on Trade Me after fees."
There's no affordable tool in the NZ small retail stack that sits across all your systems and synthesises the information into actionable intelligence. Enterprise retailers use platforms like Power BI or Tableau, but those cost thousands and require a data analyst to configure. You just need someone to tell you what's working and what isn't.
How AI Solves This
Every Monday morning, your AI assistant sends you a weekly business briefing on WhatsApp. You've set it up by sharing export files from your key systems — Shopify sales CSV, Xero profit and loss, Trade Me seller report, and Meta ad spend summary.
AI (WhatsApp, Monday 7:30am):
Weekly Briefing — 3-9 March 2026
Revenue: $9,240 total ($6,100 Shopify, $2,340 in-store, $800 Trade Me)
Top performers: Summer linen range — 23 units, 58% margin. Restock recommended by Friday.
Watch list: Ceramic mugs — 4 units sold, sitting on 38 units of stock. At current velocity, that's 9+ weeks of inventory. Consider bundling or clearance pricing.
Channel insight: Trade Me margin is 24% after fees vs. 55% on your own site. The 3 Trade Me sales of the wool throw would have earned you $87 more through Shopify.
Marketing: Instagram ad spend $120, attributed to 6 sales ($410 revenue). Cost per acquisition: $20. Facebook ad spend $80, attributed to 1 sale ($45 revenue). Recommendation: pause Facebook, reallocate to Instagram.
Action items:
- Reorder summer linen — supplier lead time is 10 days
- Create a ceramic mug bundle offer for this week's social content
- Pause Facebook ads, increase Instagram budget to $150
- Review Trade Me listing fees — consider listing only high-margin items
You read it over coffee. In five minutes, you know more about your business than you'd learn from two hours of spreadsheet diving.
How It Works
Your workspace includes:
- Weekly data exports — you drop in updated CSVs each Sunday evening
- MARGINS.md — your cost of goods and supplier pricing for margin calculations
- CHANNELS.md — fee structures for Trade Me, Shopify Payments, market stalls
- GOALS.md — your targets for revenue, margin, and stock turnover
The AI cross-references these files to produce the briefing. It flags anomalies, identifies trends, and makes specific recommendations.
The Result
- One briefing replaces hours of spreadsheet work — data from every system, synthesised into plain language
- Channel profitability exposed — you see real margins after fees, not just top-line revenue
- Slow-moving stock identified early — before it becomes a write-off
- Marketing spend optimised — clear cost-per-acquisition by channel
- Decisions backed by data — reorder, discount, and budget decisions based on evidence, not gut feel
What AI Can't Do Here
- AI won't connect to your systems automatically — you provide the data exports (CSVs, screenshots, or forwarded reports)
- AI won't replace a full-time accountant or financial adviser for tax and compliance
- AI analysis is only as good as the data you provide — missing or inaccurate inputs produce misleading insights
- AI won't make decisions for you — it provides recommendations, you decide
Who This Is For
- Owner-operators selling across multiple channels (own site, Trade Me, markets, in-store) who can't see the full picture
- Retailers making reorder and pricing decisions based on gut feel instead of data
- Any NZ small retailer who uses Shopify and Xero but has never seen a combined profitability report
- Solo operators spending hours on admin who need a smarter way to understand their numbers