Whether you are sending a CSV file or connecting us to your product API, these are the columns/fields you will need to curate about each product. These fields were created to help your products sell. This article explains each of the required and optional fields that you should include in your data. If working in Excel or Numbers, to generate a CSV file, export your spreadsheet as “.csv” (comma-separated values). You can also download a template version of our CSV here and simply fill in the rows.
Required Fields
For each record (product) in your data, you must have a value for each of the following fields:
Item Type
SKU/Style
Cost
Image/Video 1
Item Title
Description
All other fields are optional; some, if left blank, will be auto-populated (i.e. SKU becomes Item Title, and Meta Description is populated with text from the Description field).
...
Because this data is what is going to be helping consumers make purchase decisions about your products, we strongly recommend having at least the following fields in addition those required above.
...
Item Title
...
Any gemstone/diamond data (weights, shapes, etc)
Image/Video 2-5
Metal Type
Length/Width (if applicable)
Ring Setting (y/n) (if applicable)
Setting Type (if applicable)
...
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, use “Y” to allow drop shipping for a given item. Entering “N” or leaving the field blank will not allow the item to be drop-shipped.
Specific Order
Any fields that you include in the CSV file must appear in the exact order given below. Otherwise, your product information will not be imported correctly. If you do not wish to fill out a column or series of columns, or those column attributes are not applicable to a given product, leave an empty column.
Fields
All Fields
We recommend you use as many of these as possible. For help or guidance, reach out to assets@punchmark.com.
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.
...
Ring Size(s) - Number(s)
List all available ring sizes for this item, separated by commas (e.g. "6,6.5,7,7.5,8,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.
...