July 23, 2026

This update is a delivery-readiness audit of the inventory now served by the production Supabase catalog. It is intentionally read-only: no product status, price, category, media, or inventory record was changed during this review.

The production storefront function is healthy and currently returns all 1,046 imported operational products. Because that function exposes only active products, the original draft catalog is now fully public. The storefront receives 2,069 sellable variants across 10 categories, with the most recent production catalog update reported as July 18, 2026 at 15:49 UTC.

The audit confirms that the migration, public API boundary, and managed-media fallback are working. It also turns the remaining cleanup into a short approval queue so price or assortment changes can be reviewed before they are written back to Supabase.

Quick client review

These findings are audit candidates, not automatic errors. A nine-cent cone or a forty-cent single-dose packet may reflect an intended per-unit calculation, but the storefront currently treats that value as the price of the cartable variant. The sellable unit needs to be confirmed before a price floor or bulk correction is approved.

The pricing provenance makes that review more important than the low-price examples alone:

The importer deliberately refuses to publish an active catalog with unit-cost fallback prices unless that risk is explicitly acknowledged. These products were safely imported as drafts and activated afterward, so the apply-time safeguard did not perform a second price signoff when their status changed.

Production inventory snapshot

The read-only public catalog check passed for the western-7457 location:

The category distribution shows why the catalog feels dense. Wraps, glass, and the broad Other bucket account for 725 products before accessories, disposables, snacks, and the smaller shelves are considered.

Snacks remain part of the existing catalog in this pass. No Snacks/Cooler split, taxonomy rewrite, or remote category change was made.

Price and sellable-unit review

The public price range is $0.09 to $310.00. The range itself is not necessarily wrong, but the low end includes products whose names describe bulk cones, displays, cases, or multi-packs while the variant price appears to represent a single inner unit.

Examples from the lowest-price queue:

The recommended next step is not a blanket price increase. Review the full 1,672-variant unit-cost-fallback queue against supplier package quantity, intended KOF sellable unit, unit cost, suggested MSRP, and current store price. The 231 products at $2 or less are simply the first visual QA batch. Approved changes can then be applied by SKU through the inventory-management boundary without rewriting the remaining catalog.

Assortment and policy review

The original compliance firewall successfully kept the five CBD-review products and 272 restricted-cannabinoid products out of this operational catalog. The live assortment still contains other product groups that deserve an explicit client decision before checkout is treated as final.

A conservative name-and-tag audit identified:

• 57 products mentioning kratom, kava, mitragynine, 7-OH, or 7-hydroxy;
• 25 medicine or health-product records, including cold medicine, pain relief, antacid, detox, and sleep-aid products;
• five nicotine-pouch products;
• non-core general merchandise such as automotive fluids, personal-care products, a large LED OPEN sign, and wholesale packaging supplies.

This audit does not make a legal determination about those products. It identifies them so KOF can decide whether each cohort remains active, needs an age or commerce rule, moves to a clearer category, or stays out of the first client-facing release.

The Other category is the clearest assortment-review queue. It currently mixes 7-hydroxy and kratom products with nicotine pouches, medicine, automotive items, personal care, and ordinary general merchandise. Keeping all 165 records under one storefront label makes both shopper navigation and staff review less precise.

Several supplier product types also expose high-confidence taxonomy review candidates:

These rows should not be bulk-moved from their display labels alone. They provide a compact batch for a client-approved category mapping. Examples include Whole Herbs Kratom Powder under Trays & Storage, wired earphones under Disposables, RAW apparel under Other or Wraps & Papers, and detox products inside Snacks.

The 48-product Snacks category currently contains 21 conventional food products, 21 drinks, and six detox or cleanse products. This is recorded as an audit fact only; the storefront hierarchy remains unchanged in this update.

Duplicate-name review

Product slugs and IDs are unique, but five names appear on more than one active product record:

• OCB - Virgin Pre-roll Cones — two records;
• OCB Organic Hemp 1 1/4 Cone Tower — two records;
• OCB Bamboo Unbleached 1 1/4 Cone Tower — three records;
• Zig Zag Pre-Rolled Cones — two records;
• Small Smell Proof Storage Bag with Hand Strap — two records.

These may represent different supplier packages rather than duplicate inventory. Before merging anything, compare the source IDs, SKUs, pack quantities, costs, and variants. If the records are intentionally separate, their public names should explain the distinction.

Media and merchandising completion

The guarded media synchronization described in the July 18 update is now complete for every existing media record. All 2,298 database media rows have a Storage path and public URL.

Managed media coverage is also visible in the public production response. For 1,025 products, the original Shopify image remains the first choice and the self-hosted Supabase asset is supplied as the browser fallback. This verifies the intended source-first delivery path for 98% of the active catalog.

The remaining 21 products use only the KOF crown:

Examples include Gambler cigarette tubes, several TOP filter-tip and tube products, glass stash jars, a Puffco Peak Pro travel pack, and Yummyland freeze-dried candy. These can be completed as a small, explicit media queue instead of rerunning the whole image pipeline.

Metadata cleanup should follow the same approach. Missing brand and description fields are concentrated in Glass, Other, and Snacks. Client-reviewed copy for featured or high-traffic items will improve the storefront more safely than generating hundreds of generic descriptions.

Tags need a presentation pass as well. The active products contain 5,352 supplier-tag occurrences across 528 distinct values. Of those occurrences, 2,790 use obvious upstream vocabulary such as Brand_, Country_, Type_, Gas Station, or General Merchandise. Those source tags remain useful for operations, but the storefront should map approved values to customer-facing badges rather than expose supplier metadata verbatim.

Stock meaning remains explicit

None of the active variants currently track KOF location inventory, and the production database has no inventory-level rows yet. The production snapshot reports 2,069 “units” because each supplier-available, untracked variant contributes one availability placeholder. That number is not a physical on-hand count.

The storefront already adapts its language to show available variants rather than claiming a quantity on hand. Before final checkout and fulfillment behavior is enabled, KOF should choose one of two explicit models:

1. keep inventory untracked and treat every order as a staff-reviewed availability request; or
2. initialize and maintain actual Western Avenue stock levels for the products approved for online sale.

Category navigation now resets cleanly

Changing a storefront category now returns the shopper to the product results heading after the new filtered list has rendered. This prevents a category click made deep in the catalog from leaving the new list stranded at the previous vertical position.

The reset is deliberately scoped to an actual shopper-initiated category change. Opening a product and using browser Back still restores the previous category, page, and scroll position. Clicking the already-selected category also avoids an unnecessary jump.

Repository delivery cleanup

THCA Reserve has been removed from the KOF workspace and main-store navigation. Its review client, dependencies, 272-product snapshot, and required local image fallbacks now live in a separate, gitignored project under source-code-context/thca-reserve.

KOF retains the shared classification firewall and optional API contract needed to keep restricted cannabinoid records out of the operational storefront. Historical THCA documentation remains as a record of the earlier compliance work, while the client-facing KOF project no longer builds, launches, or links to that separate demo.

Proposed approval order

No Supabase write is included in this update. For the next pass, the smallest safe approval order is:

1. Review the 57 specialty-ingestible records and any other non-core assortment that should not be generally cartable.
2. Approve real retail prices for the 1,672 unit-cost-fallback variants, beginning with the 231 products that have a variant at $2 or less.
3. Decide whether the five repeated-name groups should merge or receive clearer package names.
4. Replace the 21 crown-only images.
5. Reclassify or deactivate approved records from Other and Retail Supplies.
6. Fill brand, description, and tag gaps for the products that remain in the delivery assortment.
7. Choose staff-reviewed availability or real tracked inventory before enabling final fulfillment.

Once those decisions are approved, the changes can be applied narrowly to the identified Supabase records and followed by the same read-only storefront audit to verify the final public result.