pneumatic wrist device — active leads crm wip
working view of the suppliers we plan to actually engage. loads all rows from crm.csv (one row per verified lead; the canonical data store — never hardcoded in this page). editable columns (stage, owner, next step, notes) persist in this browser (localStorage); non-editable columns (company, contact, tier, confidence, credit rating) always reflect the current csv.
loading csv…
paste a JSON snapshot to import (merges with current state)
| stage | company | 中文 | conf | contact | owner | next step | notes | credit | product link |
|---|
workflow
stage definitions — recommended transitions:
- new — on the radar, no contact yet
- contacted — first message sent, awaiting reply
- engaged — replied, in active conversation
- quoted — received pricing / capability data
- shortlist — finalist for next round (sample, NDA, audit)
- pass — declined or unresponsive
data source
this page is a view over crm.csv (the project's canonical CRM store, kept in sync with leads_clean.csv and stage-2 verify results). to add a lead: append a row to crm.csv with the right lead_id, then reload this page. to update non-editable fields (company, contact, tier, confidence, credit tier): edit the csv.
credit tier — alibaba.com credit-rating badge, sourced manually (per ishmael 2026-06-20). canonical tokens: credit-low (信用较弱), credit-medium (中等), credit-ok (良好), credit-great (优秀), credit-missing (not looked up). credit_source column carries the provenance ("per ishmael YYYY-MM-DD, alibaba.com").
product link — every row has a direct link to its product. one row per company: where stage-2 produced multiple L-rows for the same company (e.g. 智惠宇 with 5 air-pump offers), they're collapsed into a single row whose lead_id is the joined list (e.g. L008 + L024 + L025 + L051 + L052), with all 5 product URLs in website (semicolon-separated) and all 5 labels in product_link_label (||-separated). The UI renders the multi-link case as a <details> with one link per offer.
csv path on the server: ~/srv/projects/pneumatic-wrist-leads/crm.csv · local workspace copy: ~/.openclaw/workspace/projects/pneumatic_wrist_device_leads/crm.csv