Update empty descriptions and short descriptions with the title of the products

update-descriptions-and-short-descriptions.sql

# Description
UPDATE catalog_product_entity_text as t
SET t.value = (
    SELECT
    v.value
    FROM catalog_product_entity_varchar as v
    WHERE v.entity_id = t.entity_id
    AND v.store_id = t.store_id
    AND v.attribute_id = 71
)
WHERE t.attribute_id = 72
AND t.value IS NULL
ORDER BY t.value_id ASC
LIMIT 1;

# Short Description
UPDATE catalog_product_entity_text as t
SET t.value = (
    SELECT
    v.value
    FROM catalog_product_entity_varchar as v
    WHERE v.entity_id = t.entity_id
    AND v.store_id = t.store_id
    AND v.attribute_id = 71
)
WHERE t.attribute_id = 73
AND t.value IS NULL
ORDER BY t.value_id ASC
LIMIT 1;