Reward Points Module for ZC v13x

[Rasyr]

I will have to set up a PayPal IPN Payment mod onto my test rig and then work out how to setup the sandbox so I can test it.

And of course, this morning somebody had to go and use Paypal, and it award him points.... (so 1 out 4, IIRC got their RP when checking out with Paypal).

Perhaps it has something to do with whether or not they return to the site afterwards (though I would think that most do, since we sell PDFs, and they have to return to download them).


Another issue --

We gave everybody on the store 1,000 Reward Points (i.e. $10.00). One fellow went and purchased $10 worth of products, and it still wanted him to select a Payment option (even with a zero balance), and Paypal won't process anything with a zero balance....

Tons of fun... hehe

[hem]

And of course, this morning somebody had to go and use Paypal, and it award him points.... (so 1 out 4, IIRC got their RP when checking out with Paypal).

Perhaps it has something to do with whether or not they return to the site afterwards (though I would think that most do, since we sell PDFs, and they have to return to download them).


Another issue --

We gave everybody on the store 1,000 Reward Points (i.e. $10.00). One fellow went and purchased $10 worth of products, and it still wanted him to select a Payment option (even with a zero balance), and Paypal won't process anything with a zero balance....

Tons of fun... hehe

But did they use PayPal IPN???

And I'm looking into the zero balance/select payment thing- I came across it during testing.

[Rasyr]

But did they use PayPal IPN???

And I'm looking into the zero balance/select payment thing- I came across it during testing.

yeah, 1 person out of like 4 that used Paypal ended up with point in the Pending category (still, they never moved to earned automatically though).

And to make it interesting, the day before, somebody else order the exact same thing (specific book with a bundled PDF) and he didn't get any points.

And a guy who just ordered and paid through paypal didn't get his points put into Pending (or Earned)

Aha! A pattern emerges!!! All of the Paypal purchasers who did NOT receive their points in Pending (we can worry about them being automatically moved to Earned later) had a "Trans. type" of "unique". The guy who's purchase gave him his RP in Pending had a "Trans. Type" of "web_accept".

That has to be significant somehow....

[hem]

yeah, 1 person out of like 4 that used Paypal ended up with point in the Pending category (still, they never moved to earned automatically though).

And to make it interesting, the day before, somebody else order the exact same thing (specific book with a bundled PDF) and he didn't get any points.

And a guy who just ordered and paid through paypal didn't get his points put into Pending (or Earned)

Aha! A pattern emerges!!! All of the Paypal purchasers who did NOT receive their points in Pending (we can worry about them being automatically moved to Earned later) had a "Trans. type" of "unique". The guy who's purchase gave him his RP in Pending had a "Trans. Type" of "web_accept".

That has to be significant somehow....

Rasyr- I will look into the transaction type and see what relevance it has.

Regarding your earlier comment about paying with PayPal but not returning to your site- As the PayPal return is to checkout_process.php, then there will be no reward of points unless this is run. Unfortunately the points cannot be rewarded before PayPal is called otherwise the customer could end up with RP even if they cancel the PayPal transaction

Question- If I remember rightly, you use phpmysql- Could you check the reward_status_track table and see if any of the "non appearing" transactions are there (but with zero points in pending or earned)- Might add another piece to the jigsaw.

[fiji]

Rasyr- I will look into the transaction type and see what relevance it has.

Regarding your earlier comment about paying with PayPal but not returning to your site- As the PayPal return is to checkout_process.php, then there will be no reward of points unless this is run. Unfortunately the points cannot be rewarded before PayPal is called otherwise the customer could end up with RP even if they cancel the PayPal transaction

Question- If I remember rightly, you use phpmysql- Could you check the reward_status_track table and see if any of the "non appearing" transactions are there (but with zero points in pending or earned)- Might add another piece to the jigsaw.

Andrew,
I mention before the paypal problem.
I test many times and the paypal returning to my site and create an order sucessful. Everything is working well.
The only problem is no pending point and no earned point.
You can try the paypal via sandbox.

[hem]

Andrew,
I mention before the paypal problem.
I test many times and the paypal returning to my site and create an order sucessful. Everything is working well.
The only problem is no pending point and no earned point.
You can try the paypal via sandbox.

Fiji- according to the ZenCart Wiki on PayPal IPN I cannot test it with the sandbox and I have to use it in a live environment.

[Rasyr]

Rasyr- I will look into the transaction type and see what relevance it has.

Regarding your earlier comment about paying with PayPal but not returning to your site- As the PayPal return is to checkout_process.php, then there will be no reward of points unless this is run. Unfortunately the points cannot be rewarded before PayPal is called otherwise the customer could end up with RP even if they cancel the PayPal transaction

Question- If I remember rightly, you use phpmysql- Could you check the reward_status_track table and see if any of the "non appearing" transactions are there (but with zero points in pending or earned)- Might add another piece to the jigsaw.

Actually I use mySQL Front (a stand-alone app).

And in looking, no, the Paypal orders (with the transaction type of "unique) are not in that table.

[NullMind]

Andrew

I could have swore it worked before, I know I tested it .. but it was with the beta, wonder fi somthing changed, but when changing order status with Super Orders, it will not redeem the credits (when moving order to status that should redeem)

[hem]

Andrew

I could have swore it worked before, I know I tested it .. but it was with the beta, wonder fi somthing changed, but when changing order status with Super Orders, it will not redeem the credits (when moving order to status that should redeem)

It should work- As long as Super Orders changes the order status (which I track on) the sync should change the point redeem also.

I think I might have to stick version tracking into the code headers- Might help with all the old versions/new versions to make sure we're all singing off the same hymn sheet.

[Louis]

Andrew

I could have swore it worked before, I know I tested it .. but it was with the beta, wonder fi somthing changed, but when changing order status with Super Orders, it will not redeem the credits (when moving order to status that should redeem)

Andrew, Nullmind,

It does work with super orders. I installed it the day it was made final and completed a number of orders already with the points transferring to earned. Today I recieved my first order paid by RP's and it also worked great.

Thanks for a fantastic mod. I will buy you a cuppa towards the end of the month. Have you got a paypal account where we can donate?