Skip to content
MSO CloudDocumentation

Commerce data

On this page

Orders, products, inventory, creators, reports and customer operations over the organization's own data.

orders#

Source: apps/web/src/server/routers/orders.ts

Procedure Type Access Description
orders.summary query authedProcedure KPI cards on the landing dashboard.
orders.dailyGmv query authedProcedure Daily time-series for line charts.
orders.opsStatus query brandProcedure Ops Floor status: a single SQL fetch that returns three operationally useful breakdowns for the /workspaces/ops dashboard: 1.
orders.list query brandProcedure —
orders.getDetail query brandProcedure Single-order detail — lazy-loaded by the orders drawer.

creators#

Source: apps/web/src/server/routers/creators.ts

Procedure Type Access Description
creators.list query brandProcedure —
creators.topByGmv query brandProcedure —
creators.detail query authedProcedure —
creators.leaderboard query authedProcedure —
creators.previewCostsCsv mutation rateLimitedBrandProcedure, manage_finance parse + preview, no write (ux-d finding 5).
creators.importCostsCsv mutation rateLimitedBrandProcedure, manage_finance —

inventory#

Source: apps/web/src/server/routers/inventory.ts

Procedure Type Access Description
inventory.currentLevels query brandProcedure Latest quantity-on-hand per product.
inventory.expiringSoon query brandProcedure Products with expiry in the next N days.
inventory.riskTable query brandProcedure —

products#

Source: apps/web/src/server/routers/products.ts

Procedure Type Access Description
products.list query brandProcedure —
products.categoryOptions query brandProcedure —
products.updateCategory mutation rateLimitedBrandProcedure —
products.codeBook query brandProcedure this org's installed SKU code book, so a server-rendered catalog can decode its own SKUs in one read instead of one call per row.
products.decodeSku query brandProcedure Decode one SKU against the org'S own code book (never another tenant's —

subscription#

Source: apps/web/src/server/routers/subscription.ts

Procedure Type Access Description
subscription.events subscription authedProcedure Server-sent event stream of real-time events per organization (order.created, order.status_changed, inventory.below_reorder_point, creator.hour_spike), read from a Redis stream.

attribution#

Source: apps/web/src/server/routers/attribution.ts

Procedure Type Access Description
attribution.refresh mutation rateLimitedBrandProcedure, owner or admin —
attribution.byOrder query brandProcedure —
attribution.byCreator query brandProcedure —
attribution.byCampaign query brandProcedure —
attribution.shoppers query brandProcedure —

audiences#

Source: apps/web/src/server/routers/audiences.ts

Procedure Type Access Description
audiences.list query orgProcedure —
audiences.presets query orgProcedure —
audiences.get query orgProcedure —
audiences.previewCount mutation rateLimitedOrgProcedure, manage_audiences —
audiences.upsert mutation rateLimitedOrgProcedure, manage_audiences —
audiences.delete mutation rateLimitedOrgProcedure, manage_audiences —
audiences.refreshNow mutation rateLimitedOrgProcedure, manage_audiences —
audiences.members query orgProcedure —

cases#

Source: apps/web/src/server/routers/cases.ts

Procedure Type Access Description
cases.list query orgProcedure —
cases.get query orgProcedure —
cases.acknowledge mutation rateLimitedOrgProcedure, manage_cases —
cases.resolve mutation rateLimitedOrgProcedure, manage_cases —
cases.escalate mutation rateLimitedOrgProcedure, manage_cases —
cases.slaList query orgProcedure —

activation#

Source: apps/web/src/server/routers/activation.ts

Procedure Type Access Description
activation.destinationsList query orgProcedure —
activation.upsertDestination mutation rateLimitedOrgProcedure, manage_activation —
activation.runs query orgProcedure —
activation.runSync mutation authedProcedure, manage_activation Run an audience-sync.

campaigns#

Source: apps/web/src/server/routers/campaigns.ts

Procedure Type Access Description
campaigns.list query brandProcedure —
campaigns.create mutation rateLimitedBrandProcedure —
campaigns.end mutation rateLimitedBrandProcedure —
campaigns.performance query brandProcedure —
campaigns.elasticity query brandProcedure —

reports#

Source: apps/web/src/server/routers/reports.ts

Procedure Type Access Description
reports.activePlatforms query brandProcedure —
reports.orgMenuLabels query orgProcedure —
reports.commercePerformance query authedProcedure Parallel-phase pattern (see bloCreator):
reports.settlement query authedProcedure —
reports.liveCommerce query authedProcedure —
reports.holidayCalendar query brandProcedure —
reports.aiCubeBriefing query authedProcedure —
reports.cohortRfmKol query authedProcedure —
reports.operations query authedProcedure —
reports.bloLatestOrderDate query brandProcedure —
reports.bloOverview query authedProcedure —
reports.bloSku query authedProcedure —
reports.bloCreator query authedProcedure —
reports.bloLivestream query authedProcedure —
reports.creatorDirectory query authedProcedure —

marketplace#

Source: apps/web/src/server/routers/marketplace.ts

Procedure Type Access Description
marketplace.overview query authedProcedure —