Does your guild enforce a sales quota? Use
Master Merchant to see top sellers? If so, you can do all this from within Master Merchant and do not need this add-on.
But if you also want to record sales to a spreadsheet, that's where this add-on comes in.
This add-on scans Master Merchant sales history, summarizes gold totals for your guild's sellers and buyers over last week, then writes that to a SavedVariables file. It can then convert that SavedVariables file to a comma-separated-value file suitable for import into a spreadsheet.
It also tracks the guild roster, noting when a new member joins, so that you can give new members a bit of a grace period before you enforce quotas. (This tracking can take a couple weeks to become useful, since "joined" date is really "joined or first ran Guild Sales Quota 3.1" date.)
Column list:
- guild name
- saved time range begin
- saved time range end
- player account @name
- sold: gold earned in the guild trader last week
- bought: gold spent in the guild trader last week
- is a guild member? Many buyers aren't members.
- is a newbie? Anyone who joined in the last 10 days.
- joined: when did they join the guild?
- columns to help you audit which sales contributed to the total for the reported week: sales count, first/last sales time, buyer, amount.
Instructions:
- Click "Save Data Now" button. Add-on will scan Master Merchant and guild membership lists.
- Log out (or relog). ESO will then save data, writing SavedVariables/GuildSalesQuota.lua.
- From a terminal window, run
% cd ~/Documents/Elder Scrolls Online/live/AddOns/GuildSalesQuota
% lua GuildSalesQuota_to_csv.lua
(Or drag and drop GuildSalesQuota_to_csv.lua onto lua52.exe) This creates SavedVariables/GuildSalesQuota.csv
- Import GuildSalesQuota.csv into a spreadsheet.
GuildSalesQuota_to_csv.lua requires that you have downloaded and installed a standalone Lua interpreter, presumably from
lua.org.
New for 3.1: no longer integrates with
Shissu's Guild Tools. No longer requires the large suite of Shissu tools just to track a single "joined guild date".
Not 100% Accurate: we have occasional reports of sales not appearing in all members' Master Merchant history. This can cause Guild Sales Quota to underreport how much a guild member sold. So if a guild member rebuts with "Hey, I sold a 10k motif page last week!", trust your fellow guildie, not Guild Sales Quota.
--Z