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.
Optional: integrates with Shissu's Guild Tools to fetch each member's join date. This integration helps guild masters give new members a bit of a grace period before enforcing sales quotas.
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. (optional, requires Shissu's Guild Tools)
joined: when did they join the guild (optional, requires Shissu's Guild Tools)
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.
Bugfix: delay Master Merchant calls until after M.M. has a chance to fully initialize. Avoids "attempt to index a nil value
stack traceback:" crash in call to MasterMerchant:ActiveSettings(). Bug introduced in 2.7.1. Thank you @Rushinator for reporting it and helping me test the fix.
Remove GuildGoldDeposits integration. Too inaccurate to be useful. Easier to track deposits/raffle tickets elsewhere.
Add "Date Options" dropdown menu to match Master Merchant's list of date options, so that you can export Today, Yesterday, This Week, Last Week, All History, or other date ranges. Larger time scales might exceed Lua memory or SavedVariables limits.
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.