joecastelino
@joecastelino
Public Skills
tekion-department-opcode-census
by joecastelino
Answer "what opcodes would I need to build for department X" / "run a report of ROs closed in the <UCD/PDI/Body Shop/Express> department over the last N days". Produces the opcode list a department actually uses, classified EXCLUSIVE vs SHARED, cross-referenced against the Service Type each opcode is tagged to — which is what determines whether a GL-mapping-by-Service-Type change will actually capture the work.
tekion-duplicate-customer-record-diagnosis
by joecastelino
Confirm/refute a store claim that an RO, recommendation, or deferred service "went to a different customer number for the same customer" in Tekion. Finds duplicate customer records sharing a phone/VIN, maps which customer id each RO + recommendation was stamped with, and identifies who wrote it.
tekion-fee-not-showing-diagnosis
by joecastelino
Diagnose "the store can't see / isn't getting charged fee X" in Tekion — e.g. "SCT isn't seeing fees 1TIRE 2TIRE 3TIRE 4TIRE". Covers the Fee Management v3 API (list + per-fee detail), the ADD_TO_RO ("Allow to Add at RO Level") flag that controls whether a fee appears in the RO fee dropdown, opcode→fee attachment, and how to prove whether a fee is actually landing on real ROs. Use for any Tekion fee visibility, fee-not-auto-applying, or fee-attach-rate question.
tekion-media-api
by joecastelino
Add, read, or delete MEDIA (vehicle photos/videos/360s, and deal document files) in Tekion via the public OpenAPI. Covers the URL-reference model for Vehicle Inventory media and the 2-step presigned binary upload for Deal documents, plus how to prove write access without writing data. Use for "can we push photos into Tekion", VI image automation, vAuto/photographer feeds, or deal-doc uploads.
tekion-notification-settings-audit
by joecastelino
Definitively answer "where did notification X go / does notification Y exist / who gets notified when Z happens" in Tekion. Dumps the COMPLETE list of user notification event types (all modules) from the internal notification-preference API instead of scrolling the giant Profile Settings table, then maps the request to the right config surface (per-user Profile Settings vs Service Settings vs Dispatch vs Scheduling vs Parts Settings). Load for any "I can't find the setting that notifies ..." ticket.
tekion-coupon-management
by joecastelino
Create/edit service discount coupons in Tekion's Coupon Management app (e.g. tire promos like Bridgestone B3G1, $-off or %-off labor/parts coupons). Covers the real URLs, form mechanics (old antd calendar, react-select GL account), toggle defaults, GL split conventions, and verification. Verified live at SCT 2026-08-02.
tekion-openapi-repair-orders
by joecastelino
Pull repair orders, jobs, operations (opcode + labor $), parts, and vehicle data from the official Tekion OpenAPI — no browser, no OTP. Also covers logging into the APC partner portal (apc.tekioncloud.com) to scrape API docs and download OpenAPI specs.
tekion-menu-missing-services-diagnosis
by joecastelino
Diagnose a Tekion service-menu ticket where a manager/advisor says the menu is "missing items", "missing services", "the service didn't show up", or the package looks short — i.e. WRONG CONTENT, not wrong price. Differential diagnosis across the 4 known root causes (row tier-coverage gap, wrong baseSystemInterval stamp, row-scope miss, inert Modify-System-Services entry), all readable over the API without a browser. Sibling of tekion-quotes-menu-price-diagnosis (that one = wrong DOLLARS; this one = missing LINES).
bc-gm-menu-build
by joecastelino
The Blackstone Chevrolet & Cadillac (BC, Tekion dealer 1251) GM service-menu build project. Contains Joe's spec direction (clone the Blackstone Toyota architecture), the verified GMLOF oil-tier price audit, the parts-override plan for vehicle-correct GM parts, and open decisions. Load for ANY "GM menu", "BC menu build", "GMLOF", or Blackstone Chevrolet service menu work.
bt-tony-menu-rebuild
by joecastelino
The Blackstone Toyota (BT, dealer 1249) service-menu rebuild project for Tony Garcia (Service Manager). Tony wants menus restructured into Factory Recs / Factory Recs Plus with 25 ordered add-on services. Contains the FULL locked spec, Joe's approved decisions, the opcode audit results, and the build plan. Load for ANY "BT menu", "Tony menu", "Factory Recs", or Blackstone Toyota service menu work. STATUS 2026-07-21: full 5K–200K range (5K-step) built, PUBLISHED, Tony-validated; Phase 7 generic Transmission Fluid placeholders DONE; Phase 8 Tony's BG MENU REVAMP 2026 part-match batch DONE + quote-verified (baseline tony-partmatch-baseline-20260721.json). Remaining: x2.5K half-step menus + EV rows only.
tekion-parts-menu-attach-rate-report
by joecastelino
Build a "how many of part X were sold, and what % were bundled into a service menu vs sold à la carte" report for any Tekion store and part category (e.g. cabin filters, engine air filters, wiper blades). Combines the part-sales ledger with a cheap RO-tag menu classification. Use when Joe asks for a parts sales report that must "include service menus" / show menu attach rate.
tekion-labor-rate-create
by joecastelino
Create or complete a Tekion Labor Rate Pricing entry (e.g. a Caliber Collision wholesale-parts labor rate) via the Labor Pricing screen. Covers the list-first dedup check, the create/edit form field mechanics, and the Part Price Code gotcha (no generic "Wholesale" option — codes are custom per store).
hermes-agent-provider-switch
by joecastelino
Diagnose why an AMG agent (Walter II, Don, Ralph, Stacey, etc.) is dead/unresponsive on an LLM-billing error, and switch it from OpenRouter to the ChatGPT-Team Codex OAuth provider. Use when an agent boots but can't reply, an ask-agent ping returns an HTTP 402 (out of credits) or 400 (unsupported model), or OpenRouter credits are exhausted. Covers the read_file API-key-masking landmine and how to discover the account's valid Codex model names.
tekion-apc-docs-scraper
by joecastelino
Log into the Tekion APC partner portal (apc.tekioncloud.com) and download the full OpenAPI 3.1 specs for every REST API endpoint and every webhook event. Single continuous Playwright session (APC sessions don't persist). Use when building/maintaining the DealerDetail Fixed Ops app or any tool that needs the authoritative Tekion API/webhook schemas.
tekion-parts-autoorder-diagnosis
by joecastelino
Diagnose why parts at a Tekion store stocked out / didn't auto-order (forcing local sourcing from Sunnyvale/Capitol/etc.). The CANONICAL parts-replenishment skill (supersedes tekion-parts-shortage-diagnosis). Works from RO numbers OR part numbers. Pulls live Stocking Details (Source Code, Stocking Status, Manual Order, BRP/BSL, Min/Max, On Hand/Order, Open Documents, Transactions ledger) per part, runs the day-supply demand calc, exposes the BSL Round-Down trap and the negative-on-hand backfill trap, and produces a per-part verdict + fix (Min Qty vs source-code BRP/BSL vs in-and-out receiving discipline). Use whenever Joe asks "why aren't these parts auto ordering / why do we have shortages / why did we have to get parts locally / why is my shelf at 0 when Min is set."
tekion-clock-time-by-opcode
by joecastelino
Build an "actual tech clocked time vs billed time BY OPCODE" report (over-clock / unapplied-time-at-opcode-grain) for any Tekion store. Uses the internal rosearchservice visibility-dashboard TECH_CLOCK datasource (the engine behind the custom "Ro Actual Time Report"), which carries opcode on every clock punch — something the standard Tech Performance report cannot do (its Unapplied Hours is per-technician only). Verified SV (826) 2026-07-20.
jay-skill-pack-sync
by joecastelino
Maintain the PUBLIC skill-pack repo github.com/joecastelino/jay-skill-pack — the auto-synced, secret-redacted mirror of Jay's entire skill library, README sorted by usage count. Use when Joe asks about the skill pack repo, when a sync fails, when a new secret needs redaction, or when installing Jay's skills into another agent.
dealerdetail-persona-and-dedup
by joecastelino
Split the DealerDetail advisor dashboard by Tekion persona (SERVICE_ADVISOR vs an "Others" bucket for cashiers/warranty clerks/service managers/techs), backfill the persona column from the Tekion users API, and fix duplicate-advisor rows caused by null-name pre-scope-upgrade pulls. Use when advisor numbers look polluted by non-advisors, when you see an "Unassigned"/null advisor, when personas are 0/N populated, or when the same Tekion userId appears under two Advisor rows.
findmy
by joecastelino
Track Apple devices and AirTags via FindMy.app on macOS using AppleScript and screen capture.
local-nemotron-stt-fleet
by joecastelino
Stand up NVIDIA Nemotron 3.5 ASR (streaming, CPU ONNX) as the shared speech-to-text backend for every Hermes agent on this machine, replacing the broken faster-whisper/libcublas path. Use when voice messages arrive untranscribed or when asked to enable local speech recognition for the agent fleet.
dealerdetail-dev-setup
by joecastelino
Bootstrap the DealerDetail Next.js app for local development against the live Supabase project, verify the DB + Prisma migration state, and validate the Tekion production API before building the API-driven data pipeline. Covers credential retrieval, .env wiring, and the gotchas (Slack-mangled connection strings, missing psql, prototype-vs-API architecture). Use whenever standing up, migrating, or extending the DealerDetail Fixed Ops app.
tekion-api-upgrade-audit
by joecastelino
Audit what changed after a Tekion APC API plan/scope/app-version upgrade — rescrape specs, diff the catalog, live-probe every section for scope (read AND write) safely without touching production data. Use whenever Joe says the API was upgraded, a new tier was purchased, premium docs were authorized, or the installed app version was bumped.
hermes-slack-token-recovery
by joecastelino
Fix an AMG Hermes agent that is silent on Slack because its SLACK_BOT_TOKEN/SLACK_APP_TOKEN are missing or wrong in the profile .env — including recovering LOST tokens from old session transcripts without asking Joe to regenerate them at api.slack.com. Use when an agent's service is running but it never answers Slack messages (Autumn case, 2026-07-14).
tekion-mom-service-gross-fleet
by joecastelino
Produce a month-over-month (or any period-vs-period) SERVICE GROSS read across all 7 AMG stores from the live Tekion OpenAPI — who's winning, who's slipping, and whether it's a VOLUME story or a MARGIN story. Uses a throttle-safe sequential RO sample (labor GP + parts GP per RO) scaled by exact closed-RO counts, because the GL department-gross endpoint is still locked and a full penny-accurate fan-out trips the rate limit for hours. Use when Joe asks "service gross month over month", "who's doing well / breaking numbers across the stores", "fleet service gross May vs June", or any cross-store gross trend.