merchmix-product-review-be

Creates merchandise performance reviews for selected departments, categories, subcategories, brands, stores, seasons, and reporting periods.

The review pipeline resolves calendar bounds, queries current-year and prior-year metrics, retrieves terminal CSOH and WSSI-derived values, assembles a hierarchy tree, applies weeks-of-cover goals, and persists a versioned compressed PRV artifact.

Lets retail users retrieve available reviews and inspect their current status or a specific historical version.

REST handlers list reviews by period, return current or versioned artifact bytes, expose artifact status, and decode stored PRV blobs into diagnostic review nodes.

Provides detailed style-level size breakdowns so users can investigate product performance beyond the summary hierarchy.

The size-breakdown route executes a dynamic SQL query for a style code within a review scope and returns its size-level performance data.

Allows merchants to record comments, highlights, lowlights, actions, and executive summaries against a review.

Review artifacts contain dedicated commentary columns, with REST and MCP operations for reading and updating commentary.

Generates AI-written review commentary to help merchants prepare trade discussions and summaries.

The write-AI operation is backed by an optional OpenAI configuration and writes generated content to the review artifact; the environment configuration indicates the feature degrades when AI credentials are absent.

Exports a merchandise review into an Excel workbook for offline analysis and sharing.

The export handler builds an XLSX workbook using rust_xlsxwriter and exposes it through the review export route.

Schedules review delivery to a mailbox through email or Slack, including recurring delivery options.

Delivery schedules store channel, destination, mailbox, send time, recurrence, subject, message, and status. A background delivery scheduler handles scheduled dispatch, cancellation, and immediate-send flows.

Creates and delivers recurring weekly summaries of merchandise performance, including KPIs, risks, winners and losers, opportunities, and prioritized actions.

The service manages weekly briefing schedules and runs, supports preview and test execution, stores JSON briefing summaries, and runs a background scheduler plus an internal dispatch endpoint.

Stores and updates client-specific settings used when preparing product reviews, including weeks-of-cover goal bands and overrides.

The settings API reads and writes persisted review settings; WocGoalSettings supports default and brand/category/subcategory-level thresholds with validation.

Provides season information and reporting-period calendar context used to select and build reviews.

The seasons endpoint reads season data, while pipeline calendar modules resolve weekly, monthly, quarterly, and seasonal bounds and latest available weeks.

Uses WSSI planning data to enrich reviews with budget and stock-related merchandise metrics.

A generated tonic client implements the WssiService contract with GenerateWssi and GetBudgetExportValues RPCs; the review pipeline also fetches WSSI aggregates and derives metrics such as terminal stock and budget values.

Allows AI agents and other compatible clients to perform review, settings, and weekly briefing operations through a tool interface.

An MCP Streamable HTTP server exposes tool wrappers over the existing HTTP handlers, with tenant resolution from the X-Client-ID request header and host/origin restrictions.