Project Quote · August 12, 2026 · TIN Development

Canolight Spec Coverage — Tier 1+2 Loader

A focused loader-script engagement that closes ~87% of the Canolight PDP-spec gap in 6 hours, using catalogue data we already extracted.

$280Total development
0.75 daysEstimated timeline
6 hoursTotal effort
LowProject complexity
Canada Lighting SuppliesPrepared for
The Project

Canolight Spec Coverage — Tier 1+2 Loader

1,341 active Canolight products exist in Neon. 1,138 already show structured specs on the storefront (84.9% usable). The remaining 203 show "Specifications available upon request" because supplier_products.specs is empty for them. The blocker isn't extraction, it's matching: a Gemini 2.5 Flash pass over the April 2026 general catalogue (General-Catalogue-Canolight-April-2026.pdf) already produced catalogue-extraction.json on July 6 with 547 structured SKUs, and a separate August staging file magnetic-track-products.json holds 462 magnetic-track records. We just need a small, idempotent loader script that matches these against the un-matched 203 in Neon and writes structured specs back.

💡Key insight: Of the 203 unmatched Canolight products, 117 (57.6%) are exact-SKU matches against the catalogue extraction and 61 more (30.0%) are family/prefix-fuzzy matches against a known parent SKU. That's 178 products (~87%) fillable in hours, not weeks — no Gemini calls, no PDF re-parsing, no website crawl. Only 25 accessory-only SKUs (string-light kits, endcaps, signal repeaters) need a separate follow-up plan.
Closes 87% of the Canolight spec gap (178 of 203 unmatched products)
Idempotent — safe to re-run after each catalogue re-extraction
Brand PDP coverage jumps 32.4% → ≥85% usable with zero downstream changes
Pricing Model

Model tiers — actual OpenRouter ratios

Each phase is assigned the tier that matches its complexity. Rates are derived from real model output costs on OpenRouter, with Claude Sonnet 4.5 as the baseline.

Opus
Claude Opus 4.6
$100/hr
Development rate
1.67× baseline
Complex AI · Multi-agent systems · Novel architecture · Deep reasoning
Sonnet
Claude Sonnet 4.5 · GPT-4o
$60/hr
Baseline
1× baseline
Standard features · Integrations · APIs · Backend development
Haiku
Claude Haiku 4.5 · GPT-4o mini
$20/hr
0.33× baseline
Actual ratio
Automations · Templates · CRUD · Config · Scaffolding
Implementation

Project phases & costs

#PhaseTierDaysHoursRateCost
1
Canolight Spec Loader — Tier 1+2
Build scripts/specs-from-canolight-catalogue.ts — a reusable idempotent loader. Tier 1: exact-SKU upsert from catalogue-extraction.json (117 SKUs). Tier 2: family/prefix-fuzzy parent-SKU fill (61 SKUs) using safe inherit-then-override rules with the variant suffix noted. Safe with --dry-run flag for staging rollout.
  • 178 of 203 unmatched products gain structured specs
  • Idempotent — safe to re-run after each catalogue re-extraction
  • 25 Tier-3 SKUs surfaced as an explicit fallback list for follow-up
 Sonnet 0.5d 4h $60/hr $240
2
Verification + Coverage Re-publication
Run __specs_coverage_production.ts against the live Shopify PDPs. Build a per-brand coverage delta report and surface the diff to confirm Canolight jumps 32.4% → ≥85%. Tag and commit the loader + verifier; surface the Tier-3 list as a follow-up ticket.
  • Pre/post coverage numbers captured and committed to repo
  • Re-run the canonical __specs_coverage_production.ts from any machine
  • Tier-3 fallback list handed off to a separate workstream
 Haiku 0.25d 2h $20/hr $40
Total 0.75 6h — $280
Running Costs

Ongoing operating costs

The loader itself is pure data-mapping and has no LLM operating cost. The optional recurring cost is a quarterly re-extraction of the catalogue PDF using Gemini 2.5 Flash to pick up new SKUs added by Canolight.

RE-RUN ON DEMAND
$0/mo
loader only — no LLM cost
QUARTERLY RE-EXTRACT
$30/mo
$90/quarter · Gemini 2.5 Flash
MONTHLY RE-EXTRACT
$100/mo
billed by usage · includes AI audit
Impact

Per-brand coverage delta

203 → 25
Unmatched SKUs
178 PDPs switch from "available upon request" to full specs
32.4% → ≥85%
Brand usable-coverage
matches eiko / eurofase effective range
6 hrs
Total engineering time
vs. original 1–5 day regex-prose mapper approach

Project Approval & Sign-off

By signing below both parties agree to the scope, timeline, and costs outlined in this quote. A 50% deposit is required to commence work. Balance due on completion.

Name & title
Name & title
$280 development + ongoing operating costs per schedule above
Canolight Spec Coverage — Tier 1+2 Loader · August 12, 2026 · TIN Development Confidential · Powered by frontier AI models