Download
(2 MB)
Download
Updated: 01/22/19 09:18 PM
Pictures
File Info
Compatibility:
Wrathstone (4.3)
Updated:01/22/19 09:18 PM
Created:11/14/14 11:59 PM
Monthly downloads:617
Total downloads:157,024
Favorites:109
MD5:
Categories:Auction House & Vendors, Utility Mods
Guild Sales Assistant for Master Merchant  Popular! (More than 5000 hits)
Version: 3.9.1
by: dopiate, hawkeye1889
Guild Sales Assistant 3.9.1



Have you tried Guild Sales Master? It's the perfect companion to GSA!

"Using Master Merchant like you should be? Awesome, how about an offline analysis tool! No login necessary. Great way of keeping track of what you're selling in guild stores and helping you then go and craft more."

Quoted From TESO: Essential Addons version2

"Want to go Nerd in Nirn? – then get Guild Sales Assistant for Master Merchant and build an offline database with a great analytic tool set so you can really track what you are selling in your guild stores."

Quoted From The Merchants Guide
...More reviews just below......More reviews just below......More reviews just below......More reviews just below......More reviews just below......More reviews just below......More reviews just below...







Reviews From Around The Web...

And tonight have just added one called 'Guild Sales Assistant' which is a really REALLY good way of keeping track of what you're selling in guild stores and helping you then go and craft more.*

Master Merchant + Guild Sales Assistant are great add-ons.*

100% agree!*

Recommended Addons!*

If you do not use a banking/store app - i would recommend adding one. I personally use Master Merchant which also integrates with Guild Sales Assistant for offline storage of your merchant data.*

What are the best addons to use?*










You MUST have GSA and MM both enabled if you wish to get any new sales offline.

GSA no longer has an in game GUI.

The default GUI has been changed to Master Merchant

To get the offline component working.

1 - make sure you have the latest GSA and MM installed
2 - run the game so GSA and MM can gather your sales
3 - Play for a minute or two and then you can log out (or just keep playing)
4 - then ONLY after you have logged out the FIRST TIME - follow the steps in this video (yes the number of files in the zip has changed.



Thanks to the hard work of Philgo68 we were able to make it possible to run GSA and Master Merchant together.

------------------


If you have trouble with the video the steps are...
  1. Browse to your AddOns folder (open up GuildSalesAssistant folder)
  2. Run the Guild Sales Assistant program
  3. Follow the directions :-)
I do realize this isn't much information but it really is that easy


Reminder: You must have .Net installed if you plan to use the offline tool. If you aren't sure if you have it you can get the latest here - it will not hurt anything to install it or upgrade to the latest one. I am letting everyone know now so there are no bug reports because you didn't get .Net Framework installed!
3.9.1 - fixed a bug introduced in a previous version and API bump

3.9 - minor fixes, tried future proofing a bit more - this is the LAST version. Unless there is a program ending bug, this is it!



3.8.7 murk - API bump for Murk patch
3.8.7a2 - API bump (just updating it to be courteous) reuploaded to fix folder name mistake
3.8.7a - API bump (just updating it to be courteous)
3.8.7 - API bump (just updating it to be courteous)
3.8.6 - No functional changes / just cosmetic typos and misaligned sections (optional update - not a necessary one)
3.8.5 - corrected a minor bug with furniture and linked my bands full catalog from the options menu (all of it's free)
3.8.4 - API bump
3.8.3 - fixed a text bug that was bothering me

3.8.1a - just an API bump
3.8.1 -- tweaks, minor fixes
3.8 -- in one of my previous updates I removed the left and right navigation bars (they have been put back)
-- this version has a more modern look now (I could use a new logo if anyone has the skills)


3.7.6 - Fixed an issue handing some new items
3.7.5 - Removed LUA Memory feature no longer supported by the new client
3.7.4 - API bump + minor code changes
3.7.2 - API bump
3.7.1a - API bump
3.7.1 - fixed issue with item sorting by date being applied to time-frame summaries
3.7.1 - fixed issue with days being skipped when browsing using the < and > buttons

3.7 -- tightened up some core routines (mainly just optimizing)
3.6 -- just an API bump
3.5 -- I have added a section to the options screen to keep data for:

*Forever
*90 days
*60 days
*30 days

This was added as option so your database doesn't get too big with sales that are no longer relevant.


Old Stuff:

New Look! Large sections of code re-written!
  1. Future Patch Protection
  2. Duplicate Proof
  3. Faster (in all aspects)
  4. Database Maintenance & Health Checks on Start Up

reminder: don't forget about the options menu!





version 2.2.2 (1) - No functional changes just made my manifest file Fast API compatible.
version 2.2.3 - "protection mode" - I'm getting bad data from MM and I am trying to protect your DB so this release will only let you view your history until Phil and I can get things worked out.
version 2.2.4 - updated to work with the new patch - some history will be missing but should be picked up in the next version.
version 2.5.0 - transitioning to new format while supporting the old still. Nothing function has changed, it's all under the hood. Preparing for the future.



old change log info......

11/15/2014 - Initial release Version: v.08 (just the LUA engine for users to start collecting data).
------------- Version will be in sync at release, both programs will be 1.0
11/17/2014 - Cleaned up UI issues I didn't notice plus I added back in the key bind option
------------- I wasn't planning on any updates till 1.0 but I didn't realize the key bind was gone
11/24/2014 - Full version of GSA 1.0 the entire suite is released
------------- Please read the directions, watch the video and enjoy the offline tool
11/26/2014 - Added some items to the offline component that should have been in v 1.0
------------- Changed Average Price (in item selection) to Average Price Per Unit
------------- In the Options added the ability to factor in the 8% Guild Sales Tax to all your totals
------------- Added the ability to "uninstall" GSA so it goes through the 'first run' routine again (if needed)
12/01/2014 - Added in the two most requested features
------------- You can now filter by guild - it will show only results for the guild selected
------------- You can now get sales for a date range and not a single date
12/01/2014 - Bug fix and feature
------------- fixed issue where data range selection can go haywire
------------- added feature to backup your database
12/07/2014 - Utility release
------------- added a stand-alone tool to reset GSA (along with source)
12/11/2014 - Offline component optimized and given a "face lift"
------------- as stated in the forums this is a totally optional update.
12/17/2014 - Two new features added both make the program easier to use
------------- 1) on any "report screen" - daily, calendar chosen, etc - you can now double click the line
------------ item and it will take you directly to the detailed history for that product.
------------- 2) on the options screen you can now choose to ALWAYS have results sorted by
------------- date with newest sales listed first (no more double clicking the column header!
12/17/2014 - sorting code had opposite effect in sales reports - I have fixed it :-)
12/26/2014 - Report exporting to csv added
------------- Will use whatever program csv is associated to in Windows.
------------- Due to reports being hard to see I have reverted back to a simpler look
12/29/2014 - Report exporting to csv had a bug in the title it auto selected if you went from range to single date
------------- fixed the grid lines issue

I have multiple machines and this is how my grid (listview) lines look on different ones! (btw never use listview - GRIDVIEW only for those future .NET programmers).

example 1 (home pc)


example 2 (work pc)


It's nuts - well I figured out a solution - on the options page is a button you can toggle Gray or White

so at work I toggle Gray



and I get this now?!?!



I don't know whats up with .NET and the XP Visuals or No XP visuals or whatever but I'm sorry if you have not grid lines for a long time. I actually didn't know.

ok that is what's fixed in 1.5b - along with the report title issue.

(ps there is no difference betweeen 1.5a and 1.5b only, that it was slow enough for me to run our enterprise code analyzer on my app and make some optimization changes. Plus, fix some of my old VB6 style coding to better, more efficient syntax.)

01/15/2015 --All columns are now sortable, this now includes all monetary columns.
01/31/2015 --Updated backup option for archive data
------------- --Minor bug fixes on export csv names (there was a bug)
02/03/2015 --Fix a very hard to find bug that added new sales twice when you hit "reload data"
-------------- --Added arrows to the single day view so you can use buttons to browse easier
-------------- --very simple < previous day, > next day icons
02/05/2015 --added check for Patch 6 - this version should not be run with Patch 6
------------- --This version will protect you from harming your database
------------- --I have the Patch 6 version ready to go but I can not release until the patch
02/19/2015 -- the online component has been retired
------------- --Master Merchant is the new GUI / Data Collector for GSA
04/17/2015 -- Fixed a long standing issue with not all guilds being listed for sorting
------------- -- Added option to skip the ESO intro videos
Archived Files (61)
File Name
Version
Size
Uploader
Date
3.9
2MB
dopiate
01/05/19 01:04 PM
3.8.7 murk
2MB
dopiate
10/22/18 02:06 PM
3.8.7b
2MB
hawkeye1889
08/16/18 10:47 PM
3.8.7b
2MB
hawkeye1889
08/16/18 10:10 PM
3.8.7a2
2MB
hawkeye1889
06/02/18 09:42 PM
3.8.7a
2MB
hawkeye1889
06/02/18 06:48 PM
3.8.7
2MB
hawkeye1889
02/21/18 04:49 PM
3.8.6
2MB
dopiate
10/31/17 06:41 AM
3.8.5
2MB
dopiate
10/29/17 02:24 PM
3.8.4
2MB
dopiate
10/23/17 08:12 AM
3.8.3
2MB
dopiate
09/20/17 04:50 PM
3.8.1a
2MB
dopiate
08/22/17 06:41 PM
3.8.1
2MB
dopiate
07/25/17 08:24 PM
3.8
2MB
dopiate
07/23/17 06:46 AM
3.7.6
864kB
dopiate
07/11/17 04:59 AM
3.7.5
864kB
dopiate
05/23/17 02:55 AM
3.7.4
865kB
dopiate
05/22/17 05:32 AM
3.7.2
865kB
dopiate
02/06/17 05:34 PM
3.7.1a
865kB
dopiate
10/05/16 05:01 PM
3.7.1
865kB
dopiate
09/08/16 08:24 AM
3.7
865kB
dopiate
08/20/16 12:33 PM
3.6
865kB
dopiate
07/30/16 03:46 PM
3.5
865kB
dopiate
07/13/16 06:44 PM
3.4
864kB
dopiate
06/18/16 03:13 PM
3.3c
859kB
dopiate
05/03/16 08:22 AM
3.3b
859kB
dopiate
05/02/16 01:40 PM
3.3a
859kB
dopiate
03/08/16 12:34 PM
3.3
859kB
dopiate
01/01/16 08:02 AM
3.2.1
858kB
dopiate
12/23/15 12:45 PM
3.2
858kB
dopiate
12/12/15 08:24 AM
3.1
858kB
dopiate
11/29/15 02:36 PM
3.0
857kB
dopiate
11/24/15 07:02 PM
2.5.0
850kB
dopiate
11/07/15 03:17 PM
2.2.4
849kB
dopiate
11/04/15 07:48 AM
2.2.3
851kB
dopiate
11/03/15 05:23 AM
2.2.2a
850kB
dopiate
10/28/15 04:43 PM
2.2.2 (1)
850kB
dopiate
09/22/15 02:57 AM
2.2.2
850kB
dopiate
09/21/15 05:26 PM
2.2.1
848kB
dopiate
09/17/15 10:06 AM
2.2.0
848kB
dopiate
09/16/15 04:53 PM
2.1.2
847kB
dopiate
09/01/15 05:03 AM
2.1.1
930kB
dopiate
04/17/15 08:06 PM
2.1.0
930kB
dopiate
04/17/15 10:45 AM
2.0 for Update
930kB
dopiate
03/03/15 01:23 PM
2.0
930kB
dopiate
02/19/15 05:10 PM
 GSA
1.6a
908kB
dopiate
02/05/15 02:05 PM
 GSA
1.6
908kB
dopiate
02/03/15 08:01 PM
 GSA
1.5d
909kB
dopiate
01/31/15 10:58 AM
 GSA
1.5c
907kB
dopiate
01/15/15 01:57 PM
1.5b
907kB
dopiate
12/29/14 12:29 PM
 GSA
1.5
908kB
dopiate
12/26/14 03:44 PM
 GSA
1.4a
907kB
dopiate
12/17/14 11:18 AM
 GSA
1.4
907kB
dopiate
12/17/14 09:28 AM
 GSA
1.3
906kB
dopiate
12/11/14 08:36 AM
 GSA
1.2a(1)
901kB
dopiate
12/07/14 06:13 AM
 GSA
1.2a
818kB
dopiate
12/02/14 08:53 PM
1.2
818kB
dopiate
12/01/14 06:11 AM
1.1
813kB
dopiate
11/26/14 09:15 PM
1.0
813kB
dopiate
11/24/14 06:18 PM
v.08a
65kB
dopiate
11/17/14 07:55 PM
v.08
65kB
dopiate
11/14/14 11:59 PM


Post A Reply Comment Options
Unread 12/29/14, 06:14 PM  
ContraTempo
 
ContraTempo's Avatar

Forum posts: 6
File comments: 41
Uploads: 0
A Thousand Thankyous

Just a little praise. This addon has made a huge difference in my guild sales income. Different items sell better/worse and for more/less in different guilds, so this lets me quickly determine where to sell my stuff for the best price and/or the quickest sale. It lets me know what sells and what doesn't. It helps me to figure out if I am under/over pricing items. The stats let me know if my sales strategy is successful or not.

The code base has got to be larger and more complex than the typical addon so thanks for the time and dedication you put into maintaining this spiffy addon.
Report comment to moderator  
Reply With Quote
Unread 12/26/14, 09:36 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
New Screen Caps and misc info...

all the images of the offline GSA are new

the ones up there had been there for months - and it doesn't even look like that anymore

one thing I neglected to mention is that all reports are saved to "Documents\Elder Scrolls Online\live\GSA Reports"

I figured it was convenient place - If you disagree tell me

you can always select to not save the reports there but that's the default path

remember you aren't locked in the Excel for .csv -- GSA just checks the .csv file association and launches that app -- it doesn't care what you use - just that you have decided that's what you wanted to open CSV.

also there is no combination of filters, days, items, etc... that it won't export for you and I even write you're header row for you !

-d

PS now you can send you friends proof you have a 25k day! :-) also if you get a good graph template to use let me know because i'm striking out in the graphing dept.
Report comment to moderator  
Reply With Quote
Unread 12/23/14, 07:10 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Made a very nice list!

Comment from the official forums
Home Forums General Discussion - English New Player Questions





-d
Report comment to moderator  
Reply With Quote
Unread 12/17/14, 10:07 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
The two features added to GSA

1- From any report screen (daily sales, new sales, selected date or range sales) - you can now click on the items you want to see detailed history of.

example:

In Show Today's Sales, line item 3 is Thin Broth - double click on Thin Broth and it will bring you directly to the items sales history for Thin Broth.

2-You can now decide to set sorting item details screens to Date sorted, newest first. Previously you had to always double click on the Date column for that to be set - the does away with that process.

The option to turn this on is on the Options page.

These options hopefully make GSA even easier to use and more intuitive.


-d
Report comment to moderator  
Reply With Quote
Unread 12/11/14, 06:07 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Update Coming Today - Optional

I have migrated the offline component to Visual Studio .Net 2013 and while doing that I have decided to try and update the look of GSA.

Design and style are things that I am not good at but even I could tell that the interface was bland. Plus, Tony mentioned it looked dull and I agreed with him. I love when people aren't afraid to be honest. Tony is the best person you could ask for to give you feedback. That's a A+ dude!

I also took advantage of .Net 2013's new features to optimize code, use less memory and overall make the application faster. We are talking milliseconds here so I don't really expect anyone to notice. The real point is that it's more efficient and compliant with the new version of windows.

This would be considered a tune-up release and all the changes are "under the hood", therefore it's optional.

The functionality between 1.2a and 1.3 is the same but 1.3 is structurally much different.

I would suggest an upgrade but as stated before it's not necessary to continue use GSA as is.

Why am I telling you all this? Because if you are using my application it's your right to know what I changed and why I changed it.

-d

PS the new screenshot doesn't really do it justice it's just that on my home PC I have all graphic enhancements turned off in Win7 and it's in "classic mode" -- when I run it at work it looks much better. I've even run it on Windows 10 and it's completely compatible.
Last edited by dopiate : 12/11/14 at 06:32 AM.
Report comment to moderator  
Reply With Quote
Unread 12/07/14, 05:33 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Re: Deleted entire key folder

Originally Posted by HeroOfEvbof
Thus the problem is if the first time you run, if you point to a folder that does not have GuildSalesAssistant.lua, you will never get a chance to Uninstall the registry keys via the .exe and will instead be forced to do so via regedit or something akin to that.
Ok my first priority - did you get all setup - if not I will do a TeamViewer with you and help you get setup.

Due what you said about unist (which I didn't know) I wrote this stand alone reset.



I am very sorry that it took this long for you to get setup.

I thank you VERY MUCH for hanging in there and figuring out the issues.

I am going to make this tool available ASAP for anyone else that has this issue.

For some reason I was under the impression you could get to "unist" no matter what -- this will fix that.

Again, my apologies as an addon should never be this hard to install.

Humbly yours,

-d
Last edited by dopiate : 12/07/14 at 07:40 AM.
Report comment to moderator  
Reply With Quote
Unread 12/07/14, 01:41 AM  
HeroOfEvbof

Forum posts: 0
File comments: 64
Uploads: 0
Deleted entire key folder

I did delete the entire key folder. After that I also cleaned every folder and reinstalled. That allowed me to run once and point to the correct directory.

I am fairly positive that my initial install in the morning was totally hosed. Because I didnt point to the savedvariable folder, GuildSalesAssistant.lua never got made and the Auto key never got made.

Here is a example of a bad install - this time into a folder called dummy.
After I run the .exe once and point to dummy folder, here is the registry


Meanwhile, this is what is in the dummy folder


And this is the error I get the next time I run the .exe


I never get the Unexpected Exception Error and thus never get a chance to correct my mistake.

But if the dummy folder has GuildSalesAssistant.lua


The registry ends up looking the same after fresh install and first run but the dummy folder has both files and the error is different


With this error, I had the opportunity to click Options and then click Uninst

Thus the problem is if the first time you run, if you point to a folder that does not have GuildSalesAssistant.lua, you will never get a chance to Uninstall the registry keys via the .exe and will instead be forced to do so via regedit or something akin to that.
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 11:48 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Ok I see some odd things - personally I say start from scratch unless you got it working.

Here is what i see is odd (since I know exactly what should be there)

In this screenshot you dont have an auto value -- that means it didn't do all it needs to install correctly - just delete the entire ShopAssist key - or the options GUI has a place where it will do it for you

you should have an arch, auto, and svcpath value if the install works and you don't

I think you should kill that entire key and let it run its course again.

1st delete in your saved variables the GuildSalesAssistantDB.lua (it won't harm anything)

remove the full key/subkeys - remove that file

then launch the Guild Sales Assistant file in the GuildSalesAssistant folder

What worries me is that I dont see an GuildSalesAssistant.lua in this screenshot

Are you sure you have a GuildSalesAssistant.lua ? is this entire package something you just installed today?

you have to play the game for like 10 minutes until it tells you it's done collecting - it says it in game -- then you can launch the offline tool --- and go through the steps.

by doing it with the wrong path and sorta out of order it's very confused

PM if you need further help - I'll reply right away

but I suggest

remove the entire key - either manually or using my program

make sure you have GSA enabled in the game - wait for it to tell you it's done collecting -- when it is you should log out (you don't have to quit) and then launch the offline tool

that should fix everything

-d
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 11:18 AM  
HeroOfEvbof

Forum posts: 0
File comments: 64
Uploads: 0
I did have a saved data file

I did have a saved data file when I ran the offline, but it since my regkey was pointed in the wrong place I got the wierd error.

I have recreated it here in screenshots.
http://imgur.com/a/QJtPk

I definetly had a ready savedvariable file but my registry is clearly pointed to the wrong place. This wrong place is giving an an error that isnt quite what I expect.

Instead of giving some sort of popups that would allow me to continue, it did the following:

It created a DB file in my badly pointed to directory and gave me an error that tells me to log on and make save some data.
Of course that data I would save would not be in this badly pointed to directory, so I would continue to get this inaccurate error.

If my registry does point to the savedvariable directory and the data file is not there I get the error you would suspect



Anyways, this is pretty easy to recreate. It is unlikely this error will come up often, I was a total dingbat and didnt read the instructions and pointed to AddOns instead of SavedVariables and I doubt there are that many dingbats like myself out there.
Last edited by HeroOfEvbof : 12/06/14 at 11:26 AM.
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 08:30 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Re: Used regedit to re-point folder

Originally Posted by HeroOfEvbof
I used regedit and got it to work. Thanks - I knew it was in the registery somewhere but I did a search on guild and on sales, LoL.
that key is legacy from when this was called Shopkeeper Assistant

just never changed it :-)

-d (very lazy)
Last edited by dopiate : 12/06/14 at 08:31 AM.
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 08:18 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
You are there - but you missed a KEY detail :-)


from the front page

If you are not already using GSA then you have no data for the offline application to use.
You MUST first login and allow the online application to complete one scan (it will alert you during this process) before you can use the offline tool.

You also must either:

1. Log out of your character once so the data is saved to your hard drive
2. Use the "Save Sales (Reload UI)" button on the GUI - that will also save the data to your HD

After that you can start the offline application


:-)

go online - and switch toons at least once

then you are golden.

It's a database tool - but you have yet to generate any data

-d
Last edited by dopiate : 12/06/14 at 08:20 AM.
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 08:10 AM  
HeroOfEvbof

Forum posts: 0
File comments: 64
Uploads: 0
Used regedit to re-point folder

I used regedit and got it to work. Thanks - I knew it was in the registery somewhere but I did a search on guild and on sales, LoL.

Anyways, this is the dialog I get when I was having problems. I very stupidly had the program pointed to /live/addons/guild sales assitant/



When I click OK everything simply closes up.
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 08:05 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Originally Posted by QuadroTony
Originally Posted by dopiate
3) - what do you mean - like right-click close from tray?
if we close application by "X" buttong - do not close it, but just hide to tray
some windows applications have this option too, i personally like it
but nvm, its not so important =)

w8ting for your Graph feature
no never mind - I will look into it :-)

I'm about to release:

Guild Sales Assistant (No ESO GUI) in 2 minutes!

-d
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 07:58 AM  
QuadroTony
Banned
 
QuadroTony's Avatar
AddOn Author - Click to view AddOns

Forum posts: 828
File comments: 3866
Uploads: 3
Originally Posted by dopiate
3) - what do you mean - like right-click close from tray?
if we close application by "X" buttong - do not close it, but just hide to tray
some windows applications have this option too, i personally like it
but nvm, its not so important =)

w8ting for your Graph feature
Report comment to moderator  
Reply With Quote
Unread 12/06/14, 07:48 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Originally Posted by QuadroTony
request options:
start with windows
start minimised
closed to tray
Tony :-)

1- put the shortcut in your start up folder
2 - I can add a switch to start minimized no problem.

3) - what do you mean - like right-click close from tray?

-d
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: