Reward Points Module for ZC v13x

[LisaVB]

Is there a table or something to set my rewards?

I want to allow 1 point per ever dollar spent
I want each point to be worth ten cents ($.10)

Where do I set this up? Or what settings to I need to find to set them up.

[sai1983]

As LisaVB. I too want to reward point per dollar. 1dollar=1point. I want to generate a gift card for 500points. Once gift card is generated, points should be deducted and customer has to come in person to store to collect the gift. He/She brings his GiftCardId or printed gift card. So that admin can logs into admin panel and checks the gift card Id and give customer a gift.

[Sailman]

PHP People - I need some help. I have Reward Points 140 installed. On the checkout_payment page, it displays in a DIV:

Reward Points-
You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after you click continue.

Current Reward Points:582 points earned ($582.00)

Value of Redeemed Reward Points:$194.00 (194)
Redeem Reward Points:

I need to remove the display of the value of the points ($582.00) in the top line, and the "Value of Redeemed Reward Points:$194.00 " line completely as well as the "Redeem Reward Points:" line with either the checkbox or the field completely.

All redeeming of points will be done a different way. I don't care about the math of points valuing, as long as it is hidden. I need to either remove ALL the lines except Current Reward Points (without the value) or remove this DIV entirely from the Checkout_payment page. When I try to comment out parts of ot_reward_points.php, it crashes the checkout process.

Any guidance would be appreciated.

[ardhill]

Is there a table or something to set my rewards?

I want to allow 1 point per ever dollar spent
I want each point to be worth ten cents ($.10)

Where do I set this up? Or what settings to I need to find to set them up.

Go to your Zen Cart Admin then
Catalog menu
Reward Points
and set the "Global Reward Point Ratio" to 10.0000

That should give you 10% of every dollar spent as Reward Points and 1 point = 1 cent. So for every dollar spent, the customer should get 10 Reward Points / 10 cents in value.

This should give the same same value you want, and is the way I use it.

If you really want each point to equal 10c then someone else may be able to help.

Paul

[ardhill]

I want to generate a gift card for 500points...

Not sure if this mod can do that.

Personally I would probably look at using Zen Cart's own Gift Voucher mod that comes with the cart.

[Sailman]

I need all Reward Points to be posted automatically as Earned, without having order status changes, etc.
We will redeem the points off-line in a different manner. Using the Advanced/Order Status in the Admin doesn't change anything. All points still go to Pending and I must manually change them to Earned in Admin/Customers/Reward Points.

I have messed with some of the functions, but only succeeded in crashing it. Is there a place where a few lines of code will put all points in the cart automatically to Earned?

[Kezza]

any word on the edit orders working with rewards points?

[cooki01]

First of all... MERRY CHRISTMAS EVERYONE!!
this is the first time I have posted. I think I have the right forum... I apologise if it is not.
I am using Reward Point full suite 1.33a

All database tables have prefix zen_<tablename>
I have a number of other mods installed - but this is the first one to generated the level of issues I have encountered.
Modifications I made to the Original install readme instructions:

1. modified CUSTOM folder name to "tvzen_jellyfish" in line with the template I am using.
2. Changed table creation and table referances in new.sql to have "zen_" prefix "zen_configuration", "zen_configuration_group" and the three reward tables, master, customer points & status track eg "zen_reward_master"
3. Modified 2 files "reward_points_filenames.php" located in "zc_admin\includes\extra_datafiles" and "includes\extra_datafiles" - Lines 6-9 added "zen_" to the table names after "DB_PREFIX ." eg "define('TABLE_REWARD_MASTER', DB_PREFIX . 'zen_reward_master');"

Outcome:

1. Configuration -> Reward Points works!
2. Customers -> Reward Points throws an error
   
   1142 SELECT command denied to user 'admin_zc1'@'localhost' for table 'reward_customer_points'
   in:
   [UPDATE zen_zen.reward_customer_points cp, zen_zen.reward_status_track rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM zen_zen.reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
3. Customers -> Group Reward Redeem throws an error
   
   1142 SELECT command denied to user 'admin_zc1'@'localhost' for table 'reward_master'
   in:
   [SELECT * FROM zen_zen.reward_master WHERE scope='0' AND scope_id='0';]
   If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
   The Group reward redeem error occurs within the ZEN Cart Admin construct, while the Reward Point error is a completely formless whitescreen within the browser.

The thing I find strange about the errors is the reference to zen_zen.reward_master.
The database name is not zen_zen, it is similar to database_zc and I don't know where it is getting this from. Plus... it is not referring to to the prefix => zen_reward_master... I think this may be from DB_PREFIX (but I don't know where this is defined.)
If anyone can offer some words of assistance... I would be most apprecaitive!!

[cooki01]

Oh my!!
I found it!!
Developers ToolKit showed me where DB_PREFIX was defined!! yay!
Then I realised that the files "reward_points_filenames.php" should not have been edited at all!!
My frustration is over! :) yay!

[hem]

any word on the edit orders working with rewards points?

It works with the latest version but I don't know if that has been released yet.