Certrow

Validate / CPSC eFiling CSV example rows, column by column

CPSC eFiling CSV example rows, column by column

Template V3 ships with three example products. These are the 72 columns they fill in, of 83.

Template V3 columnKindExample coffee table productExample dresser productExample toy product
Product UpdateRequiredYNN
Current Version IDContingentV1
New Version IDRequiredV2JAN202588901
Primary Product IDRequiredSKU00000123456789121234567890123
Primary Product ID TypeRequiredSKUUPCGTIN
SKUOptionalSKU00001
Model NumberOptionalMODEL-1A
Serial NumberOptional987654321
Alternate IdentifierOptionalABC-123-0001
Certificate TypeRequiredGCCGCCCPC
Product Name (Model)RequiredExample coffee table productExample dresser productExample toy product
Trade/Brand NameOptionalJoe's FurnitureHannah's Home GoodsFuture-Nauts
Product/Model DescriptionOptionalCoffee tableHardwood dresserJetpack Adventurer
Product/Model ColorOptionalGreyWalnutBlue
Product/Model StyleOptionalModernContemporary
Manufacturer Is New?ContingentNNY
Manufacturer GLNRequired9506000140445
Manufacturer Alternate IDRequiredmanufacturer-01example-manufacturer
Manufacturer NameContingentExample Manufacturer
Small Batch Manufacturer CPSC IDOptionalABC1234
Manufacturer Address Line 1Contingent12345 Example Address
Manufacturer Apt/Suite NumberContingentSte. 001
Manufacturer CityContingentCity
Manufacturer State/ProvinceContingentState/Province
Manufacturer CountryContingentCountry
Manufacturer Zip/Postal CodeContingent12345
Manufacturer PhoneContingent555-123-5748
Manufacturer EmailContingentsupport@example.xy
Manufacture DateRequired11/202502/202506/2025
Production Start DateOptional2/7/2025
Production End DateOptional2/9/2025
Lot NumberOptional544363112345
Lot Number Assigned ByOptionalManufacturerSeller
Lab 1 TypeRequiredLABNOLITL
Lab 1 Is New?ContingentY
Lab 1 CPSC-IDContingent1234
Lab 1 Alternate IDContingentexample-lab-1
Lab 1 NameContingentExample Lab 1
Lab 1 Address Line 1Contingent4321 Placeholder Hwy
Lab 1 CityContingentCITY NAME
Lab 1 State/ProvinceContingentPROVINCE
Lab 1 CountryContingentCOUNTRY
Lab 1 Zip/Postal CodeContingent12345
Lab 1 PhoneContingent555-456-7890
Lab 1 EmailContingentinfo@lab1.xy
Lab 1 Citation CodesRequired12051500.91(d)(8); 1500.91(d)(6)1215; 1216; 1217
Lab 1 Test Report IDOptional1234-5556788901
Lab 1 Test URLOptionalwww.lab1.xy/test-report-url/1234-55567www.examplelab.xy/reports/88901
Lab 1 Is Component?OptionalFALSENoYes
Lab 1 Component DescriptionOptionalName of component
Lab 2 TypeContingentLABITL
Lab 2 Is New?ContingentN
Lab 2 CPSC-IDContingent1234
Lab 2 Alternate IDContingentexample-lab
Lab 2 Citation CodesContingent1215; 12161201; 1202
Lab 2 Test Report IDOptional1234-55567
Lab 2 Test URLOptionalwww.example-test-report-url.xy/reports/1234-55567
Lab 2 Test Report Access KeyOptionalreportpassword
Lab 2 Is Component?OptionalTRUENo
Lab 2 Component DescriptionOptionalExample component name
Last Test DateRequired10/28/202502/01/20256/20/2025
Point of Contact (POC) for Test Result RecordsRequiredOtherOtherManufacturer
POC Is New?ContingentYN
POC Alternate IDContingentcustom-POC-IDcustom-POC-ID
POC NameContingentPOC Name
POC Address Line 1Contingent444 Example Address
POC CityContingentCITY
POC State/ProvinceContingentSTATE
POC CountryContingentCOUNTRY
POC Zip/Postal CodeContingent12345
POC PhoneContingent555-222-3333
POC EmailContingentCustom-POC@example.xy

Source: .CSV Template for Bulk Upload V3 (CPSC library date 2025-12-18), read 2026-11-10. Values are CPSC's placeholders, copied as they appear.

What each row shows

  • Example coffee table product: an update to an existing certificate (Product Update = Y, version V1 to V2), two labs of type LAB, one of them created on this row with Is New? = Y, and a point of contact of type Other created on this row.
  • Example dresser product: a new GCC with a testing exclusion. Lab 1 has type NOL and holds two exclusion codes; Lab 2 is a CPSC-accepted lab (ITL) with its 4-digit ID. The manufacturer and the point of contact already exist, so only their IDs are given.
  • Example toy product: a new CPC. The manufacturer is created on this row (Is New? = Y with name, address and contact details), one ITL lab tested to three rules, and the point of contact is the manufacturer.

Where the examples differ from CPSC's own guide and lists

  • The guide gives dates as MM/DD/CCYY. The examples hold 2/7/2025, 2/9/2025 and 6/20/2025, without leading zeros. Whether the Registry accepts both is not published; the padded form is the one the guide names.
  • Lab CPSC-ID 1234 is a placeholder. It is not one of the 739 laboratories on CPSC's accepted-lab list as downloaded 2026-11-10.
  • The dresser is a GCC and cites 1500.91(d)(8) and 1500.91(d)(6), which CPSC's code workbook marks for CPC only.
  • "Lab {#} Is Component?" holds FALSE, TRUE, Yes and No across the three rows. The guide lists True, False, Yes and No.

Delete them before you upload

The guide says the example rows "should be fully deleted before attempting to upload any data". The validator recognises them by name and tells you if they are still in the file.

Check a file All 83 columns

Questions

Is there an example of a filled-in CPSC eFiling CSV row?

Yes. CPSC's Template V3 workbook ships with three example rows: Example coffee table product, Example dresser product, Example toy product. They fill 72 of the 83 columns. CPSC's guide says to delete them before uploading.