Simpler template to ingest leveling data?

To update product record data (be it lexile levels, accelerated reader/renlearn, guided reading levels, etc), the procedure is always the same:

At a minimum you need an “isbn” column and one more column from the “products” template. In effect, we’re creating a simplified version of the “products” template (plus the “isbn” column).

Example: Template to update guided reading level data

isbn

guided_level

isbn

guided_level

978X

A

978Y

B

Example: Template to update recovery level data

isbn

recovery_level

isbn

recovery_level

978X

XYZ

978Y

ABC

Example: Template to update dewey data

isbn

dewey

isbn

dewey

978X

421

978Y

923.0

You’re not limited to one data column; you can update multiple fields with one ingestion.

Example: Template to update Lexile data

isbn

lexile

lexile_code

isbn

lexile

lexile_code

978X

300

HL

978Y

400

GN

Example: Template to update Scholastic Reading Counts data

isbn

srcquiznr

srcpoints

srcreadlevel

isbn

srcquiznr

srcpoints

srcreadlevel

978X

A2047

99

4

978Y

B5129

23

2

Example: Template to update Accelerated Reader data

isbn

alsquiznr

alspoints

alsreadlevel

alsinterestlevel

isbn

alsquiznr

alspoints

alsreadlevel

alsinterestlevel

978X

A2047

99

4

3

978Y

B5129

23

2

3

This type of solution doesn’t apply to just leveling data; it applies to any field in the “products” template.

Example: Template to update product description data

isbn

description

isbn

description

978X

Lorem ipsum dolor sit amet, consectetur…

978Y

Excepteur sint occaecat cupidatat non proident…