|
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:
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-999.
* 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.
|
|