Learn how to use a spreadsheet template to import products

1. Add data to the product template spreadsheet

  • Each row in the spreadsheet template represents one product. Complete one column or many.
  • The title column name must be present in the top row to identify the spreadsheet as an import of products.
  • Each row must have data in the title column to be valid.

New products only

A new product is created for each row in your spreadsheet. Currently, you cannot update existing products using the importer.

Each new imported product will automatically create a new work and a contract with the same name. If the product name and work name should not be the same, update the work name manually within Consonance after import.

Multiple new products for the same new work

If several products in your spreadsheet should belong to the same work (hardback, paperback and ebook, for example), use a matching same work identifier for each product. The same work identifier can be any set of characters that is unique within that column. You might choose one of the product’s ISBNs.

alt text

2. Product columns

Title

  • Titles are automatically de-prefixed. The Hobbit is stored with The as the title prefix and Hobbit as the title, for ONIX compliance.

Subtitle

Edition number

ISBN

  • For now, the ISBN must be entered without hyphens.
  • The data will be validated for the correct number of characters and digits, and the standard ISBN checksum.
  • ISBN-10 will be automatically converted to ISBN-13 for ONIX compliance.
  • ISBN will be formatted for ONIX compliance.

Same work identifier

  • All rows with matching work identifiers will be created under the same newly created work. For example, placing 01 in the same work identifier column on the row with the hardback and the row with the paperback, will create both products under the same work. Otherwise, two separate works will be created, one for each product.
  • The same work identifier can be any set of characters that is unique within that column. You might choose one of the product’s ISBNs.

Pub date

  • The date must be in the format YYYY-MM-DD for absolute clarity.
  • The date must make sense with publishing status. For example, if the pub date is in the future, the publishing status must be forthcoming.

Publishing status

  • Must be a valid ONIX publishing status: either the code, description or one of the keywords: OP or OOP.
  • Must not be 00 Unspecified or 09 Unknown because these are strongly advised against by ONIX recipients.
  • Must not be 12 Recalled (deprecated) because it is deprecated.
  • Must not be 16 Temporarily withdrawn from sale because this requires additional fields.
  • View ONIX publishing status codes.
  • Must make sense with publication date. For example, if the publishing status is forthcoming, the pub date must be in the future.
  • If this field is not provided and a pub date is present, the system automatically assigns: future dates to “02 - Forthcoming” status, past dates to “04 - Active” status.
  • If this field is not provided and a pub date is not present, the system automatically assigns “00 - Unspecified”. Be sure to update this field manually after import.

Product form

  • Must be a valid ONIX product form code such as BB or DG.
  • 00 Undefined or anything ending in A are disallowed as too generic.
  • View ONIX product form codes.
  • If nothing is provided, the system automatically assigns 00 Undefined. Be sure to update this field manually after import.

Imprint code

Main Thema

Main BIC subject

3. More product bulk upload options

Other product attributes are available to manage in bulk elsewhere in the system:

All docs about Import & export