commerce

The codes that identify products and published works: EAN and UPC product barcodes, ISBNs for books, ISSNs for periodicals, and ISRCs for sound recordings and music videos.

5 commerce types: 1 a sibling also accepts and reads alike, 3 that decompose into parts.

5 types

The 5 commerce types

Each type's first registry sample, against every sibling's rule

Type	Sample	Also accepted by
EAN ean · VARCHAR	5901234123457	isbn
ISBN isbn · VARCHAR	978-0-13-110362-7	—
ISRC isrc · VARCHAR	USUAN1400011	—
ISSN issn · VARCHAR	0028-0836	—
UPC upc · VARCHAR	042100005264	—

Which commerce type is it?

2 of 5 commerce types accept it, and read it alike.

Type	Reads it as
EAN `ean`	5901234123457
ISBN `isbn`	5901234123457

Use it

Shell

printf '%s\n' '5901234123457' '96385074' > column.txt
finetype infer -f column.txt --mode column

DuckDB

SELECT ft_profile(v) FROM (VALUES ('5901234123457'), ('96385074')) t(v);

After 96385074, one type remains: ean.

commerce

The 5 commerce types

Which commerce type is it?

Use it

Type Registry