Jewelry CSV Fields

You can import jewelry information by importing a CSV file. This article explains each of the required and optional fields that you can include in your CSV file. To generate a CSV file, export your spreadsheet as “.csv” (comma-separated values).

Required Fields

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

• SKU

• Primary Image

Some fields are optional; others, if left blank, will be auto-populated (i.e. SKU will become the Item Title, and Meta Description will be populated with text from the Description field).

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.

Below are the fields for the advanced CSV template. Only fields marked with an asterisk (*) are required.

Value Types

Next to each field name is a value type (in italics). These value types will help you fill out your CSV with the proper information so your site information displays properly.

• Text: words, phrases, dashes, and alphanumeric characters

• Number: numeric values, including decimals (0, 1, 12, 13.4). Do not enter dollar signs, even when entering prices.

• Option: yes/no or true/false statements. For example,

Fields

Item Type - Text
This corresponds to the type of product, such as ring, pendant, bracelet, etc. This information is not required, but can be helpful for categorizing and filtering your products.

SKU / Style Number* - Text
Each item will need its own unique style number. This field is used as a unique key for updating your product details, and to provide a point of reference for product inquiries and orders.

Gender - Text
This field is not required, but every item should have a gender, whether it's Women’s, Men's, or Unisex. You can also check the box labeled "Use Women’s for all blank gender values" when importing your CSV.

Item Title - Text
If you do not have a title, then the SKU will be used. This will also act as your meta title if you do not set a unique meta title.

Cost - Number
This is for your own reference, and this will not be shown on the front-end of the website, unless you have a special wholesale customer system set up through Punchmark.

Retail Price - Number
The price that will show directly to your visitors.

Sale Price - Number
If filled, this will display a discounted price to your visitors. Leave this field blank for full-price items.

Description - Text
This field should contain as much information about your product as possible.

Brand/Collection - Text
This field must match your brand name/collection title exactly in order to tag a product with one of your brands.

Vendor Style - Text
Entering a vendor style is only for your own reference but can be useful when placing orders with vendors.

Availability - Text or Number
Enter either a numeric value or a textual value, such as “3” or “Usually ships within 3-5 business days.” Entering "0" means your item will ship today; "1" means it will ship tomorrow. If you enter a number, this field will automatically populate the number of days until it will be available to a customer when added to their shopping cart.

Primary Category - Text
To be visible, each item must have one unique primary category. If this field is blank, your item will simply be entered as "uncategorized" and will not show up on the front end of your website. This field must match one of your categories exactly.

Other Categories - Text
If there are additional categories in which you would like your product to appear, enter these categories separated by commas. The categories you list must match your existing categories exactly. You will still need to enter a primary category in order for this field to import properly. These categories cannot be the same as your primary category.

Primary Image* - Text
This field must match the file name of one of the images you have already uploaded. If the image does not exist, then the item will not be imported.

Primary Image Alt Tag - Text
To add an alt tag up to 125 characters for the first image for SEO purposes and screen readers.

Image 2 - Text
To add an alternate image that has already been uploaded.

Image Alt Tag 2 - Text
To add an alt tag up to 125 characters for the second image for SEO purposes and screen readers.

Image 3 - Text
To add a third image that has already been uploaded.

Image Alt Tag 3 - Text
To add an alt tag up to 125 characters for the third image for SEO purposes and screen readers.

Image 4 - Text
To add a fourth image that has already been uploaded.

Image Alt Tag 4 - Text
To add an alt tag up to 125 characters for the fourth image for SEO purposes and screen readers.

Image 5 - Text
To add a fifth image that has already been uploaded.

Image Alt Tag 5 - Text
To add an alt tag up to 125 characters for the fifth image for SEO purposes and screen readers.

YouTube Link - Text
If you have a YouTube video for this product, enter the link to the video, which will be embedded on the product details page.

Metal Type - Text
Enter the metal type or abbreviation for the first metal type.

Metal Finish - Text
Enter the metal finish (i.e. Polished).

Ring Setting - Option
If your product is a ring setting, indicate "Y" in this field, which helps customers find matching diamonds if you have the Diamond Search installed.

Setting Type - Text
Enter the type of setting here. Possible setting values are prong, baguette, three stone, bezel, half bezel, tension, channel end, channel, pave, or halo.

Style
The general ring style, if the ring is not a bridal or engagement ring (e.g. knot, eternity, etc.).

Shape Range - Text
If this is a setting, entering the range of possible diamond shapes separated by commas will help customers find matching diamonds if you have the Diamond Search installed (e.g. "round,oval,pear").

Ring Sizes - Number(s)
List all available ring sizes for this item, separated by commas (e.g. "6,6.5,7,7.5,8.8,5,9" etc). If multiple sizes are listed, and e-commerce is enabled, a value must be selected to add it to the cart. Otherwise, one value will be listed for the item information.

Center Diamond Included - Option
If a center diamond is included, enter "Y" in this field.

Center Diamond Carat Weight - Number
This field is for the carat weight of your center diamond.

Center Diamond Shape - Text
The shape of your center diamond.

Center Diamond Cut - Text
The cut of your center diamond. Possible values are EX, VG, G, F, or P.

Center Diamond Clarity - Text
The clarity of your center diamond. Possible values are F, IF, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, I2, or I3.

Center Diamond Color - Text
The color of your center diamond.

Center Diamond Dimensions - Text
The dimensions of your center diamond.

Center Diamond Lab Type - Text
The lab where your center diamond's report was generated.

Center Diamond Lab Report Image - Text
If you have an image of your lab report, you can upload it via FTP. Entering the name of the image here will associate your center diamond with this lab report.

Center Diamond Fluorescence - Text
The fluorescence intensity of your center diamond (e.g. Strong, Faint, etc.)

Center Diamond Fluorescence Color - Text
The diamond fluorescence color of your center diamond.

Center Diamond Table % - Number
The table percentage of your center diamond.

Center Diamond Depth % - Number
The depth percentage of your center diamond.

Center Diamond Culet - Option
If your center diamond has a culet, enter "Y" in this field.

Center Diamond Price - Number
The total price of your center diamond. Do not include a dollar sign.

Center Diamond Price Per Carat - Number
The price per carat of your center diamond. Do not include a dollar sign.

Common Diamond Carat Weight - Number
The total carat weight of your other diamonds.

Common Diamond Shape - Text
The general shape of your other diamonds.

Common Diamond Cut - Text
The general cut grade of your other diamonds. Possible values are EX, VG, G, F, or P.

Common Diamond Clarity - Text
The general clarity of your other diamonds. Possible values are F, IF, VVS1, VVS2, VS1, VS2, SI1, SI2, SI3, I1, I2, or I3.

Common Diamond Color - Text
The general color of your other diamonds.

Total Diamond Count - Number
The number of diamonds in your piece of jewelry, including the center diamond.

Total Diamond Carat Weight - Number
The total carat weight, including the center diamond.

Low Carat Range - Number
The lowest carat weight that can fit in this setting.

High Carat Range - Number
The highest carat weight that can fit in this setting.

Center Gemstone Included - Option
If a center gemstone is included, enter "Y" in this field.

Center Gemstone Type - Text
The type of center gemstone.

Center Gemstone Shape - Text
The shape of the center gemstone.

Center Gemstone Carat Weight - Number
The carat weight of the center gemstone.

Center Gemstone Dimensions - Text
The dimensions of the center gemstone.

Gemstone Type A - Text
The first of five additional gemstone types for a given piece aside from the center gemstone.

Gemstone Type A Shape - Text
The shape of the first gemstone.

Gemstone Type A Carat Weight - Number
The carat weight of the first gemstone.

Gemstone Type A Count - Number
The number of gemstones of the first type.

Gemstone Type A Setting Type - Text
Enter the type of setting here. Possible setting values are prong, baguette, three stone, bezel, half bezel, tension, channel end, channel, pave, or halo.

Gemstone Type B - Text
The second of five additional gemstone types for a given piece aside from the center gemstone.

Gemstone Type B Shape - Text
The shape of the second gemstone.

Gemstone Type B Carat Weight - Number
The carat weight of the second gemstone.

Gemstone Type B Count - Number
The number of gemstones of the second type.

Gemstone Type B Setting Type - Text
Enter the type of setting here. Possible setting values are prong, baguette, three stone, bezel, half bezel, tension, channel end, channel, pave, or halo.

Gemstone Type C - Text
The third of five additional gemstone types for a given piece aside from the center gemstone.

Gemstone Type C Shape - Text
The shape of the third gemstone.

Gemstone Type C Carat Weight - Number
The carat weight of the third gemstone.

Gemstone Type C Count - Number
The number of gemstones of the third type.

Gemstone Type C Setting Type - Text
Enter the type of setting here. Possible setting values are prong, baguette, three stone, bezel, half bezel, tension, channel end, channel, pave, or halo.

Gemstone Type D - Text
The fourth of five additional gemstone types for a given piece aside from the center gemstone.

Gemstone Type D Shape - Text
The shape of the fourth gemstone.

Gemstone Type D Carat Weight - Number
The carat weight of the fourth gemstone.

Gemstone Type D Count - Number
The number of gemstones of the fourth type.

Gemstone Type D Setting Type - Text
Enter the type of setting here. Possible setting values are prong, baguette, three stone, bezel, half bezel, tension, channel end, channel, pave, or halo.

Gemstone Type E - Text
The fifth of five additional gemstone types for a given piece aside from the center gemstone.

Gemstone Type E Shape - Text
The shape of the fifth gemstone.

Gemstone Type E Carat Weight - Number
The carat weight of the fifth gemstone.

Gemstone Type E Count - Number
The number of gemstones of the fifth type.

Gemstone Type E Setting Type - Text
Enter the type of setting here. Possible setting values are prong, baguette, three stone, bezel, half bezel, tension, channel end, channel, pave, or halo.

Total Gemstone Carat Weight - Number
The total carat weight of all gemstones.

Watch Type - Text

The type of watch (analog, digital, quartz, casual, etc.).

Watch Band Material - Text

The material the watch band is made of (leather, gold, stainless steel, silicone, etc.).

Watch Band Style - Text

They style of watch band (Milanese, Oyster, Pilot, embossed leather, etc.).

Watch Case Size - Number

The size of the watch case, in mm.

Watch Case Material - Text

The watch case material (stainless steel, gold, etc.).

Watch Crystal Type - Text

The type or types of crystals in the watch. If there is more than one, enter each value separated by a comma.

Watch Bezel - Text

The type of bezel on the watch (stationary, compass, countdown, etc.).

Watch Dial Color - Text

The color of the watch dial.

Watch Movement - Text

The type of movement driving the watch (quartz, mechanical, automatic).

Watch Clasp - Text

The type of clasp on the watch band.

Watch Water Resistance - Text

Enter any information about the water resistance level of the watch. You can enter sentences, such as “Water resistant up to 100ft” or a simple option (yes/no).

Watch Functions - Text

Any additional functions the watch has, such as day of the week/month, stopwatch functions, etc.

Watch Dial Shape - Text

The shape of the watch dial (round, rectangle, oval, etc.).

Watch Dial Type - Text

The type of dial on the watch (co-signed, crosshair, enamel, etc.).

Watch Band Color - Text

The watch band color.

Enable Checkout - Option
If e-commerce is active, enter a "Y" in this field to have an "Add to Cart" button.

Stock Level - Number
The default stock level is "1". If the stock level is zero, the default out-of-stock message will be displayed. If the stock level is above 1, and e-commerce is enabled, visitors will be able to add multiple quantities to the cart.

Weight - Number
The weight of this piece, in any unit of measure, as a numeric value.

Weight Measurement - Text
Enter the weight unit type, such as lbs, ounces, grams, etc.

Length - Number
Enter a numeric value of the width of the item.

Length Measurement - Text
Enter the length unit type, such as inches, in, ", centimeters, cm, etc.

Width - Number
Enter a numeric value of the width of the item.

Width Measurement - Text
Enter the width unit type, such as inches, millimeters, mm, etc.

Fixed Shipping Price - Number
If this item requires more for shipping, enter a fixed shipping price value, not including dollar signs.

Meta Title - Text
You can generate a page title to improve search engine optimization (SEO) for this specific product page. If blank, the page title is generated by the item title.

Meta Keywords - Text
You can enter enter keyword values separated by commas (e.g. diamonds, diamond jewelry, gold, yellow gold, amethyst, amethysts). This will also tag these items for search terms when visitors search for products.

Meta Description - Text
Meta Descriptions are sometimes used by search engines to generate a description on the search results page. This field also helps you get better search engine optimization (SEO) for this product, as it is adding more pertinent content to your product details page. By leaving this field blank, the meta description is automatically generated by your product description.

Exclude From Coupons - Text

The value can be Yes/No or 1/0, and represents whether the item in this row is coupon-applicable. If set to “no” or 0, coupon discounts won’t be calculated based on this item.