You can import premium vendor and update product information by importing a CSV file. This article explains each of the required and optional fields that you can should include in your CSV file. To generate a CSV file, export your spreadsheet as “.csv” (comma-separated values).
Required Fields
For each record (product) in your CSV file, there you must be have a value for each of these the following fields:
Item Type
SKU/Style
Cost
Image/Video 1
Some All other fields are optional; otherssome, if left blank, will be auto-populated (i.e. SKU will become the becomes Item Title, and Meta Description will be is 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,
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
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* 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.
...
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.
Image/Video 1* 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.
...
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 from your product description.