Page History

Upload from

...

interface

...

Image Added

Speadsheet format

Cutwise Import format base on XLSX and CSV format.

Data fields, that are used in Cutwise Product Import (* - field is required):

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: the number of characters is limited to = 32, all uppercase letters (A-Z), all lowercase letters (a-z), numbers (0-9), a hyphen or short dash ( - ), the dot (.) no more than one in a row, underscores (_), slash ( / ), do not use the spacebar. Uppercase and lowercase are equivalent (A=a).
Type	Type, Product Type, ProductType	diamond, rough, jewelry * diamond type by default
Shape *	Shape, Shp	Round = Round, Round Brilliant, B, BR, RB, RD, RBC, RND Pear = Pear, P, PS, PSH, PB, PMB Emerald = Emerald, E, EM, EC Princess = Princess, PRN, PR, PRIN, PN, PC, MDSQB, SMB Marquise = Marquise, MQB, M, MQ Asscher = Asscher, A, CSS, CSSC, AC Cushion = Cushion, CB, Cushion Brilliant, C, CUX, CU, CMB, CUSH, CUS RCRMB, CRC, CSC, CX, RCSB, SCMB, SCX Heart = Heart, H, HS, HT, MHRC Oval = Oval, O, OV, OMB Radiant = Radiant, R, RAD, RA, RC, RDN, CRB, RCRB
Size *	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, 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, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, I2, I3. * For fancy colored stones that have no clarity, enter "N" for none.
Key To Symbols	Key To Symbols, KeyToSymbols, Key, InclusionDetails, Inclusion Details	Text * Text length 1-100 symbols
Polish	Polish, Finish, Pol	Ideal = Ideal, I, ID Excellent = Excellent, X, EX Very Good = Very Good, VG, V, V. Good, V.G Good = Good, G, GD Fair = Fair, F, FR Poor = Poor, P, PR
Symmetry	Symmetry, Sym, Symetry, Sym-metry, Symm	Ideal = Ideal, I, ID Excellent = Excellent, X, EX Very Good = Very Good, VG, V, V. Good, V.G Good = Good, G, GD Fair = Fair, F, FR Poor = Poor, P, PR
Cut Grade	Cut, CutGrade, Cut Grade	Ideal = Ideal, I, ID Excellent = Excellent, X, EX Very Good = Very Good, VG, V, V. Good, V.G Good = Good, G, GD Fair = Fair, F, FR Poor = Poor, P, PR
Fluorescence Intensity	Flr, FlrIntensity, Fluo Intensity, Fluor, Fluor Intensity, Fluorescence, Fluorescence Intensity, FluorescenceIntensity, FluorIntensity	Very Strong = Very Strong, VS, VST, FL4 Strong = Strong, S, STG, ST, FL3 Medium = Medium, M, MED, FL2, Faint = Faint, F, FNT, Negligible, FA, FL1 None = None, N, NON,No, NIL, FL0
Fluorescence Color	Fluorescence Color, FlrColor, Fluo Color, Fluor Color, FluorColor, FluorescenceColor	Blue = B, Blue, BL White = W, White, WH Yellow = Y, Yellow, YL Orange = O, Orange, OR Red = R, Red Green = G, Green, BG None = N, None, NIL, NON
Laboratory	Lab, Laboratory	GIA = GIA, G.I.A, G AGS = AGS, AGSL, AGS0, A HRD = HRD, H IGI = IGI, I IIDGR = IIDGR EGL = EGL CIBJO = CIBJO
Girdle Finish	Girdle Finish, Girdle Condition, GirdleFinish	Polished = Polished, P Faceted = Faceted, F Bruted = Bruted, B
Girdle Thin	Girdle Thin, Girdle, GirdleMin, GirdleThin	Extremely Thin = Extremely Thin, XTN, XTHN, EXTN, ETN, EN, XN Very Thin = Very Thin, VTN, VTHN, VTHIN, VN Thin = Thin, TN, THN Medium = Medium, M, MED, MD Slightly Thick = Slightly Thick, STK, SLTK, SLTHK Thick = Thick, TK, THK, THIK, THIC Very Thick = Very Thick, VTK, VTHCK, VTHK, VTHICK Extremely Thick = Extremely Thick, XTK, EXTHICK, EXTHK, XTHK, XTHICK, XTHIK, ETK, EK, XK
Girdle Thick	Girdle Thick, GirdleMax, GirdleThick	Extremely Thin = Extremely Thin, XTN, XTHN, EXTN, ETN, EN, XN Very Thin = Very Thin, VTN, VTHN, VTHIN, VN Thin = Thin, TN, THN Medium = Medium, M, MED, MD Slightly Thick = Slightly Thick, STK, SLTK, SLTHK Thick = Thick, TK, THK, THIK, THIC Very Thick = Very Thick, VTK, VTHCK, VTHK, VTHICK Extremely Thick = Extremely Thick, XTK, EXTHICK, EXTHK, XTHK, XTHICK, XTHIK, ETK, EK, XK * Girdle Thick should be more, than Girdle Thin. If they are equals, Girdle Thick shouldn`t be set.
Culet Size	Culet Size, Culet, CuletSize, Culet_size, CuletGrade, Cullet, CulletGrade	None = N, None Very Small = VS, Very Small Small = S, Small Medium = M, Medium Slightly Large = SL, Slightly Large Large = L, Large Very Large = VL, Very Large Extremely Large = EL, Extremely Large
Certificate #	Certificate #, Cert Num, CertID, CertificateID, CertificateNum, CertificateNumber, CertNo, CertNum, CmPub	* Enter the number on the certificate from the grading lab.
Fancy Color	Fancy Color, FancyColor, FancyColorMainBody, FC-Main Body, FCMainBody	Black = Black, BK Blue = Blue, B Brown = Brown, BN Gray = Gray, Grey, GY Green = Green, G Orange = Orange, O Pink = Pink, P Purple = Purple, PL Red = Red, R Yellow = Yellow, Y * To enter two colors, separate with a hyphen or a space. Example: Blue-Green, Blue Green, B-G, B G
Fancy Color Intensity	Fancy Color Intensity, FancyColorIntensity, FCIntensity, FC-Intensity	Faint = Faint, F Very Light = Very Light, VL Light = Light, L Fancy Light = Fancy Light, FCL, FL Fancy = Fancy, FC Fancy Dark = Fancy Dark, FCD Fancy Intense = Fancy Intense, I Fancy Vivid = Fancy Vivid, FV Fancy Deep = Fancy Deep, D, DP, Deep
Fancy Color Overtone	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.

...

Versions Compared

Old Version 10

New Version 11

Key

Upload from

interface

Image Added

Speadsheet format