WooCommerce: SQL to fix sorting by date

woocommerce_fix_sorting_by_date.sql

-- 
-- When the product "post date" is incorrect
-- (for example, as a result of batch import-export)
-- this SQL will fake the date using the post_ID
-- 
-- @author Gregory Karpinsky, http://www.tiv.net/
-- @version 14.08.19
--

UPDATE wp_posts
  SET `post_date` = CURDATE( ) + INTERVAL ID SECOND
  WHERE `post_type` = 'product';

-- Assuming that WP timezone is UTC
UPDATE wp_posts
  SET `post_date_gmt` = `post_date`
  WHERE `post_type` = 'product';

-- EOF