Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO catalog_product_entity_group_price(
- entity_id,
- value,
- customer_group_id,
- all_groups, website_id)
- SELECT entity_id,
- value + (value/10) as value,
- 2 as customer_group_id,
- 0 as all_groups,
- 0 as website_id
- FROM catalog_product_entity_decimal
- WHERE entity_type_id=10
- AND attribute_id=100
- AND value IS NOT NULL
Add Comment
Please, Sign In to add comment