Sample report
This is a real check of a small test file. The products and the catalog behind it are made up.
Columns used
- Brand: Brand
- Part number: Part Number
- UPC: UPC
- Length: Length (in)
- Width: Width (in)
- Height: Height (in)
- Weight: Weight (lb)
Summary
- Rows checked
- 12
- Found in catalog
- 2
- Differs from catalog
- 4
- Not found
- 6
- Rows we can update
- 3
Errors found
- UPC check digit is wrong3
- Dimensions look like a placeholder cube2
- Same brand and MPN appear on several rows2
- Same UPC appears on different products in this file2
- Brand is empty1
- UPC is empty1
- One or more dimensions are empty1
- Weight is empty1
- UPC is in scientific notation, digits were lost1
- UPC length is not 8, 12, 13 or 14 digits1
- UPC lost its leading zeros, the check digit is valid after restoring them1
- Weight and dimensions give a physically impossible density1
- Brand differs from our data for this UPC and MPN1
- This UPC belongs to a different product in our data1
- Dimensions differ from our data1
- Dimensions look like centimeters instead of inches1
- Weight differs from our data1
- Weight looks like kilograms instead of pounds1
What we will correct
| Row | Changes | Brand | Part Number | UPC | Length (in) | Width (in) | Height (in) | Weight (lb) |
|---|---|---|---|---|---|---|---|---|
| 3 | UPC: 12345678905 → 012345678905 | Northline Auto | NL-1002 | 12345678905 | 10 | 8 | 6 | 5 |
| 4 | Dimensions: 25.4 x 20.32 x 15.24 → 10 x 8 x 6 | Northline Auto | NL-1003 | 042100005264 | 25.4 | 20.32 | 15.24 | 5 |
| 7 | Dimensions: 30 x 30 x 30 → 10 x 8 x 6; Weight: 50 → 5 | Redpoint | RP-2002 | 073010106116 | 30 | 30 | 30 | 50 |
Corrected file: $9 for 3 rows we fill in or correct.
Payments are launching soon, so the corrected file cannot be bought yet.
Sample rows
| Row | Status | Errors | Changes | Brand | Part Number | UPC | Length (in) | Width (in) | Height (in) | Weight (lb) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | Found | Same UPC appears on different products in this file | Northline Auto | NL-1001 | 036000291452 | 10 | 8 | 6 | 5 | |
| 3 | Found | UPC lost its leading zeros, the check digit is valid after restoring them | Corrected in the file | Northline Auto | NL-1002 | 12345678905 | 10 | 8 | 6 | 5 |
| 4 | Differs | Dimensions look like centimeters instead of inches | Corrected in the file | Northline Auto | NL-1003 | 042100005264 | 25.4 | 20.32 | 15.24 | 5 |
| 5 | Differs | Brand differs from our data for this UPC and MPN; Weight looks like kilograms instead of pounds | Redpoint Parts | RP-2001 | 096385074293 | 10 | 8 | 6 | 2.27 | |
| 6 | Differs | Same UPC appears on different products in this file; This UPC belongs to a different product in our data | Redpoint Parts | RP-2002 | 036000291452 | 10 | 8 | 6 | 5 | |
| 7 | Differs | Dimensions differ from our data; Weight differs from our data | Corrected in the file | Redpoint | RP-2002 | 073010106116 | 30 | 30 | 30 | 50 |
| 8 | Not found | UPC is in scientific notation, digits were lost; Dimensions look like a placeholder cube | Summit Garage | SG-300 | 3.6E+10 | 12 | 12 | 12 | 4 | |
| 9 | Not found | UPC check digit is wrong; Dimensions look like a placeholder cube | Summit Garage | SG-301 | 036000291453 | 5 | 5 | 5 | 1 | |
| 10 | Not found | UPC is empty; One or more dimensions are empty; Weight is empty | Summit Garage | SG-302 | 4 | 3 | ||||
| 11 | Not found | Brand is empty; UPC length is not 8, 12, 13 or 14 digits; Weight and dimensions give a physically impossible density | SG-303 | 12345 | 2 | 2 | 40 | 900 | ||
| 12 | Not found | UPC check digit is wrong; Same brand and MPN appear on several rows | Summit Garage | SG-304 | 090000000000 | 14 | 9 | 7 | 3 | |
| 13 | Not found | UPC check digit is wrong; Same brand and MPN appear on several rows | Summit Garage | SG-304 | 090000000000 | 14 | 9 | 7 | 3 |