Reward Points Module for ZC v13x

retched:

Oh I didn't know this mod already existed? I had mangled this mod to get it to work like that one :mellow:

Just out of interest, what would you call that function?

hem:

Just out of interest, what would you call that function?

The function which I changed?

retched:

The function which I changed?

Well, what snappy name would you give it? Perpetual Rewards? Longtime Customer Benefit? Loyalty Accruement?

hem:

Well, what snappy name would you give it? Perpetual Rewards? Longtime Customer Benefit? Loyalty Accruement?

Lifetime Customer Rewards would be something I'd name it.

Hello,

First, thank you for your wonderful contribution!

I want to encourage customers to write reviews or testimonials in my site. Is it possible to reward customers, say 10 reward points, for them to do so?

Lina

lina0962:

Hello,

First, thank you for your wonderful contribution!

I want to encourage customers to write reviews or testimonials in my site. Is it possible to reward customers, say 10 reward points, for them to do so?

Lina

You can manually add in points on your own after you moderate them.

If you want to automatically add them on a posted review... I think this can be done by adding a few lines to the review poster.

Version 1.40a now available for testing.

The major change for this version is a new stub written especially to handle missing PayPal IPN orders. It is available for download from my website (http://www.omnicia.com).

Make sure you backup your database first (just to be safe).

IMPORTANT. If you use PayPal IPN and you have been manually adding Reward Points to customers, you must run the following SQL patch BEFORE installing this version. Failure to do so will result in doubled up points.

INSERT IGNORE INTO reward_status_track
	(customers_id,orders_id,date,reward_points,status)
	SELECT o.customers_id,o.orders_id,NOW(),ot.text,IF(o.orders_status=1,0,1)
		FROM orders o,orders_total ot
		WHERE ot.orders_id=o.orders_id AND  
			  ot.class='ot_reward_points_display';

This patch is also available in the root folder of the zip and is called prep_IPN_RP_orders.sql.

Further to this, if you are upgrading from the latest version (1.33a) then all you need to do is copy /admin/includes/functions/extra_functions/reward_points_functions.php to the corresponding folder in your admin folder. No need to install updates.sql either as there have been no changes to the MySQL tables.

hem:

That's correct. You've already installed it once, it does not need installing again.

Well, this is still not showing up right. Not sure what the problem is.

I may take a snapshot of the current site and start over.

hem:

Further to this, if you are upgrading from the latest version (1.33a) then all you need to do is copy /admin/includes/functions/extra_functions/reward_points_functions.php to the corresponding folder in your admin folder. No need to install updates.sql either as there have been no changes to the MySQL tables.

I am eager to give the new version a try and will do so shortly. One question, I am using the rewards points and an order editor (sorry don't recall which one off hand) but when I edit orders, it does very strange things to the rewards points. It will change the total to 0 on the order page. Now it does not seem to make a difference to the ACTUAL points as they are still added to the account when the order is completed but it has been tough with my paypal orders as you know, it has not been adding the reward points for paypal orders so each time I had to manually enter reward points for an order I had edited, I had to also calculate the reward points myself as well. Also if you add an item to an order, the reward points don't seem to change for the edited order.

I understand that both of these modules are from different people. Does there need to be a collaboration on the module creator's part to see if there is a fix to these issues? I am amazingly happy with my rewards points module and very happy with my order editor as well.

If you would like more information or would like to view the site I am talking about you can go to https://www.urbansamuraihobbies.com.

Thanks.

Spencer.

urbansamurai:

I am eager to give the new version a try and will do so shortly. One question, I am using the rewards points and an order editor (sorry don't recall which one off hand) but when I edit orders, it does very strange things to the rewards points. It will change the total to 0 on the order page. Now it does not seem to make a difference to the ACTUAL points as they are still added to the account when the order is completed but it has been tough with my paypal orders as you know, it has not been adding the reward points for paypal orders so each time I had to manually enter reward points for an order I had edited, I had to also calculate the reward points myself as well. Also if you add an item to an order, the reward points don't seem to change for the edited order.

I understand that both of these modules are from different people. Does there need to be a collaboration on the module creator's part to see if there is a fix to these issues? I am amazingly happy with my rewards points module and very happy with my order editor as well.

If you would like more information or would like to view the site I am talking about you can go to www.urbansamuraihobbies.com.

Thanks.

Spencer.

I'm having similar problems between Super Orders and Edit Orders what generally happens is that any number entered where total points are are converted to a $0.00 like entry (example, I enter 400, the number is converted to $400).

The only way for this to be fixed is to take apart the edit order mod and determine how it gets values then add in custom coding so that when you modify the value of the points, it doesn't change on you.

Another, less practical, way of fixing this would be to go into your MySQL DB with a tool like phpMyAdmin and have it at that way. But again, this is NOT ideal for beginner's.

Hi,

Thanks for a great module. This thread is 168 pages long!.

I have had a look through and found a similar issue to mine (page 99) but could not see an answer, I may have missed it.

I have this set to 1 in admin - configuration - rewards points

"How to calculate Reward Points
0= Always use the base price.
1= Use price less Discounts and Specials."

But the rewards are granted on based price (i.e. item for 60, special / sale price 45, 60 points awarded) , I have tried switching the options.

ZenCart 1.3.9d
PHP Version: 5.2.6 (Zend: 2.2.0)
Database: MySQL 5.0.51a

Any ideas before I start to dig into the code?

Alan

sailsport:

Hi,

Thanks for a great module. This thread is 168 pages long!.

I have had a look through and found a similar issue to mine (page 99) but could not see an answer, I may have missed it.

I have this set to 1 in admin - configuration - rewards points

"How to calculate Reward Points
0= Always use the base price.
1= Use price less Discounts and Specials."

But the rewards are granted on based price (i.e. item for 60, special / sale price 45, 60 points awarded) , I have tried switching the options.

ZenCart 1.3.9d
PHP Version: 5.2.6 (Zend: 2.2.0)
Database: MySQL 5.0.51a

Any ideas before I start to dig into the code?

Alan

This option should be what you're looking for:

Adjust Reward Points for Sales/Specials
How to calculate Reward Points
0= Always use the base price.
1= Use price less Discounts and Specials.

If you're still noticing this on the item info page, then a bit of coding needs to be changed indeed.

sailsport:

Hi,

Thanks for a great module. This thread is 168 pages long!.

I have had a look through and found a similar issue to mine (page 99) but could not see an answer, I may have missed it.

I have this set to 1 in admin - configuration - rewards points

"How to calculate Reward Points
0= Always use the base price.
1= Use price less Discounts and Specials."

But the rewards are granted on based price (i.e. item for 60, special / sale price 45, 60 points awarded) , I have tried switching the options.

ZenCart 1.3.9d
PHP Version: 5.2.6 (Zend: 2.2.0)
Database: MySQL 5.0.51a

Any ideas before I start to dig into the code?

Alan

What version are you using? The latest version is 1.40a and is available off of my website.

Thank I'll try 1.40, the version I got from the zen site 11 Oct was 1.32a

I am getting an access error on https://www.omnicia.com

"You don't have permission to access / on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

sailsport:

I am getting an access error on www.omnicia.com

"You don't have permission to access / on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

I'm able to access it fine?

sailsport:

I am getting an access error on https://www.omnicia.com

"You don't have permission to access / on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

Where are you trying to access from? Specifically your IP address (www.myipaddress.com)

Yes I can access you from my phone, (not much use!) so definitely my ip being blocked.

188-222-128-186.zone13.bethere.co.uk

188.222.128.186

It shouldn't be in any block lists for any reason I know of, let me know if you find out something I don't.

Alan

sailsport:

Yes I can access you from my phone, (not much use!) so definitely my ip being blocked.

188-222-128-186.zone13.bethere.co.uk

188.222.128.186

It shouldn't be in any block lists for any reason I know of, let me know if you find out something I don't.

Alan

Okay, try now.