Change expiration date to all places

This topic contains 7 replies, has 3 voices, and was last updated by  P O 6 years, 2 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #459276

    P O
    Expired Member
    Post count: 501

    I need to change the expiration date of all places to a new one.

    Select all, new expiration date: 25/01/2019

    How ?

    #459290

    Kor
    Moderator
    Post count: 16516

    Hi PO,

    You can try using the import/export CSV method to do bulk tasks.

    Thanks

    #459420

    P O
    Expired Member
    Post count: 501

    That does not feel safe. CVS will have a different format and for sure will end in a mess.

    Unless you can please share an exact step by step on what to do, what format, how to export in in local, how to import it, avoid duplicates when importing, etc…

    Maybe a MySQL query to change all places at once?

    Thanks.

    #459422

    Kor
    Moderator
    Post count: 16516

    Hi PO,

    Thanks for your reply. I’m referring to the method here https://wpgeodirectory.com/docs/core-export/ . You should always backup everything if you’re updating a massive data.

    Thanks.

    #459423

    P O
    Expired Member
    Post count: 501

    Exactly, 10 alerts telling you everything will be a mess if a comma is wrong feels not safe at all.

    Maybe a MySQL query to change all places at once?

    Thanks.

    #459443

    Kor
    Moderator
    Post count: 16516

    Hi PO,

    I’ll forward this to a developer for a second opinion.

    Thanks!

    #459493

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    BACKUP YOUR DATABASE!
    (assuming standard wp_ prefix and for places)

    
    
    UPDATE wp_geodir_gd_place_detail 
    SET expire_date ='2019-01-25' 
    WHERE expire_date != 'Never'

    Stiofan

    #459777

    P O
    Expired Member
    Post count: 501

    Perfect, much better!

    Thank you.

Viewing 8 posts - 1 through 8 (of 8 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount