It does not 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 the examples at 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:
Electronics:TVs:Color
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.
For example, the path Electronics:TVs:Color will result in three Section pages with the following IDs:
electronics
electronics-tvs
electronics-tvs-color
**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.
***Availability:
Availability is a special type of field. It doesn't normally appear on the Edit page for an Item page. Including this field in your database upload file will cause it to be automatically overridden on your Item pages.
****Ypath:
Ypath is a field that allows you to place your items into specific Shopping product departments. This will help ensure correct placement of your products into Yahoo! Shopping. For information concerning the proper format required for the entries in this field, please consult our Ypath guide at the following URL:
http://shopping.yahoo.com/ypath/
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.
See Also