Skip to content

Instantly share code, notes, and snippets.

@skyred

skyred/Reset weight according to alphabetical order of the names

Created April 21, 2016 18:21
Show Gist options
  • Save skyred/d2f35bbc51e3cfe2d32bfda74decb492 to your computer and use it in GitHub Desktop.
Save skyred/d2f35bbc51e3cfe2d32bfda74decb492 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Reset weight according to alphabetical order of the names
SET @rank:=0;
UPDATE commerce_product_attribute_value_field_data
SET weight=@rank:=@rank+1
WHERE attribute = 'style'
ORDER BY name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment