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.
This add-on also scans guild bank deposits and records each member's deposited total during the week.
Optional: integrates with Shissu's Guild Tools to fetch each member's join date. This is to help guildmasters give new members a bit of a grace period before enforcing sales quotas.
week ending on date
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. (optional, requires Shissu's Guild Tools)
joined: when did they join the guild (optional, requires Shissu's Guild Tools)
gold deposited: amount deposited to guild bank during the week
columns to help you audit which sales contributed to the total for the reported week: sales count, first/last sales time, buyer, amount.
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.
Add 5 hours of slop for GuildGoldDeposits integration, so that gold deposits/raffle ticket purchases made for Sunday raffles will still count towards last week's quota. Yes this implies that a single ticket purchase during the slop range will erroneously meet TWO week's quotas. It's either this or you have to tell the add-on which exact ticket purchase was the cutoff. That's no fun.
Add sale_ct, first/last sale columns, to help with auditing. With this data you can go to Master Merchant, filter on the seller, and identify exactly which sales contributed to the reported week's total.
Add "is_newbie", "joined", and "gold_deposited" columns
Increment API version for ESO 2.6 (One Tamriel). No other changes.
Increment API version for ESO 2.5 (Shadows of the Hist).
Fix nil value error for players with multiple ESO accounts.
lua: GuildSalesQuota_to_csv.lua:138: attempt to index a nil value (global 'guild_name')
GuildSalesQuota_to_csv.lua:138: in main chunk
[C]: in ?
Increment API version for ESO 2.4 (Dark Brotherhood). No other changes.