Diamond CSV Fields
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.