Data sources
Every source Morgan needs, its real current state, and the specific thing standing in the way of each one.
Which store is licence OCM-CAURD-24-000055-D1?
The export carries a licence number and no store name. Morgan will not guess — a wrong store list poisons every downstream join.
Set. The store detail page now shows this data, with a banner stating that the attribution was made by a person.
The export contains exactly ONE licence, so it covers ONE store - it is not a multi-store extract. Nothing in the file (no store name, address, or location column) identifies which store. The '-D1' suffix indicates the first dispensary premises on this licence. The licence is a New York OCM CAURD licence, which rules OUT the Oregon store; Rochester, Buffalo, Batavia and Monroe Ave are all NY and all remain possible. Do NOT assign this data to a named store until the licence number is confirmed against Flowhub location credentials.
Oregon is disabled above because it is OLCC-regulated, and this is a New York OCM licence. That is the one thing the file rules out on its own.
Connection status
2 of 8 sources have ever returned data. Tested live when this page opened.
| Source | State | Last success | Next | Action |
|---|---|---|---|---|
| Discrepancies export · OCM-CAURD-24-000055-D1A Flowhub-versus-Metrc reconciliation export, imported as a file. The only source in this dashboard that has ever produced a figure. | SNAPSHOT | 09 Sep 2026 | manual re-import only | |
| Flowhub · Rochester (Monroe Ave)Reconciliation export for licence OCM-CAURD-24-000055-D1, imported 09 Sep 2026. A file import, not a live connection — the Flowhub API is still IP-allowlisted. | SNAPSHOT | unknown | hourly in business hours, once connected | |
| Flowhub · BuffaloFlowhub credentials for Buffalo are in the vault; the API is IP-allowlisted and not yet reachable. | NOT CONNECTED | unknown | hourly in business hours, once connected | |
| Flowhub · BataviaFlowhub credentials for Batavia are in the vault; the API is IP-allowlisted and not yet reachable. | NOT CONNECTED | unknown | hourly in business hours, once connected | |
| Flowhub · OregonFlowhub credentials for Oregon are in the vault; the API is IP-allowlisted and not yet reachable. | NOT CONNECTED | unknown | hourly in business hours, once connected | |
| Metrc · batch & complianceMetrc needs two keys. Arcovo's Integrator/Vendor key is not in the vault, so no store can be queried. | BLOCKED | unknown | with each inventory pull, once unblocked | |
| Supabase · Morgan tablesproducts_master, store_inventory_snapshot, sales_velocity and aging_buckets have not been created. Nothing this dashboard shows is persisted anywhere. | NOT PROVISIONED | unknown | — | |
| customers-export.csvReceived and read: 99 rows, one column of UUIDs. It carries no name, no date, no order and no spend, so nothing in this dashboard is built on it. | RECEIVED | 09 Sep 2026 | — | no analysable columns |
What every badge in this dashboard means
Five provenance states, and where each one genuinely applies today.
- LIVE
Computed from a real source that refreshed successfully.
The whole Reconciliation page, and every figure drawn from licence OCM-CAURD-24-000055-D1.
- DERIVED
Computed from live data by a heuristic no human has confirmed yet.
Brand and cultivator views. A naming convention covers 14.6 % of rows and no human has confirmed it.
- STALE
Real data whose last refresh failed or aged out. Its age is shown.
Nothing today: no connected source has aged past its refresh window. The state exists so a failed pull keeps its last-good data rather than blanking.
- SAMPLE
Demonstration data, pending connection. Never a production figure.
Sales velocity, Aging buckets, Reorder & buying — in full, every mark, every tile.
- UNAVAILABLE
The value could not be produced — a join failed or the field does not exist.
Every batch number, every compliance state, and every figure for a store that has never connected.
What Morgan found wrong with the data
Real findings from the 7,395-row export, in its first hour.
- 48 rows
48 packages carry an invalid Metrc label
Every malformed tag is free-typed junk entered into Flowhub's package field ('123', 'ghv', 'Cthulhu fghftxfgn', 'pre metrc 10'). Metrc's join key is Flowhub regulatoryId = Metrc Label, so for these rows the batch join is IMPOSSIBLE - Morgan must render batch as 'unavailable', never blank and never borrowed from another record. This is the single clearest real-world example of Morgan's required failure semantics.
- 226 rows
226 packages report a negative quantity in Metrc
Metrc is reporting a NEGATIVE on-hand quantity - impossible in reality, means more units were reported sold/transferred than were ever received.
- 3,430 rows
Product names match on only 8.6 % of shared packages
Flowhub and Metrc name the same package differently on almost every row (e.g. Flowhub 'Blackberry Kush T2 AIO (2g)' vs Metrc 'Timeless AIO T2 - 2000mg Disposable Vape - Blackberry Kush'). Name is NOT a safe join key; the package tag is. This quantifies the size of Morgan's SKU normalisation problem.
- 1,838 rows
1838 rows have a blank Type
A blank Type is not missing data - it is the export's encoding for 'package reconciles, no discrepancy'. All 1,838 such rows have Difference = 0. Morgan should relabel these 'in agreement' rather than show an empty cell.
- 3 rows
3 rows carry fractional quantities under a unit of "Each"
Reporting UOM is 'Each' on 99.4% of rows, yet some Flowhub quantities are fractional (e.g. 18.400000000000002) - float drift plus gram-weighted product counted as 'Each'. Round for display; do not round before differencing. Raw values such as '18.400000000000002' and '4.8999999999999995' arrive from the source system already float-damaged.
- 7,395 rows
This export covers one licence, and therefore one store
One licence, one store. This export CANNOT populate a multi-store view. Any per-store comparison in the dashboard must be labelled sample/demo pending the remaining store connections.
Open questions for Goodlife
Things Morgan cannot answer on its own, surfaced rather than guessed.
Which stores are in Morgan V1, and what are their licence numbers?
Definition of Done V2
Rochester
Buffalo
Oregon
V1 Requirements Checklist
Rochester
Monroe Ave
BLA
1Password vault
Rochester
Buffalo
Batavia
Oregon
- Is "Monroe Ave" the Rochester store’s address, or a separate store?
- Is "BLA" the Batavia store, or a category of store (Bona-fide Labor Agreement)?
- Is Batavia in V1 (vault) or deferred (client scope answer)?
- No document states a licence number for any store, so the one real licence cannot be attributed.
No document in the corpus specifies a column-level Supabase schema.
The four table names are agreed; their columns are not. The tech spec also names cultivator_volume, audit_log and a per-store credential vault that the V1 checklist does not. The types in this build are Morgan’s own proposal, not a specification anyone has signed off.