Inventory items fields

Modified on Wed, 23 Aug, 2023 at 11:30 AM

The following table is a summary of the most common fields under inventory items. This table should be addressed as a guide for which fields are existing and which ones should be used for different needs.

For more details on how to use the import tool, please read Import Inventory File and Import Lots File.

Item Overview

Field	Description	Notes	Expected Column Header
Description	Item Description / Title. Used for identification and summary of the item attributes.	Required. If not provided, the platform will generate a description using attributes in "Item Overview".	description / name
Category	Category of the item.	Item Category Settings	category
Code	Internal non-unique code for identification.	Used for barcode scanners.	code / barcode
Size	Size of Item (dimensions).		size
Size Unit	Size unit of the provided size.	Defaults to size unit configuration.	size_unit
Weight	Weight of Item.	required.	weight / tcw / ct_weight
Weight Unit	Weight unit of the provided weight.	Defaults to weight unit configuration.	weight_unit
Grade(s)	List of grades describing the quality of the item.		grade / grades
Source(s)	List of sources the item originated from.	source / sources
Supplier	Originated supplier of the item.		supplier
Notes	Free-text for notes and any additional information.	Not private and exposed to customers.	notes

General Attributes

Field	Description	Notes	Expected Column Header
Average Weight	Provided average weight of the item's content. Used for cases where the item contains a bundle of items.		avg_weight
Average Size	Provided average size of the item's content. Used for cases where the item contains a bundle of items.		avg_size
Blockchain	Blockchain service provider.		provenance_provider
Signature ID	Signature ID provider.		signature_id_provider
Treatment	Is the item passed through any kind of treatment?		treatment
Physical ID	External identical of the physical item or the box / container.		physical_id

Internal Attributes

The following attributes are private data and is not shared with customers.

Field	Description	Notes	Expected Column Header
Internal Size	Size of Item (dimensions).		internal_size
Internal Size Unit	Size unit of the provided size.		internal_size_unit
Internal Grades	List of grades describing the quality of the item.		internal_grade / internal_grades
Internal Sources	List of sources the item originated from.	Can be set only on new items or items with no internal source defined. The platform is self-managing the internal sources list based on the production process.	internal_source / internal_sources

Rough Attributes

Field	Description	Notes	Expected Column Header
Stones	The number of stones the item contains.		stones
Color	Color grading of the item.		color
Clarity	Clarity grading of the item.	cl / clarity
Measurement	Measurement of the item (dimensions).		mm / measurement
Fluorescence	Fluorescence grading of the item.		fl / fluorescence

Polished Attributes

Field	Description	Notes	Expected Column Header
Stones	The number of stones the item contains.		stones
Shape	Shape refers to the general silhouette of a diamond and can be classified as any number of shapes including round, cushion or pear.	Eg. BR, OV, EM, PS, etc.	shape
Color	The absence of color ranging from colorless to light yellow or brown	Eg. D, E, F, G, etc.	color
Clarity	The relative absence of inclusions and blemishes. Graded on a scale from Flawless to Included based on size, nature, number, position, and relief of characteristics visible under 10x magnification.	Eg. VS1, VVS2, etc.	cl
Cut	For standard, D-to-Z color, round brilliant diamonds. Cut grade incorporates the aspects of face-up appearance, design, and craftsmanship.	Eg. G, VG, EX, F, P	cut
Polish	Smoothness of the diamond’s surface, assessed on a scale ranging from excellent to poor.	Eg. G, VG, EX, F, P	polish
Symmetry	Exactness of the diamond’s outline, and the shape, placement, and alignment of its facets, assessed on a scale ranging from excellent to poor.	Eg. G, VG, EX, F, P	sym / symmetry
Fluorescence	Strength and color of the diamond when viewed under long-wave ultraviolet light. A fluorescence description of “none” represents a range of fluorescence from indiscernible to very faint. Used for identification purposes.	Eg. N, F, etc.	fl / fluorescence
Measurement	Diamond dimensions listed as “minimum diameter – maximum diameter x depth” for round diamonds and “length x width x depth” for fancy-shaped diamonds.		mm
Gridle	Thickness of the intersection of the crown and pavilion which defines the perimeter of the diamond.
Culet	Size of the facet at the tip of a gemstone relative to the average diameter for round shapes or width for fancy shapes.
Depth	Table-to-culet depth, expressed as a percentage of average girdle diameter for round shapes or width for fancy shapes.		depth
Table	Table size expressed as a percentage of a round brilliant’s average girdle diameter for round shapes or width for fancy shapes.		table
Ratio	Each diamond shape has a range of ideal length to width ratios		ratio
Lower Half	The Lower Half % describes the average distance a diamond's lower girdle halves run on a straight line from girdle to culet.
S Length	Length of star facets expressed as a percentage of the total distance between the girdle and the edge of the table facet.
Crown Angle	Crown angle is the measured angle between the bezel facet plane and the table plane.	The average of eight crown angle measurements is reported to the nearest half of a degree (0.5°).
Crown Height	Crown height percentage is the diamond’s crown height, measured from the table to the intersection of the bezel facet and the girdle, expressed as a percentage of its average girdle diameter.	It is reported to the nearest half of a percent (0.5%)
Pavilion Angle	Pavilion angle is the measured angle between the pavilion main facet plane and the table plane.	The average of eight pavilion angle measurements is reported to the nearest 0.2 degrees.
Pavilion Height	Pavilion depth percentage is the diamond’s pavilion depth, measured from the culet to the intersection of the pavilion main facet and the girdle, expressed as a percentage of its average girdle diameter.	It is reported to the nearest half of a percent (0.5%).
Hearts Arrows	Hearts and Arrows diamonds are precision-cut round diamonds. Because of their exact angles and symmetry, they show a hearts-and-arrows pattern when viewed	Arrows are visible from the top of the diamond, and hearts are visible when the diamond is face-down.
Eye Clean	Eye Clean grading of the item.
Lab	The lab which certified the item.	Used to redirect customers to the lab certification.	lab_type
Lab Certification	The lab certification ID / number	Used to redirect customers to the lab certification.	lab_id

Zvi Yehuda Attributes

Field	Description	Notes	Expected Column Header
Type 2A	Indication diamond classified as Type2A		type2a
Results	The conclusive color		zy_result
Color	The basic color of the stone and defines the basic color of the diamond, disregarding fluorescence, brown hue etc.		zy_color
Blue UV	The blue fluorescence details appear in blue.		zy_blueuv
Blue UV Level	The details include classification into 5 levels: NONE, FAINT, LIGHT, MEDIUM and STRONG		zy_blueLevel
Yellow UV	Yellow fluorescence in the diamond		zy_yellowuv
Fancy Yellow	At the end of the fancy yellow measurement, the machine will give 1 of 5 results: NO FANCY YELLOW – the color of the stone is M-Z; LIGHT FANCY YELLOW; FANCY YELLOW; INTENSE YELLOW; VIVD YELLOW		zy_fancyYellow
Type	Type value of the measurement.		zy_type
Brown	Brown hue is only measured for the color range D-F		zy_brown

Item Breakdown

In case an item contains more than a single stone, and usually more than a single bag / box (container), the platform provides an option to specify how is the item divided internally.

Each bag / box should be described with the following information:
Size - the size (measurement) of the content of the container.
Weight - the total weight of the container (using the same unit as the item's weight unit).
Stones - the number of stones inside the container.

The system is displaying this information to customers, together with the percent value of the weight that each container contains.

Media

Each inventory item may contain different media to be displayed for customers and for internal uses.

Cover Image - main image to be displayed for the item. This image is also used as the cover image for lots.
3D video - provides a link for 3D video (currently supports Youtube or Vimeo).

Sarine Advisor Documents

For rough diamonds, the platform is supporting the upload of Sarine Advisor documents. The documents are shared with customers as downloadable links.