WordPress Task: Edit Post Dates in Bulk

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

# There are two values for every date (gmt and non-gmt) and their
# diff is varying because Daylight Saving Time clock change can
# be different at different date in different countries
#
SELECT post_date, post_date_gmt, post_modified, post_modified_gmt, post_name
  FROM etkwp_posts
  WHERE post_type = "shop" AND post_status = "publish"
  ORDER BY post_date
  LIMIT 10

# Now, just list older posts
#
SELECT DATE(post_date_gmt) as created, DATE(post_modified_gmt) as modified, post_name, post_title, post_status
  FROM etkwp_posts
  WHERE post_type = "shop"
    AND post_status = "publish"
    AND post_date <= DATE_SUB(CURDATE(), Interval 6 month)
  ORDER BY post_date_gmt
  LIMIT 10

# Change date 1 year forward step, only if is still older
# than modified date minus 5 days. Execute multiple times if you want.
#
UPDATE etkwp_posts
  SET
    post_date = DATE_ADD(post_date, Interval 1 year),
    post_date_gmt = DATE_ADD(post_date_gmt, Interval 1 year)
  WHERE post_type = "shop"
    AND post_status = "publish"
    AND DATE_ADD(post_date_gmt, Interval 1 year) <= DATE_SUB(post_modified_gmt, Interval 5 day)