COMET Standard Data Dictionary v 1.0.10

	A	B	C	D	E	F	G	H	I	J	K
1	Field Name	Field Position	Field Class	Field Type	Required	Field Length	Field Description	Field Example	Field Media	Field Notes	TO WORK ON

2	UPC	1	Essential Data	Number	For Comics	17	The UPC field provides the 12-digit Universal Product Code and 5-digit supplements for all items which carry a UPC. Example 75960608857704611 Within the UPC field there are key pieces of information that should be conveyed. The first digit represents the number system character, the second set of five digits represents the manufacturer code (or in our case publisher code), the next set of five digits represent the product code (or in our case series code), the next digit is a check code which is generated by the UPC system. The final five digit code represents the supplemental data for a publication. This is expressed as one of two format types where I = issue, C = cover, and P = printing IIICP - three digits for issue number, one digit for cover, and one digit for printing IICCP - two digits for issue number, two digits for cover, and one digit for printing You may choose either system, but whatever you choose must be used for the entire run of a title. BE AWARE: IICCP means you can only have 99 issues in a series.	75960608857704611		When deciding on an ICP formatting, you will need to abide by that format for the entire duration of the UPC's lifetime. You can't start using IICCP, and then decide after issue 100 to use IIICP because those Supplemental codes will have already been used in previous issues.
3	ISBN	2	Essential Data	Number	For Books	13	The ISBN field provides the 13-digit International Standard Book Number for all items which carry an ISBN.	9781302920494
4	EAN	3	Essential Data	Number	For Books	18	The EAN is 13-digit International Standard Book Number + the additional 5 characters in price.	978130292049451499		Each new printing with a price change will have a different 18 digit EAN. Multiple EAN's may share the same ISBN (13 digit number).
5	FullTitle	4	Essential Data	Text	Yes	512	The Full Title field encompasses the full title of an item. This field may contain relevant information such as series number and variant information, where applicable.	Something is Killing the Children #1 Fall of the House of Slaughter Artgerm Full Art (Mature)		Periodical: [SeriesName] #[issue number] [one-shot] Cover [cvr letter] [variant description] [ratio in 1:## format] Collcted/GN/TPB/HC: [SeriesName] [volume abbreviation] [number with leading zero] [variant description] [format abbr]
6	PriceUSD	5	Essential Data	Decimal	Yes	12	The PriceUSD field includes the suggested retail price in US dollars that is printed on the product. Note that this field will not include a dollar sign ($). Also known as the MSRP.	3.99
7	PriceCAD	6	Core Data	Decimal	No	8,2	The PriceCAD field includes the suggested retail price in Canadian dollars. Note that this field will not include a dollar sign ($).	9.99
8	PriceUK	7	Core Data	Decimal	No	8,2	The PriceUK field includes the suggested retail price in British Pound Sterling. Note that this field will not include a currency symbol.	5.99
9	NETPrice	8	Extended Data	Decimal	No	10,2	If an Item is flagged as NET Priced, it defaults to the USD item price. Use this field to override that default. (Example: 5.06 for an item that is net priced at $5.06)	5.06
10	NETPriced	9	Extended Data	Y/N	No	1	Indicates a product is NET priced	N
11	SeriesName	10	Core Data	Text	Comics & Graphic Novels	256	The SeriesName field is the main title of the item.	Something is Killing the Children		SeriesName must be included on one-shots, multi-issue series, and TPB/HC/Collected Editions
12	SeriesNumber	11	Core Data	Number	For Comics	12	The SeriesNumber field displays the issue or volume number of the item, if it is part of a numbered series.	1		This filed should only hold numbers, never text. Decimal places are allowed.
13	SubTitle	12	Core Data	Text	No	256	The Subtitle field is a secondary or explanatory title, often printed on the cover of an item.	Fall of the House of Slaughter
14	CoverDescription	13	Core Data	Text	For any non-main cover	256	The CoverDescription field describes the cover differences between different editions. Should not contain the word "Cover".	Artgerm Full Art		This is NOT for describing cover A or B, this is for describing a theme or artist.
15	PrimaryFormatType	14	Core Data	Pick List	Yes	2	The PrimaryFormatType field contains a code that corresponds to the specific format of the item. Book, Merchandise (See FormatTypes in the data definitions). This should start from the outside of the product to the inside (a slipcase is outside of hardcovers, for example). For example, if an item is a box set of hardcovers, the FormatType should be BX.	CB		See the FormatType table in the Data Definitions.
16	SecondaryFormatTypes	15	Core Data	Pick List	No	64	SecondaryFormatTypes further defines format types. For example, Hardcover > Omnibus (See FormatTypes in the data definitions). This field is a comma-separated list of format codes.	BX,LF		See the FormatType table in the Data Definitions.
17	ProductCategory	16	Essential Data	Pick List	Yes	24	The ProductCategory is the categorization that the product falls under for taxation purposes.	Comics		See Categorization table
18	TextNumber	17	Core Data	Text	No	64	The TextNumber field (Red, Black, Omega, etc)	Omega
19	VolumeTag	18	Core Data	Pick List	No	16	Is the collection referred to as a Book, Season, Volume or other?	Volume		See the VolumeType table in the Data Definitions.
20	Description	19	Core Data	Text	Yes	150000	The Description field displays the full description associated with the item. Note that this text will not contain any HTML formatting, and double quotes will be escaped to maintain file integrity.	Erica's heartbreak in the wake of tragedy turns to rage as she faces Cutter one final time. But who else will fall at the hands of the Order, and how will things change for Cecilia and the House of Slaughter?		All text should be UTF-8 encoded Text shall not contain HTML. Do not use double quotes Remove any special characters before submission (Example: MS Word formatting). All text values should be trimmed of any leading or trailing whitespace at the input and output interfaces of any entities handling data.
21	InitialOrderDate	20	Extended Data	Date	No	10	Identifies when the initial orders are due on a product (YYYY-MM-DD)	2021-02-02
22	FOCDate	21	Extended Data	Date	No	10	The FOCDate field provides the Final Order Cutoff date for the item, expressed in YYYY-MM-DD. Example 2023-10-13 (may be different than publisher FOC)	2021-03-26
23	OnSaleDate	22	Core Data	Date	Yes	10	The OnSaleDate field provides the expected On Sale Date/In-Store Date for the item, expressed in YYYY-MM-DD.	45735
24	OriginalCatalogDate	23	Extended Data	Date	No	10	The OriginalCatalogDate field corresponds to the date when the item was originally listed, expressed in YYYY-MM-DD. (for Offered again and Resolicited Items)	2021-01-26
25	PublisherName	24	Core Data	Text	Yes	256	The PublisherName field displays the name of the publisher or division that is publishing the item.	Marvel Comics		Please be consistent. "Honesty Comics" is not the same as "HONESTY COMICS" or "Honesty."
26	ImprintName	25	Core Data	Text	No	256	The ImprintName field displays the name of the imprint or brand that is publishing the item. Example: DC Universe versus Black Label, Skybound for Image Comics	Skybound
27	Storyline	26	Core Data	Text	No	256	A group of issues that tie together into one storyline, these may cross series codes, or be contained within one series code.	Fall of the House of X
28	SeriesFrequency	27	Core Data	Pick List	Comics & Graphic Novels	32	The SeriesFrequency field discloses information specific to the publication cadence or type of the item.	Monthly
29	MaxIssue	28	Core Data	Number	No	12	The Max Issue information refers to the highest number (last issue) in a limited series. For example, in Umbrella Academy: Apocalypse Suite #4 (of 6), the Max Issue data [(of 6)] identifies the title as a six-issue limited series.	6		This is an extremely helpful sales tool at the register. "Do you want to subscribe? It's only 6 issues"
30	VariantNumber	29	Core Data	Number	Yes	6	A numerical representation of the order in which a variant was added (i.e. the fourth added variant would have the number 4), should correspond with the last 2 or 3 digits of a UPC (depending on your ICP pattern) where possible.	2		Expect retailers to convert this to a cover letter where 0 = CVR A, 1 = CVR B, etc.
31	VariantRatio	30	Core Data	Text	No	6	The VariantRatio field is a numeric field that denotes the ordering requirement, if any, to purchase the item. This should be expressed in the format of X:Y for a 1 in 25, we would express X = 1 and Y = 25 for a result of 1:25. If empty, we assume this product is not a ratio variant	0.05902777778		This was brought up as an item we should revisit, should we display this as 1:20 rather than 20?
32	SeriesCode	31	Core Data	Number	For Comics	24	SeriesCode is used to denote a specific title numerically and encompasses all issues of a given title. For Comics, a series code should be unique to the first 11 digits of a UPC code (with some exceptions).	75960609661		SeriesCode must be on all periodicals (including one-shots, annuals, and multi-issue series), as well as all multi-volume collected editions in any format. SeriesCode may be on TPBs/HC/Absolute/Other formats that do not have a second volume.
33	SeriesType	32	Core Data	Pick List	For Comics	32	What type of a comic is this, for example a one-shot vs ongoing vs limited series?	Limited Series
34	ParentSeriesCode	33	Core Data	Number	No	24	The ParentSeriesCode will indicate a series code that this is a child of (example: Annual is the child of a series code). Batman (1940) is the parent of Batman New52 (2011), which is the parent of Batman Rebirth (2016). Is only intended for the first issue of a series, or for a one-shot	76194130640		Ensure that the parent code is an item within the same format as the child item.
35	SeriesFamily	34	Core Data	Text	No	128	SeriesFamily represents a family of titles (All Spider-Man, All Batman, All X-Men, All Titans)	Batman			What is a valid entry, how do we best represent the family, what are the best practices.
36	PageCount	35	Core Data	Number	Yes	6	The PageCount field displays the page count of the publication.	64
37	PrimaryContentType	36	Core Data	Pick List	Yes	32	PrimaryContentType defines something as primarily original content, or primarily reprinted content.	Original Content		See PrimaryContentType table in the Data Definitions.
38	IssueSort	37	Core Data	Decimal	No	14,2	Sorting number (which should usually be the same as the Series Number, except for when it is not. i.e. Deathmate Black, Deathmate Series, Zero Hour #4 (which was the first issue).	57.5		Decimal places are allowed.
39	BISAC1	38	Core Data	Pick List	Yes	9	The BISAC field denotes the first 9-character alphanumeric BISAC code associated with the item. The Book Industry Standards and Communications (BISAC) Subject Heading list is an industry-approved list of subject descriptors, intended to help retailers and data providers standardize genre and subject classification. (NOTE: You may use any BISAC categories available from the BISG)	CGN004030
40	BISAC1Description	39	Core Data	Pick List	Yes	128	The BISAC Description field provides the descriptive translation of the corresponding BISAC1 subject code.	COMICS & GRAPHIC NOVELS / Fantasy
41	BISAC2	40	Core Data	Pick List	No	9	The BISAC field denotes the first 9-character alphanumeric BISAC code associated with the item. The Book Industry Standards and Communications (BISAC) Subject Heading list is an industry-approved list of subject descriptors, intended to help retailers and data providers standardize genre and subject classification.	CGN004010
42	BISAC2Description	41	Core Data	Pick List	No	128	The BISAC Description field provides the descriptive translation of the corresponding BISAC1 subject code.	COMICS & GRAPHIC NOVELS / Crime & Mystery
43	BISAC3	42	Core Data	Pick List	No	9	The BISAC field denotes the first 9-character alphanumeric BISAC code associated with the item. The Book Industry Standards and Communications (BISAC) Subject Heading list is an industry-approved list of subject descriptors, intended to help retailers and data providers standardize genre and subject classification.	CGN004070
44	BISAC3Description	43	Core Data	Pick List	No	128	The BISAC Description field provides the descriptive translation of the corresponding BISAC1 subject code.	COMICS & GRAPHIC NOVELS / Science Fiction
45	Language	44	Core Data	Pick List	Yes	3	The Language field provides a 3-character code that provides information about the language of the item. See Language Codes	eng		See the LanguageCodes table in the Data Definitions.
46	AgeRange	45	Core Data	Pick List	For Kids Items	4	The AgeRange field is a four-character alphanumeric range of ages that apply to the target audience of the item. See AgeRange List of Values	14UP		See the AgeRange table in the Data Definitions.
47	MediaRating	46	Core Data	Pick List	Yes	32	The MediaRating field discloses the actual media rating value for the item. See MediaRating List of Values	Rated T+		See the MediaRating table in the Data Definitions.
48	Adult	47	Core Data	Y/N	No	1	Adult (A) titles are intended for sale only to adult customers. This field identifies items which have explicit content intended for adults.	Y
49	VariantMechanic	48	Core Data	Pick List	No	36	If this is not an open order variant, the constraint type for ordering is described here.	Ratio Variant		See Variant Mechanics table in Data Definitions
50	AlternateUPC	49	Core Data	Number	No	17	In the case a title has more variant covers than can be accounted for with the item's base barcode, this alternate UPC code would indicate the other barcodes used to qualify for a ratioed variant.	70985301898
51	OrderRequirementCodes	50	Core Data	Composite	No	2048	OrderRequirementCodes is a comma separated list containing barcodes that may be used in conjunction with ExceedPercentage or ratio variants. Ratio and non-ratio variants, by default count toward these thresholds unless listed in the OrderExceptionCodes.	72513032443605151, 72513032443605161
52	OrderExceptionCodes	51	Core Data	Composite	No	2048	Comma separated list of barcodes outside of the default set that are to be EXCLUDED in ratio threshhold math.	76194137779700191, 76194137779700122
53	ExceedPercentage	52	Core Data	Number	No	4	X% of the item identified in the OrderRequirementCodes field.	10		In this example, you need to order 10% of the listed UPC's in order to qualify for 1 of these. So if you ordered 90 of the other UPC's, you could order 9 of this item.
54	EligibleCodes	53	Core Data	Composite	No	2048	The EligibleCodes field is a numeric field of barcodes that should be used in conjunction with ExceedPercentage. Barcodes in this field will be used to determine the total quantity of all items of a specific title that must meet or exceed the quantity calculated by ExceedPercentage	75960620483001121, 75960620483001111
55	PublisherCode	54	Core Data	Text	Yes	5	Numerical representation of the 5 digit "Manufacturer Code" used to designate a UPC code	59606
56	ContentItems	55	Core Data	Text	No	512	Text field that indicates what is in the collection.	Collects Secret Origins #48, Swamp Thing #40, The Sandman #8, Doom Patrol #25, Warlord #48 and #55, Legion of Super-Heroes #298, Nathaniel Dusk #1, Infinity Inc. #14, The New Teen Titans #16, The Best of DC: Blue Ribbon Digest #58, Watchmen #1, Camelot 3000 #1, Batman: The Dark Knight Returns #2, Angel Love #1, and History of the DC Universe #1-2
57	Reprint	56	Core Data	Y/N	For Comics	1	Is the item a Reprint? Facsimile editions - Image Firsts, something that has come out previously.	N		A simple yes or no flag to indicate whether a periodical is a first print or not.
58	Printing	57	Core Data	Number	Yes	3	What printing is the item	2
59	WriterISNI	58	Core Data	Text	No	512	The ISNI number for the Writer, comma separated list of all writers on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0001 2146 227X
60	Writer	59	Core Data	Text	Yes	512	The Writer field identifies the primary creator responsible for authoring/writing the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Neil Gaiman
61	ArtistISNI	60	Core Data	Text	No	512	The ISNI number for the Artist, comma separated list of all artists on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0001 1691 8041
62	Artist	61	Core Data	Text	For Comics	512	The Arist field identifies the primary creator responsible for illustrating the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Jack Kirby
63	CoverArtistISNI	62	Core Data	Text	No	512	The ISNI number for the Cover Artist, comma separated list of all artists on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0001 0776 4052
64	CoverArtist	63	Core Data	Text	For Comics	512	The CoverArtist field identifies the primary creator responsible for illustrating the cover of the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Marie Severin
65	ColoristISNI	64	Core Data	Text	No	512	The ISNI number for the Colorist (if any), comma separated list of all colorists on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0003 9593 3286
66	Colorist	65	Core Data	Text	No	512	The Colorist field identifies the primary creator responsible for coloring the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Tatjana Wood
67	InkerISNI	66	Core Data	Text	No	512	The ISNI number for the Inker (if any), comma separated list of all inkers on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0003 5502 7529
68	Inker	67	Core Data	Text	No	512	The Inker field identifies the primary creator responsible for inking the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Bill Sienkiewicz
69	EditorISNI	68	Core Data	Text	No	512	The ISNI number for the Editor (if any), comma separated list of all editors on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0004 2851 3043
70	Editor	69	Core Data	Text	No	512	The Editor field identifies the primary creator responsible for editing the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Karen Berger
71	LettererISNI	70	Core Data	Text	No	512	The ISNI number for the Letterer (if any), comma separated list of all letterers on the item, multiple creators should be separated by a semicolon, this field should be text.	0000 0003 6467 1658
72	Letterer	71	Core Data	Text	No	128	The Letterer field identifies the primary creator responsible for lettering the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Breitweiser, Elizabeth
73	Contributor	72	Core Data	Text	No	16	The Contributor field identifies the any other primary creator responsible for some other contribution to the item. If there is more than one contributor per role, all contributors will be displayed as FIRST LAST name and separated by a semicolon.	Ken Albery; Erik Larsen
74	CartonQuantity	73	Core Data	Number	No	6	The CartonQuantity field displays the number of individual units contained in a single carton.	12
75	UnitMeasurements	74	Core Data	Text	Yes	8	Imperial or Metric	Imperial
76	Unit Width	75	Core Data	Decimal	Yes	10,4	The Width field displays the width of the item in inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	12.3616
77	Unit Height	76	Core Data	Decimal	Yes	10,4	The Height field displays the height of the item in inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	12.3616
78	Unit Depth	77	Core Data	Decimal	Yes	10,4	The depth field displays the depth of the item in inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	0.8
79	Unit Weight	78	Core Data	Decimal	Yes	10,4	The weight field displays the weight of the item in pounds (Imperial) or grams (Metric), rounded to the fourth decimal place.	6.9991
80	Case Weight	79	Extended Data	Decimal	No	10,4	The weight of a case pounds (Imperial) or grams (Metric), rounded to the fourth decimal place.	8.1673
81	Case Length	80	Extended Data	Decimal	No	10,4	The length of a case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	14.25
82	Case Width	81	Extended Data	Decimal	No	10,4	The width of a case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	36.616
83	Case Height	82	Extended Data	Decimal	No	10,4	The height of the case inches (Imperial), or cm (Metric), rounded to the fourth decimal place.	5.24
84	StockCode	83	Extended Data	Text	Yes	36	The Primary ID of the item that can be tracked month-to-month	ID11031989		If the PrimaryID is UPC/ISBN or EAN, it should be repeated in this field. Note that ISBN is not 1-to-1, EAN is 1-to-1.
85	MonthCode	84	Extended Data	Text	No	10	The ID of the item for a specific catalogue month (traditionally MMMYY#### format)	SEP081984
86	AlternateCode	85	Extended Data	Text	No	36	Any alternate codes for other distribution arms.	SBAPR0550
87	OfferedAgain	86	Extended Data	Y/N	No	1	Sometimes, items are solicited more than once in subsequent catalogues. This field denotes if an item is being Offered Again.	N
88	Resolicited	87	Extended Data	Y/N	No	1	A re-issued item was previously listed, but was cancelled before shipping and is being listed again. No previous orders were committed, and this re-issue will be the first time this product is being ordered.	N
89	FOCItem	88	Extended Data	Y/N	No	1	This field denotes whether a title is eligible for order adjustments by the Final Order Cutoff.	Y
90	DemandCheck	89	Extended Data	Y/N	No	1	After the Final Order Cut-off deadline, the publisher will evaluate the orders and determine if the product will be reprinted. If the orders do not justify a reprint, all orders will be canceled, and retailers will be notified via the Order Cancellation section of their invoices.	N
91	InitialOrderIncrement	90	Extended Data	Number	No	10	Minimum quantity required to order, similar to a case quantity.	12		This field serves a different purpose than the pre-existing Diamond field named OrderIncrement.
92	ReOrderIncrement	91	Extended Data	Number	No	10	Minimum quantity required to re-order, similar to a case quantity.	6
93	BundleQuantity	92	Extended Data	Number	No	10	Quantity of breakable units in a bundle.	12
94	BundleUPCs	93	Extended Data	Composite	No	2048	What UPCs are within this bundle of items?	72513032443605151, 72513032443605161
95	SalesRestrictions	94	Extended Data	Pick List	No	2048	The SalesRestrictions field displays the geographic territories where the item may not be sold, in a comma separated list. See list of country codes (based on 2 character ISO 3166 country codes).	CA, UK		Using the standard ISO 3166-1 Alpha-2 Codes
96	OrderFormNotes	95	Extended Data	Text	No	1024	Order Form Notes are parenthetical descriptions, added below catalogue line items, offering additional ordering information on solicited merchandise.	50/50 Covers Distributed in Equal Ratio
97	CatalogPage	96	Extended Data	Number	No	4	This field identifies the page number in the distributor catalogue on which an item’s solicitation information can be found.	14
98	CatalogMonth	97	Extended Data	Date	No	7	Identifies the original date the item was solicited. Also known as "Catalogue Date". (YYYY-MM), for items that are cancelled and re-solicited, this date will be for the NEW solicitation date.	2021-02
99	DiscountCode	98	Extended Data	Text	No	6	Discount codes are the code which designates which discount an account is eligible for. This supports fluctuating discounts based on publisher or vendor, and requires a table to decode.	D
100	ReorderDiscountCode	99	Extended Data	Text	No	6	Discount codes are the code which designates which discount an account is eligible for a reorder.	DR