What is the status of the Marketplace transaction history?

Discussion and support for the Kitely Market
Post Reply
User avatar
Kayaker Magic
Posts: 354
Joined: Sun Dec 01, 2013 8:40 am
Has thanked: 52 times
Been thanked: 393 times

What is the status of the Marketplace transaction history?

Post by Kayaker Magic »

What is the status of the Marketplace transaction history? I read in the forums that this would be implemented some day, but I don't see it yet. What I saw in the forums was a report from a community meeting that suggested CSV files might be the format.

For managing updates to products, I keep a database of everything I have sold. In SL you can download a CSV file of recent transactions or you can get an HTTP request for each transaction as they happen. This is sent to a URL that I enter into the SL Marketplace setup, then that URL is sent the transaction information, and I had to write a PHP script to catch the data and stuff it into a MySQL database .

This means the database is updated instantly as sales happen. I don't have to download a CSV file once a month and translate it into my database format (which I used to have to do in SL). Instead the PHP script does the conversion on the fly, one transaction at a time. Also, I wrote a script for my in-world vendors that sends a similar HTTP request every time someone buys something in-world. That I could implement myself in-world in Kitely, but I would like to request HTTP request transactions from the Kitely Market.

HA! You (the Kitely Team) are busy doing other things for us, have not even added CSV support yet, and I already want the next thing! CSV histories would be better than having to paw through the history looking for transactions, so I'll happily take that when you have time to get to it!
These users thanked the author Kayaker Magic for the post:
Ozwell Wayfarer
User avatar
Ozwell Wayfarer
Posts: 584
Joined: Thu Jan 10, 2013 10:32 am
Has thanked: 860 times
Been thanked: 972 times

Re: What is the status of the Marketplace transaction histor

Post by Ozwell Wayfarer »

I second that this would be very useful and a welcome feature!

...while we are on the MP, it would also be great to see a way to modify the number of items shown per page.
User avatar
Ilan Tochner
Posts: 6729
Joined: Sun Dec 23, 2012 8:44 am
Has thanked: 5253 times
Been thanked: 4675 times
Contact:

Re: What is the status of the Marketplace transaction histor

Post by Ilan Tochner »

Hi Kayaker,

Currently merchants can see their sales history in three places:
1) In your store's Sales History page (you get to it from the "Go to" menu at the top of the website). This includes a detailed list of all your store's transactions.
2) In the History page, amongst other tracked events.
3) In email notifications we send merchants whenever their Kitely Market store has made a new sale.

Until we implement CSV export of your marketplace transactions you can use either one of these methods to track your transactions. The third option can be used in conjunction with your modified tracking system to automatically populate your database (the email format is fixed so you should be able to easily create a parser for it).
These users thanked the author Ilan Tochner for the post:
Constance Peregrine
User avatar
Dundridge Dreadlow
Posts: 616
Joined: Mon May 06, 2013 2:23 pm
Location: England
Has thanked: 590 times
Been thanked: 339 times

Re: What is the status of the Marketplace transaction histor

Post by Dundridge Dreadlow »

..can we request a simple filter to show sales, or visits by others :D That shouldn't take you too much effort or give you too much hassle :)
These users thanked the author Dundridge Dreadlow for the post:
Ozwell Wayfarer
ImageImageImageImageImageImage
PS. Kitely is awesome.
User avatar
Ilan Tochner
Posts: 6729
Joined: Sun Dec 23, 2012 8:44 am
Has thanked: 5253 times
Been thanked: 4675 times
Contact:

Re: What is the status of the Marketplace transaction histor

Post by Ilan Tochner »

Hi Dundridge,

Sorry, there are a great deal of small nice-to-have features on our todo list that have to wait until after we're done with the bigger, higher priority, items that have been pending for way too long (such as full Hypergrid support).

In any case, you can already see Kitely Market transactions by themselves in your store's Sales History page (it isn't the same page as your account History page).
User avatar
Kayaker Magic
Posts: 354
Joined: Sun Dec 01, 2013 8:40 am
Has thanked: 52 times
Been thanked: 393 times

Re: What is the status of the Marketplace transaction histor

Post by Kayaker Magic »

Ozwell Wayfarer wrote:while we are on the MP, it would also be great to see a way to modify the number of items shown per page.
I have found the easiest way for me to extract the data was to select the text right out of the Sales History page and paste it into a text file. The resulting text file has every item on 10 lines (with lots of blank lines). I plan to write something to parse this and stuff it into my MySQL database. In the mean time I can store the text file as a backup on my hard drive.

Copying new sales from the Sales History page every once in a while is not a hardship now, but in that wonderful glorious future when sails\\\\\sales are booming, it will probably get old. Being able to modify the number of items shown per page would be a welcome feature to speed this process up as well.
Post Reply