WooCommerce import Points & Rewards using Customer Order CSV Importer

functions.php

<?php
add_action( 'woocommerce_api_points_rewards_custom_generator', 'wc_points_rewards_generate_custom_points' );
function wc_points_rewards_generate_custom_points() {
	$customers = get_users( array(
		'meta_key' => 'wc_points_balance'
	) );
	foreach ( $customers as $customer ) {
		$points = get_user_meta( $customer->ID, 'wc_points_balance', true );
		if ( $points > 0 ) {
			if ( WC_Points_Rewards_Manager::increase_points( $customer->ID, $points, 'IMPORT' ) ) {
				print $customer->user_nicename . ', ' . $points . ' imported<br>';
				delete_user_meta( $customer->ID, 'wc_points_balance' );
				wp_cache_delete( $customer->ID, 'user' . '_meta' );
			} else print 'Import Failed: ' . $customer->user_nicename;
		}
 	}
	die();
}

Hi

I do have the woocommerce Points and Rewards system installed but before i installed them i already had 19000+ customers registered.
However the customers would not show in my points manager until they purchase an item that gives points.
Does this plugin import the Customers from the Users section to the Manage Points area?

thanks
Junaid Jameel

Hi, I love the idea of this but when I place the code in my functions.php my site throws an error. Any fix to this code to work with current plugin version? thanks in advance

Does not work. I used 'wc_points_balance' as the field name, nothing happens.

Does not work. I used 'wc_points_balance' as the field name, nothing happens.

The meta key is just points_balance @C00woot

Hi has anyone got this to work? I have the code loaded in functions.php and when I run the importer using a simple test with a single email address and points column (labelled wc_points_balance) it asks to map the column headers to the customer database. of course the points fields are not there, so I wonder how this is achieved?