EMC Shopkeeper A utility for viewing your EMC shop transactions. It groups all your transactions by item or by player, telling you how many rupees you made off each item. Screenshots: Current version: 0.5.27 (February 24, 2021) Project Page: https://mangstadt.github.io/emc-shopkeeper Source Code: https://github.com/mangstadt/emc-shopkeeper Wiki: http://empireminecraft.com/wiki/emc-shopkeeper/ FAQ See the Project Page for a list of Frequently Asked Questions. As many of you know, I have a shop on SMP5 (10117). It has been in operation for just over one year. I was curious to know exactly how many items my shop sold and how many rupees my shop made, so I wrote a program which downloads my entire transaction history (over 4,000 pages long) and puts it into a database. Here are some of my findings. I hope you find them interesting/useful. I was surprised at how much wheat I sold. Top 10 Most Popular Items Wheat Cobblestone Oak Log Stone Stone Brick Glass Pine Log Birch Log Sand Sugar Cane Top 10 Most Profitable Items Diamond Iron Ingot Glowstone Exp Bottle Emerald Wheat Villager Egg Emerald Block Oak Log Stone Brick Most Popular Log Type:Oak Most Popular Music Disc: Cat Most Popular Animal Egg: Villager I've put the program on Github if you are interested in using it yourself or if you are a programmer and want to contribute code. At the moment, it requires some technical knowledge to use, but I am working on a user-friendly GUI (graphical user interface) to make it easier to use. https://github.com/mangstadt/emc-shopkeeper
'Fraid since my two brain ops, (and old age lol) my programming skills have long since departed Now, if it was written in COBOL or Easycoder - well....
I haven't tried it yet but have a few questions. Is the program standalone or does it output something like a .csv file? Are your statements based directly from the output or based on observations? Can you tell who made the purchases? Like was the wheat popular because of the amount you sold or because many people bought it?
Right now, you run it from the command-line and it outputs the results there. For the GUI, I plan on putting the results in a table of some sort. And yes, I'd like to add the ability to export the data to CSV and other formats. It comes directly from the data. For the most popular items, I simply sorted the data by number of items sold. For the most profitable, I sorted the data by the amount of rupees I earned from selling each item. Yes, it also records the name of the player who initiated the transaction. I plan on adding the ability to see who your best customers and suppliers are, as well as what your best selling items are. The reason why wheat is so high might be because I have been selling it the longest. When I first started my shop, I pretty much only sold farm-based items. I also have a large wheat farm, so I always have wheat in stock. Wheat was also very popular for a week or two when villager trading was introduced.
I just realized I didn't answer your question. >.< The "Top 10 Most Popular" list is based on the amount of wheat sold, not on the amount people who bought it. So technically, one person could have bought all that wheat.
For your stats, is it possible to divide them by time periods? Like per month, or per year? If not, that might be a future feature request for ya.
Right now, it puts all the results in a table and sorts by item name. I might add the ability to group by month at a later time. My main focus at the moment is on making the app useable.
Version 0.1 is complete. This version allows you to download your shop transactions and query them by date. It groups the transactions by item, allowing you to see how many rupees you earned from each item. You can also export to CSV (for viewing them in a spreadsheet app, like Microsoft Excel) and BB Code (for sharing your transactions here on the forums). Screenshots: To run EMC Shopkeeper, click the link below to download the startup file. Then, double click the file to run it. https://github.com/mangstadt/emc-shopkeeper/raw/master/dist/emc-shopkeeper.jnlp You will see a security warning appear. This warning appears because EMC Shopkeeper requires permission to download your transactions from EMC and to save your transactions to your hard drive. Alternatively, you can also download the full JAR file. Double-click the JAR file to run it.
