Reward Points Module for ZC v13x

[hem]

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 The second one was sorted in v1.25- so if you have v1.26 (the alpha release) this is covered.

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

[snowy2007]

You got the first one 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?

[hem]

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

[hem]

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.

[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?