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:631
Total downloads:156,644
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 04/19/15, 10:32 PM  
Raven Ninjato
 
Raven Ninjato's Avatar

Forum posts: 4
File comments: 14
Uploads: 0
Install bug

Getting a hiccup on an install of GSA; Win 8 machine. When launching GSA after install get the following: "unhandled exception has occurred in your application. If you click continue, then the application will ignore this error and attempt to continue.." I also installed on a Win 8.1 machine for a second account and worked perfectly. What info can i provide you to help you help me?
Report comment to moderator  
Reply With Quote
Unread 04/18/15, 10:14 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Thumbs up WTF

Originally Posted by CausaMortis
I can top that
You don't have to tell me how or what you sell but give me an idea how you get sales that high?

I just passed 2 million and my database is since Nov 2014!

Amazing numbers btw.

-d
Report comment to moderator  
Reply With Quote
Unread 04/18/15, 12:49 AM  
CausaMortis

Forum posts: 2
File comments: 11
Uploads: 0
I can top that
Report comment to moderator  
Reply With Quote
Unread 04/17/15, 08:07 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Added 1 more thing ...

While I was updating the program today I decided to add the option to skip those pre-login screen videos!



You can find that on the options page.

-d
Report comment to moderator  
Reply With Quote
Unread 03/08/15, 10:02 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Damn man you got me

I don't know how you do it.

148 new sales in one shot! WOW

I had EASILY a 150k weekend!

my total



If my selling alt wasn't IN A WALL!!! I would have hit 2 miliion today.

but I do bow before the master!

Congrats Tony!

Tony you are the #1 seller and you have the proof! (I'm nipping at your heels though!).

-d

.
Last edited by dopiate : 03/13/15 at 06:24 AM.
Report comment to moderator  
Reply With Quote
Unread 03/08/15, 09:09 AM  
QuadroTony
Banned
 
QuadroTony's Avatar
AddOn Author - Click to view AddOns

Forum posts: 828
File comments: 3866
Uploads: 3
i just put it here =)

Report comment to moderator  
Reply With Quote
Unread 02/21/15, 03:37 PM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Happy you are working now!

Originally Posted by Eldorhaan
Dopiate just one word (ok few) U are my hero ^^ it works perfectly as you explain. Thank you so much !.

So now ^^ with MM in collection of data could you make the collection for all transaction ? Is it in your to do list?

Cheers
Eldorhaan,

I am very glad it works for you now :-)

I do not have plans to collect any transactions other then the users sales.

The reason for this is 1) I am not really that into playing ESO right now and so I lack the motivation to do that much work 2) it would require many many additional databases. Like what Philgo has done online with all the mule addons I would need so many different databases and unlike online I would be keeping all this data indefinitely and for myself i don't see the value in so much data offline.

That's my honest answer.

I'm sorry to say that beyond finishing TradesMan support I won't be adding too many additional features.

I think the key to GSA is time. The more of your sales you can track and analyze the better insight you will have into what sells and where. I find that the more data I have the easier it is to sell almost anything.

Again, I'm glad you got it to work. Sorry that my answer is that I won't be adding that feature.

-d
Last edited by dopiate : 02/21/15 at 04:45 PM.
Report comment to moderator  
Reply With Quote
Unread 02/21/15, 12:44 PM  
Eldorhaan
 
Eldorhaan's Avatar

Forum posts: 2
File comments: 142
Uploads: 0
Dopiate just one word (ok few) U are my hero ^^ it works perfectly as you explain. Thank you so much !.

So now ^^ with MM in collection of data could you make the collection for all transaction ? Is it in your to do list?

Cheers
Report comment to moderator  
Reply With Quote
Unread 02/21/15, 04:55 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
Manual Fix (I hope)

Eldorhaan,

Lets take my program out of the situation for the moment.

Are you ok using regedit?

you would go to command line or start->run and type regedit.



Above is what you need to delete - why you are getting an error is probably a language issue as I might be calling for something in English statically. That would not be an issue in GSA but it might be a flaw in the clean up tool.

you open regedit and follow those instructions.

Delete the entire ShopAssist folder - it wont hurt anything on your PC as it is only used for my program.

Let me know how that goes.

After that you should be able to install GSA.
Report comment to moderator  
Reply With Quote
Unread 02/21/15, 04:22 AM  
Eldorhaan
 
Eldorhaan's Avatar

Forum posts: 2
File comments: 142
Uploads: 0
No Problem dopiate yes I had your old version installed on my computer.

I try you reset tool and I get this new message That telling me that my microsoft .net is not ok, but I got the 4.5...

Warning: Spoiler
Last edited by Eldorhaan : 02/21/15 at 04:25 AM.
Report comment to moderator  
Reply With Quote
Unread 02/21/15, 03:22 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
helping you fix

Hi Eldorhaan,

Lets start with some information. I assure you I will get you working as I do not stop supporting you until my program works.

Did you have GSA installed before or is this your first install?

I think you must have tried my very very old version before I had started the actual GSA (previously Shopkeeper Assistant) because you have an error that points to the shopkeeper.lua, which is something I haven't needed or looked for in months.

I think the last update had the old version of my reset tool - not sure how that happened. Please try this version

I believe it is your registry keys and this reset should fix it and you can get re-setup.

Sorry for the inconvenience.

-d
Last edited by dopiate : 02/21/15 at 03:45 AM.
Report comment to moderator  
Reply With Quote
Unread 02/21/15, 02:13 AM  
Eldorhaan
 
Eldorhaan's Avatar

Forum posts: 2
File comments: 142
Uploads: 0
So I try to reset the location of the file with your tool and I get this message: "Impossible to delete a subkey because it doesn't exist"

Here the text error:
Warning: Spoiler
Report comment to moderator  
Reply With Quote
Unread 02/21/15, 02:13 AM  
Eldorhaan
 
Eldorhaan's Avatar

Forum posts: 2
File comments: 142
Uploads: 0
Hi Dopiate,

It's me again, I've got an issue to launch the GSA. I have a popup that indicate me that "Impossible to find the file "C:\\users\me\documents\Elder scrolls online\saved variables\shopkeeper.luaGuildSalesAssistantDB.lua"

I've try to reset the

Here the text code of the error sorry most is in French:
Warning: Spoiler
Report comment to moderator  
Reply With Quote
Unread 02/20/15, 06:24 AM  
dopiate
AddOn Author - Click to view AddOns

Forum posts: 142
File comments: 677
Uploads: 11
It's very easy

Originally Posted by QuadroTony
so i need to reinstall addon completely now right?
or it will delete online component while updating through the minion?
You already use MM, correct? and it's up to date?

Just to make sure to login one last time with GSA (before update) and make sure all your sales are current. (this is a precaution, but not required)

Then you can let minion update.

That's it.

You don't have to remove anything. The online component was completely re-written and now looks to MM as the data collector and so we have created a solution that requires you to do nothing extra. (credit to Philgo for this great solution).

Your shortcut to GSA stays the same.

It's really just an update but what it updates is a big change in the code.

Now you can have GSA and MM enabled together with zero issues.

Actually Tony you bring up a good point that I forgot to add to my main page.

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

The is exactly the opposite of how it used to be. Now GSA NEEDS MM got get new sales.

Thank you for your question - that helped me realize I forgot something.

-d
Last edited by dopiate : 02/20/15 at 06:48 AM.
Report comment to moderator  
Reply With Quote
Unread 02/20/15, 05:12 AM  
QuadroTony
Banned
 
QuadroTony's Avatar
AddOn Author - Click to view AddOns

Forum posts: 828
File comments: 3866
Uploads: 3
so i need to reinstall addon completely now right?
or it will delete online component while updating through the minion?
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: