You can import diamond information by exporting your spreadsheet to a CSV file. This article explains each of the required and optional fields that you can include in your CSV file.

Required Fields

For each record in your CSV file, there must be a value for each of these fields:

  • SKU

  • Shape

  • Weight

  • Color

  • Clarity

Specific order

Any fields that you include in the CSV file must appear in the exact order given below. Otherwise, your diamond information will not be imported.

Sample CSV file

You can download a sample CSV file here and make modifications to that file in a program such as Microsoft Excel with your own data.

SKU (Required)

Each diamond will need its own unique SKU. You can use your vendor's stock number, or even a certificate number. This field is used as a unique key for updating your diamond details, and to provide a point of reference for diamond inquiries and orders.

Shape (Required)

Possible values for shapes are:

  • BR = Round Brilliant

  • PRI = Princess

  • EC = Emerald

  • AS = Asscher

  • MQ = Marquise

  • OV = Oval

  • RAD = Radiant

  • PS = Pear

  • CU = Cushion

  • HS = Heart

Weight (Required)

The carat weight field is numeric only, in decimal format, and will only show two decimal places.

Color (Required)

Colors ranging D-L can be found normally by using the color slider. Any other value will be considered a fancy color, which must also be described using the "Fancy Color" and "Fancy Color Intensity" fields.

Clarity (Required)

Possible clarity values are F, IF, VVS1, VVS2, VS1, VS2, SI1, SI2, I1, and I2. Please note that I3 diamonds are not included in the diamond search.

Price (Required)

The price field is for your cost of the diamond, in which retail will be automatically calculated using your markups per each carat weight increment. It is important to note that this field is not price per carat, but the total cost of the diamond.

Cost per Carat

If you want to keep track of your costs, whether from Rapnet or other sources, you can use this field for this purpose. This field is not shown on the front-end along with other diamond information, and is just used for your own calculations.

Price per Carat

This field represents the retail price per carat, if you decide to include this information for your own use. This information is not shown on the front-end.

Discounted Price

If you would like to display a discounted price for your diamond, enter it in this field.

Cut Grade

Possible cut values are EX, VG, G, F, or written out as Excellent, Very Good, Good, or Fair. In-between values can be used by entering VGEX, GVG, or FG. Ideal will be rewritten as EX.

Light Performance

For AGS diamonds, you can include the Light Performance information.

Proportion Factors

For AGS diamonds, you can include the information regarding the Proportion Factors.

Dimension Length

The length of your diamond's measurements in millimeters.

Dimension Width

The width of your diamond's measurements in millimeters.

Dimension Depth

The depth of your diamond's measurements in millimeters.

Measurements

Use this field only if your diamond's measurements are in one field (e.g. 6.04 x 6.01 x 5.89). This field will only be used if the length, width, and depth fields are blank. Note: if you use this field instead of each dimension separately, the L:W ratio can only be derived if you have an "x" or "-" separating each dimension value in this measurements field.

Depth %

Numeric only, in decimal format, and will only show two decimal places.

Table %

Numeric only, in decimal format, and will only show two decimal places.

Girdle Thin

The description of the thin part of the girdle (e.g. Very Thin, THN, etc.) in text value.

Girdle Thick

The description of the thick part of the girdle (e.g. Thick, THK, etc.) in text value.

Girdle %

Numeric only, in decimal format, and will only show two decimal places.

Culet

The culet field has a Yes or No value.

Polish

Possible polish values are EX, VG, G, F, or written out as Excellent, Very Good, Good, or Fair. In-between values can be used by entering VGEX, GVG, or FG.

Symmetry

Possible symmetry values are EX, VG, G, F, or written out as Excellent, Very Good, Good, or Fair. In-between values can be used by entering VGEX, GVG, or FG.

Fluorescence Intensity

The intensity of the fluorescence (e.g. Faint, Strong, None, etc.) in text value.

Fluorescence Color

The color of the fluorescence (e.g. Blue, Yellow, None, etc.) in text value.

Crown Height

Numeric only, in decimal format, and will only show two decimal places.

Crown Angle

Numeric only, in decimal format, and will only show two decimal places.

Pavlion Depth

Numeric only, in decimal format, and will only show two decimal places.

Pavilion Angle

Numeric only, in decimal format, and will only show two decimal places.

Enhancements

Any enhancements for the diamond (e.g. Color Treated, Fracture Filled, etc.) in text value.

Laser Inscription

The diamond's laser inscription information, if any.

Comments

Any comments about your diamond, in text value.

Origin

If you want to include the origin of the diamond you can enter this information here (e.g. Canada, South Africa, Australia, etc.)

Lab

Possible values are AGS, AGS Israel, Canadamark, EGL, EGL Israel, EGL USA, Forevermark, GIA, GIA Israel, HRD, or IGI.

Lab Report #

The lab report number or certificate number of the diamond, if any.

Lab Report Image

If you have an image for your lab report, you can either enter the direct URL for the image starting with "http://", or you can specify the exact image name of a lab report image that has been uploaded via FTP. For FTP access, please contact Punchmark.

Diamond Image

If you have an image of the actual diamond itself, you can either enter the direct URL for the image starting with "http://", or you can specify the exact image name of a lab report image that has been uploaded via FTP. For FTP access, please contact Punchmark.

Vendor Stock Number

This field is simply for your own reference, and can be the same as your SKU if you'd like.

Fancy Color

The information for the diamond's fancy color, if any.

Fancy Color Intensity

The intensity of the diamond's color, if any.

Availability

This field represents the amount of days it will take to ship your diamond. For example, if you enter "0" your diamond will ship today, "1" means it will ship tomorrow. You can also enter a text value, such as "Usually ships within 3-5 business days" which will display as such on the front end. If your value is numeric, this field will automatically calculate the days it will be available to a customer when added to their shopping cart.