Expiration dates

  • Resolved hiStrat76

    (@histrat76)


    8 years, 8 months ago

    Hi,

    Is there any quick and easy way to delete existing expiration dates on older listings? We’ve updated the settings so listings never expire and its working of course for new listings but doesn’t change the old ones. Any guidance on an efficient way to update the older listings to never expire?

    Thanks for your help,

    Anne

    https://wordpress.org/plugins/business-directory-plugin/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Business Directory Plugin

    (@businessdirectoryplugin)

    8 years, 8 months ago

    Hi hiStrat76,

    I’ll need to get a query from my developer on that–I’ll report back shortly.

    Plugin Author Business Directory Plugin

    (@businessdirectoryplugin)

    8 years, 8 months ago

    OK, here’s what my developer suggested:

    If he wants all listings to not expire the query below will help (assuming “wp” is the WP table prefix), but he said “older listings”, so I don’t know if a specific limit should be added to the query.

    UPDATE wp_wpbdp_listing_fees SET expires_on = NULL, email_sent = 0

    That takes care of making older listings not expire, but if they’ve already expired in a category that won’t fix it, so if there are expired listings it’d be better for him to first use the “Renew listing” bulk action and then execute the query above.

    Thread Starter hiStrat76

    (@histrat76)

    8 years, 8 months ago

    That worked beautifully. Thanks!

    Anne

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Expiration dates’ is closed to new replies.