Members Database Project - White Swirl needs YOU!

[7th_son]

I have a proposition to make to the community.
If this gains any steam, I will split this into a separate topic, but let's just see.

Please post below if you would be willing to tackle 1 record/poster/item and search ebay for finished and current auctions, search popsike for past sales, and even search under the rug for old receipts, and most importantly, record that data in the database. Just 1 item, make it your own and find all info out there. I believe that if we get info into the database, people will start referencing it in discussions and it will positively stimulate its growth. Think about how useful this could be.

Who's with me? Post below, and choose an item, any item. Or as an alternative, we could start at the chronological start, and move forward from there.
_______________________________________________________________________________________

INFO FOR ADDING SALES:
For current and completed ebay auctions, simply enter the ebay item number under the "listings" tab. The system recognizes completed auctions and automatically adds the auction's ending price.
For items found at popsike.com or expressobeans.com or a similar source, enter them under the sales history tab. For currency, please use US$ and when the final sale was in another currency, please convert to US$ using the date of sale at a website such as this one: http://www.oanda.com/currency/converter/ .

Yes, at present it will record your name as the seller, but shortly we will likely change that column to "recorded by" or similar and add another column for seller or source etc. The most important thing for now, is gathering the data.
_______________________________________________________________________________________


1. 7th_son: let's shake hands, 1st press, Italy (red)
2.
3.
4.
5.


EDIT: Here's what our goal looks like:

[dagingerrocker]

That's much appreciated! You can add finished ebay auctions, by simply entering the item number under the listings tab in the database, it will realize that the auction is finished and post the selling price. That way it doesn't read as though you have sold it. But, either way, it's information and we appreciate it!

I have a proposition to make to the community.
If this gains any steam, I will split this into a separate topic, but let's just see.

Please post below if you would be willing to tackle 1 record/poster/item and search ebay for finished and current auctions, search popsike for past sales, and even search under the rug for old receipts, and most importantly, record that data in the database. Just 1 item, make it your own and find all info out there. I believe that if we get info into the database, people will start referencing it in discussions and it will positively stimulate it's growth. Think about how useful this could be.

Who's with me? Post below, and choose an item, any item. Or as an alternative, we could start at the chronological start, and move forward from there.

1. 7th_son: let's shake hands, 1st press, Italy (red)
2.
3.
4.
5.

ill do lsh second

[TheHen0]

I'll do LSH first.

[7th_son]

ill do lsh second

Very cool of you, if you want to join the list, just copy it from the most recent post and add your name and the item of your choosing. We'll keep a running list. All are welcome to help!

Who's with me? Post below, and choose an item, any item. Or as an alternative, we could start at the chronological start, and move forward from there.

1. 7th_son: let's shake hands, 1st press, Italy (red)
2. dagingerrocker: let's shake hands, 2nd press, Italy (black)
3.
4.
5.

[7th_son]

I'll do both WS record store day reissues.

1. 7th_son: let's shake hands, 1st press, Italy (red)
2. dagingerrocker: let's shake hands, 2nd press, Italy (black)
3. TheHen0: The White Stripes RSD reissues 2011, TMR (let's shake hands and lafayette blues)
4.
5.
6.
7.
....

[7th_son]

ill do lsh second

Very cool of you, if you want to join the list, just copy it from the most recent post and add your name and the item of your choosing. We'll keep a running list. All are welcome to help!

Who's with me? Post below, and choose an item, any item. Or as an alternative, we could start at the chronological start, and move forward from there.

1. 7th_son: let's shake hands, 1st press, Italy (red)
2. dagingerrocker: let's shake hands, 2nd press, Italy (black)
3.
4. elduderino: triple decker
5.

i'll do the nipple becker.

1. 7th_son: let's shake hands, 1st press, Italy (red)
2. dagingerrocker: let's shake hands, 2nd press, Italy (black)
3. TheHen0: The White Stripes RSD reissues 2011, TMR (let's shake hands and lafayette blues)
4. elduderino: Triple Decker
5.
6.
7.
....

[shaneoftheroad]

I'll take Hand Springs.

1. 7th_son: let's shake hands, 1st press, Italy (red)
2. dagingerrocker: let's shake hands, 2nd press, Italy (black)
3. TheHen0: The White Stripes RSD reissues 2011, TMR (let's shake hands and lafayette blues)
4. elduderino: Triple Decker
5. shaneoftheroad: Hand Springs
6.
7.

[shaneoftheroad]

I think this should be a separate thread but it's a GREAT idea to get our database built up properly.

[dagingerrocker]

now i went through all popsike records of my record i averaged it out and found the average cost for an LSH 2nd press is 78 dollars, yet the most recent sale was for 37, so what now?

[7th_son]

I think this should be a separate thread but it's a GREAT idea to get our database built up properly.

Thanks for helping shane, and you're right, I'll split this off since we seem to be gathering steam here.

[7th_son]

now i went through all popsike records of my record i averaged it out and found the average cost for an LSH 2nd press is 78 dollars, yet the most recent sale was for 37, so what now?

Ok, so what you want to do now is record the date and price of each sale in the database, like I am currently doing here:

http://www.whiteswirl.com/index.php?act ... view=sales

[TheHen0]

now i went through all popsike records of my record i averaged it out and found the average cost for an LSH 2nd press is 78 dollars, yet the most recent sale was for 37, so what now?

I got one for 25.

[dylnfan]

1. 7th_son: let's shake hands, 1st press, Italy (red)
2. dagingerrocker: let's shake hands, 2nd press, Italy (black)
3. TheHen0: The White Stripes RSD reissues 2011, TMR (let's shake hands and lafayette blues)
4. elduderino: Triple Decker
5. shaneoftheroad: Hand Springs
6. dylnfan: Lafayette Blues, Italy, 1st Press, White

Don't forget to convert foreign currencies!

[7th_son]

Don't forget to convert foreign currencies!

Thanks dylnfan! And yes, a couple of things should be paid attention to:

i. foreign currencies, please convert to US$, here is a useful site: http://www.xe.com/
ii. fakes! If you select one of the records that their are known fakes of, please pay attention when recording sales and leave the fakes out. Records to be aware of include: let's shake hands 1st and 2nd presses (Italy), Hello Operator (SFTRI). There is info on fakes here: viewtopic.php?f=17&t=1470 . Really, there aren't very many I suppose, but if you aren't familiar with identifying a fake Hello Operator, maybe don't choose that one.

Anything else?

[shaneoftheroad]

now i went through all popsike records of my record i averaged it out and found the average cost for an LSH 2nd press is 78 dollars, yet the most recent sale was for 37, so what now?

Ok, so what you want to do now is record the date and price of each sale in the database, like I am currently doing here:

http://www.whiteswirl.com/index.php?act ... view=sales

Is it a problem that when we add the price it says the item was sold by us? Can we change that in the system?