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.