wc_update_320_mexican_states() WC 1.0
Update state codes for Mexico.
No Hooks.
Return
Null. Nothing.
Usage
wc_update_320_mexican_states();
Code of wc_update_320_mexican_states() wc update 320 mexican states WC 5.0.0
function wc_update_320_mexican_states() {
global $wpdb;
$mx_states = array(
'Distrito Federal' => 'CMX',
'Jalisco' => 'JAL',
'Nuevo Leon' => 'NLE',
'Aguascalientes' => 'AGS',
'Baja California' => 'BCN',
'Baja California Sur' => 'BCS',
'Campeche' => 'CAM',
'Chiapas' => 'CHP',
'Chihuahua' => 'CHH',
'Coahuila' => 'COA',
'Colima' => 'COL',
'Durango' => 'DGO',
'Guanajuato' => 'GTO',
'Guerrero' => 'GRO',
'Hidalgo' => 'HGO',
'Estado de Mexico' => 'MEX',
'Michoacan' => 'MIC',
'Morelos' => 'MOR',
'Nayarit' => 'NAY',
'Oaxaca' => 'OAX',
'Puebla' => 'PUE',
'Queretaro' => 'QRO',
'Quintana Roo' => 'ROO',
'San Luis Potosi' => 'SLP',
'Sinaloa' => 'SIN',
'Sonora' => 'SON',
'Tabasco' => 'TAB',
'Tamaulipas' => 'TMP',
'Tlaxcala' => 'TLA',
'Veracruz' => 'VER',
'Yucatan' => 'YUC',
'Zacatecas' => 'ZAC',
);
foreach ( $mx_states as $old => $new ) {
$wpdb->query(
$wpdb->prepare(
"UPDATE $wpdb->postmeta
SET meta_value = %s
WHERE meta_key IN ( '_billing_state', '_shipping_state' )
AND meta_value = %s",
$new,
$old
)
);
$wpdb->update(
"{$wpdb->prefix}woocommerce_shipping_zone_locations",
array(
'location_code' => 'MX:' . $new,
),
array(
'location_code' => 'MX:' . $old,
)
);
$wpdb->update(
"{$wpdb->prefix}woocommerce_tax_rates",
array(
'tax_rate_state' => strtoupper( $new ),
),
array(
'tax_rate_state' => strtoupper( $old ),
)
);
}
}