seforoth

I recommend creating a migration using the following plugin: https://en-au.ww.wp.xz.cn/plugins/all-in-one-wp-migration/

Then setup a staging area and import the migration to it. You can then deactivate/delete WC v3 on your live version without any worries what-so-ever. Once you’ve downgraded to the previous WC version, you’ll be able to see what’ll happen to the orders. I seriously doubt you will lose anything, as I haven’t noticed much of a difference, but in any case you’ll have the migration to return back to your original state if anything were to go wrong.

• This reply was modified 9 years, 1 month ago by seforoth.
• This reply was modified 9 years, 1 month ago by seforoth.

Hi Tijmen,

Thank you very much on the info!

However, I couldn’t wait so I jerry-rigged something yesterday 😉 Here is the code if anyone else is interested.

<?php
if ( isset( $_POST['update_all_entries'] ) ) {
		global $wpdb;

		$stores = $wpdb->get_results( "SELECT * FROM $wpdb->wpsl_stores" );

		foreach ( $stores as $store ) {
			$address = urlencode($store->address.','.$store->address2.','.$store->city.','.$store->state.','.$store->zip.','.$store->country);
			$url = "http://maps.google.com/maps/api/geocode/json?sensor=false&address={$address}";
			$data = file_get_contents( $url );
			$data = json_decode( $data );

			$lat = $data->results[0]->geometry->location->lat;
			$lng = $data->results[0]->geometry->location->lng;

			$result = $wpdb->query( $wpdb->prepare( "UPDATE $wpdb->wpsl_stores SET lat = %f, lng = %f WHERE wpsl_id = %d", $lat, $lng, $store->wpsl_id ) );
			sleep(2);
		}
	}
    ?>
                    <form method="post" action="http://homyped.dev/wp-admin/admin.php?page=wpsl_settings" accept-charset="utf-8">
					<input type="submit" id="update-all-entries" name="update_all_entries" value="UPDATE ALL ENTIRES">
					</form>

I’ve added this code to the map-settings.php as it made the most sense to have it there.

Kind Regards,

Sef

You’re the best man! 🙂

Thank you very much for the really quick reply 🙂

Is there a rough date when this may be available?