Products

	Name	Variant code / SKU	Category	Default sales price	Cost	Profit	Margin
				MYR	MYR	MYR

Showing 1–18 of 333 (sample rows from Katana snapshot)

Per page

Project Gaia — static mockup in Filament v3 table idiom. No backend. Sample data: Katana tenant snapshot 2026-04-12.

Products — field manifest

Field	Filament component	Type	Source	FK target
Name	TextColumn::searchable(isIndividual)->url()->sortable()	string (product / variant)	derived: product.name + ' / ' + variant option values; one grid row per variant	variants.id
Variant code / SKU	TextColumn::searchable(isIndividual)	string, nullable	stored: variants.sku — separate field, not derived (BBeast rows show variant in Name but empty SKU)	—
Category	TextColumn::badge() + SelectFilter	string lookup	stored: items.category_id (End Product, Tea Powder observed)	categories.id
Default sales price	TextColumn::money('MYR')	money MYR, nullable	stored per variant; 0 on most rows, blank (never set) on 2 rows in sample	—
Cost	TextColumn::money('MYR') (not filterable)	money MYR	derived: inventory engine cost — moving average / BOM + operations roll-up	—
Profit	TextColumn::money('MYR')->color(fn) red when negative	money MYR	derived: default sales price − cost (verified on every dump row)	—
Margin	TextColumn::state(fn) — blank when price 0	percent, nullable render	derived: profit ÷ default sales price; engine suppresses divide-by-zero (blank on all sample rows)	—
Prod. time	— (dropped: empty across entire snapshot)	duration	derived: total production time rolled up from recipe/operations rows	—
Active / Archive tabs	Tabs (lifecycle filter); Archive view not captured	bool flag	stored: items.archived_at	—
Bulk actions	BulkAction: Bulk edit / Archive / Delete / Export	action	Katana toolbar icon cluster (download, print, edit, archive, delete)	—

Profit = Default sales price − Cost, computed per row (all dump rows verify exactly).
Margin = Profit ÷ Default sales price, rendered blank when sales price is 0 — engine suppresses divide-by-zero instead of showing 0% or infinity.
Cost is engine-computed (moving average / BOM roll-up) — non-filterable column with 2-decimal values on items whose sales price was never set.
One grid row per variant, not per product: "Double Root Coffee" appears 3× with variant codes 2023-01 / 2024-01 / 2024-02; Name concatenates product name + ' / ' + variant option values.
Item count "333 items" is the total across pagination/virtual scroll, not the rendered rows.
"Import done." toast in capture — products support async CSV import with completion notification.
No totals/footer row on this grid — no tfoot summarizer.
Money always suffixed "MYR"; Katana shows negatives with plain minus — mockup upgrades negatives to Filament red per idiom.
Bulk actions: BulkAction::make('bulkEdit')->form(...) (category / price / batch tracking); ->archive() sets items.archived_at; ExportAction runs via the Filament export job (async notification, same pipeline as the import toast); DeleteBulkAction is policy-guarded — deletable only when no stock_movements rows reference the variant, so items with ledger history are skipped (archive instead — GMP immutability). Toolbar Export CSV icon runs the same export over the filtered set when nothing is selected.