Hello @astroruss,
Just as seeds of thought… Amazon sometimes has crap data that been entered in to their Db, this gets pulled back and in particular this happens with the authors last name.
For example whoever edits or updates Amazon, likes to put the word Author in the the Author field when they shouldn’t, this plays havoc with the ordering filters.
i.e…
Author: Dan Brown (author)
or
Author: James Patterson and (author) Jo Nesbo
These will end up alphabetically at the beginning because of the letter “A” in author.
So you can see sometimes you may have to sanitize the crap data to allow the filters to separate the names out and order the books entries correctly.
Take a look at the books that change and then look at and edit the author field entries to check if there are any oddities.
Jake has to do a lot of work to separate out the first an last names as Amazon does not provide a separate Db table for surnames.
So in short the old expression still stands crap data in crap data out.
Some editorial administration by human eye is needed I am afraid, however Jakes filters do a great job considering.
Andrew