Magento 1.9

Magento: Update price from excluding to including tax

/* Run php shell/indexer.php reindexall afterwards */
SET FOREIGN_KEY_CHECKS = 0;
UPDATE catalog_product_entity_tier_price 
   SET value = value * 1.15;
UPDATE catalog_product_index_price 
   SET price = price * 1.15, final_price = final_price * 1.15, min_price = min_price * 1.15, max_price = max_price * 1.15;
UPDATE catalog_product_index_price 
   SET tier_price = tier_price * 1.15
WHERE tier_price IS NOT NULL;
UPDATE catalog_product_index_price 
   SET group_price = group_price * 1.15
WHERE group_price IS NOT NULL;
UPDATE catalog_product_index_price_idx 
   SET price = price * 1.15, final_price = final_price * 1.15, min_price = min_price * 1.15, max_price = max_price * 1.15;
UPDATE catalog_product_index_price_idx 
   SET tier_price = tier_price * 1.15
WHERE tier_price IS NOT NULL;
UPDATE catalog_product_index_price_idx 
   SET group_price = group_price * 1.15
WHERE group_price IS NOT NULL;
UPDATE catalog_product_entity_decimal 
   SET value = value * 1.15
WHERE attribute_id IN (75, 76, 90, 91, 99);
SET FOREIGN_KEY_CHECKS = 1;