Upload from Vendor interface
Speadsheet format
Cutwise Import format base on XLSX and CSV format.
Data fields, 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. Every media (photo, video, etc) of one stone (product) must have same Stock #. Valid symbols in the Stock # name:
Uppercase and lowercase are equivalent (A=a). |
Type | Product Type, ProductType | diamond, rough, jewelry |
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 | 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 |
Cutwise Product Import supports multiple certificates for single product.
Each next certificate can be marked by leading Lab field, like:
Stock # | Lab | CertNo | Lab | CertNo |
---|---|---|---|---|
S1 | GIA | 123456789 | IIDGR | 12345678 |
S2 | GIA | 987654321 |
Cutwise Product Import supports Microsoft Office XLSX and CSV formats.
File example
Archive format
Archive should be compressed as zip and contains .zip extension.
Archive should contain exact 1 Spreadsheet in CSV or XLSX format.
Certificate files can be added in archive. Each certificate file must be named in format 123456789.pdf, where 123456789 is certifcate number, mentioned in Spreadsheet file.
Maxium allowed archive file size is 500 Mb.