UPDATE products
SET sku = CONCAT('__deleted_product_', id),
  woo_product_id = NULL,
  woo_variation_id = NULL
WHERE active = FALSE;

UPDATE product_size_options
SET sku = CASE
  WHEN sku IS NULL OR sku = '' THEN NULL
  ELSE CONCAT('__deleted_size_', id)
END
WHERE active = FALSE;

UPDATE inventory_items
SET sku = CONCAT('__deleted_inventory_', id)
WHERE active = FALSE;
