Elder Scrolls Online AddOns » Optional » Discontinued & Outdated » Guild Sales Quota-discontinued
  • Addon Info.
  • Change Log
  • Other Files (11)
  • Comments (17)
    • Download
    (46 Kb)
    Download
    Updated: 09/11/17 01:42 PM
    Pictures
    File Info
    Compatibility:
    Horns of the Reach (3.1)
    Updated:09/11/17 01:42 PM
    Created:05/20/16 11:36 AM
    Monthly downloads:40
    Total downloads:4,308
    Favorites:4
    MD5:
    Guild Sales Quota-discontinued
    Version: 3.1.1
    by: ziggr [More]
    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:
    1. Click "Save Data Now" button. Add-on will scan Master Merchant and guild membership lists.
    2. Log out (or relog). ESO will then save data, writing SavedVariables/GuildSalesQuota.lua.
    3. 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
    4. 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
    3.1.1 2017-09-10
    • Replace Shissu with our own roster tracker.

    2.7.4 2017-03-28
    • Recently added "rank" column now includes rank names for all ranks, whether custom or default. Thank you to Ayantir's GMen and Rushinator for the pointers.

    2.7.3 2017-03-28
    • Add "rank" column. Custom rank titles included, so you get "3 Veteran" instead of just "3". But non-custom rank titles, I have no idea how to get from the ZOS API, so you're stuck with "1" instead of "1 Guildmaster". Sorry.

    2.7.2 2017-02-18
    • 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(). Thank you @Rushinator for reporting it and helping me test the fix.

    2.7.1 2017-02-17
    • 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.

    2.6.4 2016-12-20
    • 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.

    2.6.3 2016-10-28
    • 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.

    2.6.2 2016-10-18
    • Add "is_newbie", "joined", and "gold_deposited" columns

    2.6.1 2016-10-05
    • Increment API version for ESO 2.6 (One Tamriel). No other changes.

    2.5.1 2016-08-06
    • Increment API version for ESO 2.5 (Shadows of the Hist).
    • Fix nil value error for players with multiple ESO accounts.
      Code:
      lua: GuildSalesQuota_to_csv.lua:138: attempt to index a nil value (global 'guild_name')
stack traceback:
    GuildSalesQuota_to_csv.lua:138: in main chunk
    [C]: in ?

    2.4.1 2016-05-31
    • Increment API version for ESO 2.4 (Dark Brotherhood). No other changes.

    2.3.11.1 2016-05-20
    Initial release.
    Optional Files (0)


    Archived Files (11)
    File Name
    Version
    Size
    Uploader
    Date
     Guild Sales Quota
    2.7.4
    46kB
    ziggr
    03/28/17 10:23 PM
     Guild Sales Quota
    2.7.3
    46kB
    ziggr
    03/28/17 05:58 PM
     Guild Sales Quota
    2.7.2
    45kB
    ziggr
    02/18/17 06:27 PM
     Guild Sales Quota
    2.7.1
    45kB
    ziggr
    02/17/17 06:20 PM
     Guild Sales Quota
    2.6.4
    45kB
    ziggr
    12/20/16 09:24 PM
     Guild Sales Quota
    2.6.3
    45kB
    ziggr
    10/28/16 02:02 PM
     Guild Sales Quota
    2.6.2
    44kB
    ziggr
    10/18/16 11:24 PM
     Guild Sales Quota
    2.6.1
    42kB
    ziggr
    10/05/16 07:58 PM
     Guild Sales Quota
    2.5.1
    42kB
    ziggr
    08/06/16 05:10 PM
     Guild Sales Quota
    2.4.1
    42kB
    ziggr
    05/31/16 08:02 PM
     Guild Sales Quota
    2.3.11.1
    42kB
    ziggr
    05/20/16 11:36 AM


    Post A Reply Comment Options
    Page 2 of 2 < 1 2
    Unread 04/09/18, 09:38 AM  
    ziggr
     
    ziggr's Avatar
    AddOn Author - Click to view AddOns

    Forum posts: 27
    File comments: 275
    Uploads: 10
    Originally Posted by IcyDeadPeople
    Thank you for developing Guild Sales Quota ziggr - I'm just trying it today for the first time and looks like an incredibly handy add-on!

    One small suggestion for new features in the future - ever considered adding a field to track gold deposits to guild bank made by the members?
    I did indeed consider it. With such a field, my weekly guild quota enforcement could track both sales data and donations/raffle ticket deposits. Less work for me each week!

    But our guild has a flexible raffle/donation cutoff time, and locking it to the trader flip deadline Sunday 8pm EST would make that column useless to us. This, along with other differences between sales and donation data, discouraged me from ever merging the two data sets under a single table.

    I did write add-ons to track guild bank deposits. But I lack the time or interest to maintain them, so they've fallen into disrepair:
    --Z
    Report comment to moderator  
    Reply With Quote
    Unread 02/27/19, 08:27 PM  
    Rushinator

    Forum posts: 0
    File comments: 34
    Uploads: 0
    Love the addon & its one of my essential tools for keeping track of guild member sales.

    Recently though I have noticed the accuracy dropping a lot. For example, the Master Merchant total guild sales would be at 108M but Guild Sales Quota would be at 92M (16M difference). I also looked at each individual member and saw members with a lot of missing sales compared to Master Merchant.

    I'm aware that Guild Sales Quota is not 100% accurate but there seems to have been a steep drop off recently. I don't know if its due to one of the recent updates or not, whether its an API updates or Master Merchant changes.

    I'm just wondering if there's any chance of an update that would fix this? I'm still using the addon as its essential but I'm currently I'm having to use a different process to extract accurate MM sales numbers (no where as easy as your addon).

    Thank you.

    Edit 1: Master Merchant has an export function that saves it's data into the Master Merchant lua file. Would it be possible for Guild Sales Quota to use this data to improve accuracy? Basically /mm export -> reloadui -> then Export all the data with GuildSalesQuota (using the MM data from that master merchant lua file for sales & purchases).

    GuildSalesQuota btw is so helpful because it includes data that MM's export doesn't such as Joined Date & newbie status. Data that I use for my immunity status & general info for how long a member has been in the guild.
    Last edited by Rushinator : 02/28/19 at 12:21 AM.
    Report comment to moderator  
    Reply With Quote
    Post A Reply
    Page 2 of 2 < 1 2


    Report this file Report this File

    Category Jump: