Column names must be as specified in the templates. If TitleLeaf does not recognize a column name, then the data will not be ingested.
The column order does not affect ingestion.
A column header with a red background is a required field. The row will not be successfully ingested without it.
Hover the cursor over the column header for column details.
Remove blank columns from the right end of the spreadsheet (i.e., columns without a header).
Remove blank rows rows from the bottom of the spreadsheet.
Avoid carriage returns in fields (eg, in description and annotation.
Be careful of non-ascii characters. Verify when copying from Excel to Google Doc.
Do not put "-" or "N/A" in fields (simply leave blank).
Template: products
A Title (see type column) can be assigned to multiple sets (eg, columns set1, set2, set3)
A Set (see type column) cannot be assigned to other sets
To assign a Title to a Set, the set row must precede the title row. In other words, the set must be defined (or it must pre-exist in the database) before it's used in columns set1, set2, set3
Both titles and sets can be assigned to a series/subseries
Format dates as YYYY-MM-DD. For example, August 1 2015 should be formatted by your spreadsheet application as "2015-08-01".
The proprietary_id is for the product (not the product format)
Unacceptable interest_level_min values: PK (use either P or K, for Preschool and Kindergarten respectively)
The first_release_on is optional, but recommended. It is the earliest release date of all associated product formats.
No need for title column if subtitle not included as well
Avoid duplicate categories (e.g., "Art" and "Arts")
The interest_level_max value must be greater than or equal to interest_level_min value
Unacceptable interest/reading level: 0
Template: product_formats
The proprietary_product_id is mandatory if creating a new product format. The value represents the proprietary_id of a pre-existing product. It is used to associate the product format record to the product record.
The proprietary_id is for the product format (not the product).
The format_name overrides the default format for the given product format row only. Refer to the Override Format Name guide for more information.
The release_on is mandatory. It is the release date of the product format.
If the release date is in the future, then the status must be set to NYP
Format dates as YYYY-MM-DD. For example, August 1 2015 should be formatted by your spreadsheet application as "2015-08-01".
Unacceptable copyright value: 0
Unacceptable pages value: 0
Do not include single or double quotes in the dimensions column. The value is assumed to be in inches.
Do not put fractions in the dimensions column. Use decimals instead (8 1/4 => 8.25).