Analytics πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick analytics b2b

Report Wholesale and B2B Order Share

Separate B2B/wholesale company orders from consumer orders to see how much revenue, margin, and volume each channel contributes.

πŸ“‹ Prompt
Run in Sidekick
Split revenue and order volume between B2B/wholesale (company account) orders and regular consumer orders for [LAST 90 DAYS].

Per channel:

  Order count
  Revenue
  % of total revenue
  AOV
  Average gross margin % (using cost-per-item), since B2B pricing usually runs thinner margin than consumer
  Top 5 products by revenue within each channel


B2B-specific detail:

  Top 10 company accounts by revenue in the period
  % of B2B revenue from repeat company orders vs a company’s first order
  Average order size for B2B vs consumer


Output format:

  Table: channel, orders, revenue, % of total, AOV, avg margin %
  Top-10 company accounts table


Deliverables:

  Both tables
  A clear comparison of unit economics between the two channels β€” which one drives more revenue vs which one drives more margin dollars β€” since those can point in different directions and change how much sales effort each channel deserves

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions