|
Each product record in the file will contain several fields. Some are required, others are optional and others are required based on the type of product. For example, ISBN is a required field for a book but optional for all other types of products. The field names below are the names used within FeedPerfect. You can use these names within your CSV Comma Separated Value; this file format is a tabular data format that has fields separated by the comma character and quoted by the double quote character. file or use any other names (such as the field names in your database). When your products are imported, you will map the names you choose to the FeedPerfect names. Recommendation: Unless you have a requirement to use your own names, use the FeedPerfect names. The following is a list of all the available fields that can be used. Notes
* = Required fields: Only the ProductID and URL fields are actually required for the import to succeed. Exclusion of other required fields will cause Feed Generation errors for the Feeds that require them.
HR = Highly Recommended. Don't leave your Feed without them. The more fields you use with good information, the better your products will be listed in the CSEs.
Most fields have default values available per feed. If all/most of your products use the same information for a field, consider using a default value during field mapping and skip importing that field. | FieldName | Required | Format | Max Length | Description | | ProductID | * | Alphanumeric | 100 | This is any unique identifier that you have for this product must match column name and field value to tie to other CSV file info or to Yahoo store productID. | | Code | | Alphanumeric | 150 | any unique identifier is searchable in Catalog enhancement. Used primarily for Yahoo stores. In many cases it is the same as Product ID. If you don't have a specific need for this field, it can be left out. | | Description | HR | Alphanumeric | 500 | Main description/title for product | | cc | * | URL | 100 | relative URL for the product page on your site. | | Thumb | HR | Fully Qualified URL | 100 | Small image URL. | | Image | HR | Fully Qualified URL | 100 | Larger image URL. | | Weight | | decimal - up to 3 decimal places | | weight in pounds (10.1, 10, 10.001) | | Orderable | * | 1/0, y/n | | 1 or Y for orderable 0 or N for not orderable Product won't be imported into FeedPerfect if 0/N | | Taxable | | 1/0, y/n | | 1 or Y if taxable 0 or N if not taxable | | Caption | | Alphanumeric | 500 | Main lengthy description. No real limit on size. Main CSE's do have size limits on this field. | | Availability | | Alphanumeric | 100 | Additional text concerning availability (This item usually ships within 3 - 4 days) | | Price | * | decimal - up to 3 decimal places | | Normal price, or MSRP | | SalePrice | | decimal - up to 3 decimal places | | current sale price if this is lower, map CSE price field to this variable as primary data source and Price as secondary source. | | StoreCategory | | Alphanumeric | 100 | your store category The full category path is to be used. Each part is separated by a ">" (i.e. kids>toys). | | Manufacturer | HR | Alphanumeric | 100 | Chevrolet | | Brand | HR | Alphanumeric | 100 | Impala | | ProductStatus | | 1/0, y/n | 1 | 1 or Y 0 or N | | COG | | decimal - up to 2 decimal places | | Cost of goods sold. Not currently used in FeedPerfect. | | UPC | HR | Alphanumeric | 12 | | | InStock | | 1/0, y/n | 1 | 1 or Y 0 or N | | Shipping | | decimal - up to 2 decimal places | | Shipping | | ManfacturerCode | | Alphanumeric | 100 | Manufacturer Part No | | ProductType | | Integer | 11 | 3 or 78645846 | | Currency | | Alphanumeric | 3 | USD (only one supported in FP) | | ShipMethod | | Alphanumeric | 100 | Any shipping information. (FedEx, Free Shipping, Local pickup only, etc) | | ShipFrom | | | | 18702 | | ISBN | | Alphanumeric | 100 | | | Books | | Alphanumeric | 500 | This can be mapped to any Book related field | | Video | | Alphanumeric | 500 | This can be mapped to any Video related field | | Music | | Alphanumeric | 500 | This can be mapped to any Music related field | | Author | | Alphanumeric | 250 | This can be mapped to any Book, Music or Video, related field like Director, Artist, etc | | Custom 1 | | Alphanumeric | 500 | This can be mapped to any FeedPerfect field | | Custom 2 | | Alphanumeric | 500 | This can be mapped to any FeedPerfect field | | Custom 3 | | Alphanumeric | 500 | This can be mapped to any FeedPerfect field | A sample CSV File can be downloaded by clicking here. If Clicking does not work, please try to copy and paste the link into your browser.
|
