gistfile1.sql

UPDATE ecomm_tax SET value = 0.1, name="TVA 10 %" WHERE value = 0.07 OR value = 0.1;
UPDATE ecomm_tax SET value = 0.2, name="TVA 20 %" WHERE value = 0.196 OR value = 0.2;

# Annuler les corrections pour Blondel
UPDATE ecomm_product SET tax_id = 109 WHERE tax_id = 117 AND site_id = 1260;
DELETE FROM ecomm_tax WHERE id = 117 AND site_id = 1260;

#######################################
# Si T.T.C doit rester identique
SET @site := 1260; # Changer cette valeur

# base_price
UPDATE ecomm_product p
SET
p.base_price = ROUND(p.price_with_tax / (1 + (SELECT t.value FROM ecomm_tax t WHERE t.id = p.tax_id)), 2)
WHERE site_id = @site;
#######################################

### ATTENTION : NE PAS APPLIQUER LES 2 BLOCS EN MEME TEMPS, il s'agit de 2 cas différents

#######################################
# Si H.T doit rester identique
SET @site := 1260; # Changer cette valeur

# price_with_tax
UPDATE ecomm_product p
SET 
p.price_with_tax = ROUND(p.base_price + (p.base_price * (SELECT t.value FROM ecomm_tax t WHERE t.id = p.tax_id)), 2),
p.price_with_discount = ROUND(p.base_price + (p.base_price * (SELECT t.value FROM ecomm_tax t WHERE t.id = p.tax_id)), 2)
WHERE site_id = @site;

# price_with_discount à partir de price_with_tax
UPDATE ecomm_product p
SET 
p.price_with_discount = ROUND(p.price_with_tax + (p.price_with_tax * discount), 2)
WHERE site_id = @site AND discount IS NOT NULL;
#######################################