Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field nameAcceptable alternate field namesAcceptable field values

Stock #

ReferenceNum, ReferenceNumber, Stock, Stock Num, Stock_no, StockNo, StockNum, StockNumber, VenderStockNumber

* Enter your inventory stock number.


Every media (photo, video, etc) of one stone (product) must have same Stock #.


Valid symbols in the Stock # name:


  1. the number of characters is limited to = 32,
  2. all uppercase letters (A-Z),
  3. all lowercase letters (a-z),
  4. numbers (0-9),
  5. a hyphen or short dash ( - ),
  6. the dot (.) no more than one in a row,
  7. underscores (_),
  8. slash ( / ),
  9. do not use the spacebar.


Uppercase and lowercase are equivalent (A=a).

TypeProduct Type, ProductTypediamond, rough, jewelry

Shape

ShpRound = B, BR, RB, RD, RBC, Round Brilliant, RND
Pear = P, PS, PSH, PB, PMB
Emerald = E, EM,EC
Princess = PRN, PR, PRIN, PN, PC, MDSQB, SMB
Marquise = MQB, M, MQ
Asscher = A, CSS, CSSC, AC
Cushion = CB, Cushion Brilliant, C, CUX, CU, CMB, CUSH, CUS RCRMB, CRC, CSC, CX, RCSB, SCMB, SCX
Heart = H, HS, HT, MHRC
Oval = O, OV, OMB
Radiant = R, RAD, RA, RC, RDN, CRB, RCRB

Size


Carat, CaratSize, CaratWeight, Ct, CtSize, CtWeight, Weight, Sz, Weight

Enter .01-99.
* For parcels enter total carat weight up to two decimal points.

Color

Color, Colr, ColourD, 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.

Clarity

Clar, Clarity, Clearity, PurityFL, 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.

Polish

Finish, PolI = 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

Symmetry

Sym, Symetry, Sym-metryI = 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

Cut Grade

Cut, CutGradeI = Ideal, ID
EX = Excellent, EXC
VG = Very Good 
= Good 
F = Fair 
P = Poor

Fluorescence Intensity

Flr, FlrIntensity, Fluo Intensity, Fluor, Fluor Intensity, Fluorescence, Fluorescence Intensity, FluorescenceIntensity, FluorIntensityVS = 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

Lab

Lab, Cert, Certificate, Laboratory

GIA = G.I.A, G

AGS = AGS, AGSL, AGS0, A

HRD = HRD, H

IGI = IGI, I

IIDGR

EGL

CIBJO





Certificate #

Cert Num, CertID, CertificateID, CertificateNum, CertificateNumber, CertNo, CertNum, CmPub* Enter the number on the certificate from the grading lab.

Fancy Color

FancyColor, FancyColorMainBody,
FC-Main Body, FCMainBody
BK = Black
B = Blue
BN = Brown
GY = Gray, Grey 
G = Green
O = Orange
P = Pink
PL = Purple
R = Red
Y = Yellow

* 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-IntensityF = 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, FCOvertoneBrownish
Brown
Grayish
Gray
Greenish
Pinkish
Grayish Brownish
Purplish
Yellowish
Orangy

...