Release Planner

What this page gives you

Release Planner is the operational handoff from concept planning to release execution. It combines product values, concept fallback, recipe and production signals, plus custom metadata in one release-readiness view.

What this page is for

Use Release Planner to monitor whether each product is ready to launch, already released, or missing key details. It is the control surface for readiness checks before teams move into packaging and sales execution.

Quick workflow

1. Choose Pending or Released.
2. Review metadata definitions in the top panel and update field setup if needed.
3. Scan rows for readiness gaps using the colour cues.
4. Click Edit on a product to update product values and metadata.
5. Use metadata Confirmed toggles to mark reviewed values.
6. Export CSV when needed from the datatable export button.

Which products appear on this page

Included

All non-deleted products appear, including products not created from drafts.

Filter source

Status uses effective_release_window = COALESCE(product.release_window, draft.release_date).

Not shown

If both product.release_window and draft.release_date are null, the product does not match either status filter and is hidden.

Status filter logic

Pending

Effective release window is today or later.

Released

Effective release window is before today.

Brew date and production status behavior

Brew Date source

If an unstarted schedule exists, show scheduled brew date. Otherwise show actual batch creation date(s).

Production Status source

Shows one status badge per non-cancelled batch for the active recipe.

Production status labels shown

• Planned
• Brewing
• Brew Finishing
• Cellaring
• Ready for Packaging

These labels are normalized from lower-level batch states.

Colour and visual guide

Readiness colour legend

red usually means concept fallback or missing final value, black (neutral) usually means target is set, and green means set, confirmed, or complete.

How to interpret quickly

Scan for red cells first to find release blockers, then verify green confirmations before launch.

Column rules and colour semantics

Column	Display source	Signal rule
Product Name	product.title, else draft title fallback	green if product title exists, red if only fallback or blank
Alternative Name	Product value, else draft fallback	green if product value exists, red otherwise
Recipe	Active recipe brand link, if present	neutral
Brew Date	Scheduled date (pre-batch) or batch creation date(s)	green when showing actual batch-created date(s)
Production Status	Batch production status badge(s)	Badge styling, not red/green text driven
Series	Product series, else draft series fallback	green if product series exists, red otherwise (cell also tinted with series colour)
Style	Product style, else draft style fallback	green if product style exists, red otherwise
ABV	Recipe target ABV, else product/draft ABV	neutral when recipe target ABV exists, red otherwise
BBT Volume	Product BBT volume, else draft fallback	neutral when recipe exists and product BBT volume exists, red otherwise
Price Tier	Product tier, else draft tier fallback	red when product tier is not set
Release Window	Product release window, else draft release date fallback	red when product release window is not set
Metadata columns	Per definition value	green when value is marked confirmed

Metadata definitions workflow (top panel)

1. Review existing definitions shown as draggable pills.
2. Add, edit, or delete fields as needed.
3. Reorder definitions to match your release review flow.
4. Save changes; reorder persists immediately and the page reloads on success.

Field types:

• Text
• Date

Metadata value workflow (product edit modal)

• Each metadata definition appears in the product form.
• Every value has a Confirmed toggle.
• Date fields use date input UI.
• Important rule: when a metadata value changes, confirmation is automatically cleared unless confirmation is explicitly set in that same save.