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:634
Total downloads:156,637
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 05/16/15, 05:54 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Seems very possible.

I can make it run on both

but you have be my eyes on this one

1.st you you will have trouble with EVERY addon since SavedVaraibles was not meant to be shard. The last once closed will write the variables all else will be lost.

2.I would install the 2nd copy to somewhere else (Tony was running the two accounts at one time - same install - different accounts)

3, I would assume the EU copy does not got to "C:\Users\d\Documents\Elder Scrolls Online\live\" (my examlple) but "C:\Users\d\Documents\Elder Scrolls Online\liveuu\

4. If I were to do this I would put it in a totally separate place to be safe.

You would need a 2nd icon on your desktop, I could make the program DB handle 2 accounts but honestly I don't play so much anymore and would lack the desire. It currently only pulls from one SavedVariables per .exe.

Those are my suggestion.

-d
Last edited by dopiate : 05/16/15 at 05:56 PM.
Report comment to moderator  
Reply With Quote
Unread 05/16/15, 06:19 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
One other thing

All my registry keys would need to have a separate hive name from the one I'm currently using.

If you want to try this it wold take me all of 5 minutes to do find/replace and give up a fully working 2nd version.

-d
Report comment to moderator  
Reply With Quote
Unread 06/10/15, 12:02 PM  
GreyRanger

Forum posts: 0
File comments: 18
Uploads: 0
Can't maximize window

I have tried Guild Sales Assistant on two machines (Win 7 and Win 8) and run into the same problem on both. When I start GSA it comes up in a window, but I can't adjust the size or go to a full screen view (maximize or restore). As a result I can't access some of the functions (export importantly) or see all the sales on some good days.

Any suggestions. Thanks.
Report comment to moderator  
Reply With Quote
Unread 06/11/15, 05:10 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Re: Can't maximize window

Originally Posted by GreyRanger
I have tried Guild Sales Assistant on two machines (Win 7 and Win 8) and run into the same problem on both. When I start GSA it comes up in a window, but I can't adjust the size or go to a full screen view (maximize or restore). As a result I can't access some of the functions (export importantly) or see all the sales on some good days.

Any suggestions. Thanks.
Can you send me a screen shot - I had this happen to one other person.

Do you not get scroll bars?

The reason you can't maximize is when you do every element has to be anchored and they aren't it would look horrible so I had to lock that feature.

If I can see what you are looking at I can adjust it for custom.

reply to my email: [email protected]

Don't worry I will fix it.

-d
Report comment to moderator  
Reply With Quote
Unread 06/12/15, 05:26 AM  
GreyRanger

Forum posts: 0
File comments: 18
Uploads: 0
Wow, you are too kind to be willing to look at this. I sent the email.
Best wishes.
Report comment to moderator  
Reply With Quote
Unread 06/12/15, 11:38 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Originally Posted by GreyRanger
Wow, you are too kind to be willing to look at this. I sent the email.
Best wishes.
Always :-)

and we got you fixed.

-d
Report comment to moderator  
Reply With Quote
Unread 06/25/15, 08:11 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
All users of GSA for MM....

Sadly, I have to report that I am no longer playing ESO anymore.

How will this affect Guild Sales Assistant for Master Merchant?

I will make every effort to keep this addon bug free and up to date as long as Philgo68 keeps Master Merchant up to date, there should be no problems.

I would like to apologize to Argusus as I was never able to find the time to finish the integration with TradesMan (It’s a great addon!). That is my only regret and I wish that had been accomplished.

I no longer have the free time I used to, so unless my life drastically changes, Guild Sales Assistant for Master Merchant will not be adding any new features (but I will do my best to continue support/bug fix).

Since it’s dependent on Master Merchant it will keep working just as it has, patch after patch.

One day I hope ZeniMax puts out some new content or a new zone with quests and I have a reason to come back and play. But, for now I have no time/desire to play the same content over and over.

I will keep Speed Farmer updated but if SWAPS Continued breaks someone else will have to take that over.

I’ve enjoyed my time on ESO and coding here, there is a great coder community, lots of users with great ideas and feedback plus, everyone is very helpful!

I wish you all the best of luck,

-dopiate

Ps It’s pretty cool I got my 5000th download toady (that means it’s “popular” according to ESOUI.com) and I get the "popular star"
Report comment to moderator  
Reply With Quote
Unread 08/04/15, 07:38 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Just a brief comment (data purge)

Someone requested this and I needed to do it also.

Do what?

Purge all the data pre patch 1.6.5 (when everything changed).

It's not necessary, it's optional!

I did it so closing GSA is faster.

When you close GSA it does a very through dupe finding routine - the larger the db the longer the time :-)

Here is the instructions if you want to do it also.

I wrote it as if you never used Excel so it's much longer than it needs to be because I documented everything. Better more info than less.

-d
Report comment to moderator  
Reply With Quote
Unread 09/10/15, 01:21 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Sort of an issue

They made an in game change that I find very annoying.

Just letting everyone know I am aware of it and will most likely release a new version to fix it.

What they did is when you had a stack of Flax (for example) it was listed as a sale of Flax.

Seems reasonable, right?

Well, now it's listed as Flaxs! so the database sees them as two separate things. It screws up your sales history.

Now, Rubedo Leather is still Rubedo Leather but spidersilk is now spidersilks. PITA

In a day or so I'll add some code to strip the s off the end so your sales of spidersilk all line up.

Who know they could hot fix Ancestor Silk soon to Ancestor Silks :-)

It's a minor issue but I like consistency so I'll probably fix it.

-d
Report comment to moderator  
Reply With Quote
Unread 09/16/15, 02:13 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Improved Version - Assist if you can

I have finished an improved version of GSA that will automatically take into account the plural changes that were made to items in the game. Unfortunately they did not make this change to every item so I will have to provide a "master list" that will guide the program on what to change.

Using my own database, this is the list I came up with. If you know of any others it would be helpful if you let me know now. You will be able to update your own list but it would be much better if I could get them all as soon as it's released.

Here is the list

Let me know if you know of any I should add before I release the updated version.

Thanks,
-d
Last edited by dopiate : 09/16/15 at 02:14 PM.
Report comment to moderator  
Reply With Quote
Unread 09/17/15, 08:33 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
New Version Today

I believe I have all the item names now (I did some data mining) so this will limit the user interaction.

I also made some code more efficient.

It has just been uploaded.

-d
Last edited by dopiate : 09/17/15 at 10:08 AM.
Report comment to moderator  
Reply With Quote
Unread 11/02/15, 08:54 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Do Not Use!!!

The data I get from MM is broken!

Since I am "all in" with Master Merchant there isn't much I can do except wait for his update.

Sorry :-(

Best thing to do is backup (from your savedvariables folder)

GuildSalesAssistant.lua
GuildSalesAssistantDB.lua

I can't fix it on my end as the data I'm getting is missing a key component, the name of the item!

-d
Report comment to moderator  
Reply With Quote
Unread 11/03/15, 05:27 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Grab New Version For Protection

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.

sorry for any inconvenience - if we can get it fixed within 15 days you will still get all your sales.

It's an easy fix I just have to coordinate with Philgo68, who is very easy to work with.

I believe he has started writing the fix - so I hope this won't be long.

-d
Report comment to moderator  
Reply With Quote
Unread 11/03/15, 12:27 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Update on status

Philgo68 and I have traded emails and we know what the issue is.

It should be fixed fairly quickly, so that you don't lose any sales info.

If you already ran GSA and imported sales with no "item name", I will add a quick routine in GSA to purge those for you.

-d
Report comment to moderator  
Reply With Quote
Unread 11/03/15, 06:28 PM  
Philgo68
AddOn Author - Click to view AddOns

Forum posts: 6
File comments: 320
Uploads: 2
Re: Update on status

Originally Posted by dopiate
Philgo68 and I have traded emails and we know what the issue is.

It should be fixed fairly quickly, so that you don't lose any sales info.

If you already ran GSA and imported sales with no "item name", I will add a quick routine in GSA to purge those for you.

-d
New code sent to you for review. Checked out in testing here.

God Bless,

Philgo
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: