Skip to main content
Card class: Non-Hero • Category: Ecommerce Platform

​
At a glance

Anomaly alert that fires when consolidated gross margin % drops by more than 2 percentage points vs prior 30-day period. A 2pt margin drop on 10mmonthlyrevenue=10m monthly revenue = 200,000/month of erased gross profit, immediately. Margin compression is one of the strategically dangerous metrics: small drops compound, and once normalised, they are hard to reverse without painful pricing actions.
Trigger thresholdgross_margin_pct(this 30D) - gross_margin_pct(prior 30D) < -2.0 pts. Floor: only fires if revenue is non-trivial (>$100k 30D).
Signal interpretationA 2pt drop typically points at: (1) cost inflation (supplier-side pricing increase absorbed by the merchant); (2) freight cost spike (fuel surcharges, carrier rate increases); (3) mix shift toward lower-margin SKUs; (4) discount escalation; (5) FX exposure (importer cost rose because supplier currency strengthened).
Recommended action(1) Open Margin by SKU: drop concentrated on specific SKUs (SKU-specific cost) or broad (freight, FX, mix)? (2) Cross-reference Landed Cost Variance. (3) Decide: pass cost through to customer (price increase), absorb (margin hit), or shift product mix.
Time window30D vsP
Rolesowner, finance, merchandising

​
Calculation

Calculated automatically from your NetSuite data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

An AU electronics manufacturer / distributor on NetSuite OneWorld. Alert fired Monday 04 May 26. Alert payload:
MetricThis 30DPrior 30DDelta
RevenueA$3,820,000A$3,720,000+2.7%
COGSA$2,840,000A$2,640,000+7.6%
Gross margin %25.7%29.0%-3.3 pts
Implied profit lost-A$126,000--
3.3pt margin drop on flat-ish revenue. Investigation:
  1. Open Margin by SKU: 18 of the top 50 SKUs show margin drops of 4 to 8 points. Concentration is among AU-imported electronics (chargers, cables, accessories from Asian suppliers).
  2. Cross-reference Landed Cost Variance: freight costs from Asia to AU rose 28% in the period (carrier rate increase + sea-freight surcharge).
  3. Cross-reference FX Currency Exposure: AUD weakened 4% against USD in the period, raising the AUD-cost of USD-denominated supplier invoices.
  4. Cross-reference Revenue by Class: no mix shift detected (revenue spread across product classes is unchanged).
  5. Conclusion: 1.8pts of the drop = freight/carrier rates (transient, may reverse), 1.2pts = AUD weakening (FX, may reverse), 0.3pts = miscellaneous.
Action:
  • Pass-through: raise list prices 4 to 6% on the 18 affected SKUs (the AUD-cost increase is real; customers should bear it). Estimated margin recovery: 2 of the 3.3 pts.
  • Don’t pass through: the freight surcharge is volatile and may drop in 30 to 60 days; absorb temporarily. Recovery on rate normalisation.
  • Hedging: the FX gap could justify an AUD/USD forward hedge for the 90D pipeline of imports; cost ~0.5% of notional.
  • Cross-reference Pricing Adjustment Memos: ensure no mass-pricing-update accidentally erased margin.
Outcome (60 days later):
  • 2.0pt of price-action recovery.
  • 0.8pt of freight-rate normalisation.
  • 0.5pt residual still under investigation.
  • Net margin recovered to 28.0% (1pt below original baseline; sustainable).

​
Sibling cards merchants should reference together

CardWhy pair it with Margin Compression
Gross Margin %The headline metric.
Margin by SKUDecomposition: which SKUs drove the drop.
Margin Erosion AlertsPer-SKU equivalent.
Landed Cost VarianceCause check on supplier / freight pricing.
FX Currency ExposureCause check on currency.
Total COGSThe denominator change.

​
Reconciling against the vendor’s own dashboard

This is an alert card; reconciliation is via the underlying Gross Margin % metric. NS Income Statement at Reports > Financial > Income Statement gives the period-over-period margin view. Threshold tuning: 2pp default suits stable-margin distribution. Apparel businesses with ±5pp seasonal swings tune to 4pp. SaaS / services with very stable margins tune tighter to 1pp.

​
Known limitations / merchant FAQs

My margin always drops in Q4 because of holiday discounting. Suppress? Yes. Configure seasonality in the manifest. Q4 promotion-driven margin drops are expected; the alert is for unexpected drops. A 2pt drop sounds small. Why is it material? Because gross profit at typical mid-market scale is 6 to 8 figures monthly. 2pt on 10mrevenue=10m revenue = 200,000/month or $2.4m/year. Compounded if not corrected. My OneWorld account: per-subsidiary alerting? Yes. UK subsidiary’s margin drop independent of US. My margin dropped, but cost actually didn’t change. What happened? Mix shift: lower-margin SKUs took a higher share of revenue. Cross-reference Revenue by Class and the per-SKU mix view. Should I always raise prices when this fires? No. Three options: (1) raise prices (preserve margin, may lose volume), (2) absorb (preserve volume, lose margin), (3) shift mix (rebalance toward higher-margin products). The right choice depends on competitive position and customer elasticity. Inventory write-downs cause margin drops; will the alert fire on those? Yes. NS write-downs hit COGS in the period, dropping margin. If the write-down is a one-off (clearance event, dead-stock cleanup), suppress via period flag; if structural (chronic write-downs), the alert is the right signal.

​
Tracked live in Vortex IQ Nerve Centre

Margin Compression is one of hundreds of KPI pulses Vortex IQ tracks across NetSuite and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.