Thread: Razors on the Classifieds

so perhaps we could make some box you can check for sold that moves it to the archives in 24 hours????

I've been happy that the listings stay somewhere because I want to start selling again and need an idea of prices

so I say don't delete, just move

Even if it's not archived and you could just have a check box next to search to filter out any item with the price "Sold!" .. that would be perfect.

Or at the very least change the sort algorithm so that when you sort by price, it places the sold items at the bottom instead of sorting them in with the live ads by their sale price. Or even add a new sort option entirely that is to the effect of "Show current ads on top" that just sorts the ads the same way they are by default, by date listed, but does so such that all live ads are listed first, and then followed by the sold items. I'm not sure if we have access to the code, but this ought to be fairly simple for whoever does it.

Originally Posted by pjrage

Even if it's not archived and you could just have a check box next to search to filter out any item with the price "Sold!" .. that would be perfect.

Or at the very least change the sort algorithm so that when you sort by price, it places the sold items at the bottom instead of sorting them in with the live ads by their sale price. Or even add a new sort option entirely that is to the effect of "Show current ads on top" that just sorts the ads the same way they are by default, by date listed, but does so such that all live ads are listed first, and then followed by the sold items. I'm not sure if we have access to the code, but this ought to be fairly simple for whoever does it.

+1 on changing the sorting algorithm - that should be fairly straight forward to implement.

The forum maker has a forum - maybe we can find something in there
vBulletin Community Forum

Originally Posted by akw

+1 on changing the sorting algorithm - that should be fairly straight forward to implement.

The forum maker has a forum - maybe we can find something in there
vBulletin Community Forum

sure, if you find out how to do it just let us know. in an ideal world you would just give us the patch of the fix, but a long as it's 'fairly straight forward to implement' I think a description what to change and how would work just fine.

I *think* - correct me if I'm wrong - this board probably runs on top of a MySQL database and unless things have changed since the last time I was involved in development on a site backed by that DB the luxury of triggers and stored procedures don't exist. If thats the case there is a fair amount of custom development to be done to implement what you guys are considering to be a small straight forward change.

I'll go back into my hole now ...

Originally Posted by gugi

sure, if you find out how to do it just let us know. in an ideal world you would just give us the patch of the fix, but a long as it's 'fairly straight forward to implement' I think a description what to change and how would work just fine.

It looks like the software is closed source so I can't provide you a fix. If you can get me access to the SRP dev site then I can look around. If that's not possible I can make some suggestions if you can help me get me some information on how the classifieds forum is written.

It appears the classifieds are custom code and that the price is stored in its own database column based on the fact that you can sort the price highest-lowest (and vice versa). If this isn't the case then some front end work is being done to allow the sort.

Does each item for sale have it's own "custom" database record? If yes - what fields are included in the classifieds table.

Adam

Understood that custom work is not easy, but for the wish list: an arhchive of past sales is *essential*. Just think how useful it is go back and see old threads and not have to reinvent the wheel every time? But having a few days or even weeks of Sold ads around isnt enough to provide a usable reference source for past sale data, it really does just get in the way more than anything. The only benefit I see in the current system is that you can get a sense of the volume of traffic moving through the classifieds, kinds of things that sell, etc, calibrating your hopes for future things coming through.

Also, lets not exaggerate on how fast things sell - it's true, most things sell within a couple of days, but not usually a matter of minutes or hours. OVer on Badger & Blade good things sell in 2-10 minutes! Similar situation on another collecting forum I've been on. I think the current scene is actually good - great for sellers, as things are usually going to sell within a few days or a week, but also buyers have a good chance at getting things. But you do need to check the listings every day or two....which isnt that hard because there arent that many things listed each day, lik 0-4.

Just my 2 cents, having been a bit of a Classifieds Hound the last few weeks.