Guest User

Untitled

a guest
Mar 19th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. INSERT INTO catalog_product_entity_group_price(
  2. entity_id,
  3. value,
  4. customer_group_id,
  5. all_groups, website_id)
  6.  
  7. SELECT entity_id,
  8. value + (value/10) as value,
  9. 2 as customer_group_id,
  10. 0 as all_groups,
  11. 0 as website_id
  12.  
  13. FROM catalog_product_entity_decimal
  14.  
  15. WHERE entity_type_id=10
  16. AND attribute_id=100
  17. AND value IS NOT NULL
Add Comment
Please, Sign In to add comment