Database Suggestions

Please discuss the database in this forum.
User avatar
higherlimits
Little People
Posts: 4089
Joined: Tue Apr 21, 2009 1:14 am

Re: Database Suggestions

Post by higherlimits »

Can I get someone's thoughts on something?

For Pink Lafayettes should we have each different version (ie. different franc note denomonation) be a different item or should they all be lumped into one?
User avatar
EdwardWBjornson
Little Acorn
Posts: 463
Joined: Wed Nov 25, 2009 8:21 am
Location: Norway

Re: Database Suggestions

Post by EdwardWBjornson »

Different ones :)
User avatar
trickster
Greek Mod
Posts: 5524
Joined: Wed May 06, 2009 5:30 am
Location: Greece
Contact:

Re: Database Suggestions

Post by trickster »

The ' problem in the Comments section is still giving me SQL errors
I cannot write
You 've
etc
Please check my TMR pin/button ISO viewtopic.php?f=18&t=11426
User avatar
higherlimits
Little People
Posts: 4089
Joined: Tue Apr 21, 2009 1:14 am

Re: Database Suggestions

Post by higherlimits »

Comments? You mean description?
User avatar
trickster
Greek Mod
Posts: 5524
Joined: Wed May 06, 2009 5:30 am
Location: Greece
Contact:

Re: Database Suggestions

Post by trickster »

higherlimits wrote:Comments? You mean description?
Yep!
Please check my TMR pin/button ISO viewtopic.php?f=18&t=11426
User avatar
chrono_1980
Little Ghost
Posts: 2187
Joined: Sat Jul 17, 2010 2:41 am
Location: The Great White North

Re: Database Suggestions

Post by chrono_1980 »

Curious how many people are using the listings portion of the database? It seems like this would be pretty darn useful like EB, if enough people started using it...

Also, in addition to a price, maybe a trade line could be added to? Not sure if/how that would work...
User avatar
colditz
Little Acorn
Posts: 350
Joined: Wed May 19, 2010 12:30 am
Location: Nottingham, UK

Re: Database Suggestions

Post by colditz »

A suggestion for the "Sales History" tab on the database ;

- the "Ebay Sales" column should also show the ebay listing ID
- if the date on that listing is less than 90 days, the ebay listing ID should be a http link to the actual listing on ebay.

So, for those that want to do a bit more research into the last items that were sold, they can actually see
things like condition, shipping, etc.
User avatar
colditz
Little Acorn
Posts: 350
Joined: Wed May 19, 2010 12:30 am
Location: Nottingham, UK

Re: Database Suggestions

Post by colditz »

There is an issue with "Best Offer" ebay items, as follows ;

- Item on ebay up for "Buy it Now" of $150 + "Best Offer".
- someone adds that ebay ID to the database, before the listing has ended & it appears (as normal) in the 'listings' tab.
- the listing ends early, as seller has accepted a "Best Offer" of $140

-- the listing then goes into the 'Sales History' tab as $150 instead of the correct $140.

Hope that makes sense.
User avatar
higherlimits
Little People
Posts: 4089
Joined: Tue Apr 21, 2009 1:14 am

Re: Database Suggestions

Post by higherlimits »

Yes, makes sense..

There is also an issue where auctions that don't meet the reserve are recorded as 'sold' in the database... We'll have to fix these issues.
User avatar
higherlimits
Little People
Posts: 4089
Joined: Tue Apr 21, 2009 1:14 am

Re: Database Suggestions

Post by higherlimits »

I think both of these issues have been fixed and the 'Wanted' list has been reconfigured. Should be uploaded at some point tonight. Please let me know if you find any further issues.
User avatar
colditz
Little Acorn
Posts: 350
Joined: Wed May 19, 2010 12:30 am
Location: Nottingham, UK

Re: Database Suggestions

Post by colditz »

When adding an ebay listing to the Sales History, it now forces you to enter something in the "Notes" box
- surely just the ebay ID is enough ?
User avatar
higherlimits
Little People
Posts: 4089
Joined: Tue Apr 21, 2009 1:14 am

Re: Database Suggestions

Post by higherlimits »

colditz wrote:When adding an ebay listing to the Sales History, it now forces you to enter something in the "Notes" box
- surely just the ebay ID is enough ?
This is fixed now, thanks for letting us know!
User avatar
colditz
Little Acorn
Posts: 350
Joined: Wed May 19, 2010 12:30 am
Location: Nottingham, UK

Re: Database Suggestions

Post by colditz »

higherlimits wrote:Yes, makes sense..

There is also an issue where auctions that don't meet the reserve are recorded as 'sold' in the database... We'll have to fix these issues.
The "Best Offer" Issue is still not fixed (although, this is a slightly different set of events) ;

- I've just entered ebay ID 130493065759 into the Jerry King tri-color listings tab, which is a finished auction that was originally $150
but the seller allowed a 'Best Buy' of $125.

- As you can see from http://www.whiteswirl.com/index.php?act ... view=sales it went through at $150 still (it's one
of the ones listed 2011-03-04).

Also, the database still allows duplicate ebay ID's - so, please could you remove one of the two $150 on the 2011-03-04 ? thanks.

One final thing, what timezone do the ebay sales go into the database as ? that ID above, according to ebay, finished Mar 03, 2011 19:51:21 PST
but the database is showing 2011-03-04.
User avatar
higherlimits
Little People
Posts: 4089
Joined: Tue Apr 21, 2009 1:14 am

Re: Database Suggestions

Post by higherlimits »

colditz wrote:
higherlimits wrote:Yes, makes sense..

There is also an issue where auctions that don't meet the reserve are recorded as 'sold' in the database... We'll have to fix these issues.
The "Best Offer" Issue is still not fixed (although, this is a slightly different set of events) ;

- I've just entered ebay ID 130493065759 into the Jerry King tri-color listings tab, which is a finished auction that was originally $150
but the seller allowed a 'Best Buy' of $125.

- As you can see from http://www.whiteswirl.com/index.php?act ... view=sales it went through at $150 still (it's one
of the ones listed 2011-03-04).

Also, the database still allows duplicate ebay ID's - so, please could you remove one of the two $150 on the 2011-03-04 ? thanks.

One final thing, what timezone do the ebay sales go into the database as ? that ID above, according to ebay, finished Mar 03, 2011 19:51:21 PST
but the database is showing 2011-03-04.
The Best Offer should now be fixed. took a LONG time to get it done as it required a lot of research and ebay developer's codes etc.

I'm not sure what timezone the sales go in, I would have assumed EST but I'm not sure..
User avatar
love_islander
Little People
Posts: 4679
Joined: Fri Nov 27, 2009 10:12 pm
Location: Melbourne, Australia

Re: Database Suggestions

Post by love_islander »

wow, cool. keep up the good work. i promise that when i get back to civilisation i intend to add some stuff to the database, even if its just ebay listings
Post Reply