All Case StudiesRetail & E-commerce

You're Selling Plenty. You Just Don't Know What's Actually Profitable.

How AI synthesises data from Shopify, Xero, and your marketing channels into a weekly briefing — so you stop guessing and start making decisions.

4 min readUpdated 2026-03-15Based on Claude Sonnet 4 / GPT-4o

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 Trade Me's success fees? 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:

  1. Reorder summer linen — supplier lead time is 10 days
  2. Create a ceramic mug bundle offer for this week's social content
  3. Pause Facebook ads, increase Instagram budget to $150
  4. 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.

How We Set This Up

None of this works if the AI is just a standalone chatbot with no connection to your actual business. That's why BestAI builds a custom integration program — a piece of software that bridges your AI assistant with the systems you already use.

For this kind of setup, that means:

  • Embedding the AI assistant into your website as a live chat widget
  • Connecting the AI to WhatsApp and Facebook Messenger so customers can reach you on the channels they already use
  • Syncing with your calendar so AI-booked appointments appear in your real schedule
  • Linking to your accounting or invoicing system so nothing gets lost between quote and invoice
  • Setting up email notifications and automated follow-up sequences
  • Building your knowledge base from an initial interview and keeping it updated as your business evolves

Here's our process:

  1. We map your current workflow — We sit down with you and figure out what tools you're using and how enquiries currently flow through your business.
  2. We build the connections — Our developers write a custom program (an API connector) that lets the AI talk to your systems. No manual data entry, no copy-pasting between apps.
  3. We test end-to-end — Every workflow gets tested with real scenarios before going live. Nothing launches until it works reliably.
  4. We maintain it — When your business changes, we update the integration to match.

You don't need to be technical. We handle all the development — you just tell us how your business runs, and we make the AI fit into that.

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

Want This for Your Business?

Book a 45-minute workflow review and we'll show you exactly how this applies to your specific situation, no obligation, no fluff.