evgv/mage_sql_copy_description_to_short_description.md

Last active August 29, 2016 09:42

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/evgv/e51e68ceb2197639afd7782d9de4462f.js"></script>
Save evgv/e51e68ceb2197639afd7782d9de4462f to your computer and use it in GitHub Desktop.

Magento. SQL. Copy product description attribute to short description.

Raw

mage_sql_copy_description_to_short_description.md

UPDATE catalog_product_entity_text AS A

SET A.value = (
			SELECT B.value
			FROM (SELECT * FROM catalog_product_entity_text) AS B
			WHERE B.attribute_id = 72
			AND B.entity_id = A.entity_id
			AND B.store_id = A.store_id
		)
					
WHERE A.attribute_id = 73
#AND A.entity_id = 388
#AND A.store_id = 4