I would like to randomly generate a small town's market square. I'm thinking mundane items and merchants. Does know of any cool products that help with this?
thequickhoof
Event Coordinator - Dragon's Lair Comics & Fantasy®
Just for the merchants I can think of a half-dozen products (many of them produced by Paizo, like the Face Cards) that'll let you pull out some randomized but fully-developed NPCs. GameMastery Guide has a great NPC gallery as well.