Template notes

Owned by Tim Peterson
Last updated: Jul 05, 2023
2 min read

All Templates

  • 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.

Template: products-with-one-format

  • A title (see type column) can be assigned to multiple sets

  • 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

  • Be careful of non-ascii characters. Verify when copying from Excel to Google Doc.

  • Do not include inch abbreviation (") in dimensions

  • Do not put fractions in the dimensions column. Use decimals instead (8 1/4 => 8.25)

  • Format dates as YYYY-MM-DD. For example, August 1 2015 should be formatted by your spreadsheet application as "2015-08-01".

  • Do not put "-" or "N/A" in fields (simply leave blank)

  • proprietary_id is for the product (not the product format)

  • proprietary_product_format_id is optional and can be added to define the product format’s proprietary ID. Keep in mind the distinction between product and product format.

  • Unacceptable interest_level_min values: PK (use either P or K, for Preschool and Kindergarten respectively)

  • release_on is mandatory. It is a value stored on the Product Format level. It signifies the release date of the given product format.

  • If release_on is in the future, then the status must be set to NYP.

  • The first_release_on column is optional. It is a value stored on the Product level. It is the earliest release date of all associated product formats.

  • Unacceptable copyright: 0

  • Unacceptable pages: 0

  • No need for title column if subtitle not included as well

  • Avoid duplicate categories (e.g., "Art" and "Arts")

  • Isbn columns (e.g., reinforced_book_isbn, pdf_isbn, etc) can be added or deleted. At least one isbn column is required. For each isbn column, a product format will be created if it doesn't already exist in the database. The format is dictated by the column name. The remaining product format values are the same for all formats as defined in the product template (e.g., each format will have the same price, copyright, pages, etc). To override these values, you must use the "product_formats-template" google doc.

  • Delete blank columns from the right end of the spreadsheet (i.e., columns without a header).

  • Delete blank rows from the bottom of the spreadsheet.

  • Avoid carriage returns in description and annotation. To convey formatting, use the web_description field and include HTML markup.

  • interest_level_max must be greater than or equal to interest_level_min

  • Unacceptable interest/reading level: 0

TitleLeaf • Status