Below is the list of fields for Punchmark’s advanced CSV product template. Only fields marked with an asterisk (*) are required. You will notice that certain fields will not apply for a particular piece, so these fields can be ignored. Some fields require exact matches to Punchmark’s standard classifications, such as metal type, diamond clarity, etc. If you are uncertain about possible values of a specific field, please contact Punchmark.
ITEM TYPE
This corresponds to the main type of product, such as ring, pendant, bracelet, etc. Please enter the most descriptive version of the product type. Some examples of descriptive item types are engagement ring, wedding band, diamond necklace, men’s ring, gemstone pendant, or pearl strand bracelet. This field will be matched against a standard item type. If there is no match, you can map your item type to a standard item type.
SKU / STYLE*
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. If you have variations of products, these will each need their own style number.
GENDER
This field is not required, but every item should have a gender, whether it's women’s, men’s, or unisex.
ITEM TITLE
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. The item title is very important for SEO purposes, and should be brief, such as “Silver Amethyst Bracelet” or even “14K white gold diamond engagement ring”.
COST
Your cost is never shown to the public. This is multiplied by each retailer’s markup in order to derive their retail price.
RETAIL
This field is generally used for reference in case a retailer needs it to help them decide what markup to use.
WEB DESCRIPTION
This field should contain as much information about your product as possible, as this is shown to the consumer, and this is what conveys trust about a given piece. An example could be “This stunning two-tone diamond engagement ring features a yellow gold cathedral setting atop a white gold shank for that balance between traditional and modern. This ring can accommodate a center stone between 0.50 and 4.00 carats, which is not included. Features .22 carats of graduated round diamonds along the sides. Matching wedding band available.”
BRAND
If this field matches the name of an installed brand on your website, this product will be tagged as that brand.
BASE SKU / VENDOR STYLE #
Entering a base SKU will allow you to create variations of a given piece, as long as specific style numbers are used for each variation. For example, an engagement ring “ER-1234” might be the base SKU of two variations, ER-1234-14KW and ER-1234-14KY, available in 14K white and 14K yellow gold, respectively. These additional variations are to be added as separate rows in the CSV file. This field is only required if you wish to have variations for a given piece.
AVAILABILITY
This field represents the amount of days it will take to ship your product to the customer. For example, if you enter "0" your item will ship today, and "1" means it will ship tomorrow. You can also enter a range, such as “3-5” which would represent 3-5 business days. This field is important, as it helps the retailers automatically calculate the days it will be available to a consumer when an item is added to their shopping cart. Retailers create set up their own default availability per each vendor, and if you do not allow drop shipping, the retailer’s value will override any availability you set in this field.
PRIMARY CATEGORY*
This must match one of the existing categories on your website for the product to be visible on your website.
OTHER CATEGORIES
If there are additional categories in which you would like your product to appear, enter these categories separated by commas. These categories cannot be the same as your primary category.
IMAGE / VIDEO 1*
This field must match the exact file name of one of the images (or videos) you will be importing. You can also add the full URL of an image, and our scripts will download the image and resize it accordingly. If your images are named by style number, it is suggested to create a field in excel that uses the adjacent style number field, and then appends “.jpg”, or “.png” to the end.
IMAGE / VIDEO 2
To add an alternate image or video.
IMAGE / VIDEO 3
To add a third image or video.
IMAGE / VIDEO 4
To add a fourth image or video.
IMAGE / VIDEO 5
To add a fifth image or video.
YOUTUBE LINK
If you have a YouTube video for this product, enter the link to the video, which can be used for demonstration purposes, or if you have a youtube link of the 360˚ video itself.
METAL TYPE / MATERIAL
Enter the metal type or abbreviation for the metal type(s) of this piece. These can be entered as combinations; for example “14KWYR” means 14K white, yellow, and rose gold. You can enter the long version or the abbreviated value, and if it is not matched to our system, we can map this field to one of our standard metal types or groups.
RING SETTING
If your product is a ring setting, indicate "1" in this field, which makes it so it can be included in the Bridal Ring Designer on retailers’ websites, where engagement rings can be matched with diamonds.
SETTING TYPE
Enter the type of setting here. Possible setting values are prong, baguette, threestone, bezel, halfbezel, tension, channelend, channel, pave, halo, burnished, sharedprong, bead, bar, invisible, antique, bypass, multirow, singlerow, solitaire, sidestone, fivestone, or cluster.
SHAPE RANGE
If this is a setting, entering the range of possible diamond shapes separated by commas will help customers find matching diamonds. This field is required if you would like an item featured in the Bridal Ring Designer.
RING SIZE(S)
If this piece is only available in one ring size, you can enter it in this field. Otherwise, you can list all available ring sizes for this item, separated by commas (e.g. "6,6.5,7,7.5,8.8,5,9"). When there are multiple ring sizes, consumers will must choose one option before adding it to their shopping cart. If there is a different cost for each ring size, these can be set up in standard JSON data format. Please contact Punchmark for an example of this JSON format.
CENTER DIAMOND INCLUDED
If a center diamond is included in the cost, enter “1” in this field.
CENTER DIAMOND CARAT WEIGHT
This field is for the carat weight of your center diamond.
CENTER DIAMOND SHAPE
The shape of your center diamond.
CENTER DIAMOND CUT
The cut of your center diamond. Possible values are EX, VG, G, F, or P.
CENTER DIAMOND CLARITY
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
The color of your center diamond.
CENTER DIAMOND DIMENSIONS
The dimensions of your center diamond.
CENTER DIAMOND LAB TYPE
The lab where your center diamond's report was generated.
CENTER DIAMOND LAB GROWN
Enter a “1” if this diamond is lab grown.
CENTER DIAMOND LAB REPORT IMAGE
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
The fluorescence intensity of your center diamond (e.g. Strong, Faint, etc.)
CENTER DIAMOND FLUORESCENCE COLOR
The diamond fluorescence color of your center diamond.
CENTER DIAMOND TABLE %
The table percentage of your center diamond.
CENTER DIAMOND DEPTH %
The depth percentage of your center diamond.
CENTER DIAMOND CULET
If your center diamond has a culet, enter "1" in this field.
CENTER DIAMOND PRICE
The total price of your center diamond.
CENTER DIAMOND PRICE PER CARAT
The price per carat of your center diamond.
COMMON DIAMOND CARAT WEIGHT
The total carat weight of your other diamonds.
COMMON DIAMOND SHAPE
The general shape of your other diamonds.
COMMON DIAMOND CUT
The general cut grade of your other diamonds. Possible values are EX, VG, G, F, or P.
COMMON DIAMOND CLARITY
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
The general color of your other diamonds.
COMMON DIAMOND LAB GROWN
Enter a “1” if the common diamonds in this piece are lab grown.
TOTAL DIAMOND COUNT
The number of diamonds in your piece of jewelry, including the center diamond.
TOTAL DIAMOND CARAT WEIGHT
The total carat weight, including the center diamond.
LOW CARAT RANGE
The lowest carat weight that can fit in this setting. This field is required if you would like an item featured in the Bridal Ring Designer.
HIGH CARAT RANGE
The highest carat weight that can fit in this setting. This field is required if you would like an item featured in the Bridal Ring Designer.
CENTER GEMSTONE INCLUDED
If a center gemstone is included, enter "1" in this field.
CENTER GEMSTONE TYPE
The type of center gemstone.
CENTER GEMSTONE SHAPE
The shape of the center gemstone.
CENTER GEMSTONE CARAT WEIGHT
The carat weight of the center gemstone.
CENTER GEMSTONE DIMENSIONS
The dimensions of the center gemstone.
CENTER GEMSTONE QUALITY
The quality of the center gemstone, if applicable.
CENTER GEMSTONE LAB GROWN
Enter a “1” if the center gemstone is lab grown.
CENTER GEMSTONE AGTA CODE
Enter the AGTA code of the center gemstone, if applicable.
GEMSTONE TYPE A
The first of Five additional gemstone types for a given piece aside from the center gemstone.
GEMSTONE TYPE A CARAT WEIGHT
The carat weight of the first gemstone.
GEMSTONE TYPE B
The second of Five additional gemstone types for a given piece aside from the center gemstone.
GEMSTONE TYPE B CARAT WEIGHT
The carat weight of the second gemstone.
GEMSTONE TYPE C
The third of Five additional gemstone types for a given piece aside from the center gemstone.
GEMSTONE TYPE C CARAT WEIGHT
The carat weight of the third gemstone.
GEMSTONE TYPE D
The fourth of Five additional gemstone types for a given piece aside from the center gemstone.
GEMSTONE TYPE D CARAT WEIGHT
The carat weight of the fourth gemstone.
GEMSTONE TYPE E
The fifth of Five additional gemstone types for a given piece aside from the center gemstone.
GEMSTONE TYPE E CARAT WEIGHT
The carat weight of the fifth gemstone.
TOTAL GEMSTONE CARAT WEIGHT
The total carat weight of all gemstones.
STOCK LEVEL
The stock level will be ignored if drop shipping is inactive. If drop shipping is active, this stock level will be used to coordinate the stock levels across multiple retailer websites, and will be adjusted accordingly. If you have drop shipping enabled, and you have a virtually “unlimited” supply of a given piece, this can be set to “99” if you do not want to monitor stock levels closely.
WEIGHT
The weight of this piece, in any unit of measure, as a numeric value.
WEIGHT MEASUREMENT
Enter the weight measurement type, such as lbs, ounces, grams, etc.
LENGTH
Enter a numeric value of the width of the item.
LENGTH MEASUREMENT
Enter the length measurement type, such as inches, in, ", centimeters, cm, etc.
WIDTH
Enter a numeric value of the width of the item.
WIDTH MEASUREMENT
Enter the width measurement type, such as inches, millimeters, mm, etc.
WATCH TYPE
If this piece is a watch, enter the type of watch in this field.
WATCH BRACELET MATERIAL
Enter the material of the watch bracelet or strap.
WATCH BRACELET STYLE
Enter the style of bracelet for the watch.
WATCH CASE SIZE
Enter the case size of the watch.
WATCH CASE MATERIAL
Enter the material of the watch case.
WATCH CRYSTAL TYPE
Enter the crystal type of the watch.
WATCH BEZEL
Enter the information about the watch bezel.
WATCH DIAL COLOR
Enter the color of the watch dial.
WATCH MOVEMENT
Enter the watch movement.
WATCH CLASP
Enter the type of clasp of the watch.
WATCH WATER RESISTANCE
Enter the water resistance of the watch, if applicable.
WATCH FUNCTIONS
Enter any special functions this watch has.
META TITLE
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. Note: Retailers are able to update this content themselves, and typically add their own geographical location.
META KEYWORDS
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. Note: Retailers are able to update this content themselves, and typically add their own geographical location.
META DESCRIPTION
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. Note: Retailers are able to update this content themselves, and typically add their own geographical location.