Amazon.com apologised yesterday for an “embarrassing and ham-fisted cataloguing error” that led to the sales ranking being removed from tens of thousands of books and made searching for books more difficult.