Supported fields for CSV files
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.
pathThe 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 spearator will be replaced by a hyphen (-).
For example, the path Electronics:TVs:Color will result in three Section pages with the following IDs:
idThis 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.
nameAppears 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.
codeThis 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.
priceIf 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-pricePrice entered here overrides the regular price. Format and quantity pricing follows the same format as price.
leafMust 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.
optionsFor 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
headlineA 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.
captionText 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.
abstractText 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-weightHow 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.
orderableSet 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.
taxableAre you required to collect sales tax on this item? Must be set to Yes or No.
gift-certificateIf Yes, this item will be treated as a gift certificate. Both the taxable and need-ship fields must be set to No.
availabilityAvailability 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-titleAppears 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.
descriptionText below the clickable link wherever your store appears in web search results.
product-urlRequired 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.
conditionRequired 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.