Hi! I'm trying to renew the expired listing but I'm unable to do it... When I'm trying to publish it goes in draft or scheduled... Please help!
Hello, Go to function.php present in your theme directory and add the code given below Code: global $wpdb; $data="SELECT * FROM wp_posts WHERE post_status = 'draft'"; $queries = $wpdb->get_results($data); foreach ($queries as $query) { echo $post_id=$query->ID; $meta_key='gc_listing_duration'; $post_status='post_status'; $posttable='wp_posts'; $meta_value='08/20/2013 07:15:45'; update_post_meta($post_id, $meta_key, $meta_value); $wpdb->update($posttable,array($post_status =>'publish'), array( 'ID' =>$post_id ),array('%s'),array( '%d' )); } "$meta_value" defines as the date at which you want to expire your listing, So fill "$meta_value" as per your requirements. Firstly save that code in the bottom of function.php file and then refresh your dashboard and website, It will activate your all listings after that remove that code and again save your file.
Hi! I already tried it's not working... Expired listing are still in draft... I tried few times but still it didn't work... Any idea? Tc!
Hello, The code provided above is working fine at our side, If you are getting problem then, Please provide the following information listed below. Thread Link: Your Website URL: WordPress Username: WordPress Password: Send this information on our email at [email protected] We will check your issue.
Those instructions didn't work for me either; I'm still waiting on support feedback for this via this post http://www.inkthemes.com/community/threads/bulk-renew-expired-listings-again.8064/#post-30181 In the meantime, would be very interested in what you came up with, trentmunday Thanks! ~CJ
Hello sooraj! We have got your email regarding to another issue. We will reply you soon with fix of both. Thank & Regards Pramod
