How to automatically delete listing with "Not Active" status after expiration

Discussion in 'Technical Support' started by user2616, Nov 22, 2012.

  1. user2616 Customer

    I notice that the listing with "Not Active" status never deleted by the system after expiration. The numbers keep growing from the day I setup the system.

    How to set the system to delete these listing automatically?

    Peri
  2. Mike-N-Tosh Developer & Moderator

    There is no setting to delete "Not Active" listings. The big question is, "Why do you have them and why does it keep growing?"

    Typically these are listings that the potential seller "abandoned" during checkout. So why are they abandoning the checkout process? Usually, this is due to overpricing or lack of understanding of the listing process.
  3. user2616 Customer

    Thanks Mike for your reply.

    I am ok if the users occasionally abandon during checkout. But, I notice that the abandoned listing (Not Active) keep accumulating in the database. How to auto clean up these listing after certain period, for example after expiration.

    Any suggestion?

    Peri
  4. Mike-N-Tosh Developer & Moderator

    There isn't any automated way to do this in the script currently.

    This might be a good feature request to submit to 68 Classifieds.

    It is the cron.php that handles the "auto delete" function of expired listings. This file does have a "module hook", so it would be possible to make your own module to do this function and of course you could also hard code a new function at the end of the file to handle it as well although I wouldn't recommend that.
  5. user2616 Customer

    Mike and 68C users,

    How you cleanup "Not Active" listing?

    Thanks.

    Peri
  6. user2616 Customer

    Hi Blair / John / Larry,

    Could you please help to resolve the above problem?

    Also, please help to check on Mike's suggestion above (This might be a good feature request to submit to 68 Classifieds).

    Thanks

    Peri
  7. user2616 Customer

    Hi Blair,

    Could you please help to attend to my query.

    Thanks.

    Peri
  8. user2616 Customer

    Hi Blair,

    Could you please help to attend to my query.

    Thanks.

    Peri
  9. user2616 Customer

    Hi Blair,

    Could you please help to attend to my query.

    Thanks.

    Peri
  10. freeze2 Customer

    Since this feature is not built into the current 68C script, you will most likely need to hire someone to create a module. As Mike suggested above, it is possible to accomplish.
  11. Mike-N-Tosh Developer & Moderator

    Peri, you can submit this as a "Feature request" yourself if it's important to you. Submit a Feature Request. Please also bare in mind that these are Community support forums where 68 Classified customers/users help support each other and no one is paid to do so.

    As already pointed out by freeze2 and I, this is not a built in feature. Unfortunately, it is also not something simple enough for me or anyone else to simply tell you to just do this or paste a few couple lines of code here.

    In my 5+ years of experience in using 68 Classifieds and being on these forums, this hasn't been an issue for anyone else (at least no one has posted this issue nor have any of my clients asked me for a solution to it). This leads me back to my first response to your inquiry as to why is this happening on your site.
  12. user2616 Customer

    Mike,

    I have submitted "Feature request".

    I fully understand that 68 Classified Forum is a Community support forums and you and other friends not paid for helping me and other users. Thank you for volunteer to help me and other users.

    I hope that this feature become built in feature so that all 68C sites can enjoy having clean database rather than I attempt to customize the system.

    68C provides the option to the end users to leave the posting of listing process half way and the listing becomes "Not Active" listing. So naturally the end users likely to leave the posting process half way. So it is good that the system deletes the "Not Active" listing after expiry.

    Currently, 68C deletes "Active" listing after x number of days after expiry. So it is good that 68C deletes both "Active" and "Not Active" listing after x number of days after expiry.

    Just to understand, in your sites, when the end users leave the posting process half way leaving "Not Active" listing, how do you clean up these listing? May be, I can follow your method.

    Every time, I post a question or ask for help, you always respond to my post with suggestion/solution. I want to thank you for that. Another friend is seymourjames, but in the recent time I do not see him in this forum.

    Also, I used to get prompt response from the developer team. This time, I do not see any developer team responding to my query. I am wondering what happened to Blair, John, Larry and others. Is the developer team active?

    I spent quite some time in learning 68C and now I am very comfortable in maintaining my sites. After seeing no developer team around here to respond to users queries, I start worrying if me and other users like me left alone. I hope to get response from the developer team, at least say "Hi".

    Peri
  13. user2616 Customer

    freeze2, In your sites, when the end users leave the checkout process half way, how do you clean up the "Not Active" listing?

    Thanks.

    Peri
  14. freeze2 Customer

    For me, I check the listings every day. If a user has left the checkout process with an unfinished ad, I will either approve it or delete it. I have put "Tips" throughout my checkout system, which has greatly decreased the amount of "Not Active" listings.
  15. user2616 Customer

    freeze2, Thank you for your fast response. In Admin, Manage Listing, I notice that Change Status has Active, Not Active and Delete options. Are you are referring to these options?

    That means, I can select the old "Not Active" listing and change the Status to "Delete". For now, I follow your method.

    Thanks a lot for your quick solution.
  16. freeze2 Customer

    Yes, you can change the listing status as described. I actually manage things through the "Manage Orders" part of the admin.
  17. user2616 Customer

    I deleted "Not Active" listing using Manage Listing in Admin.

    I checked Manage Orders. Found thousands of records, meaning all records from day 1 of setting up the site.

    Do I have to delete old records manually using Manage Orders?
  18. freeze2 Customer

    You do not need to delete the orders if you do not want to, they're a record of orders placed through your system.
  19. user2616 Customer

    freeze2, Listings are posted free in my site. I do not rally need old order records.

    Can the system clean up these records periodically or I need to clean up manually?
  20. freeze2 Customer

    You would need to clean them up manually if this is important to you.

Share This Page