6 lines
220 B
SQL
6 lines
220 B
SQL
-- Change Switzerland Express shipping price to 8 CHF
|
|
|
|
UPDATE "delivery-methods_prices" SET price = 8 WHERE territory = 'CH' AND currency = 'CHF'
|
|
AND method = (select id from "delivery-methods" where name = 'dhl');
|
|
|