Versions Compared

Key

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

...

Cutwise Import format base on CSV format.

Data fields from RapNet format, that are used in Cutwise Product Import:

Field nameAcceptable alternate field namesAcceptable field values

Stock #

ReferenceNum, ReferenceNumber, Stock, Stock Num, Stock_no, StockNo, StockNum, StockNumber, VenderStockNumber* Enter your inventory stock number.

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

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


Fields, supporting only on Cutwise Product Import:

...