You can import and update product information by importing a CSV file. 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 CSV file. To 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 CSV filedata, 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).-populated (i.e. SKU becomes Item Title, and Meta Description is populated with text from the Description field).
Minimum Recommended Fields
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.
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)
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, 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.
...
Image/Video 1 - Text
This field must match the file name of one of the images or videos you have already uploaded. If the image does not exist, then the item will not be imported. Allowed formats are jpg, png, and mp4
Image/Video 2 - Text
To add an alternate image or video that has already been uploaded.
...
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.
...