So, I'm a bit of a spreadsheet nerd, and I decided I wanted a way to quickly and efficiently generate shop inventories for my game. I found this table shared on this reddit post, and used it as a template to create this spreadsheet.
What the sheet does is calculate (by generating random numbers) what types of items a shop will have based on its availability, and what their prices are. Availability levels are Limited (think traveling merchants), Rural, Urban, and Premium (capital cities and such). Hidden columns randomly roll a d100 (more or less) and if the roll is successful it randomly selects a price for the item between .75x and 1.5x of the base price. Prices can be adjusted for expensive/inexpensive/favorable/unfavorable conditions by changing the value in the Price Multiplier box, and all important numbers are visible to allow for manual rolling, since the random number generators cause the sheet to change every time any cell is edited. The easy way to lock a shop's inventory values is to set up the editable cells in the top row, then download the sheet as a PDF; it will produce random values that will not change after that point.
What I'm looking for is advice on other ways to improve it. For example, I've already just now changed it to limit prices to two types of coins maximum so it doesn't give prices like '3 pp, 1 gp, 1 ep, 4 sp, 8 cp.' Also, there seems to be a rare glitch where it gives prices like '10 cp' rather than properly converting to '1 sp,' and I'm working on fixing that.
Once I've got it polished I was going to make it downloadable and such for folks, and possibly make a version that doesn't use electrum since I know some people dislike it. Anyone have any ideas or suggestions?
Random Magic Shop Generator 5e
Magic Item Shop Generator
Magic shops have been covered in the 5e Guide to Treasure and Items, mentioning the 5e Magic Shop and Donjon Random Magic Shop. You'll want ways for characters to explore your world so try Quests lists at DnD Speak or or my D&D One Shot ideas generator for an alternative take. Beyond the World. 5eMagic.Shop v0.15.0. This website provides a toolset for Dungeon Masters running 5th Edition Dungeons and Dragons games. Our free generators and calculators prioritize flexibility and ease-of-use for all sorts of campaigns and tables. A magic item shop inventory generator based on Sane Magic Item Prices for 5th Edition Dungeons and Dragons. Cookies & Storage. This site requires the use of cookies and similar techniques to personalize content, analyze traffic, and otherwise improve your experience. 5eMagic.Shop v0.15.0. This website provides a toolset for Dungeon Masters running 5th Edition Dungeons and Dragons games. Our free generators and calculators prioritize flexibility and ease-of-use for all sorts of campaigns and tables. Our Patreon supporters (called 'Keepers') enjoy even more benefits including increased customization and organizational tools. The Magic Item Shop Random Inventory Generator randomly creates a magic item shop’s inventory based on your desired criteria (# minor potions, # medium potions, # major rings, # minor wondrous items, # minor weapons, etc.) using the SRD for 3.5 rules. (The results can usually be adjusted or some items dropped for other fantasy games/versions.).