Keep Sold Data Archive Feature

damon18 · July 31st, 2008, 02:20 PM

Quote:

Originally Posted by dwessell

Is it possible for all SOLD items to be moved into a sold category and archived forever?

When you consider new features for classifieds, please put this on the list. There is a lot of good data in the solds that is lost. With a sold archive we could have stats on things like average time to sell, average sale price, monthly sales volume, highest priced item sold... etc. As well as data on how much a particular brand/model/year has sold in the past.

Seems like archiving the solds would only be a new table sold_products that would have the same fields as products. Then a change to editproduct.php to insert the fields of the item marked sold into the sold_prodcuts table (and remove them if the item is relisted). Then the item would be deleted from the products table after 14 days as is the case now.

Once we have the sold_products table, it opens the possibility for stats and other uses.

Please consider.

ktmtalk · October 31st, 2009, 01:46 PM

perhaps one solution would be to:
Set up a new section, call it SOLD items, set it so that only an admin has access to it. Move all sold listings into this section and, change the sendnotice to never delete (or expire) listings in that section.

damon18 · November 4th, 2009, 04:03 PM

That kind of thing would work as a minimum. Of course would like a little more to be able to use the data produced. Would like to have a way for people marking their item sold to provide info on the actual sale price and any special info about the sale.

damon18 · March 2nd, 2010, 09:36 PM

Just checking back to see if any sold archive features were ever added to classifieds with the new versions. It's really a shame to just delete the ads after they are marked sold, lots of research value and also SEO for the site with a sold archive.

sgthoskins · March 20th, 2010, 05:41 PM

Another person who would like to see a feature that when an item is sold it can be moved in to a hidden category that only admins and mods can see.

I've been served a grand jury subpoena in the past and having all prior adds from a particular user was vital in having justice served from someone who was breaking the law.