Expiration dates

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

    (@businessdirectoryplugin)

    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)

    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)

    That worked beautifully. Thanks!

    Anne

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