Categories / Operations & Inventory
Multi-store sales and stock reporting
Sports nutrition brand · 5–8 hours a week saved on reporting
- Task
- stop reviewing each store separately and hand-maintaining Google Sheets; use sell-through to drive promos vs reorders
- Result
- 10+ Shopify stores connected in one view; 5–8 hours/week saved on reporting; marketing adopted sell-through reports to run promos on overstock
- Tools
- Prediko (cross-store reports, Sell-Through Rate report, SKU health, reorder recommendations); Shopify
- Setup
- connect all Shopify storefronts → standardize product types/data structure → run unified sales reports filtered by store/product type → use Sell-Through Rate report weekly: low sell-through → marketing promo
- high → reorder from Prediko recommendation
Send this to your AI
A ready-to-send prompt built from this card. Your AI will ask a few questions about your business, then give you a beginner setup plan.
Copy prompt
Help me set this up for my business: "Multi-store sales and stock reporting".
Example business: sports nutrition DTC brand (own production; 10+ Shopify stores across markets). Task: stop reviewing each store separately and hand-maintaining Google Sheets; use sell-through to drive promos vs reorders.
Reported result: 10+ Shopify stores connected in one view; 5–8 hours/week saved on reporting; marketing adopted sell-through reports to run promos on overstock
Tools: Prediko (cross-store reports, Sell-Through Rate report, SKU health, reorder recommendations); Shopify
Setup outline:
1. connect all Shopify storefronts → standardize product types/data structure → run unified sales reports…
2. high → reorder from Prediko recommendation
First, ask me up to 5 questions about my business and tools. Then give me a beginner step-by-step setup plan, plus copy-paste prompts/templates I can use. Plain English, and tell me if any step needs a tech helper.
via autopilotbusiness.ai/use-case/sports-nutrition-brand-prediko-unified-reports-across-10-shopify-store/Step-by-step setup guide + copy-paste prompt
> Cost: Paid. Prediko starts at $49/month (Shopify billing, 14-day trial). Your combined sales decide the tier.
Honest note: these are reports and rules-based recommendations, not a chatbot. "5–8 hours a week saved" and marketing adopting the reports come from Prediko's own case study. The idea is simple and useful for anyone with more than one store: low sell-through means promote it, high sell-through means reorder it. Sell-through rate is units sold ÷ (units sold + stock left at the end).
Prerequisites
- Two or more Shopify stores you own (for example one per country).
- Product types and SKUs named the same way in each store. Tidy this first; it makes the combined reports usable.
- Someone in marketing who will act on the weekly report.
Step-by-step setup
Step 1. Install Prediko on your main store. Install Prediko from the Shopify App Store and create your account.
Step 2. Add your other stores through Prediko. Go to Settings → Connected Stores → Add Shopify Store and connect each store from inside Prediko (don't install it separately in each store). The first sync can take up to 8 hours.
Step 3. Combine matching locations. If several stores ship from the same warehouse, go to Settings → Inventory Settings → Connected Locations → Combine Locations so stock isn't counted twice. The Buy table always shows the combined picture. In the Plan, you can filter by store.
Step 4. Build the sell-through report. Open Reporting from the main menu and choose Sell Through Rate. Add filters for store and product type, then save it as a view.
Step 5. Send it every week. In the report, click Schedule Send, add the marketing and purchasing emails, choose weekly and a time, set the start date and click Schedule. Export sends you an Excel copy whenever you want one.
Step 6. Agree the rule with your team. For example: under 20% sell-through over 30 days → marketing runs a promotion; over 70% → purchasing checks the Buy table and reorders. Pick thresholds that suit your products.
Step 7. Reorder from one place. On the Buy tab, use the Reorder or Buy Now view, tick products, click Create draft order and send.
Easier: let your AI do it
Prediko has an official MCP server, so an AI chat can read your reports and, with your OK, draft orders. In Claude, open Settings → Connectors → Browse connectors, search Prediko and click Connect (or Add custom connector with https://mcp.prediko.io/mcp). ChatGPT needs a paid plan with developer mode (Settings → Advanced settings), then Settings → Connectors → Create. Ask: "Which products have the lowest sell-through across all stores this month, and which store holds the most of each?"
What success looks like
One weekly email replaces ten store-by-store checks. Marketing picks promotions from the slow-sellers list, and purchasing reorders the fast-sellers before they run out.
Common issues & fixes
- Products show up twice: the stores name the same product differently. Align SKUs or product types.
- Stock looks doubled: locations shared by several stores haven't been combined.
- A new store has no data yet: wait for the first sync (up to 8 hours).
Optional: Maintenance
- Each quarter, review your promote/reorder thresholds.
- When you open a new store, add it in Connected Stores and check its locations.
Copy-paste prompt
Here is this week's sell-through report across my Shopify stores: [PASTE PRODUCT, STORE, UNITS SOLD, STOCK LEFT, SELL-THROUGH %].
1. List the 5 products to promote and the 5 to reorder, with one line of reasoning each.
2. Flag any product that sells well in one store but sits in another, and suggest moving stock instead of buying more.
3. Write a 3-line summary I can paste into our team chat.
Use only the numbers I gave you.Sources
- Case: Prediko case study (sports nutrition brand, 10+ stores). Credit: the brand's operations team (vendor-published).
- Prediko Help: How do I connect more than one store?
- Prediko Help: Reports
- Prediko Help: Can I schedule reports to my inbox?
- Prediko Help: Views on the Buy Table
- Prediko Help: How to create a Purchase Order
- Prediko Help: Connect Prediko to AI agents
- Prediko pricing
Industries: AI automation for E-commerce & Shopify Stores
Results as reported by the source; not independently verified. Community-sourced from public sites and attributed to the source platform. Original author? Ask us to correct or remove it. Read the disclaimer.