Skip to end of metadata
Go to start of metadata

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 is required):

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).

Type

Type, Product Type, ProductTypediamond, rough, jewelry

Shape

Shape, ShpRound = 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, 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, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, I2, I3. 
* For fancy colored stones that have no clarity, enter "N" for none.

Polish

Polish, Finish, PolIdeal = 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, SymmIdeal = 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 GradeIdeal = 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, FluorIntensityVery 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

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 FinishGirdle Finish, Girdle Condition, GirdleFinish

Polished = Polished, P
Faceted = Faceted, F
Bruted = Bruted, B

Girdle ThinGirdle 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 ThickGirdle 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 SizeCulet Size, Culet, CuletSize, Culet_size, CuletGrade, Cullet, CulletGradeNone = 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 #LabCertNoLabCertNo
S1GIA123456789IIDGR12345678
S2GIA987654321


Cutwise Product Import supports Microsoft Office XLSX and CSV formats. 

File example

upload_example.xlsx

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.

  • No labels