Osgood
Hero
I've tried that, spreadsheet and all (my excel skills are quite good), but it still takes up so much table time it's crazy. I have two or three players that are so into this part of the game it's ridiculous--they weigh every item, thinking about how they can maximize it long term, then beg and cry for just one more roll, then spend a really long time haggling price over items they don't even really care about... all while the other players get really bored and annoyed by the whole exercise.My answer here is to make what's available at any given time completely random, determined on a table* weighted toward common items. They get to a town and ask if there's any items for sale, I quickly roll to get a general idea of how much happens to be available right now vs what one might expect in a place this size, then generate that many items and there's yer shopping list.
* - note: unless you really like dice-rolling you'll want to use a spreadsheet for this, and the spreadsheet is also immensely faster. Inputting all the data, however, takes ages; you've been warned.![]()
I'm inclined to say something like only a handful of scrolls, potions, and other consumable will ever be available to purchase... but there's a hard limit on magic items in the campaign (that only I know), so for every item you purchase, that's one less you'll find through adventuring. Think hard before buying that potion of healing, you may rob yourself of a magic sword later!