Reward Point Mod beta now available

[NullMind]

question, we have a brick and mortar shop, people can come in and buy stuff and we tie it to their account via the EPOS .. but their order will end on a different category

will the points only be rewarded to orders on ONE category ? can we setup two ?

[fiji]

Andrew,

Thanks for your hard work

1. Global Redeem group is still not working from my test, does anyone else test it yet?
2. discounted/specials is fixed. It's working.

Regards

[hem]

hoo, I was about to buy Xrewards ... but now I think i'll wait for this one

When do you think it will be ready for a live store ?

Round about now, if no other problems show up and no-one thinks there's a show-stopper feature missing.

[hem]

Andrew,

Thanks for your hard work

1. Global Redeem group is still not working from my test, does anyone else test it yet?
2. discounted/specials is fixed. It's working.

Regards

Fiji- can you give me the steps and I try and recreate it- Also when you look at the customer list- Is the Redeem Ratio showing up against any customer with Group Pricing set to ---None---???

[gransazer]

Hi,

I just install this modules and found this error :

a. customer > reward points and the error shown
" 1054 Unknown column 'cp.pending_points' in 'field list'
in:
[UPDATE riz_reward_customer_points cp, riz_reward_point_history rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM riz_reward_point_history 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."

b. and when i click continue checkout button the error show

"1054 Unknown column 'redeem_ratio' in 'field list'
in:
[SELECT redeem_ratio FROM riz_reward_master prp, riz_customers as c, riz_group_pricing as gp WHERE c.customers_id=1 AND gp.group_id=c.customers_group_pricing AND ((prp.scope_id=1 AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;] "

so... anyone can help.

tq

[Berserker]

What is the Global Redeem group for? If I turn that to off, will people not be able to redeem against their purchases?

Also, am I able to award points from Admin now?

Thank you

[hem]

Hi,

I just install this modules and found this error :

a. customer > reward points and the error shown
" 1054 Unknown column 'cp.pending_points' in 'field list'
in:
[UPDATE riz_reward_customer_points cp, riz_reward_point_history rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM riz_reward_point_history 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."

b. and when i click continue checkout button the error show

"1054 Unknown column 'redeem_ratio' in 'field list'
in:
[SELECT redeem_ratio FROM riz_reward_master prp, riz_customers as c, riz_group_pricing as gp WHERE c.customers_id=1 AND gp.group_id=c.customers_group_pricing AND ((prp.scope_id=1 AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;] "

so... anyone can help.

tq

Which version did you download (it's in the readme.txt file).

[hem]

What is the Global Redeem group for? If I turn that to off, will people not be able to redeem against their purchases?

Also, am I able to award points from Admin now?

Thank you

The global redeem is the redeem value of all products that are not within Group Pricing. If you want a global switch off- set this to 0.

And yes, reward points in Admin is now available. Admin->Customers->Reward Points.

[gransazer]

Which version did you download (it's in the readme.txt file).

i think latest version (1.0.3b)

[hem]

i think latest version (1.0.3b)

Try copying and pasting the contents of the install.sql file to Admin->Tools->Install SQL Patches but skip the RENAME on the first line- That should sort the problem.