Across 5 sources — the Items-Jessar master spreadsheet, the Electrical & Beauty Cover Inventory list, the live jessar.ca WordPress export, 11 catalog PDFs, and the Master SKU file — we have 3,211 unique SKUs. Reconciled against your active/discontinued flags (orange highlight + red font), here is the migration plan in numbers.
| Bilingual names (EN + FR) | 2,659 of 3,211 | 83% |
| Have UPC barcode | 2,506 of 3,211 | 78% |
| Have product images on current jessar.ca | 2,138 of 3,211 | 67% |
| Have studio photos (Quasimodo) | 2,808 of 3,211 | 87% |
| Have box artwork PDF | 2,595 of 3,211 | 81% |
| Appear in a catalog PDF | 1,715 of 3,211 | 53% |
| Already flagged by Jessar as needing data | 1,030 of 3,211 | 32% |
We ran all 1,557 box artwork PDFs provided by Chris through an extraction pipeline that reads product names, specs, romance copy, features, certifications, care instructions, and more. Weight data was pulled from the Items-Jessar spreadsheet and merged in.
| Product names (EN + FR extracted) | 1,556 of 1,667 | 93% |
| Dimensions (PDF + Excel combined) | 1,570 of 1,667 | 94% |
| Weight (from Items-Jessar spreadsheet) | 1,005 of 1,667 | 60% |
| Feature bullet points (EN) | 1,030 of 1,667 | 62% |
| Romance copy (EN) — from artwork | 822 of 1,667 | 49% |
| Romance copy — to be generated | 845 remaining | in queue |
| Certifications (text readable) | 234 of 1,667 | 14% — vision pass needed |
Note: Some fields (care instructions, wattage/voltage, capacity) are intentionally not applicable for all product categories. A bulb doesn't need care instructions; a pan doesn't need voltage. Gaps are tracked only against applicable products.
6- (458 SKUs, cleaning/utility) and 3- (127 SKUs, electrical). The other 4 prefixes are now mapped: 1- = Xtricity Bulbs · 4- = Xtricity Electrical · 5- = Jessar Lighting · 7- = JS Gourmet (kitchen), JS Maison (home & lifestyle), plus specialty lines VeraRoma, Cook & Fresca, iBake by VeraRoma, and Pop Fluff. The 6- and 3- prefixes still need confirmation from your team.Does this accurately reflect your product catalog? The SKU counts, groupings, and completeness picture above are the foundation everything else gets built on. If anything looks off — a missing product line, a count that seems wrong, a category that doesn't make sense, please let me know. Once everything looks good, give me a sign off and I will move onto next step for the data.