How do I edit the Expiration Date? (or Expire an Ad)

[KenDude]

With the most recent version members could set their ads to expire in a certain period of time, such as 1 day, 1 week, 30 days, or Never. Well I'm getting complaints from my members that some ads are really old because the lister selected never. So I wanted to go in as the admin and change that to expire the ad. I see no way to do that. When I try to Edit the ad, the box for expiration doesn't show up!

I can delete the ad (don't want to do that, want the old ad around for archive and pricing purposes)

I can mark the ad as Sold (don't want to do that because the item didn't really sell)

I see no way to "Expire" an ad or choose an expiration number of days that would render the ad expired.

Can anyone help??

[Chuck S]

I think this is what your missing you need to set the cron script to expire ads and auctions

Cron Job: sendnotice.php

[KenDude]

Originally Posted by Chuck S

I think this is what your missing you need to set the cron script to expire ads and auctions

Cron Job: sendnotice.php

The site is expiring ads and auctions, but based on the value the members sets when they place an ad. If the member sets "never" then it never expires the ad. I want to be able to go in and change their "never" to something else like 30 days and then the Cron job will expire it.

[KenDude]

BTW I went ahead and set up a cron job to run sendnotice.php and this is what it spit out:

Classifieds Send Notice

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 23: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by r6tanz for USD10000000000.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=2150 High bidder's email address: tdinh22781@yahoo.com Auction link: http://www.caymanclub.net/classified...php?product=23 Thank you!]

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 49: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by Qtqc for USD1150.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=1299 High bidder's email address: gkiousis@canadawideparking.com Auction link: http://www.caymanclub.net/classified...php?product=49 Thank you!]

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 61: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by YellowBirdII for USD1775.00. High bidder's profile link: http://www.caymanclub.net/classified...er.php?uid=858 High bidder's email address: genedominique@yahoo.com Auction link: http://www.caymanclub.net/classified...php?product=61 Thank you!]

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 67: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by Dark Teal for USD65.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=2916 High bidder's email address: robert_isaacs2003@yahoo.com Auction link: http://www.caymanclub.net/classified...php?product=67 Thank you!]

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 68: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by nwd for USD60.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=2484 High bidder's email address: nwdirr@shaw.ca Auction link: http://www.caymanclub.net/classified...php?product=68 Thank you!]

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 69: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by BlackShadow for USD77.02. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=2889 High bidder's email address: goodey10@cox.net Auction link: http://www.caymanclub.net/classified...php?product=69 Thank you!]

Email to: genedominique@yahoo.com [Gene] about auction end 83: [YellowBirdII, your auction on The Cayman Club has expired. The high bid was submitted by chucko for USD31.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=2295 High bidder's email address: chuckovii@gmail.com Auction link: http://www.caymanclub.net/classified...php?product=83 Thank you!]

Email to: genedominique@yahoo.com [Gene] about auction end 84: [YellowBirdII, your auction on The Cayman Club has expired. The high bid was submitted by Alias for USD33.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=3145 High bidder's email address: wrtbks@comcast.net Auction link: http://www.caymanclub.net/classified...php?product=84 Thank you!]

Email to: genedominique@yahoo.com [Gene] about auction end 82: [YellowBirdII, your auction on The Cayman Club has expired. The high bid was submitted by Midnight Blue for USD31.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=3129 High bidder's email address: dlipetz@hotmail.com Auction link: http://www.caymanclub.net/classified...php?product=82 Thank you!]

Email to: rwebster07@sprynet.com [spydr] about auction end 97: [spydr, your auction on The Cayman Club has expired. There were no bids on your item. You may want to review your auction and make adjustments before relisting. You can renew your auction by clicking the link: http://www.caymanclub.net/classified....php?resell=97 Auction link: http://www.caymanclub.net/classified...php?product=97 Thank you!]

Email to: K-ManS@kc.rr.com [K-Man S] about auction end 105: [K-Man S, your auction on The Cayman Club has expired. The high bid was submitted by Daytona for USD26.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=1124 High bidder's email address: cebotech1@yahoo.com Auction link: http://www.caymanclub.net/classified...hp?product=105 Thank you!]

Email to: budi.liman@gmail.com [StatiX] about auction end 127: [StatiX, your auction on The Cayman Club has expired. There were no bids on your item. You may want to review your auction and make adjustments before relisting. You can renew your auction by clicking the link: http://www.caymanclub.net/classified...php?resell=127 Auction link: http://www.caymanclub.net/classified...hp?product=127 Thank you!]

Email to: gkiousis@canadawideparking.com [Qtqc] about auction end 206: [Qtqc, your auction on The Cayman Club has expired. The high bid was submitted by Chris R. for USD925.00. High bidder's profile link: http://www.caymanclub.net/classified...r.php?uid=1759 High bidder's email address: lowlifewagon@hotmail.com Auction link: http://www.caymanclub.net/classified...hp?product=206 Thank you!]

Email to: baluyot4@sanbrunocable.com [art4xlt] about auction end 255: [art4xlt, your auction on The Cayman Club has expired. There were no bids on your item. You may want to review your auction and make adjustments before relisting. You can renew your auction by clicking the link: http://www.caymanclub.net/classified...php?resell=255 Auction link: http://www.caymanclub.net/classified...hp?product=255 Thank you!]

Email to: budi.liman@gmail.com [StatiX] about auction end 228: [StatiX, your auction on The Cayman Club has expired. There were no bids on your item. You may want to review your auction and make adjustments before relisting. You can renew your auction by clicking the link: http://www.caymanclub.net/classified...php?resell=228 Auction link: http://www.caymanclub.net/classified...hp?product=228 Thank you!]

checking for ads while will expire in 3 days...

Email to: robcohen@optonline.net [FirstCayman] about ad 269: [FirstCayman, your ad on The Cayman Club for Race Helmet Wanted is going to expire in 1 days. If you have not sold your product and wish to renew your ad for an additional 30 days, please click on the link below: http://www.caymanclub.net/classified...php?resell=269 If you have sold your item, please let us know by clicking on this link: http://www.caymanclub.net/classified...t.php?sold=269 Thank you!]

Email to: bobfrostholm@gmail.com [Cold Croc] about ad 284: [Cold Croc, your ad on The Cayman Club for 914/6 Mahle Magnesium Gas Burner wheels (4) is going to expire in 1 days. If you have not sold your product and wish to renew your ad for an additional 15 days, please click on the link below: http://www.caymanclub.net/classified...php?resell=284 If you have sold your item, please let us know by clicking on this link: http://www.caymanclub.net/classified...t.php?sold=284 Thank you!]

Email to: pho@ee.wustl.edu [Paul Ho] about ad 290: [Paul Ho, your ad on The Cayman Club for OE Bridgestone Potenza RE-050A Taken off at 2000 mi is going to expire in 2 days. If you have not sold your product and wish to renew your ad for an additional 15 days, please click on the link below: http://www.caymanclub.net/classified...php?resell=290 If you have sold your item, please let us know by clicking on this link: http://www.caymanclub.net/classified...t.php?sold=290 Thank you!]

Email to: swanc04@gmail.com [swanc] about ad 292: [swanc, your ad on The Cayman Club for 17" stand cayman alloy wheels is going to expire in 4 days. If you have not sold your product and wish to renew your ad for an additional 15 days, please click on the link below: http://www.caymanclub.net/classified...php?resell=292 If you have sold your item, please let us know by clicking on this link: http://www.caymanclub.net/classified...t.php?sold=292 Thank you!]

done...
Done

So I assume it worked, however, did it also flag items expired or just send emails?

[KenDude]

Ok i just checked my classifieds and the auctions were now all marked as SOLD, and of course will expire tomorrow, but other items in other categories that are not auction categories were not marked expired, for example there is a car listed back in March still showing up, so I suspect that the person who listed it selected expire = never. Thus the real problem here is that the EDIT AD page for teh administrator doesn't let me change that!!!

Can we get a fix? Thanks!

[Chuck S]

well edit your uploadproduct templates and remove the expire you do not wish to have

[KenDude]

Chuck,
That's not a great solution since I want to give people the opportunity to expire their own ads. If I remove that, then what would the default be? 1 day/ 1 week? never? It "should" be pretty simple to add the ability to edit that field in an ad via the admin edit page should it not?

[Chuck S]

No there is nowhere to edit a duration it is picked on upload and thats it when its expired then the sendnotice script removes it

If you dont want to have non expiring ads then remove the option as I had noted

[KenDude]

Chuck,
But I DO want expiring ads, in fact I'd like all ads to expire at no more than say 60 days, so I'd like to remove the "never" expire choice (unless there is a way to have the choices by usergroup, for example admins could make a never expire ad but regular users could not).

I guess the only way to "expire" existing ads that have their expiration set to "never" is for me to go in and mark them sold then?

[Chuck S]

You can delete them

As far as your durations correct you edit your uploadproduct templates and remove the options for the durations you do not want in that select box

[KenDude]

If I delete the ads though, then they aren't there anymore, I'd prefer to have them in the database just not shown so if there is ever a question about something from a historical perspective I can go back in the admin console and look it up. I'll check the template to see about removing the never expire choice that should at least stop the problem going forward, but I'd still like a way to expire the ads other than marking sold or deleting.

[Chuck S]

Thats not how the application works though. Ads are deleted especially with 2.6 and higher

[KenDude]

Ok well I think I am running the latest and greatest version, how do I check that btw? Went to the admin panel and it didn't tell me what version I am running, although I know I updated to the newest version in May-June 2007 timeframe, so anything newer?

I can, however, go to the EXPIRED QUEUE in my admin panel and it shows me a bunch of ads some very recently expired (like today) and I have the choice to "Delete, Approve, or Leave". If I just "leave" them, then they stay expired, but are not physically deleted, that's what I want. Hence the software seems to be doing what I want as long as there is a valid expiration date.

So it seems that what I have to do is the following:

1) Any ad without an expiration date I need to mark SOLD to expire it because there is no option to edit the expiration date when I edit an ad

2) I need to modify the template so that any new ads placed can only choose valid expiration dates, not "never".

[KenDude]

Here is yet another problem, if an ad gets deleted for which I am using that ads picture as the category thumbnail the category thumbnail disappears! I'd like to have that image remain there, or must I create a "dummy" ad for each category wiht it set to never expire in order to keep a category image?? Seems strange.

[Chuck S]

1. yes

2. yes

3. yes you create a dummy ad