Excludes failed/cancelled. Pairs with revenue to spot AOV-vs-volume issues.
At a glance
Count of completed orders over the rolling 30 days. The volume number that pairs with ecwid_total_revenue to reveal whether revenue movements are driven by basket-size or by buyer count. Critical for hobby Ecwid stores where weekly swings can be large.
| What it counts | COUNT(orders WHERE paymentStatus = PAID AND created_at in window). |
| API endpoint | GET /v3/{store-id}/orders?paymentStatus=PAID. Webhook updates fire on order state transitions. |
| VAT / tax | Not relevant; this is a count, not a value. |
| Shipping | Not relevant; count-based. |
| Discounts | Not relevant. |
| Refunds | NOT deducted (the order existed; refund is a separate event). |
| Cancellations | Excluded. Cancelled-before-payment orders never count. |
| Pending payment | Excluded until cleared. |
| Currency | Not relevant; dimensionless count. |
| Channel scope | All channels where the Ecwid widget renders (WordPress site, social shops, mobile app, POS). |
| Time window | 30D vsP. |
| Alert trigger | drop >20% WoW. The threshold is wider than total revenue (15%) because order count is more volatile on small Ecwid stores. |
| Sentiment | order_count_trend. |
| Roles | owner, marketing, operations. |
Calculation
Calculated automatically from your Ecwid data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A small UK hobby photographer running an Ecwid widget on their WordPress blog, week of 21 Apr 26 to 27 Apr 26.| Metric | This week | Prior week | Change |
|---|---|---|---|
| Total Orders (this card) | 18 | 14 | +28.6% |
| Total Revenue | £620 | £495 | +25.3% |
| Average Order Value | £34.40 | £35.40 | -2.8% |
ecwid_top_products to see which prints drove the lift, and consider featuring those prominently in the next blog post.
Sibling cards merchants should reference together
| Card | Why it matters next to Total Orders | What the combination tells you |
|---|---|---|
| Total Revenue | The dollar twin. | Revenue / orders = AOV; the three are mathematically tied. |
| Average Order Value | Basket size. | Orders up + AOV down = volume growth without basket discipline; orders up + AOV up = textbook healthy growth. |
| Conversion Rate | Funnel efficiency. | Orders dropped + conversion rate dropped = funnel broken; orders dropped + conversion stable = traffic dropped. |
| Refund Rate | Quality canary. | Order count rising + refund rate rising = the new buyers are unhappy; investigate. |
| New Customers | Acquisition vs retention. | Orders up + new customers flat = repeat surge; orders up + new customers up = acquisition working. |
| Orders by Status | Status mix view. | Failed-payment and on-hold spikes show as backend issues that depress this count. |
| Top Products by Revenue | Volume drivers. | Identify which SKUs concentrated the order growth. |
| Out-of-Stock Products | Blocking input. | Orders dropping while OOS count rose = OOS is the cause. |
Reconciling against the vendor’s own dashboard
Where to look in Ecwid’s own dashboard:Ecwid Control Panel (Why our number may legitimately differ from Ecwid’s Control Panel:my.ecwid.com) -> My Sales -> Orders The order list with filterPayment status = Paidover your chosen window is the apples-to-apples comparison.
| Reason | Direction | Why |
|---|---|---|
| Time zone | Boundary days | Ecwid uses store-local; we use UTC. |
| Cancellations | Theirs higher | Ecwid sometimes counts cancelled in default views; we exclude. |
| Pending payment | Theirs higher | We wait for PAID status. |
| Test orders | Marginal | Ecwid sandboxes can include test orders; we exclude any with metadata.test = true. |
| Sync lag | Marginal | Webhook-driven; under 60s typically. |
ecwid_total_orders = ecwid_total_revenue / ecwid_aov
The three are mathematically tied; if any pair disagrees by more than rounding, raise a sync issue.
Known limitations / merchant FAQs
Why is the alert at -20% instead of -15%? Because Ecwid stores are typically smaller and noisier than full-platform stores; -15% would generate too many false-positive alerts during normal weekly volatility. -20% catches genuinely concerning drops without daily noise. Why does the count exclude cancelled orders? Because cancelled orders represent failed transactions; they did not generate revenue and should not count as “demand”. The exclusion is consistent withecwid_total_revenue.
My order count is much higher than my “paid” count. Why?
Possibly because some orders are stuck in pending-payment limbo. PayPal Pending status, manual / wire-transfer-pending orders, or “INCOMPLETE” abandoned-checkout records can inflate the total but not the paid count. Use paymentStatus = PAID filter in Ecwid Control Panel to compare apples-to-apples.
Does this include subscription renewal orders?
Yes. Each Ecwid subscription billing creates a new order; renewals contribute to this count.
My order count rose but revenue dropped. What does that mean?
AOV dropped sharply. Likely causes: (a) a flash promo brought in low-AOV impulse buyers, (b) a hero high-priced SKU went OOS forcing buyers to cheaper alternatives, (c) a discount code went viral. Check ecwid_aov and ecwid_oos_products.
Does this count test orders?
No, we exclude orders flagged as test (metadata.test = true or sandbox marker). Some merchants accidentally leave test mode on; if your numbers look implausibly high check Ecwid Control Panel for sandbox status.
My count dropped to zero overnight. What broke?
For Ecwid specifically: (1) the host site (WordPress, Wix, Webflow) may be down, blocking the widget from rendering; (2) the Ecwid widget JavaScript may have failed to load; (3) Stripe / PayPal payment rails may have an outage; (4) the OAuth token may have expired (rare; Ecwid tokens are long-lived).
Why does this exclude POS sales for some Ecwid stores?
We do not exclude POS by default; POS orders flow through the same backend. If the merchant’s setup excludes POS from this card, it is likely a manifest configuration choice (some merchants want to track widget-only revenue vs in-person separately).
Does this include in-progress / cart-abandoned orders?
No. Only PAID orders count. Abandoned carts are a separate concept tracked in conversion-rate analysis.