Sku Check Skill

Search the build

17 commits indexed

1. a55b434 2026-07-10 pills app: parse yorkwall trade price + stock, show Retail/Net/Stock boxes
2. 803ecd6 2026-07-10 pills app: add last-portal-pull cache (reads yw-results, write-through on live)
3. 59bd09a 2026-07-10 Add pills live-check app: enter MFR or DW number, tick stock/price, check live
4. 799c755 2026-07-10 auto-save: 2026-07-10T00:12:54 (1 files) — package-lock.json
5. 082a8fb 2026-07-10 chore: v1.1.0 (dryRun feature, session close)
6. 6ebeddb 2026-07-09 feat: dryRun flag on /api/check/sku (read-only preview, no tag/slack/db write)
7. 6456c3e 2026-07-09 chore: v1.0.1 (session close) — 127.0.0.1 bind fix + .deploy.conf
8. df9809b 2026-07-09 auto-save: 2026-07-09T20:42:07 (1 files) — .gitignore
9. 7329227 2026-07-09 fix: bind to 127.0.0.1 (HOST-overridable) to avoid tailscale :9963 EADDRINUSE
10. 1c12bfb 2026-05-30 fix: read GEMINI_API_KEY from process.env instead of literal unexpanded shell string
11. 008f261 2026-05-30 security: strip hardcoded dw_admin DSN password -> env-first. No rotation/deploy.
12. 46a693f 2026-05-19 ui: add rel=noopener noreferrer to all target=_blank anchors
13. 1f37fd0 2026-05-19 server: 404-guard for .bak/.pre-/.orig/.swp paths before static mount
14. 5417edf 2026-05-19 gitignore: broaden backup/swap file exclusions
15. 460f702 2026-05-13 snapshot: 1 file(s) changed, ~1 modified
16. 64a2269 2026-05-12 sku-check: log Gemini sku-image-analysis usage to cost-tracker
17. 5f2d884 2026-05-06 initial scaffold (gitify-all 2026-05-06)

Authors

• Steve16
• steve1

Creative ideas + design notes

Commits with substantial prose (≥120 chars) — the rationale behind each move.

- parseYorkwall(bodyText): MSRP (retail), NET PRICE (trade cost + discount%),
  Quantity Available (summed batches), roll width/length — scoped by section
  header since values are unlabeled table cells.
- Attach parsed to live + lastLive; robust JSON extraction from scraper stdout.
- pills.html parsedBoxes() renders Retail/Net/Stock. Verified live: 437-RD336
  = MSRP $40, Net $20 (50% off), 412 single rolls in stock.

- readLastLive(mfr): newest saved portal result by mtime, matched on the file's
  mfr field (unifies the 3 AM overnight job + app-triggered pulls).
- Endpoint attaches out.lastLive always; a successful fresh live pull is written
  back via saveLive() so the next locked/cooldown request shows it instantly.
- Use process.execPath (not bare 'node') to spawn the scraper — PATH-safe.
- pills.html renders a 'Last portal pull · Nm ago' section (hidden when a fresh
  live pull succeeded).

- POST /api/check/live resolves either a DW number or MFR number (dash-insensitive)
  via dw_mfr_crossref, returns cached catalog price instantly + attempts the live
  yorkwall trade-portal pull (Brewster/York family) via yw-costcheck.js.
- Live pull is guarded: single-flight mutex, 20s min-gap, and a 30-min lockout
  backoff whenever the portal reports locked — the UI can never hammer the login.
- public/pills.html: pill-styled input + Stock/Price pill checkboxes + Check Live.
- De-fang stale hardcoded yorkwall password; creds now come from the secrets store.

Line 28 used single-quoted '${GEMINI_API_KEY}' which is a literal string, not an env var expansion. All Gemini AI analysis calls were sending a garbage key and failing silently.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

File tree

8 files tracked. Click any to browse the source at HEAD.

• .gitignore
• ecosystem.config.js
• package-lock.json
• package.json
• public/favicon.svg
• public/index.html
• public/pills.html
• server.js

Other build journals

← Site Factory  ·  all 4 projects  ·  Slack Dm Viewer →

Export

commits.csv · feed.atom · project.json · commits.json