Vantage: How to bulk renew 4,092 expired listings
Vantage: How to bulk renew 4,092 expired listings (Bulk Edit sets status but expiry date remains.
Hi AppThemes Team,
I’m using the Vantage theme and after 365 days I now have 4,092 listings
that show as expired. I tried Bulk Edit → Status: Published in WordPress,
but the listings remain treated as expired on the front end. It looks like
Vantage relies on an expiration date meta field (not just post_status), so
changing status alone doesn’t reactivate them.
Goal: Renew/reactivate all expired listings in bulk (not one by one),
ideally by extending the expiration based on the listing’s pricing plan
duration.
Environment (can provide exact versions if needed):
WordPress: new
Vantage: latest
PHP: 8.XX
WordPress Bulk Edit → set status to Published → listings still considered
expired.
Single “Renew” per listing works, but is not feasible for ~4k items.
Questions:
What is the canonical meta key Vantage uses for the listing expiration
date/time? (Examples I’ve seen elsewhere: expires, expire_date,
va_expire_date.) Is the value stored as UNIX timestamp or MySQL DATETIME?
Is there an official bulk action or tool in Vantage to renew many listings
at once?
If not, is there an official function/hook to renew a listing
programmatically (so the new expiry is computed from the attached pricing
plan and any related bookkeeping is handled)? A short code example would be
great.
If I update the expiry meta and set post_status to publish in bulk (via
WP-CLI/SQL), will Vantage treat the listings as active immediately, or are
there additional steps (e.g., clearing transients/caches, triggering
actions) I should run?
Any side effects to be aware of (orders, renewal logs, user notifications,
reports)?
Best practice to avoid this in the future (e.g., adjusting plan duration or
a recommended renewal workflow for large sites)?
Proposed workaround to validate (please confirm):
Detect the correct expiration meta key.
For all listings with post_status in expired (and optionally publish) where
the expiry is in the past, set a new future date (e.g., now + 365 days) and
ensure post_status = publish.
If you could confirm:
the exact meta key and expected format (UNIX vs. DATETIME, UTC vs. local),
whether there’s an official API/function to call for renewal,
and any follow-up actions Vantage expects,
…I’ll proceed safely on a staging copy first.
Thanks a lot for your guidance!
Best Regards