Preparing Your Stock File For Upload

This page is a reference to the fields and values you can use in CSV files containing your stock listings that you want to upload to RapNet. The first row should contain the field headers.

Recognized RapNet fields:

Main diamond details	Stock #, Shape, Size,Color , Clarity, Polish, Symmetry,Cut Grade , Fluorescence Intensity, Fluorescence Color, Measurements, Lab, Certificate #, Treatment
Prices	RapNet Price, RapNet Discount %, Cash Price, Cash Price Discount %
Lot location and availability	Country, State, City, Availability
Additional diamond details	Fancy Color, Fancy Color Intensity, Fancy Color Overtone, Depth %, Table %, Girdle Thin, Girdle Thick, Girdle %,Girdle Condition, Culet Size, Culet Condition, Crown Height, Crown Angle, Pavilion Depth, Pavilion Angle, Laser Inscription, Eye Clean,Cert comment , Member Comments, Report Issue Date,Seller Spec,Star Length, Shade,Black Inclusion, White Inclusion, Open Inclusion, Milky, Report Type, Report Issue Location, Key To Symbols, Brand
Permissions and other	Is Matched Pair Separable, Pair Stock #, Allow RapLink Feed, Parcel Stones, Certificate Filename, Diamond Image,Sarine name Display Cert Number, Trade Show

RapNet accepted values:

Field name	Acceptable alternate field names	Acceptable field values
Allow RapLink Feed	AllowRapLinkFeed, RapLink	Y = Yes N = No * Allows this diamond to appear in Raplink Diamond Feed Service (virtual inventory).
Availability	Avail, Availability, Available, Status	G = Guaranteed Availability, GA, Guaranteed, GuaranteedAvailable M = Out on Memo, Memo, OnMemo, On Memo STPS = Subject to Prior Sale NA = Not Available, N, Unavailable" * If "NA" is entered, the stone will not appear in search results. * Guaranteed available means the seller has immediate access to the diamond. City/State/Location must be specified.
Black Inclusion	Black Inclusion	None = Black Inclusions None, BT0 = Black Table Meaningless, BT1 = Black Table Small, BT2 = Black Table Medium, BT3 = Black Table Large, BC0 = Black Crown Meaningless, BC1 = Black Crown Small, BC2 = Black Crown Medium, BC3 = Black Crown Large * Acceptable values are the short values in bold.
Brand	Brand	Hearts and Arrows, 88-Cut, Arctic Fox, Argyle, Canada Mark, Canada Mark eligible, Canadian Ice, Heart's On Fire, Polar Bear, Polar Ice
Cash Price	Index Price, Index Asking Price	* The price at which the seller is prepared to sell for cash on delivery/order. Per Carat, no dollar sign, no commas, no cents.
Cash Discount %	IndexDiscountPercent	Examples: Entering: -0.30 will give 30% below Rap. * Enter a negative decimal (eg - 0.25) for a discount or positive decimal (eg 0.05) for a premium the Rapaport list.
Certificate #	Cert Num, CertID, CertificateID, CertificateNum, CertificateNumber, CertNo, CertNum, CmPub	* Enter the number on the certificate from the grading lab.
Certificate Filename	CertFile, CertFilename, CertificateFile, CertificateFilename, CertificateImage, CertImage, File	Only .JPG, .PDF and .PNG files are accepted. Maximum size of the scan can not exceed 1 MB. The best quality / filesize ration will create files of about 500 Kb. * Scanned image of the certificate in JPG or PDF form only.
City	City, CityLocation	* Specify the physical location of the diamond
Clarity	Clar, Clarity, Clearity, Purity	FL, IF, Loupe Clean, LC, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, P1, I2, P2, I3, P3. * For fancy colored stones that have no clarity, enter "N" for none.
Color	Color, Colr, Colour	D, E, F, G, H, I, J, K, L, M, N, O,P, Q, R, S, T, U, V, W, X, Y, Z * For fancy colors use the fancy color column.
Cert Comment	Comments, Remarks, Lab comment, Cert comment, Certificate comment, Laboratory comment	* No more than 255 characters.
Country	Country, CountryLocation, LotCountry	Specify the physical location of the diamond
Crown Angle		* Give a value to the nearest 0.5 degree.
Crown Height	Crown, Crown Percent, CrownHeight, CrownPct	* Give percentage with only one number after the decimal. Do not include % sign.
Culet Condition		P = Pointed A = Abraded C = Chipped
Culet Size	Culet, CuletSize, Culet_size, CuletGrade,Cullet, CulletGrade	EL = Extremely Large VL = Very Large L = Large SL = Slightly Large M = Medium S = Small VS = Very Small N = None
Cut Grade	Cut, CutGrade	I= Ideal, ID EX = Excellent, EXC VG = Very Good G = Good F = Fair P = Poor
Depth %	Depth, Depth Percent, DepthPct, DepthPercent, Dpth, TotalDepth	Example: 62.4 * Give percentage with only one number after the decimal. Do not include % sign.
Diamond Image	DiamondImage, Image, ImageFile, Photo	Only .JPG, .PNG and .PDF files allowed. You can also provide a URL to your image/video. PDF files are accepted. Maximum file size of the image should not exceed 1 MB.
Display Cert Number	DisplayCert, ShowCert	Y = Yes N = No * Allows you To hide/show the certificate number
Eye Clean	Eye Clean	Yes Borderline E1 E2 = E2, No
Sarine Name	Sarine Loupe, Sarin Loupe	Sarine file name
Fancy Color	FancyColor, FancyColorMainBody, FC-Main Body, FCMainBody	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 * To enter two colors, separate with a hyphen or a space. Example: Blue-Green, Blue Green, B-G, B G
Fancy Color Intensity	FancyColorIntensity, FCIntensity, FC-Intensity	F = Faint VL = Very Light L = Light FCL, FL = Fancy Light FC = Fancy, FC FCD = Fancy Dark I = Fancy Intense FV = Fancy Vivid D = Fancy Deep, DP, Deep
Fancy Color Overtone	FancyColorOvertone, FancyColorOvertones, FCOvertone	Example: Brownish-Yellowish * List any overtones in the color.
Fluorescence Color	FlrColor, Fluo Color, Fluor Color, FluorColor, FluorescenceColor	B = Blue, BL W = White, WH Y = Yellow, YL O = Orange, OR R = Red G = Green, BG N = None, NIL, NON * Default is "N" if left blank.
Fluorescence Intensity	Flr, FlrIntensity, Fluo Intensity, Fluor, Fluor Intensity, Fluorescence, Fluorescence Intensity, FluorescenceIntensity, FluorIntensity	VS = Very Strong, VST, FL4 S = Strong, STG, ST, FL3 M = Medium, MED, FL2, F = Faint,FNT, Negligible, FA, FL1 SL = SL, Slight, SLI VSL = Very Slight, VSLG, VSLT N = None, NON,No, NIL, FL0
Girdle %	Girdle Percent, GirdlePct, GirdleThicknessInPct	* Must be a positive number. Do not include % sign.
Girdle Condition	Girdle Condition	P = Polished F = Faceted B = Bruted
Girdle Thick	GirdleMax, GirdleThick	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
Girdle Thin	Girdle, GirdleMin, GirdleThin	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 * You may enter both Girdle Thin and Girdle Thick in this field, separate with a hyphen. Example: thn-thk
Is Matched Pair Separable	IsMatchedPairSeparable, IsPairSeparable, PairSep, PairSeparable, Separable, Separatable	Y = Yes N = No * If this value is set to "Y" the individual diamonds will show up in single stone searches as well as pair searches. If stones are a pair and they are marked NOT separable they will NOT show up in single stone searches.
Key To Symbols	KeyToSymbols, Key	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
Lab	Cert, Certificate, Laboratory	GIA = G.I.A, G AGS = AGS, AGSL, AGS0, A CGL = CGL, Central Gem Laboratory DCLA GCAL GSI = GSI, GS, Gemscience HRD = HRD, H IGI = IGI, I NGTC None = None, N, X, NO, NON,NC, NonCert Other = Other, Own PGS VGR RDC RDR GHI IIDGR SGL
Laser Inscription		* Enter no more than 50 characters.
Measurements	Dimensions, Meas, Measurement, Measurements	Example: 8.93 x 6.44 x 3.82
MeasWidth	Measurements Width, Width, MeasurementsWidth	* Use as alternative to "measurements"
MeasDepth	Measurements Depth, Height, MeasurementsDepth, MeasHeight	* Use as alternative to "measurements"
MeasLength	Measurements Length, Length, MeasurementsLength	* Use as alternative to "measurements"
Member Comments	Member Comments	* Enter no more than 255 characters.
Milky	Milky, Cloudy	None, Light (M1), Medium (M2), Heavy (M3)
Open Inclusion	Open Inclusion	None = Open Inclusions None, OT1 = Open Table Small, OT2 = Open Table Medium, OT3 = Open Table Large, OC1 = Open Crown Small, OC2 = Open Crown Medium, OC3 = Open Crown Large, OP1 = Open Pavilion Small, OP2 = Open Pavilion Medium, OP3 = Open Pavilion Large, OG1 = Open Girdle Small, OG2 = Open Girdle Medium, OG3 = Open Girdle Large * Acceptable values are the short values in bold.
Pair Stock #	MatchedPairStockNo, MatchedPairStockNum, MatchedPairStockNumber, Matching Stock Num, MatchingPair, MatchingStockNo, MatchingStockNum, MatchingVenderStockNumber, Pair, PairStock, PairStockNum, PairStockNumber	* Enter the stock number of the other diamond in the pair.
Parcel Stones	ParcelStoneCount, ParcelStones, StoneCount, Stones	* Enter the number of stones in the parcel. This field should be left blank for single stones.
Pavilion Angle		Example: 62.3 * Give a value to one decimal place.
Pavilion Depth	Pavil, Pavilion, Pavilion Percent, PavilionDepth, PavilionPct	Example: 62.3 * Give a value to one decimal place.
Polish	Finish, Pol	I = I, ID EX = Excellent, X VG-EX = Very Good to Excellent, VGEX VG = Very Good,V, V. Good, V.G G-VG = Good to Very Good G = Good F-G = Fair to Good F = Fair P= Poor
RapNet Discount %	PctRapNetDiscount, Rap netDisc, RapnetDiscount, RapnetDiscountPct, RapnetDiscountPercent, RapnetDiscPct, RapnetDpx, RapnetRapPct, RDisc, RDiscount, RDiscountPct, RDiscountPercent, RDiscPct, RDpx, RRapPct, RapNet Discount Price	Example: -0.34 To enter a discount below the Rap price, enter a negative decimal value, such as -.25 * Please note that if both discount% and price/ct are uploaded, only the price/ct will be considered.
RapNet Price	AskingPrice, PerCarat, PerCt, Prc, Price, PriceCarat, PriceCt, PricePerCarat, PricePerCt, Px	* The price at which the seller is prepared to sell the diamond, often a memo or credit price. Per carat, no dollar sign, no commas, no cents. ** Please note that if both discount% and price/ct are uploaded, only the price/ct will be considered.
Report Type	ReportType
Report Issue Date	Report Issue Date
Report Issue Location	Report Issue Location
Seller Spec	Seller Spec	A1
Shape	Shp	Round = B, BR, RB, RD, RBC, Round Brilliant, RND Pear = P, PS, PSH, PB, PMB Emerald = E, EM,EC Square Emerald = SQE, SQEM, SX 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 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 EuropeanCut = EU, European 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 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
Shade	Shade	None, White,Yellow,Brown,Green,Grey,Black,Pink,Blue,Mixed,Faint Brown,Faint Green,Other
ShowOnlyOnRapLink	ShowOnlyOnRapLink
Size	Carat, CaratSize, CaratWeight, Ct, CtSize, CtWeight, Weight, Sz, Weight	Enter .01-99. * For parcels enter total carat weight up to two decimal points.
State	StateLocation	* Specify the physical location of the diamond
Star Length	Star Length
Stock #	ReferenceNum, ReferenceNumber, Stock, Stock Num, Stock_no, StockNo, StockNum, StockNumber, VenderStockNumber	* Enter your inventory stock number.
Symmetry	Sym, Symetry, Sym-metry	I = I, ID EX = Excellent, X VG-EX = Very Good to Excellent, VGEX VG = Very Good,V, V. Good, V.G G-VG = Good to Very Good G = Good F-G = Fair to Good F = Fair P= Poor
Table %	Table, Table Percent, TablePct, TablePercent, Tbl	Example: 60 * Give percentage in two digit form. Do not include % sign.
Trade Show	TradeShow	For use during major trade shows. * See www.rapnet.com/showlistings for instructions.
Treatment	Enhance, Enhancement, Enhancements, Enhance-ments, Treatments	LD = Laser Drilled IRR = Irradiated CE= Clarity Enhanced, Fracture Filled COL = Color Enhanced HPHT = High pressure high temperature OT = Other (enter any other type of treatment) N = For none, if the stone is untreated. * To enter multiple values, separate with a semicolon (;). ALL treatments MUST be listed.
White Inclusions	White Inclusions	None = White Inclusions None, WT0 = White Table Meaningless, WT1 = White Table Small, WT2 = White Table Medium, WT3 = White Table Large, WC0 = White Crown Meaningless, WC1 = White Crown Small, WC2 = White Crown Medium, WC3 = White Crown Large * Acceptable values are the short values in bold.