wc_update_320_mexican_states()
Update state codes for Mexico.
Contents
Description Description
Source Source
File: includes/wc-update-functions.php
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 ), ) ); } }