Database Suggestions
- higherlimits
- Little People
- Posts: 4089
- Joined: Tue Apr 21, 2009 1:14 am
Re: Database Suggestions
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?
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?
- EdwardWBjornson
- Little Acorn
- Posts: 463
- Joined: Wed Nov 25, 2009 8:21 am
- Location: Norway
Re: Database Suggestions
Different ones
- trickster
- Greek Mod
- Posts: 5524
- Joined: Wed May 06, 2009 5:30 am
- Location: Greece
- Contact:
Re: Database Suggestions
The ' problem in the Comments section is still giving me SQL errors
I cannot write
I cannot write
etcYou 've
Please check my TMR pin/button ISO viewtopic.php?f=18&t=11426
- higherlimits
- Little People
- Posts: 4089
- Joined: Tue Apr 21, 2009 1:14 am
Re: Database Suggestions
Comments? You mean description?
- trickster
- Greek Mod
- Posts: 5524
- Joined: Wed May 06, 2009 5:30 am
- Location: Greece
- Contact:
Re: Database Suggestions
Yep!higherlimits wrote:Comments? You mean description?
Please check my TMR pin/button ISO viewtopic.php?f=18&t=11426
- chrono_1980
- Little Ghost
- Posts: 2187
- Joined: Sat Jul 17, 2010 2:41 am
- Location: The Great White North
Re: Database Suggestions
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...
Also, in addition to a price, maybe a trade line could be added to? Not sure if/how that would work...
- colditz
- Little Acorn
- Posts: 350
- Joined: Wed May 19, 2010 12:30 am
- Location: Nottingham, UK
Re: Database Suggestions
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.
- 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.
- colditz
- Little Acorn
- Posts: 350
- Joined: Wed May 19, 2010 12:30 am
- Location: Nottingham, UK
Re: Database Suggestions
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.
- 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.
- higherlimits
- Little People
- Posts: 4089
- Joined: Tue Apr 21, 2009 1:14 am
Re: Database Suggestions
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.
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.
- higherlimits
- Little People
- Posts: 4089
- Joined: Tue Apr 21, 2009 1:14 am
Re: Database Suggestions
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.
- colditz
- Little Acorn
- Posts: 350
- Joined: Wed May 19, 2010 12:30 am
- Location: Nottingham, UK
Re: Database Suggestions
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 ?
- surely just the ebay ID is enough ?
- higherlimits
- Little People
- Posts: 4089
- Joined: Tue Apr 21, 2009 1:14 am
Re: Database Suggestions
This is fixed now, thanks for letting us know!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 ?
- colditz
- Little Acorn
- Posts: 350
- Joined: Wed May 19, 2010 12:30 am
- Location: Nottingham, UK
Re: Database Suggestions
The "Best Offer" Issue is still not fixed (although, this is a slightly different set of events) ;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.
- 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.
- higherlimits
- Little People
- Posts: 4089
- Joined: Tue Apr 21, 2009 1:14 am
Re: Database Suggestions
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.colditz wrote:The "Best Offer" Issue is still not fixed (although, this is a slightly different set of events) ;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.
- 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.
I'm not sure what timezone the sales go in, I would have assumed EST but I'm not sure..
- love_islander
- Little People
- Posts: 4682
- Joined: Fri Nov 27, 2009 10:12 pm
- Location: Melbourne, Australia
Re: Database Suggestions
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
ISO: CLICK HERE