Can't activate – fatal error

Hey sorry to hear about that. It is almost certainly choking on the get_posts request. There’s no reason why it can’t be broken up, the only issue is we have somewhat limited resources to add features to these free plugins. Not to try and upsell you, but the premium version https://www.woothemes.com/products/sequential-order-numbers-pro/ does have a better install method that breaks the records up instead of trying to process them all in one swoop, so that’s a possibility if you need something sooner than later.

Hope this helps,
Justin

Hi Justin,
I don’t see how the method for the pro version should be different from the method for the free version…

Either way, here’s some free ‘resources’ for you. :o)

if ( ! $installed_version ) {
	// initial install, set the order number for all existing orders to the post id
	$limit = 200;
	$offset = 0;

	while (TRUE) {
		// Query posts
		$orders = new WP_Query( array(
			'posts_per_page'	=> $limit,
			'offset'			=> $offset,
			'post_type'			=> 'shop_order',
		));

		if (!$orders->have_posts()) break;

		while($orders->have_posts()) {
			$orders->the_post();
			$order_id = $orders->post->ID;

			if ( get_post_meta( $order_id, '_order_number', true ) == '' ) {
				add_post_meta( $order_id, '_order_number', $order_id );
			}

			// wipe post from memory
			wp_cache_delete( $order_id, 'posts' );
			wp_cache_delete( $order_id, 'post_meta' );
		}

		$offset += $limit;
	} /*(TRUE)*/
}

did the trick for me. (credits for the method go to frnhr & TheDeadMedic) I hope you’ll add this to the free version of the plugin, as I think that would be fair.

Hey Justin, let me know if you need a proper patch for applying this, I’ll make it for you!

Hey I appreciate the offer, but don’t worry about it, I have some code from another plugin I can use, and we’ll get this in at some point!