Reward Points Module for ZC v13x

snowy2007:

Cheers Andrew - I have another problem if anyone can shed any light :

In the Admin/Customers/Reward Points screen I have the following two problems :

1. When I click on a letter (sorted by Last Name) it shows me 1 screen full of names but not all the names IE: If I select the letter P then the last name on the list is "Penfold" but I have lots more customers whose last name starts with P such as Pickton etc... They are not on there. SCRAP THIS ONE - I have just realised I can change the number displayed in Admin from the default of 50

2. I have set up a test customer and earned some points. When I try to click on the edit function for that customer whose surname is "Phenton" (to manually add points etc...) and I find them by entering "Phenton" in the search box I get the following error :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%phenton%' OR c.customers_firstname LIKE '%phenton%' OR c.customers_id LIKE '%' at line 1

You got the first one :D The second one was sorted in v1.25- so if you have v1.26 (the alpha release) this is covered.

RE my previous post : If I select the "Phenton" customer from the list generated by clicking "P" at the top then the error doesn't occur - only when I have searched for the customer.

Another one :) When a product is priced at £1 it carries one point - Is there any way for the module to display this as 1 reward point rather than 1 reward points (IE: Plural)

hem:

You got the first one :D The second one was sorted in v1.25- so if you have v1.26 (the alpha release) this is covered.

Hi Andrew - I have V1.23a - where can I get V1.26 from and is it an easy upgrade?

snowy2007:

Hi Andrew - I have V1.23a - where can I get V1.26 from and is it an easy upgrade?

http://www.omnicia.com/www/Zencart%20Reward%20Points%20Module.zip

There shouldn't be any show-stoppers. The only (alpha) changes in this release is a new Reward Point Discount add-on which is not installed by default.

snowy2007:

RE my previous post : If I select the "Phenton" customer from the list generated by clicking "P" at the top then the error doesn't occur - only when I have searched for the customer.

Another one :) When a product is priced at £1 it carries one point - Is there any way for the module to display this as 1 reward point rather than 1 reward points (IE: Plural)

I think the agreed method for this type of thing is to use Reward Point(s) if it becomes an issue.

hem:

http://www.omnicia.com/www/Zencart%20Reward%20Points%20Module.zip

There shouldn't be any show-stoppers. The only (alpha) changes in this release is a new Reward Point Discount add-on which is not installed by default.

Cheers for that Andrew

hem:

I think the agreed method for this type of thing is to use Reward Point(s) if it becomes an issue.

Good Idea!! :)

Excellent contrib by the way!!

Sorry to be a pain, but another quick question:

Is there any way for points to be marked as "Earned" (rather than Pending) automatically as soon as the customer checks out (rather than waiting for an order status change).

snowy2007:

Cheers for that Andrew

Good Idea!! :)

Excellent contrib by the way!!

Sorry to be a pain, but another quick question:

Is there any way for points to be marked as "Earned" (rather than Pending) automatically as soon as the customer checks out (rather than waiting for an order status change).

Set the Reward Points Status Track to "Advanced" and set the Reward Points to go to Earned on Pending Status.

Watch out for the pitfall on doing this- A customer could make a high value purchase, then make a second order using the points from the first order and then cancel the first order.

hem:

Set the Reward Points Status Track to "Advanced" and set the Reward Points to go to Earned on Pending Status.

Watch out for the pitfall on doing this- A customer could make a high value purchase, then make a second order using the points from the first order and then cancel the first order.

Good thinking about that pitfall Andrew! I think I will leave it so that they change when the order status changes to processing.

Another thing : I have over 7000 newsletter subscribers, 2500ish of which are registered customers. I realise that I can try to convert the 5500 subscribers who aren't yet customers by giving x number of free points to new accounts but.... Is there any way I can reward my existing customers by giving them all, say, 500 points to spend?

EDIT: By the way - The link you gave for the new module didn't work. If I remove the www AFTER the ominica.com it works - is that the correct version?

snowy2007:

Good thinking about that pitfall Andrew! I think I will leave it so that they change when the order status changes to processing.

Another thing : I have over 7000 newsletter subscribers, 2500ish of which are registered customers. I realise that I can try to convert the 5500 subscribers who aren't yet customers by giving x number of free points to new accounts but.... Is there any way I can reward my existing customers by giving them all, say, 500 points to spend?

EDIT: By the way - The link you gave for the new module didn't work. If I remove the www AFTER the ominica.com it works - is that the correct version?

Yes- sorry the "Copy URL" on FireFTP doesn't allow multiple links to the same folder so if I got to \public_html\ it copies fine but if I go to \www\ (same thing) the 'www' gets copied.

Ok, i downloaded the alpha version. what is the google checkout item? does this change the checkout process?

snowy2007:

Good thinking about that pitfall Andrew! I think I will leave it so that they change when the order status changes to processing.

Another thing : I have over 7000 newsletter subscribers, 2500ish of which are registered customers. I realise that I can try to convert the 5500 subscribers who aren't yet customers by giving x number of free points to new accounts but.... Is there any way I can reward my existing customers by giving them all, say, 500 points to spend?

It's on the wishlist.

hem:

It's on the wishlist.

I take it the only easy way at the moment would be via an SQL query?

I have just had a look at the tables - scrap my previous post :)

A small bit of php code should do the trick. Am I correct in thinking it would have to do the following :

For each record in the *customer *table :

1. Extract the customers_id

2. Insert a new record into the reward_customer_points table with the extracted customers_id copied into the corresponding field and a points value inserted into the reward_points field

Would this bit of code do the trick to add 200 points to each customer? :

<?PHP

$user_name = "username";
$password = "password";
$database = "databasename";
$server = "localhost";
$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

$SQL = "SELECT * FROM customers";
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
	$custid=$db_field['customers_id'];

	$SQLINSERT = "INSERT INTO reward_customer_points (customers_id, reward_points)" 
				. " VALUES ('$custid', 200)";
		
                 $rows = mysql_query($SQLINSERT); 

	if(!$rows) { 
            $message = "Insert error: " . mysql_error(); 
            } 
}

mysql_close($db_handle);

}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}

?>

Quick question - I searched the thread but haven't found anything on it.

If I have Dual Pricing installed, it is possible to NOT allow my wholesale customers to accumulate points or would this be a custom bit of code?

Thanks!

snowy2007:

Would this bit of code do the trick to add 200 points to each customer? :

That should do it. If you "include 'application_top.php'" you could use the function UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points) which will append the points to any customer that already has points.

janellez:

Quick question - I searched the thread but haven't found anything on it.

If I have Dual Pricing installed, it is possible to NOT allow my wholesale customers to accumulate points or would this be a custom bit of code?

Thanks!

If they are all Grouped together you can set the redeem ratio for the group to 0.

hem:

That should do it. If you "include 'application_top.php'" you could use the function UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points) which will append the points to any customer that already has points.

Excellent!

Here's something to think about: Can you think of a way of doing this :

1. Give all customers the 200 points on Friday

2. If they haven't spent them (or some of them) by Sunday evening then take the 200 points away from them (time limited points offer basically).

Also, is there any easy way of turning the module off on a temporary basis - It is on the site now but I don't really want customers to be earning points until I send a newsletter out announcing it later this week.

snowy2007:

Excellent!

Here's something to think about: Can you think of a way of doing this :

1. Give all customers the 200 points on Friday

2. If they haven't spent them (or some of them) by Sunday evening then take the 200 points away from them (time limited points offer basically).

Also, is there any easy way of turning the module off on a temporary basis - It is on the site now but I don't really want customers to be earning points until I send a newsletter out announcing it later this week.

I have ideas for a Campaign addon which would do things like that, as well as say double points for certain items ordered within a particular period and Reward Points being worth more (again it would be time based).

As for switching off the mod- Just uninstall the Order Total modules and switch off any of the Reward Point sideboxes under Layout Manager.

hem:

I have ideas for a Campaign addon which would do things like that, as well as say double points for certain items ordered within a particular period and Reward Points being worth more (again it would be time based).

That would be a fantastic addition to an already great mod - i'm guessing there is no time scale for it yet though :blush: