For automatic upload to work, you must use a specific format. When you upload manually you will be able to map your columns to Mazzal's fields, and you
will get a feedback report to the values that were recognized and not. Automation will not provide any feedback, and take your file as-is. So you
must follow some strict guidelines on how to prepare your file.
Shape or "Shp"
Round = RB, RN, BR, RBC
Princess = PRN, PR
Cushion = CU, CS, CUS, C
Pear = P, PE, PS
Emerald = EM, E, EC
Radiant = RAD, RA
Oval = OV, O
Marquise = MQ, M
Heart = HS, HT, HE, H
Asscher = AC, AS
Trilliant = T, TR
European Cut = EC, EU
Trapezoid = TP
Old Miner = "Sq. Emerald", SQEM, SQE
Square Emerald = Faint
Cushion Modified Brilliant = Cushion Modified, CMB, CM, CB
Baguette = BAG, BG
Kite = K
Half Moon = HM
Bullets = BU
Shield = SH
Triangular = TRIANGLE, TRI
Octagonal = OC
Square
Rectangular
Other = X
Weight or "Size", "Carats", "Carat"
Numeric field with two decimals, e.g. "1.19".
Color or "Col", "Colour"
D
E
F
G
H
I
J
K
L
M
N
OP = O-P
QR = Q-R
ST = S-T
UV = U-V
WX = W-X
YZ = Y-Z
Color Distribution
"even", "uneven"
Fancy Color #1,
Fancy Color #2
or "FancyColor", "Fancy Color" for field with one or two values
Yellow
Brown
Pink
Blue
Green
Black
Orange
Gray
Purple
Champagne
Red
White
Violet
Chameleon
Cognac
Other
Fancy Intensity or "FancyColorIntensity"
FNT = Faint
VLT = Very Light
LGT = Light
FCL = Fancy Light
FCY = Fancy
FDK = Fancy Dark
FCI = Fancy Intense
FCV = Fancy Vivid
FDP = Fancy Deep
Color Overtone #1, Color Overtone #2
You can combine the two into one field called Overtone.
Brownish
Greenish
Yellowish
Pinkish
Purplish
Grayish
Orangey
Orangy
Reddish
Bluish
None
Clarity
FL
IF
VVS1
VVS2
VS1
VS2
SI1
SI2
SI3
I1
I2
I3
Cut or "CutGrade", "Cut Grade"
Ideal = ID, I
Excellent = EX, X
Very Good = VG
Good = GD, G
Fair = FR, F
Poor = PR, P
N
Lab
GIA
IGI
AGS
HRD
PGS
DCLA
EGL USA
CGL
Polish or "Pol"
Ideal = ID, I
Excellent = EX, X, E
Very Good-Excellent = VG-EX
Very Good = VG, V
Good-Very Good = G-VG
Good = GD, G
Fair-Good = F-G
Fair = FR, F
Poor = PR, P
Symmetry
Ideal = ID, I
Excellent = EX, X, E
Very Good-Excellent = VG-EX
Very Good = VG, V
Good-Very Good = G-VG
Good = GD, G
Fair-Good = F-G
Fair = FR, F
Poor = PR, P
MeasLength or "MeasLength", "Length"
Measurement in mm. with two decimals, e.g. 6.32
MeasWidth or "MeasWidth", "Width"
Measurement in mm. with two decimals, e.g. 6.32
MeasDepth or "MeasDepth"
Measurement in mm. with two decimals, e.g. 6.32
Measurements (combo field)
Measurements in mm. with two decimals, e.g. 6.32x6.28x3.54
DepthPercent or "DepthPCT", "Depth %", "Depth"
Depth with one decimal, e.g. 64.5
TablePercent or "TablePCT", "Table %", "Table"
Table with two digits only, e.g. 61
GirdleMin or "Girdle Thin", "GirdleThin"
XTN = Extremely Thin, Extr. Thin, Ex. Thin, Ext. Tn
VTN = Very Thin, I
TN = Thin
STN = Slightly Thin
MED = Medium, M
STK = Slightly Thick, Sl. Thick
THK = Thick, TK
VTK = Very Thick, I
ETK = Extremely Thick, XTK, Ex. Thick, Extr. Thick
GirdleMax or "Girdle Thick", "GirdleThick"
XTN = Extremely Thin, Extr. Thin, Ex. Thin, Ext. Tn
VTN = Very Thin, I
TN = Thin
STN = Slightly Thin
MED = Medium, M
STK = Slightly Thick, Sl. Thick
THK = Thick, TK
VTK = Very Thick, I
ETK = Extremely Thick, XTK, Ex. Thick, Extr. Thick
GirdleStyle or "Girdle Style", "GirdleCondition", "Girdle Condition"
Polished = "Pol."
Faceted = "fac".
Bruted
Partially Polished = "part. pol", "par. pol"
Partially Faceted = "part fac.", "par fac.""
Par.Pol./Par.Fac. = "pol/fac"
GirdlePercent or "Girdle %", "GirdlePct"
Numeric value, e.g. 2.10
Stock# or "VendorStockNumber", "Stock #", "StockNum", "StockNumber", "Packet No"
String up to 20 characters, e.g. ABC-12345
Report Number or "CertificateNum", "CertificateID", "CertNumber", "Cert Number", "Certificate Number", "Certificate #", "Report No"
String up to 20 characters, e.g. 3205693254
Report Comment or "cert comments", "Cert Comment", "CertComment", "Report Comments"
String up to 250 characters
Report Type
String, e.g. "Diamond Dossier"
Report Issue Date
String, e.g. Jan 2016
PricePerCarat or "Price", "Price/ct"
Numeric, e.g. 4500
*Price per carat takes precedence of total price.
PriceTotal or "Total Price"
Numeric, e.g. 5200
*Price per carat takes precedence of total price.
PriceListPercent or "RapnetDiscountPct", "% Discount"
Numeric, e.g. -30.5
* This will be shown as provided.
CuletSize or "Culet Size"
None = N
Large = L
Medium = M
Small = S
Very Small = VS
CuletCondition or " Culet Condition"
Pointed
Chipped
Culet (combo field)
You can combine fields from CuletSize and CuletCondition into this field. E.g Large Pointed
Treatments or "Treatment", "Enhancements"
Color Enhanced = High Pressure High Temperature, HPHT, Coating, Color Enhanced, Irradiation, Irradiated, Color Enhancement
Clarity Enhanced = Clarity Enhanced, Clarity Enhancement, Laser Drilled, Fracture Filled
Other = Anything else
Fluorescence Intensity or "Fluor. Intensity", "FluorescenceIntensity", "Fluor# Intensity"
None = N, NON
Very Slight = VSL, V.Slight
Faint = FNT, F
Slight = SL
Medium = MED, M
Strong = STG, ST
Very Strong = VST, V.Strong
Fluorescence Color or "Fluor. Color", "FluorescenceColor"
Blue = B
Yellow = Y
Green = G, F
Red = R
Orange = O
White = W
Fluorescence (combo field)
Use this field to combine Fluorescence Intensity and Fluorescence Color, e.g. Medium Blue
Crown Height or "CrownHeight"
Decimal value
Crown Angle or "CrownAngle"
Decimal value
Crown (combo field)
You can combine fields from Crown Height and Crown Angle into this field.
Pavillion Depth or "PavilionDepth", "Pavilion Depth"
Decimal value
Pavillion Angle or "PavilionAngle", "Pavilion Angle"
Decimal value
Pavillion (combo field)
You can combine fields from Pavillion Depth and Pavillion Angle into this field.
Inscription or "LaserInscription"
String up to 50 characters.
Ref Number
String up to 20 characters
Seller Comments or "Comment"
String up to 250 characters
Bundle Code
String up to 20 characters
Bundle Separable
Boolean:
True = true, 1, yes
False = false, 0, no, -1
Bundle Type
Matched Pair
Pair
Set
Bundled
Availability
In Stock = IS, A, Available, Guaranteed Available
Hold = H, on hold
Memo = M, out on memo
Private = P, Not available, NA
AllowResale
Boolean:
True = true, 1, yes
False = false, 0, no, -1
Formation Type
Natural = NAT
Synthetic = SYN, CVD, HPHT
AllowMarketPlace
Boolean:
True = true, 1, yes
False = false, 0, no, -1
Brand
Canada Mark
Canadian Origin
Location
Israel
USA
India
Belgium
Hong Kong
U.A.E.
Ramat Gan
New York
Mumbai
Antwerp
Hong Kong
Surat
Dubai
HeartsAndArrows
H&A 100%
H&A 90%
H&A 80%
H&A 70%
H&A 60%
H&A 50%
H&A = EX, VG, GD, Hearts&Arrows
Shade
White
Yellow
Brown
Green
Grey
Black
Pink
Blue
Other
None
Key to Symbols
Free text, up to 200 characters.
* Must be exactly as it appears on the grading report
ReportUrl
Free text, up to 200 characters.
Full URL starting with http:// or https://
ImageUrl
Free text, up to 200 characters.
Full URL starting with http:// or https://
VideoUrl
Free text, up to 200 characters.
Full URL starting with http:// or https://
ViewerUrl
Free text, up to 200 characters.
Full URL starting with http:// or https://
ExtraUrl
Free text, up to 200 characters.
Full URL starting with http:// or https://