Reward Points Module for ZC v13x

[snowy2007]

http://www.omnicia.com/www/Zencart%2...s%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

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).

[hem]

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.

[snowy2007]

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?

[hem]

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.

[fusionsp]

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

[hem]

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.

[snowy2007]

It's on the wishlist.

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

[snowy2007]

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

[snowy2007]

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);
}

?>