Skip to main content
Nerve Centre KPIs · Audit Profile · Sentiment Settings Audits multichannel operations health for CloudHub Insights - stock, despatch, listing, repricing and cross-channel revenue at risk - by running read-only T-SQL against the customer’s 247Cxxxx database.

​
What this audit checks

​
Authentication & access

  • TDS handshake succeeds at version 7.0 (server rejects 7.1+)
  • Read-only login has SELECT on the configured database_name (247Cxxxx)
  • Validation query returns a row (SELECT TOP 1 CompanyName FROM CompanyDetails)

​
Catalogue & inventory health

  • Out-of-stock SKUs with open demand (MasterQuantity.AvailableQuantity <=0)
  • Oversell risk - InfiniteQuantity = 1 with AvailableQuantity <=0
  • SKUs without cost price (Inventory.CostPrice NULL or 0 - blocks margin)
  • Stale inventory with stock on hand and no 30-day sales (masterinventory.Last30Day = 0)

​
Order & fulfilment health

  • Orders awaiting despatch in a non-dispatched OrderStage (OrderDetails Active = 1)
  • Despatch backlog older than 48h (OrderStageChangeLog.CreatedOn)
  • Despatch rate below threshold (dispatched orders / total via OrderStage.IsDispatched)
  • Cancellation rate above expected band (cancelled OrderStage / total)

​
Listings & catalogue accuracy

  • Errored listings (ProductStatus.Status = 0) as a share of active SKUs
  • Failed marketplace revisions (MarketPlaceListingDetails.RevisionResponse LIKE ‘%error%’)
  • SKUs without dimensions or weight breaking courier rating (Inventory Weight/Height/Length/Width NULL)

​
Repricing & buybox

  • Amazon buybox win rate below threshold (RepriceDailyReport.BuyboxOwner = 1 / total ASINs, 24h)
  • Repricer coverage gap on active Amazon SKUs (RepricingInventory vs active Amazon SKUs)
  • Overpriced SKUs losing the buybox (RepriceDailyReport.OverPricedCount)

​
Cross-channel revenue at risk

  • Out-of-stock SKUs still carrying active ad spend (cloudhub stockout JOIN amazon_ads/google_ads spend on sku/asin)
  • Catalogue drift vs marketplace - price or title differs >20% (SalesLine.SKU JOIN shopify/bigcommerce product)
  • Buybox lost on an ASIN that still has active Amazon ad spend (RepricerDaily JOIN amazon_ads spend on asin)

​
Data sources

Base URL: mssql://{host}:{port}/{database_name}
  • GET CompanyDetails - Tenant identity + connection validation.
  • GET Report_SalesReport - Revenue / margin / units (clean datetime + money).
  • GET OrderDetails - Raw orders + stage; orderdate is varchar.
  • GET Invoice - Order header, Prime/B2B flags, courier.
  • GET OrderStage - IsDispatched flag for despatch / cancel rates.
  • GET OrderStageChangeLog - Stage-change audit trail (backlog aging).
  • GET Inventory - Cost price, dimensions, status per SKU.
  • GET MasterQuantity - Live stock - stockout / backorder / oversell.
  • GET MarketPlaceListingDetails - Listing + revision responses per marketplace.
  • GET ProductStatus - Status = 0 marks an errored listing.
  • GET RepriceDailyReport - Amazon buybox + repricer pressure.
  • GET Report_Products - Pre-aggregated stock / PO snapshot.