Merchant Archive

No.

I only sell the goods I make, and have a good enough grasp of which ones are selling that I can keep my vendors stocked. Of course, I don't move hundreds of items a day out of 6 locations, either. That would be far too busy for me to have fun.

I am a merchant to sell my own goods.

I export /mailsave each day, import info into a database.
Reports are somewhat rudimentary.
I found that I tend to stock vendors every 3 days. A different vendor each time.
So I made a 3 day sales report and daily sales by location.

I managed my harvesters and lots via excel. The "average daily running costs" are input from that for each date, allowing me to calculate some idea on profit and actual costs.

I track inventory, using /mailsave and a nice little extraction program that was posted here several weeks ago. Very helpful, and with hundreds of possible items to make, it's really useful for figuring out what style and color combinations sell over time.

I kinda wish I had a good system for tracking customers at the same time that wouldn't be too much of a pain, but I mostly just work off memory and friends list for that.

I use the E-mail processor which you can get at www.thedotcommakesitfunny.com, but there is one problem. Eventually, this would leave the mail folder in my swg-catalogue with thousands of files, and it seems like I have to start a new project in Access every time I've imported new mails to the xml-file.

Any workarounds to this? I keep all my queries, but it feels kinda unneccesary to delete the previous sale table and make a new one.

Second problem if there are any sql-pro's here. All mails comes with a date "9. february 2004" and time. If I wanted a query which selects ALL mails for ALL dates, sums up the prices and I can then see that 9th february I sold for 500k credits, 10th february I sold for 750k credits... which would let me see the sales over time pretty easily.

I don't track at all. I have 4 different vendors, 3 are mine and another is for a friend. For that one I just forward him the mails and keep them until I pay him back, for the others I just restock daily when something gets sold. I restock the medical vendor every week or so.

I'm so low tech.

I just kind of take a peek at my vendors every few days and see what needs to be restocked. The alt that my fiance and I share is a merchant, and more often than not Mr. Fiance deletes my e-mails. But that's ok - I'm familiar enough with my stock to know what's missing.

With nearly 1200 items, I really should get a new system.

Anyone know if there is a parser and import to either excel / access already exist?

There's an article about this on swgtailor - which is too difficult for me but you may find it useful.

Are any of you organized merchant that have external programs/spreadsheets or whatever willing to make them available to those of us without the necessary skills to make these up? Thanks.

---

Bey wrote:

(Wants edit button )

---

You do have that option as a Community Veteran.