Paypal orders are sorta locked
xx
— wp1_postmeta
update wp1_postmeta
set meta_value = ‘0.00’
where post_id = 3387
and meta_key = ‘_order_shipping’;
update wp1_postmeta
set meta_value = ‘0.00’
where post_id = 3387
and meta_key = ‘_order_shipping_tax’;
update wp1_postmeta
set meta_value = ‘10.36’
where post_id = 3387
and meta_key = ‘_order_total’;
— wp1_woocommerce_order_itemmeta
update wp1_woocommerce_order_itemmeta oim
join wp1_woocommerce_order_items oi on oi.order_item_id = oim.order_item_id
set meta_value = ‘0.00’
where oi.order_id = 3387
and oi.order_item_type = ‘shipping’
and meta_key = ‘cost’;
update wp1_woocommerce_order_itemmeta oim
join wp1_woocommerce_order_items oi on oi.order_item_id = oim.order_item_id
set meta_value = ‘ a:1:{i:1;s:6:”0.00″;}’
where oi.order_id = 3387
and oi.order_item_type = ‘shipping’
and meta_key = ‘taxes’;
xx