Zen Cart Logo
Forums / All Other Contributions/Addons / Reward Points Module for ZC v13x

Reward Points Module for ZC v13x

Locked

Views: 470,639

Results 1,941 to 1,960 of 2,476
This thread is locked. New replies are disabled.
11 Jan 2012, 7:07 PM
#1941
nullmind avatar

nullmind

Zen Follower

Join Date:
Jul 2007
Posts:
129
Plugin Contributions:
0

Reward Points Module for ZC v13x

Athens Collectibles:

The only reason I can think of is that you haven't probably copied all the files from the admin folder to the corresponding places in your own admin folder. Check carefully that each file is copied to the appropriate folder.

On the other hand, I'm doing an upgrade to Zen Cart 1.5.0 and the mod doesn't seem to work with it. Could this be your case?

The mod seems to be working with 1.5.0, but the admin links don't show, they did stop showing with 1.5.0, I upgraded to the latest mod version to see if it would fix, but does not

11 Jan 2012, 8:10 PM
#1942
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

NullMind:

The mod seems to be working with 1.5.0, but the admin links don't show, they did stop showing with 1.5.0, I upgraded to the latest mod version to see if it would fix, but does notYes, that's what I mean. The mod seems to be working but the Admin links don't show (except those in Modules > Order Total which they do)

12 Jan 2012, 11:34 AM
#1943
nullmind avatar

nullmind

Zen Follower

Join Date:
Jul 2007
Posts:
129
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Athens Collectibles:

Yes, that's what I mean. The mod seems to be working but the Admin links don't show (except those in Modules > Order Total which they do)

then yeah, same problem :(

22 Jan 2012, 3:37 PM
#1944
swamyg1 avatar

swamyg1

Zen Follower

Join Date:
Dec 2008
Location:
San Fran
Posts:
382
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

I love this mod, it works better than any other rewards mod, and has the most features.

However, I need to know if there any way to suppress the absolutely horrid loading times?

23 Jan 2012, 3:19 AM
#1945
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

NullMind:

The mod seems to be working with 1.5.0, but the admin links don't show, they did stop showing with 1.5.0, I upgraded to the latest mod version to see if it would fix, but does not

Athens Collectibles:

Yes, that's what I mean. The mod seems to be working but the Admin links don't show (except those in Modules > Order Total which they do)

I have the reward points links showing under catalog and customers in admin, but I'm still working on the sql statement under configuration. I'm trying to get it to show there. There are some files that need to be change to get this to show under admin. If you want to know which files you need to change and to get the sql statement to get the link to show under catalog and customers let me know and I will post it.

23 Jan 2012, 3:36 PM
#1946
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Reward Points Module for ZC v13x

countrycharm:

I have the reward points links showing under catalog and customers in admin, but I'm still working on the sql statement under configuration. I'm trying to get it to show there. There are some files that need to be change to get this to show under admin. If you want to know which files you need to change and to get the sql statement to get the link to show under catalog and customers let me know and I will post it.

Please if you get this working and you're able to repackage and update for Zen Cart 1.5.0 that would be great. This mod is use by a lot of stores and an updated version will help a lot of people.

Thanks!

23 Jan 2012, 5:08 PM
#1947
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

BlessIsaacola:

Please if you get this working and you're able to repackage and update for Zen Cart 1.5.0 that would be great. This mod is use by a lot of stores and an updated version will help a lot of people.

Thanks!
I have it all worked out and showing in admin except for the configuration part. That is controlled by the sql statement. I have been trying to get it sorted out but I may need some help for that part. Anyone who wants to take a stab at it let me know and I will send what I have done so far.

24 Jan 2012, 9:40 PM
#1948
siliconbug avatar

siliconbug

Zen Follower

Join Date:
Apr 2009
Posts:
125
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

sailsport:

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
Hi Alan,

Did you fix your problem? I have the same situation here with ZC 1.3.9h/RP 1.40a. :(

26 Jan 2012, 1:57 AM
#1949
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

countrycharm:

I have it all worked out and showing in admin except for the configuration part. That is controlled by the sql statement. I have been trying to get it sorted out but I may need some help for that part. Anyone who wants to take a stab at it let me know and I will send what I have done so far.
I have it all worked out and showing in admin and under the configuration. I will update the Module and the read me on how to do this sometime soon.

31 Jan 2012, 4:02 AM
#1950
cobraplant avatar

cobraplant

Zen Follower

Join Date:
Oct 2007
Posts:
101
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

I'm want to upgrade to ZC 1.5, but I'm stuck because of this mod. I noticed that the most recent version was uploaded on January 27. I was previously using Reward 1.26, so I used the used update.sql and uploaded the new files to my test site. I've triple-checked my uploads, and I still can't see the reward links in the control panel. The links show up in ADMIN > MODULES > ORDER TOTAL. As of yet, I don't see the links in the following areas:

ADMIN > CONFIGURATION
ADMIN > CUSTOMERS

The reward points are not showing up on the test site as well. This doesn't seem to be compatible with ZC 1.5 at this time. Does the SQL need further revisions? Or is there something else I need to modify?

31 Jan 2012, 4:22 AM
#1951
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Reward Points Module for ZC v13x

Soooo.. ummmm did you miss/skip the conversation about updating this mod JUST above your post?????

CobraPlant:

I'm want to upgrade to ZC 1.5, but I'm stuck because of this mod. I noticed that the most recent version was uploaded on January 27. I was previously using Reward 1.26, so I used the used update.sql and uploaded the new files to my test site. I've triple-checked my uploads, and I still can't see the reward links in the control panel. The links show up in ADMIN > MODULES > ORDER TOTAL. As of yet, I don't see the links in the following areas:

ADMIN > CONFIGURATION
ADMIN > CUSTOMERS

The reward points are not showing up on the test site as well. This doesn't seem to be compatible with ZC 1.5 at this time. Does the SQL need further revisions? Or is there something else I need to modify?

31 Jan 2012, 4:31 AM
#1952
cobraplant avatar

cobraplant

Zen Follower

Join Date:
Oct 2007
Posts:
101
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

countrycharm:

I have it all worked out and showing in admin and under the configuration. I will update the Module and the read me on how to do this sometime soon.

DivaVocals:

Soooo.. ummmm did you miss/skip the conversation about updating this mod JUST above your post?????

Yes, I read the previous posts. The post you're referring to by countrycharm was dated January 25. The mod was updated on January 27, as indicated in the download section. This is why I posted my question, and I did so with the utmost respect to the conversation. Am I missing something here?

31 Jan 2012, 4:55 AM
#1953
cobraplant avatar

cobraplant

Zen Follower

Join Date:
Oct 2007
Posts:
101
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Countrycharm, I have a question regarding the most recent mod update (January 27). When uploading the files to ADMIN, there is a zip file for sqlpatch. After unzipping the file, should the upload appear as ADMIN > SQLPATCH > SQLPATCH.PHP. OR should it appear as ADMIN > SQLPATCH.PHP?

I tried both, and I'm still not seeing the reward links in the control panel.

31 Jan 2012, 2:24 PM
#1954
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Reward Points Module for ZC v13x

CobraPlant:

Yes, I read the previous posts. The post you're referring to by countrycharm was dated January 25. The mod was updated on January 27, as indicated in the download section. This is why I posted my question, and I did so with the utmost respect to the conversation. Am I missing something here?
Ahhhhh my bad.. I missed the part in your post where you indicated you were working with the most recent version.. I think an update was submitted over the weekend to correct the SQL files.. Countrycharm will need to confirm this though..

31 Jan 2012, 2:51 PM
#1955
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

CobraPlant:

I'm want to upgrade to ZC 1.5, but I'm stuck because of this mod. I noticed that the most recent version was uploaded on January 27. I was previously using Reward 1.26, so I used the used update.sql and uploaded the new files to my test site. I've triple-checked my uploads, and I still can't see the reward links in the control panel. The links show up in ADMIN > MODULES > ORDER TOTAL. As of yet, I don't see the links in the following areas:

ADMIN > CONFIGURATION
ADMIN > CUSTOMERS

The reward points are not showing up on the test site as well. This doesn't seem to be compatible with ZC 1.5 at this time. Does the SQL need further revisions? Or is there something else I need to modify?

A new version has been submitted to the download area. Waiting on zen to approve it.

31 Jan 2012, 3:05 PM
#1956
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

This is the ReadMe.txt on how to install Reward Point on zen cart v1.5.0

!!!BACKUP!!! ALWAYS MAKE SURE YOU HAVE AN UP TO DATE BACKUP OF YOUR FILES and MySQL DATABASE BEFORE INSTALLING

!!!WARNING!!! YOU NEED AT LEAST MySQL VERSION 5.1 OR HIGHER TO RUN THIS MOD


  1. This Reward Points Module works fine, but if you have a TEST SERVER try it out before going live.
  2. The 4 files in admin/includes/boxes/extra_boxes/ is obsolete and should be deleted or rename to something else until you are confident all is well.
  3. Added a define to admin/includes/extra_datafiles/reward_points_filenames.php and to
    amin/includes/languages/english/extra_definitions/reward_points_definitions.php to make this work on zen cart 1.5.0. The define that was inserted is
    define('BOX_CONFIGURATION_REWARD_POINTS', 'Reward Point Configuration');//moved from _dhtml.php for 1.5
  4. Go into phpmyadmin and BACKUP THE DATABASE BEFORE INSTALLING.
  5. Ensure you have carried out step 4)!

INSTALL/UPDATE
RE-UPLOAD ALL FILES. Some files has change. If you are 'UPDATING FROM ZEN CART V1.3.8, ZEN V1.3.9 TO ZEN CART V1.5.0

  1. Unzip the zip file into your Zen Cart root folder

1.1 IMPORTANT!!! READ EVERYTHING.....

  1. Copy all the files in folders named 'custom' to your corresponding custom folders.

2.1 Copy the files from includes/languages/english/extra_definitions/custom to includes/languages/english/extra_definitions/YOUR_CUSTOM_FOLDER

2.2 Copy the files from includes/modules/sideboxes/custom to includes/modules/sideboxes/YOUR_CUSTOM_FOLDER

2.3 Copy the files from includes/templates/custom to includes/templates/YOUR_CUSTOM_FOLDER

  1. Run the appropriate sql file using Admin->Tools->Install SQL Patch

3.1 If you are installing this mod for the first time use 'new.sql' and all the menus will be installed for you.
If you are updating from zen cart v1.3.8 and zen cart v1.3.9 you will have to Register the Admin Page manually
to Register the configuration page to show on the menu for zen cart v1.5.0. 'See Below'

3.2 If you use table prefixes in ZenCart you will need to manually rename 2 Reward Point Mod tables:

3.2.1.1 Rename 'yourprefix_reward_product_points' to 'yourprefix_reward_master'

3.2.1.2 Rename 'yourprefix_reward_point_history' to 'yourprefix_reward_status_track'

  1. Switch on the 'Shopping Cart with Rewards' sidebox using Admin->Tools->Layout Box Controller

4.1. There is also a "Reward Points" sidebox which displays points in cart and points earned (if logged in)

  1. Install the Reward Point Order Total module using Admin->Modules->Order Total

5.1. There is also a "Reward Points earned" module which displays the points earned at checkout

  1. You can edit Global/Category/Product reward points using Admin->Catalog->Reward Points

  2. You can change the Reward Point configurations using Admin->Configuration->Reward Points

  3. You can set global and group Reward Point redeem ratios using Admin->Customer->Group Reward Redeem

  4. You can set and change earned and pending points for each customer using Admin->Customer->Reward Points

SKIP NUMBER 10 IF YOUR MENU INSTALLED............................................................................

  1. If your configuration menu doesn't show in Admin after installing the new.sql statement you will have to install it manually.

10.1 After you install the SQL Patch Go to your phpMyAdmin Database, click on your database name to the right. At the top
click search when you come to that page enter Reward Points in the search box, tick all words, scroll down to
configuration_group and click go, click Browse, when you come to the configuration_group page look and get the configuration_group_id
number for the next step.

10.2 Log in to your store Admin go to Admin->Admin Access Management->Admin Page Registration
to Register the configuration page to show on the menu.
Copy and Paste
Page Key = configRewardPoints
Page Name = BOX_CONFIGURATION_REWARD_POINTS
Page Filename = FILENAME_CONFIGURATION
Page Parameters = gID=32 Replace the number with your phpMyAdmin Database configuration_group_id number.
Menu = Configuration
Display on Menu? = tick box for yes
Sort Order = the higher the number the lower it will display in the menu.

Run this sql statement below in your store Admin->Tools->Install SQL Patch to display the menu in
Admin->Catalog->Reward Points
Admin->Configuration->Reward Points
Admin->Customer->Group Reward Redeem

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('GroupRewardRedeem', 'BOX_GROUP_REWARD_POINTS_REDEEM', 'FILENAME_ADMIN_GROUP_REWARD_POINTS_REDEEM', '', 'customers', 'Y', 35);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('RewardPoints', 'BOX_REWARD_POINTS', 'FILENAME_ADMIN_REWARD_POINTS', '', 'catalog', 'Y', 36);
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('CustomerRewardPoints', 'BOX_CUSTOMER_REWARD_POINTS', 'FILENAME_ADMIN_CUSTOMER_REWARD_POINTS', '', 'customers', 'Y', 37);


Quick run through on how it works.

The Point Ratio is the number of reward points you award per unit of base price.
So a Point Ratio of 1 will award 10 reward points for every $10, €10, £10 etc spent.
The currency used is decided by how the prices are stored for the products.
The Global Point Ratio is used for every product, unless overwritten by a Category Point Ratio (if set).
The Category Point Ratio is overwritten by a Product Point Ratio (if set).

If you install the Reward Points Order Total Module you can also set a Redeem Ratio. This is set to 0.01
as default so each point redeemed is worth 1 cent/pence.

The Global Reward Point Redeem setting is found under Customers->Group Reward Redeem

From 1.20a: admin can set a Mode configuration item to select whether points are rewarded by product or are
rewarded by order (sub)total.

From 1.27a: admin can fine tune how points are awarded or redeemed against based against other Order Total modules
such as Group Pricing and Gift Vouchers.


Version History:
2.1
Resolved issue with Reward Points not installing on
zen cart version 1.5.0
The 4 files in admin/includes/boxes/extra_boxes/ is obsolete
Added a difine in admin/includes/extra_datafiles/reward_points_filenames.php
Added a define in admin/includes/languages/english/extra_definitions/reward_points_definitions.php
Updated admin/customers_reward_points.php
Updated admin/group_reward_points.php
Updated admin/reward_points.php

5 Feb 2012, 7:24 PM
#1957
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

**Just wanted to let everyone know that Reward Points is now compatible with zen cart version 1.5.0. Reward Points will still run on zen cart versions v1.3.8, v1.3.9. May also work with earlier versions. Reward Points does not overwrite any core files.

**========================================================

UPGRADING INSTALLATION FOR V1.5.0:

  1. This Reward Points Module works fine, but if you have a TEST SERVER try it out before going live.

  2. The 4 files in admin/includes/boxes/extra_boxes/ is obsolete and should be deleted or rename to something else until you are confident all is well. admin/includes/boxes is obsolete in v1.5.0 as well.

  3. Added a define to admin/includes/extra_datafiles/reward_points_filenames.php and to
    amin/includes/languages/english/extra_definitions/reward_points_definitions.php to make this work on zen cart 1.5.0. The define that was added is
    define('BOX_CONFIGURATION_REWARD_POINTS', 'Reward Point Configuration');//moved from _dhtml.php for 1.5

  4. Go into phpmyadmin and BACKUP THE DATABASE BEFORE INSTALLING.

5) Ensure you have carried out step 4)!

NEW INSTALLS

  1. Upload all files in the zen_1.5.0 folder.

  2. Run the included Reward Points newl.sql using the Zen-Cart Sql Patches tool
    (admin -> tools -> install sql patches) for New Installs

Enjoy.....

5 Feb 2012, 11:23 PM
#1958
tnjon avatar

tnjon

New Zenner

Join Date:
Apr 2006
Posts:
67
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

The requested URL /xxxx/xxxxx/ADMIN_FILENAME_REWARD_POINTS.php was not found on this server.
When trying to change Categories/Product Display Order:
keep getting this on a fresh 1.5.0 but it is there.

6 Feb 2012, 5:31 AM
#1959
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

Re: Reward Points Module for ZC v13x

tnjon:

The requested URL /xxxx/xxxxx/ADMIN_FILENAME_REWARD_POINTS.php was not found on this server.
When trying to change Categories/Product Display Order:
keep getting this on a fresh 1.5.0 but it is there.

Thank You for bring this up. The issue has been fixed. A new update has been submitted in the downloads area. You can download it from here until zen cart has approve it. Make sure you upload all admin files again. This should fix the problem.

6 Feb 2012, 11:57 AM
#1960
tnjon avatar

tnjon

New Zenner

Join Date:
Apr 2006
Posts:
67
Plugin Contributions:
0

Re: Reward Points Module for ZC v13x

Works great thank you very much.