Page History
...
Cutwise Import format base on RapNet CSV format: http://technet.rapaport.com/Info/LotUpload/FieldsAndValues.aspx
Data fields from RapNet format, that are used in Cutwise Product Import:
Field name | Acceptable alternate field names | Acceptable field values |
---|---|---|
Stock # | ReferenceNum, ReferenceNumber, Stock, Stock Num, Stock_no, StockNo, StockNum, StockNumber, VenderStockNumber | * Enter your inventory stock number. |
Shape | Shp | Round = 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. |
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. |
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. |
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 |
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 |
Cut Grade | Cut, CutGrade | I = Ideal, ID EX = Excellent, EXC VG = Very Good G = Good F = Fair P = Poor |
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 |
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-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 | Brownish Brown Grayish Gray Greenish Pinkish Grayish Brownish Purplish Yellowish Orangy |
Fields, supporting only on Cutwise Product Import:
Field name | Acceptable alternate field names | Acceptable field values | |||||
---|---|---|---|---|---|---|---|
Type | Product Type, ProductType | diamond, rough, jewelry | Origin Country | Specify the country of origin, like "Botswana", "Australia" | Fancy Color Overtone | as in RapNet | Brownish
Cutwise Product Import supports multiple certificates for single product.
...
Overview
Content Tools