Update product format records

A common scenario is needing to update select fields of pre-existing product format records. For example, you might need to update the Release Date of product formats due a delay in production.

This solution is very similar to updating product records.

Assumptions

The product format records already exist in TitleLeaf

Procedure

  1. Create a custom template

    1. Add an “isbn” column that will be used to find the pre-existing product format records

    2. Add the product format columns (a subset of the columns present in the “product_formats” template) that represent the data that will be updated (eg, “release_on” column will update the Release Date data of the given product format records).

  2. Populate the template

isbn

release_on

isbn

release_on

978X

2024-01-01

978Y

2024-01-01

978Z

2024-01-01

  1. Save the template as CSV file to your local computer (eg, product_formats-update.csv)

  2. Ingest the CSV file

    1. Ingestion Type = Product Formats

    2. Attachment = product_formats-update.csv