New here? Start with the full Process Guide
Everything in one document: why eFiling exists, how certificates get filed, how this Hub works, ongoing routines, roles, and the technical appendix.The 60-second version
The US CPSC requires a product safety certificate to be eFiled for every regulated product we import into the USA. Kids products need a CPC (lab-tested, with safety citations); adult products need a GCC, which for most AFG lines is a no-test flammability exemption filing. The one twist: anything with button/coin batteries needs battery documentation even if it is an adult product.
The flow: Katie drops supplier certificates into Dropbox (E-FILLING) → the processing pipeline extracts, matches to PIM and classifies every SKU → Owen reviews and approves → the batch is bulk-uploaded to CPSC → this Hub shows the live status.
SKUs — the lookup page
Search any SKU to see where it stands (Live / Awaiting / Planned / Not started). Click through for full detail: PIM data, planned certificate data and the live eFiling record side by side. The sync buttons refresh the Hub's data. Use this to answer "is X certified?"
Progress — whole-catalogue view
Completion across the entire PIM catalogue (~10,400 SKUs) by brand and kids/adult. Includes discontinued and non-US lines, so percentages look low by design. Long-term trends only — for day-to-day work use 2026 Shipments.
2026 Shipments — the page that matters
Only the SKUs actually shipping to the US this year, checked against live eFiling with progress bars per shipment list. Two downloads: the filtered list, and the FULL report — a self-explanatory workbook with one tab per action pile (missing docs / ready-not-submitted / pending / master list).
Statuses at a glance
Submitted certified, done · Awaiting cert in eFiling, not Complete · Covered by parent sibling size has the cert · Planned docs ready, not yet imported · Outstanding no documents — chase the supplier
Common tasks
| I want to… | Do this |
|---|---|
| Check one SKU | SKUs → search → click the SKU |
| See what's blocking this year's US shipments | 2026 Shipments filtered to Outstanding |
| Send someone the work-list | 2026 Shipments → Download FULL report (.xlsx) — tab 1-MISSING is the chase list |
| Add a new shipment list | Drop the xlsx into the app's data/shipments/ folder and run the shipments sync (or ask Owen) |
| Refresh data after new certificates were filed | SKUs page → Sync eFiling |
| Understand the whole process end to end | Download the Process Guide (PDF) |