These 366 SKUs are live on jessar.ca but neither the Items-Jessar master nor the Electrical/Beauty Cover Inventory list contains them. Three plausible reasons:
Hand this report to the Jessar intern after they finish the sub-brand mapping task. Same workflow: scan, decide. The high-completeness sample below (25 SKUs with the most data) is most likely category 1; the low-completeness sample is most likely category 2.
| Prefix | Count | Status |
|---|---|---|
6- | 200 | in known family (1/3/4/5/6/7) |
5- | 66 | in known family (1/3/4/5/6/7) |
7- | 50 | in known family (1/3/4/5/6/7) |
1- | 30 | in known family (1/3/4/5/6/7) |
4- | 17 | in known family (1/3/4/5/6/7) |
2- | 2 | anomalous — likely orphan or special-case SKU |
3- | 1 | in known family (1/3/4/5/6/7) |
| Bucket | Count |
|---|---|
| >=60 (likely real, secondary candidates) | 236 |
| 20-39 (sparse — likely cleanup) | 122 |
| 40-59 (mid — verify) | 8 |
Higher score = more WP data populated (image, description, categories). Lower score = sparse WP entry, often orphan.
Where these SKUs live in jessar.ca's existing taxonomy. Categories with many investigate SKUs warrant a deeper look.
| WP category | SKUs in this set |
|---|---|
| Products > Housewares > Ottoman | 28 |
| Products > Housewares > Bar stool | 25 |
| Products > Housewares > Fireplace accessories | 25 |
| Products > Electricity > Track light | 22 |
| Products > Housewares > Decorative basket | 20 |
| Products > Housewares > Furniture and Accessories > Shelves | 20 |
| Products > Electricity > wall mount | 15 |
| Products > Cleaning > Broom / Brush | 14 |
| Products > Cleaning > Sponge / Brush | 12 |
| Products > Electricity > Decorative light > Dome | 11 |
| Products > Cleaning > Mop / Squeegee | 11 |
| Products > Housewares > Furniture and Accessories > Tables | 10 |
| Products > Electricity > Light bulbs > Incandescent > A19 | 8 |
| Products > Electricity > Heater / Fan / Convector | 8 |
| Products > Miscellaneous | 8 |
The 25 investigate SKUs with the highest completeness score. Have images, descriptions, categories. These are probably legitimate products that bypassed the masters — strong candidates for the secondary tier.
| SKU | Name | Prefix | Score | Img | Desc | WP categories |
|---|---|---|---|---|---|---|
| 1-60109 | CFL A19 14W soft-white 2700k med base 1pk | 1- |
90 | ✓ | — | Products > Electricity > Light bulbs > Compact fluorescent > Spiral A19 |
| 1-63113 | Appliance clear A15/60W/130V/medium base 2cd | 1- |
90 | ✓ | — | Products > Electricity > Light bulbs > Incandescent > A15 |
| 1-69059 | Cylinder Table lamp wood base "Autentica" | 1- |
90 | ✓ | — | Products > Electricity > Table Lamps > Table Lamps (Wired) |
| 1-69065 | Cylinder Table lamp "Woodward" | 1- |
90 | ✓ | — | Products > Electricity > Table Lamps > Table Lamps (Wired) |
| 1-69931 | Cloud ceiling fixt. 11'' GU24 x 2 not includ white "Carrey" | 1- |
90 | ✓ | — | Products > Electricity > Ceiling light |
| 1-69962 | Led ceiling fixture 12'' 15W/3000k Black "Milano" 1pk | 1- |
90 | ✓ | — | Products > Electricity > Ceiling light |
| 2-70420 | Ext.Orange 3m 16/3 SJTW 1-outlet | 2- |
90 | ✓ | — | Products > Electricity > Cords/Taps/Power bars > Cord |
| 5-90002 | Pendant fixture gray and wood "Celeste" | 5- |
90 | ✓ | — | Products > Electricity > Decorative light > Dome |
| 5-90034 | Track bar 2 heads nickel-chrome "Yorkshire" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90035 | Track bar 3 heads nickel-chrome "Yorkshire" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90044 | Outdoor wall mount black "Edgar" | 5- |
90 | ✓ | — | Products > Electricity > wall mount |
| 5-90067 | Ceiling swivel light 1 head chrome "Westminster" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90072 | Ceiling swivel light 1 head black-brass "Walter" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90073 | Ceiling swivel light 1 head black-brass "Riviera" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90074 | Track bar 2 heads black-brass "Riviera" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90075 | Track bar 3 heads black-brass "Riviera" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90077 | Ceiling swivel light 1 head chrome "Oscar" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90083 | Track bar led integrated 3 heads nickel "Anita" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90085 | Ceiling swivel led integrated light 1 head nickel "Hope | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90142 | Pendant fixture 1 lamp black "Carlton" | 5- |
90 | ✓ | — | Products > Electricity > Decorative light > Cage |
| 5-90148 | Pendant fixture 1 lamp black & gold "Brentford" | 5- |
90 | ✓ | — | Products > Electricity > Decorative light > Dome |
| 5-90173 | Pendant fixture 1 lamp black "Sterling" | 5- |
90 | ✓ | — | Products > Electricity > Decorative light; Products > Electricity > Decorative light > Geometric |
| 5-90192 | Outdoor wall mount 2x60w square black "Bridge" | 5- |
90 | ✓ | — | Products > Electricity > wall mount |
| 5-90223 | Track bar 2 heads black & nickel "Jackson" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
| 5-90228 | Ceiling swivel light 1 head black & nickel "Harbour" | 5- |
90 | ✓ | — | Products > Electricity > Track light |
The 25 investigate SKUs with the lowest score. Sparse data, often missing image/description/categories. Probable migration action: cleanup (remove from WP before launch).
| SKU | Name | Prefix | Score | Img | Desc | WP categories |
|---|---|---|---|---|---|---|
| 6-01532 | CUBE OTTOMAN BLACK "MADDOX" 38 x 38 x 37.5 cm <br><br> #6- | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01533 | ROUND STORAGE OTTOMAN GRAY SET OF 2PCS "BARON" <br><br> #6 | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01534 | ROUND STORAGE OTTOMAN BEIGE SET OF 2PCS "BARON" <br><br> # | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01540 | STORAGE OTTOMAN PRINTED "LOVE" 38.0 x 38.0 x 37.5 cm <br><br& | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01543 | ADJUSTABLE HEIGHT SWIVEL BAR STOOL "CALIFORNIA" <br><br> # | 6- |
35 | ✓ | — | Products > Housewares > Bar stool |
| 6-01545 | ADJUSTABLE HEIGHT SWIVEL BAR STOOL "DAVIS" <br><br> #6-015 | 6- |
35 | ✓ | — | Products > Housewares > Bar stool |
| 6-01546 | ADJUSTABLE HEIGHT SWIVEL BAR STOOL "DAVIS" <br><br> #6-015 | 6- |
35 | ✓ | — | Products > Housewares > Bar stool |
| 6-01548 | CUBE STORAGE OTTOMAN GRAY-VELVET "CODI" 45.5 x 45.5 x 45.5 cm <br&g | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01549 | CUBE STORAGE OTTOMAN BLUE-VELVET "CODI" 45.5 x 45.5 x 45.5 cm <br&g | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01551 | RECTANGULAR STORAGE OTTOMAN GRAY-VELVET "CODI" 91.5 x 46.5 x 46.5 cm & | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01552 | RECTANGULAR STORAGE OTTOMAN BLUE-VELVET "CODI" 91.5 x 46.5 x 46.5 cm & | 6- |
35 | ✓ | — | Products > Housewares > Ottoman |
| 6-01617 | FLOATING SHELF FOR CORNER 29.7 X 29.7 X 5CM WHITE ''FLOYD'' | 6- |
35 | ✓ | — | Products > Housewares > Furniture and Accessories > Shelves |
| 6-01618 | FLOATING SHELF FOR CORNER 29.7 X 29.7 X 5CM BLACK ''FLOYD'' | 6- |
35 | ✓ | — | Products > Housewares > Furniture and Accessories > Shelves |
| 6-01636 | PLASTIC FOLDING STEP STOOL - BLACK <br><br> #6-01636 | 6- |
35 | ✓ | — | Products > Housewares > Stools |
| 7-10043 | BEAUTY COVER "ROCKY MOUNTAINS" <br><br> #7-10043 | 7- |
35 | ✓ | — | Products > Housewares > Surface liner > Adhesive rolls |
| 7-20105 | DECORATIVE PLACEMAT "CYNTHIA" <br><br> #7-20105 | 7- |
35 | ✓ | — | Products > Kitchen > Tableware > Decorative Placemats |
| 7-20108 | DECORATIVE PLACEMAT "HEAVEN" CUSHIONED <br><br> #7-20108 | 7- |
35 | ✓ | — | Products > Kitchen > Tableware > Decorative Placemats |
| 7-99225 | ACACIA ROUND SERVING TRAY <br><br> #7-99225 | 7- |
35 | ✓ | — | Products > Kitchen > Tableware > Serveware |
| 7-99226 | ACACIA RECTANGLE SERVING TRAY <br><br> #7-99226 | 7- |
35 | ✓ | — | Products > Kitchen > Tableware > Serveware |
| 7-99283 | STAINLESS STEEL COOKWARE WITH HANDLES <br><br> #7-99283 | 7- |
35 | ✓ | — | Products > Kitchen > Cooking & Preparing > Cookware & Bakeware |
| 7-99308 | 350ML DOUBLE WALL MUG WITH DRIED FLOWERS<br><br> #7-99308 | 7- |
35 | ✓ | — | Products > Kitchen > Tableware > Coffee\; Tea & Beverage > Mugs |
| 7-99334 | 20ML OIL SPRAY BOTTLE<br><br> #7-99334 | 7- |
35 | ✓ | — | Products > Miscellaneous |
| 7-99362 | 1.8L BLACK ELECTRIC KETTLE <br><br> #7-99362 | 7- |
35 | ✓ | — | Products > Kitchen > Small Appliances |
| 7-99363 | 1.8L BLACK & WOOD DESIGN ELECTRIC KETTLE <br><br> #7-99363 | 7- |
35 | ✓ | — | Products > Kitchen > Small Appliances |
| 7-99436 | 2 EMBOSSED GLASSES WITH BAMBOO LID & GLASS STRAW <br><br> #7-994 | 7- |
35 | ✓ | — | Products > Kitchen > Tableware > Drinkware |
Open the full set in product_database_viewer.html, filter Action = "investigate", and triage. Or send this report + the viewer link to the intern after the sub-brand mapping is done.