Supported fields for CSV files
A CSV (Comma Separated Values) file is a comma delimited database file. Commas are used to separate different fields in the database. The default fields that you can use in your CSV file are:
It doesn't matter what order you put the fields in, so long as the field names in the first line match the records in the remaining lines. Additionally, records don't have to contain values for all the fields in an item.
Before creating a CSV file, you may want to review our page on Uploading Data Files.
path The path is a colon-delimited listing of the section an item is contained within. If you want to create a store that is several sections deep, you can do it by separating section names by colons in the path field. For example, a Sony 19 inch color TV's path might be:
When the product is uploaded with this field, the Yahoo Store software will create a section Electronics, a section underneath it called TVs, and then a section called Color under TVs. A link to the item page will then be placed in the Color section.
- You must have the same exact path for additional products in the same section. A mispelling of any part of the path will result in the creation of additional unwanted sections.
- The path will determine the ID of Section and Subsection pages. These pages are each assigned an ID based upon its path. Non-alphanumeric characters and the colon separator will be replaced by a hyphen (-).
For example, the path Electronics:TVs:Color will result in three Section pages with the following IDs:
id This is how the store refers to your item, and it is part of the URL of that item's page when published—http://yourstore.com/id.html, where yourstore.com is your domain name, and id is your item's ID. May contain lowercase letters, numerals, and hyphens only. If you do not specify an ID, your code will be used, with some substitutions. To maintain the greatest control over your store, we strongly suggest that you specify an ID for each of your items.
name Appears on the item page, at checkout, and most other places your item is referred to. Will also be used as the headline if none specified.
code This is usually the merchant's SKU for the product. The code can contain any character.
The code is used to generate the ID for the items. Non-alphanumeric characters are changed to hyphens and everything is lowercased to create the ID.
price If price is entered, item is treated as product for sale. For quantity pricing, use several numbers:
12 2 20 10 80 means 1 for $12, 2 for $20, or 10 for $80. For free products you wish to track with Yahoo Web Analytics, enter a value of 0. Use numerals and a single decimal point only; do not use currency symbols such as $.
sale-price Price entered here overrides the regular price. Format and quantity pricing follows the same format as price.
leaf Must be either No or Yes. Think of this field as describing a tree: branches (leaf=No) are your sections and subsections: there can be branches on branches on branches. Items (leaf=Yes), on the other hand, are the end of the line—there can be multiple leaves on a single branch, but no other part of the tree attaches to a leaf. Since you should really use the path field for creating subsections in your CSV, the leaf value should almost always be Yes.
options For items with multiple sizes, colors, etc. If the item is a gift certificate, do not enter information into this field or the order will fail. In each set of options, the first word is the label (e.g Size) and the rest are the choices (Small, Medium, Large). Use a blank line to separate sets of options, and double-quotes to make several words be treated as a multiple-word phrase. Example:
Size S M L XLFor monograms, use just
Color Black White "Sea Green"
Monogram. For longer customizations, use
"Option Name" Inscription X, where
X is the maximum number of characters that will be accepted. Note the capital letters in both
headline A brief line of description that appears near the top of the item page. If nothing is entered in this field, the item's name will be shown instead.
caption Text describing the product. You can think of this as the "teaser text" or "marketing copy." Essentially, caption tells a viewer about the item, and (hopefully!) encourages a purchase.
abstract Text describing the product where it appears on other pages. If nothing is entered in this field, the item's caption will be shown instead.
ship-weight How many pounds does the product weigh? Required to accurately calculate shipping costs based on weight, including UPS Real-Time Rates. Numerals and a single decimal point only.
orderable Set to No to not display an order button, even when item has price. This is useful when an item is out of stock and you do not wish to accept back orders. Otherwise, any item that you want to sell should have orderable set to Yes.
taxable Are you required to collect sales tax on this item? Must be set to Yes or No.
gift-certificate If Yes, this item will be treated as a gift certificate. Both the taxable and need-ship fields must be set to No.
Note: The gift-certificate option is available only on Merchant Solutions Standard and Professional plans. Creating an item where gift-certificate is Yes on a Merchant Solutions Starter store will result in ordering errors.
availability Availability is a special type of field. It doesn't normally appear when editing an item page online. Including this field in your database upload file will cause it to be automatically overridden on your item pages. Use with caution.
page-title Appears at the top of your visitors' browser window; also used as the text for the clickable link wherever your store appears in web search results.
description Text below the clickable link wherever your store appears in web search results.
product-url Required by some shopping submission engines. Takes the format of http://yourstore.com/id.html, where yourstore.com is your domain name, and id is your item's ID.
condition Required by some shopping submission engines. Usually required to be
New, Used, Refurbished and so forth
Please note that misnaming any of the above fields will cause the the fields to not be recognized upon upload. These field names are not case sensitive, but they must be spelled exactly as they are listed above. The order of your fields in the CSV file are not important.
- Uploading Database Files in Store Editor
- Creating a CSV file with Notepad
- Creating a CSV file with Microsoft Excel