Skip to content

Instantly share code, notes, and snippets.

@molotovbliss

molotovbliss/truncate-colors.sql

Created February 16, 2016 01:21
Show Gist options
  • Save molotovbliss/61d4090b8e314a66ed0a to your computer and use it in GitHub Desktop.
Save molotovbliss/61d4090b8e314a66ed0a to your computer and use it in GitHub Desktop.
Download ZIP
Delete all color option values in Magento SQL
Raw
truncate-colors.sql
# Delete all color option values (attribute 80 default)
DELETE ov.*
FROM eav_attribute_option_value AS ov
JOIN eav_attribute_option AS o
ON o.option_id = ov.option_id
WHERE o.attribute_id = 80;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment