In order to upload your stock file successfully, please find below the fields and values that we accept.

You can download an example file here:

Video tutorial on how to upload CSV file

Please note that all field names are case insensitive, so it doesn't matter if its Size or SIZE .

The required fields are:
Stock #, Shape, Size, Cut, Color, Clarity, Polish, Symmetry, Fluorescence Intensity, Fluorescence Color, Measurements, Depth %, Table %, Lab, Certificate #, Location, Final Price, Treatment and Availability.

A description of each field, the possible names and values can be found below.

In addition to the required fields, we also have optional fields. The more information you provide, the better your listing will be and the more confidence buyers will have in your stock.

The optional fields are:
Eye Clean, Shade, Milky, Fancy Color, Fancy Intensity, Fancy Color Overtone, Girdle, Girdle %, Girdle Condition, Culet Size, Culet Condition, Crown Height, Crown Angle, Pavilion Height, Pavilion Angle, Inscription, Certificate Comment, Black Inclusion, White Inclusion, Open Inclusion, Key To Symbols, Mine of Origin, Canada Mark Eligible

The media fields are:
Image, Video, CertificatePdf
If you don't have these in your file, you can upload them after uploading your stock list and link them manually.  

Required Fields:

Stock #

Possible field names:
ReferenceNum, ReferenceNumber, Stock, Stock Num, Stock_no, StockNo, StockNum, StockNumber, VenderStockNumber, Stock Id, Stock_id, Stock #
Possible values:
The stock number for your item.

Shape

Possible field names:
Shape, Shp, Cut (Shape)
Possible values:
Round = B, BR, RB, RD, RBC, Round Brilliant, RND
Pear = P, PS, PSH, PB, PMB, Pear Shape, Pears
Emerald = E, EM,EC, Emerald, Emerald Cut
Square Emerald = SQE, SQEM, SX, SQ Emerald, Square Emerald, SM
Princess = PRN, PR, PRIN, PN, PC, MDSQB, SMB
Marquise = MQB, M, MQ
Asscher = A, CSS, CSSC, AC
Baguette = BAG, BG
Tapered Baguette = TBAG
Tapered Bullet = TBU, Tapered Bullet Brilliant
Calf = Calf, CLF
Briolette = Briolette, BRIO, BRIOLET, BT
Bullets = BU
Cushion Brilliant = CB, Cushion Brilliant
Cushion Modified = C, CUX, CU, CMB, CUSH, CUS RCRMB, CRC, CSC, CX, RCSB, SCMB, SCX
European Cut = EU, European, EuropeanCut
Flanders = FL, FC
Half Moon = HM, HMB
Heart = H, HS, HT, MHRC
Hexagonal = HEX, Hexagon
Kite = K, KT
Lozenge = LOZ
Octagonal = Octagonal, OC, Octagon
Old Miner = OM,
Old European = OEB,
Oval = O, OV, OMB
Pentagonal = PEN
Radiant= R, RAD, RA, RC, RDN, CRB, RCRB
Square Radiant= Sq Radiant, SQR, CCSMB
Rose = RS, RRC
Shield = SH
Square = SQ, MSB
Star = S, ST
Trapezoid = TP, TRAP, TRAPB, TZ, Trapeze
Triangle = Triangular, TRI, MTRB
Trilliant = T, TR, TRIL, TRILL, TRIB,TRL, MTRI, TRMB, TRSC
Other = X, BAT

Size

Possible field names:
Carat, Carats, CaratSize, CaratWeight, Ct, CtSize, CtWeight, Weight, Sz, Size
Possible values:
Enter a value from 0.01 to 999. Rounded to two decimal points.

Cut

Possible field names:
Cut, CutGrade, Cut Grade
Possible values:
IF = Internally Flawless, Ideal, ID, IF
EX = Excellent, EXC, EX, EX+
VG = Very Good, VG
GD = Good, GD
FR = Fair, FR, F
PR = Poor, PR, P

Color

Possible field names:
Col, Color, Colr, Colour
Possible values:
D, E, F, G, H, I, J, K, L, M, N, O,P, Q, R, S, T, U, V, W, X, Y, Z

Clarity

Possible field names:
Cla, Clar, Clarity, Purity  
Possible values:
FL, IF, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, I2, I3

Polish

Possible field names:
Pol, Finish, Polish  
Possible values:
EX = Excellent, EXC, EX, EX+
VG = Very Good, VG
GD = Good, GD
FR = Fair, FR, F
PR = Poor, PR, P

Symmetry

Possible field names:
Sym, Symm, Symmetry  
Possible values:
EX = Excellent, EXC, EX, EX+
VG = Very Good, VG
GD = Good, GD
FR = Fair, FR, F
PR = Poor, PR, P

Fluorescence Intensity

Possible field names:
Flr, Fluo, FloInt, FlrIntensity, Fluo Intensity, Fluor, Fluor Intensity, Fluorescence, Fluorescence Intensity, FluorescenceIntensity, FluorIntensity
Possible values:
Very Strong =  VST, VSTG, V. Strong, V. Str, Very StgStrong = S, STG, STR, ST, StrongMedium = M, Med, Medium, Medium BlueFaint/Slight = F, FN, FNT, Faint, SL, Slight, SLTVery Slight = VSL, VS, V.Slight, Very SlightNone = N, NN, NON, None, NIL

Fluorescence Color

Possible field names:
FlrColor, FloCol, Fluorescence Color, Fluo Color, Fluor Color, FluorColor, FluorescenceColor  
Possible values: Blue = B, Blue, BL
White = W, White, WH
Yellow = Y, Yellow, YL
Orange = O, Orange, OR
Red = R, Red
Green = G, Green, BG
None = N, None, NIL, NON
(if it is left blank, the value will be N)

Measurements

Possible field names:
Meas, Measurements, Measurement, Dimensions, Dim  
Possible values: Example: 8.93 x 6.44 x 3.82 or 8.93 x 6.44 * 3.82 

You can also specify the values individually:
Width
Possible field names:
Measurements Width, Width, MeasurementsWidth
Possible values: 6.44  
Length
Possible field names:
Measurements Length, Length, MeasurementsLength
Possible values: 8.93
Height/Depth
Possible field names:
Measurements Depth, Height, MeasurementsDepth, MeasHeight
Possible values: 3.82

Depth %

Possible field names:
Depth, Depth %, Depth Percent, DepthPct, DepthPercent, Dpth, TotalDepth  
Possible values: 62.40 or 62.40%

Table %

Possible field names:
Table, Table %, Table Percent, TablePct, TablePercent, Tbl  
Possible values: 60.40 or 60.40%

Lab

Possible field names:
Cert, Certificate, Laboratory, Lab  
Possible values: GIA, IGI, HRD
Currently we only work with these 3 certificates.

Certificate Number

Possible field names:
Cert Num, CertID, Certificate #, CertificateID, CertificateNum, CertificateNumber, CertNo, CertNum, CmPub, Certificate Number
Possible values: the certificate number

Location

Possible field names:
Country, CountryLocation, Location, City, State  
Possible values: the physical location

Price Per Carat

Possible field names:

PPC, PerCarat, Rapnet Price, RapnetPrice, Price Per Carat, PricePerCarat, Per Ct.

Possible values: the USD price per carat of the diamond

Final Price

Possible field names:
Total Value, Cash Value, Total Price, Final Price, Net Value
Possible values: the final USD price of the diamond

Availability

Possible field names:
Avail, Availability, Status, Available, Stage
Possible values:
Available = A, GA, Guaranteed Available, Available, Guaranteed
Memo = Memo, M, OnMemo, On Memo
Hold = Hold, H, Subject To Prior Sale
Not Available = any value other than the above, will result in the diamond not being available in the feed. 

Optional Fields:

Eye Clean

Possible field names:
EC, EyeClean, Eye Clean
Possible values:
Yes = Yes, 100%, 100, Eye Clean, E0
Borderline = Borderline, 90%, 90, E1
No = No, Not Eye Clean, 0%, 0, E2

Shade

Possible field names:
Shade, Brown, Shd, SHD
Possible values:
Brown = BR, Brown, VLB, VVLB, Very Light Brown, Very Very Light Brown, Light Brown, LB, Faint Brown, FB, Heavy Brown, HB, Very Heavy Brown, VHB

The same applies for:
Yellow, Green, Grey, Black, Pink, Blue, Mixed, Other

Milky

Possible field names:
Milky, Milkiness, Mlk, Cloud, Cloudiness
Possible values:
Not Milky = excellent, ex, no milky, not milky, NN, N, M0
Light Milky = Light Milky, M1 , Light
Medium Milky = Medium Milky, M2, Medium, MED
Heavy Milky = Heavy Milky, M3, Heavy

Fancy Color

Possible field names:
FancyColor, FancyColorMainBody, FC-Main Body, FCMainBody
Possible values:
BK = Black
B = Blue
BN = Brown
CH = Chameleon
CM = Champagne
CG = Cognac
GY = Gray, Grey
G = Green
O = Orange
P = Pink
PL = Purple
R = Red
V = Violet
Y = Yellow
W = White, WH
X =Other, OT

For two colors, you can separate with a hyphen or a space. Example: Blue-Green, Blue Green, B-G, B G

Fancy Intensity

Possible field names:
FancyColorIntensity, FCIntensity, FC-Intensity
Possible values:
Faint = Faint, F
Very Light = Very Light, VL
Light = Light, L
Fancy Light = Fancy Light, FCL, FL
Fancy = Fancy, FC
Fancy Dark = Fancy Dark, FCD
Fancy Intense = Fancy Intense, FI, I
Fancy Vivid = Fancy Vivid, FV, Vivid, V
Fancy Deep = Fancy Deep, DP, Deep, FD

Fancy Color Overtone

Possible field names: FancyColorOvertone, FancyColorOvertones, FCOvertone  
Possible values: Overtone of the color such as Purplish-Brown,  or Purplish Brown

Girdle

Possible field names: Girdle, Grdl, Gird 

You will have to enter both min and max in this field, such as THN-MED. If thats not possible, you can use GirdleMin and Girdle Max as listed below.

Possible values:
Extremely Thick = XTK, EXTHICK, EXTHK, XTHK, XTHICK, XTHIK, ETK, EK, XK
Very Thick= VTK, VTHCK, VTHK, VTHICK
Thick = TK, THK, THIK, THIC
Slightly Thick = STK, SLTK,SLTHK
Medium = M, MED, MD
Thin = TN, THN
Slightly Thin = STN, SLTN, SLTHN
Very Thin= VTN, VTHN, VTHIN, VN
Extremely Thin = XTN, XTHN, EXTN, ETN, EN, XN

Girlde MinPossible field names: GirdleMin, GirdleThin 

Girdle MaxPossible field names: GirdleMax, GirdleThick  

Girdle %

Possible field names:
Girdle Percent, GirdlePct
Possible values: the girdle %

Girdle Condition

Possible field names:
Girdle Condition, GirdleCon  
Possible values:
Polished = P, Polished
Faceted = F, Faceted
Bruted = B, Bruted

Culet Size

Possible field names:
Culet, Culet Size, CuletSize, Culet_size, CuletGrade
Possible values:
Extremely Large = Extremely Large, EL
Very Large = Very Large, VL
Large = Large, L
Slightly Large = Slightly Large, SL
Medium = Medium, M, Med
Small = Small, S, SM
Very Small = Very Small, VS
None = None, N, NN

Culet Condition

Possible field names:
Culet Condition, Culet_Condition, CuletCondition
Possible values:
Pointed = Pointed, P
Abraded = Abraded, A
Chipped = Chipped, C

Crown Height

Possible field names:
Crown, Crown Percent, CrownHeight, CrownPct, CH
Possible values: the crown height

Crown Angle

Possible field names:
CrownAngle, CrownAngl, CA  
Possible values: the crown angle

Pavilion Height/Depth

Possible field names:
Pavil, Pavilion, Pavilion Percent, PavilionDepth, PavilionPct, PH  
Possible values: the pavilion height or depth

Pavilion Angle

Possible field names:
Pavilion Angle, PA, PavAngle, PavilionAngle
Possible values: the pavilion angle

Inscription

Possible field names: Inscr, Inscription, Laser Inscription
Possible values: the inscription

Certificate Comment

Possible field names: Cert Comment, Certificate Comment  
Possible values: the comment of the certificate

Black Inclusion

Possible field names:
Black Inclusion, BI  

It is also possible to specify table and crown inclusions separately, the field names will then be BT  and BC  

Possible values:
No Black Inclusions = None, NN, N
Black Table Meaningless = BT0, Black Table Meaningless
Black Table Small = BT1, Black Table Small
Black Table Medium = BT2, Black Table Medium
Black Table Large = BT3, Black Table Large
Black Crown Meaningless = C0, BC0, Black Crown Meaningless
Black Crown Small = BC1, Black Crown Small
Black Crown Medium = BC2, Black Crown Medium
Black Crown Large = BC3, Black Crown Large

White Inclusion

Possible field names:
White Inclusion, WI  

It is also possible to specify table and crown white inclusions separately, the field names will then be WT and WC  

Possible values:
No White Inclusions = None, NN, N
White Table Meaningless = WT0, White Table Meaningless
White Table Small = WT1, White Table Small
White Table Medium = WT2, White Table Medium
White Table Large = WT3, White Table Large
White Crown Meaningless = W0, WC0, White Crown Meaningless
White Crown Small = WC1, White Crown Small
White Crown Medium = WC2, White Crown Medium
White Crown Large = WC3, White Crown Large

Open Inclusion

Possible field names: Open Inclusion, OI  

It is also possible to specify open table, crown, pavilion and girdle inclusions separately. The field names will then be: OT , OC , OP , OG  

Possible values:
Open Table Small = OT1, Open Table Small
Open Table Medium = OT2, Open Table Medium
Open Table Large = OT3, Open Table Large
Open Crown Small = OC1, Open Crown Small
Open Crown Medium = OC2, Open Crown Medium
Open Crown Large = OC3, Open Crown Large
Open Pavilion Small = OP1, Open Pavilion Small
Open Pavilion Medium = OP2, Open Pavilion Medium
Open Pavilion Large = OP3, Open Pavilion Large
Open Girdle Small = OG1, Open Girdle Small
Open Girdle Medium = OG2, Open Girdle Medium
Open Girdle Large = OG3, Open Girdle Large

Key To Symbols

Possible field names:
KeyToSymbols, Key, KTS, Key To Symbols  
Possible values:
Bearding, Brown patch of color, Bruise, Cavity, Chip, Cleavage, Cloud, Crystal, Crystal Surface, Etch Channel, Extra Facet, Feather, Flux Remnant, Indented Natural, Internal Graining, Internal Inscription, Internal Laser Drilling, Knot, Laser Drill Hole, Manufacturing Remnant, Minor Details of Polish, Natural, Needle, No Inclusion, Pinpoint, Reflecting Surface Graining, Surface Graining, Twinning Wisp

Mine of Origin

Possible field names:
Mine Of Origin, Country Of Origin, MOO, Mine_Of_Origin, COO, MineOrigin, Origin  
Possible values: the mine and/or country of origin

Canada Mark Eligible

Possible field names:
CM, CM Eligible, CM_Eligible
Possible values:
CM Eligible = yes, cm_eligible, Y
Not Eligible = no, n

Treatment

Possible field names:
Enhance, Enhancement, Enhancements, Treatments, HPHT  
Possible values:
Laser Drilled = Laser Drilled, LD
Irradiated = Irradiated, IRR
Clarity Enhanced= Clarity Enhanced, Fracture Filled, CE
Color Enhanced = Color Enhanced, COL
HPHT = High Pressure High Temperature, HPHT
OT = Other (enter any other type of treatment), OT

If this field is empty it will be assumed that there is no treatment.

Media Fields

Note: if you are unable to host these files yourself, you can upload them on the Nivoda Dashboard. For more information about that, look here.

Image

Possible field names: Diamond Image, Image, ImageFile, Photo, PhotoLink, ImageLink, Image Link, Photo Link
Possible values: the link to your image

Video

Possible field names: Diamond Video, v360, V360, Video, Video Link, VideoLink
Possible values: the link to your video or video page

Certificate PDF

Possible field names: CertFile, CertFilename, CertificateFile, CertificateFilename, CertificateImage, CertImage, File  
Possible values: the link to your certificate PDF

Did this answer your question?