RevShift × Jessar — May 2026

Product spec coverage report

What we filled in self-sufficiently, where the gaps are, and a concrete list of what we still need from Jessar.

Bottom line. We pulled spec data from box artwork using two pipelines — direct PDF text extraction and Apple Vision OCR on the rasterized portions. Across 1,667 primary SKUs, we now have at least one structured spec field on 1,483 (89%) and a usable spec table (3+ fields) on 1,143 (69%).

The lighting tier (Xtricity, Jessar Lighting) is well-covered from box artwork alone. The housewares tier (JS Gourmet, JS Maison) is thinner — boxes typically print dimensions + made-in but rarely list material, care, or safety claims in machine-readable form. We supplemented with name-based inference (e.g. "Acacia wood salad bowl" → material) and rasterized-text OCR.

All product copy (descriptions, romance, features) is already written for 1,667 SKUs (100%).

How to use the attached CSV (jessar_data_request_2026-05-14.csv): Each row is a SKU, each have_X column shows ✓ extracted (we pulled it from box artwork or OCR) or ✓ inferred (name) (we derived it from the product name) or blank. Blank cells are not a directive — they're "we don't have this; if you do, please add." For many products a blank cell is correct (a kettle doesn't need a "material" spec, a brush doesn't need "capacity"). You know the catalog; you decide which blanks are worth filling.

1 · What we have today

1,667

Primary SKUs in scope

1,667

SKUs with EN/FR product copy

1,506

SKUs with box-artwork features

1,483

Any structured spec field

1,143

Usable spec table (3+ fields)

685

Rich spec table (5+ fields)

852

SKUs OCR-processed (vision)

940

PDF pages OCR'd to date

2 · Coverage by sub-brand

Sub-brand	Total SKUs	Any spec field	Usable (3+ fields)	Rich (5+ fields)
JS Gourmet / JS Maison housewares	882	821 (93%)	566 (64%)	211 (24%)
Xtricity	483	371 (77%)	325 (67%)	271 (56%)
Jessar Lighting	254	243 (96%)	236 (93%)	193 (76%)
Other	30	30 (100%)	0 (0%)	0 (0%)
JS Maison	18	18 (100%)	16 (89%)	10 (56%)

3 · Coverage by spec field × SKU prefix

How well box artwork covers each spec field, broken down by SKU prefix (which maps to data-tier sub-brand). Higher = greener.

Universal (every PDP needs these)

Spec field	1- Xtricity bulbs	3- Xtricity cords	4- Xtricity other	5- Jessar Lighting	6- JS Maison	7- JS Gourmet
Dimensions	189 (59%)	30 (53%)	74 (69%)	219 (86%)	10 (56%)	633 (72%)
Country of origin	213 (67%)	31 (54%)	67 (63%)	241 (95%)	18 (100%)	538 (61%)
Color/Finish	87 (27%)	3 (5%)	25 (23%)	28 (11%)	2 (11%)	7 (1%)
Material	0 (0%)	0 (0%)	2 (2%)	12 (5%)	0 (0%)	83 (9%)

Housewares-specific (JS Gourmet / JS Maison)

Spec field	4- Xtricity other	5- Jessar Lighting	7- JS Gourmet
Capacity (ml/L/oz)	3 (3%)	2 (1%)	314 (36%)
Set count (e.g. "Set of 4")	0 (0%)	0 (0%)	85 (10%)
Pack size / piece count	0 (0%)	0 (0%)	2 (0%)
Care (dishwasher / microwave / hand wash)	0 (0%)	0 (0%)	186 (21%)
Safety claims (BPA-free, lead-free)	0 (0%)	0 (0%)	61 (7%)
Feature callouts (non-stick, etc.)	0 (0%)	0 (0%)	44 (5%)
Includes / contents list	0 (0%)	0 (0%)	0 (0%)

Lighting-specific (Xtricity / Jessar Lighting)

Spec field	1- Xtricity bulbs	3- Xtricity cords	4- Xtricity other	5- Jessar Lighting	7- JS Gourmet
Wattage	196 (61%)	14 (25%)	60 (56%)	30 (12%)	18 (2%)
Voltage	126 (39%)	8 (14%)	51 (48%)	199 (78%)	21 (2%)
Lumens	183 (57%)	2 (4%)	60 (56%)	5 (2%)	0 (0%)
Color temperature	165 (52%)	2 (4%)	71 (66%)	6 (2%)	0 (0%)
Life (hours)	220 (69%)	3 (5%)	38 (36%)	0 (0%)	0 (0%)
Base type (E26 / GU10 / etc.)	191 (60%)	2 (4%)	1 (1%)	179 (70%)	0 (0%)
Bulb shape (PAR38, A19, etc.)	90 (28%)	2 (4%)	2 (2%)	0 (0%)	0 (0%)
Beam angle	2 (1%)	0 (0%)	0 (0%)	0 (0%)	0 (0%)
Dimmable yes/no	142 (45%)	1 (2%)	29 (27%)	28 (11%)	0 (0%)

Physical extras

Spec field	1- Xtricity bulbs	4- Xtricity other	5- Jessar Lighting	6- JS Maison	7- JS Gourmet
Net weight	1 (0%)	6 (6%)	23 (9%)	8 (44%)	69 (8%)
Gross weight	1 (0%)	6 (6%)	23 (9%)	9 (50%)	69 (8%)
Width (multi-axis)	1 (0%)	6 (6%)	21 (8%)	16 (89%)	292 (33%)
Height (multi-axis)	0 (0%)	0 (0%)	3 (1%)	10 (56%)	255 (29%)
Depth (multi-axis)	1 (0%)	6 (6%)	22 (9%)	10 (56%)	86 (10%)

4 · What's blank in the housewares CSV (for your review)

For each spec, here's how many of the 900 housewares SKUs currently have a value (extracted from box artwork, OCR'd, or inferred from product name) vs. blank. Blank ≠ gap — many blanks are correct (capacity on a brush, includes on a kettle). You decide which are worth filling.

Spec column	Have (✓)	Blank	Note
UPC	899 (100%)	1	Pulled from Jessar master file (bar-code column). 100% coverage.
Minimum order quantity	899 (100%)	1	Inner (qty-per-pq) if present, otherwise Master (qte-cont). 100% coverage.
List price (MSRP candidate)	850 (94%)	50	Pulled from master file (prix-list). Confirm with Jessar whether to display on PDP.
Dimensions (box-based)	643 (71%)	257	From box artwork. Some products also have explicit width/length/thickness in master.
Weight	425 (47%)	475	From master xlsx (kg) when present, else from box artwork (net/gross).
Country of origin	556 (62%)	344	From box artwork "Made in" callouts.
Capacity	314 (35%)	586	Where the product has one (drinkware, storage, bins, appliances, bakeware).
Set / piece count	85 (9%)	815	For multi-piece sets.
Material	476 (53%)	424	Inferred from product name (acacia / bamboo / stainless / glass / etc.).
Color / finish	159 (18%)	741	Inferred from quoted names ("Antique Birch") and adjacent words ("Matte black 5L pedal bin").
Lid material	57 (6%)	843	"Glass jar with bamboo lid" → Bamboo.
Care instructions	539 (60%)	361	Implied from material (acacia → hand wash, stainless → dishwasher safe) or explicit.
Safety claims (BPA / lead / food-safe)	61 (7%)	839	Mainly for food-contact products; explicit box callouts.
Heat resistance (oven-safe max temp)	13 (1%)	887	"Oven safe up to X°F" — bakeware + silicone.
Warranty period	18 (2%)	882	"Limited warranty: N years" on box artwork.

5 · Specific things Jessar can help with (ranked by leverage)

Note: UPC, minimum order quantity (Inner / Master), and list price are already pulled from the Items-Jessar workbook — we do not need to ask for these. The asks below are for data that genuinely isn't in your master file.

Insert / instruction sheets for housewares (when convenient — JS Gourmet first, others later). If you have the manufacturer inserts that ship inside each box, please send them. They typically list material, care, dimensions, and safety in machine-readable form. We OCR them on our end. Format: PDF, scan, photo — whatever you have. For Xtricity we already have the manuals from your team.
Certifications / safety standards by product family. Logos for FCC, ICES, CSA, ETL, FDA food-contact, etc. appear in box artwork as raster images. A short table of which certifications apply to which product line would let us populate the certifications metafield without vision work. Format: e.g. "Xtricity LED bulbs → FCC, ICES-005, ENERGY STAR". One row per product family.
Confirm pricing display. The master file contains both prix-list (list price / MSRP candidate) and prix (wholesale price). We will show list price on PDPs unless you say otherwise. Wholesale price is dealer- confidential and stays internal. One-line confirmation in the call: "show list price, hide wholesale" — or whatever pricing strategy you want for the new site.
Review of the attached CSV. 900 rows across all housewares (6- and 7- prefix). Each row shows ✓ where we have a spec (from master xlsx, box artwork, or inferred from product name) and blank otherwise. Spot-check inferred values for accuracy, fill blanks where you have data on hand, leave the rest. No pressure to fill everything — we know not every field applies to every product. File: jessar_data_request_2026-05-14.csv — also attached to the meeting invite.
Confirm the 4 hero SKUs missing from masters (7-99738, 7-98690, 7-99754, 7-99757). These appear on the hero list Michael provided but aren't in Items-Jessar or the Electrical/Beauty Cover Inventory. New / discontinued / typo?

6 · What we did NOT need to ask for

Just so it's clear what RevShift produced without Jessar's involvement:

1,667 primary SKUs identified and validated against masters
Product copy (EN + FR descriptions, romance, features) for 1,667 SKUs — generated from box artwork + names + category
Box artwork extraction — PyMuPDF text layer + Apple Vision OCR pipeline; recovered 1,483 SKUs with at least one structured spec from 940+ PDF pages
Structured spec database — 24 spec categories machine-extracted, mapped to Shopify metafields
Sub-brand mapping validated (the four-data-tier finding from your team's CSV — JS Gourmet, JS Maison, Jessar Lighting, Xtricity)

Live data behind this report: internal product content review dashboard. Methodology: text-layer extraction via PyMuPDF + rasterized-text recovery via Apple Vision OCR (on-device, no API calls). Generated 2026-05-14 10:04 from work/box_artwork_specs.csv + work/product_content.csv.