logo mazzal.net
selling diamonds made easy

CSV columns and values for automatic upload

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.

  • General guidelines for "Comma-separated values" (CSV) upload:
  • Your CSV must be formatted properly with comma separated values. The standard Excel uses is the best.
  • Fields with line breaks must be surround by double quotes
  • You can use full or abbreviated values
  • Remove symbols such as percentage and degree symbols.
  • Most columns have alternative names that can be used.

  • Fields & values
    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
    StarLength
    Decimal value
    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://