I wish the bookstore could sell the ones written by sims.
You can have your sims can sell their novels to the bookstore, and then the bookstore will sell them, but your sims lose their original copies, in the process, and would have to buy new ones, if you want them to have their own books.
Sounds like a scam to me.
My Sims sold a bunch of books to the bookstore, but I can't remember them showing up for sale. Of course, I never look at all the options at the bookstore, I just click on the Music/Fishing/Recipes/Skills tab depending on what I want. I can't be bothered to scroll through all those other books.