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, Center 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,Light,Medium,Heavy
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.
Center Inclusion Center Inclusion, Centre inclusion, Central inclusion, table inclusion None,Light,Medium,Heavy
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, No , Borderline 
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
IDR
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,Medium,Heavy
Open Inclusion Open Inclusion None,Light,Medium,Heavy
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
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.