Reward Points Module for ZC v13x

nolsowski:

:oops: I have no idea what I did but now on my product description page I get this error.

146 Table 'fromprop_zc1.zen_reward_master' doesn't exist
in:
[SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='2574' AND p2c.products_id='2574' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]

and now my Rewards Point Page says it doesn't exist. Here is my site in case you need it http://www.frompropertorocker.com

Thanks!

Okay I got the page to show up. I just re added rewards points page mod again. Now working on the error lol

nolsowski:

:oops: I have no idea what I did but now on my product description page I get this error.

146 Table 'fromprop_zc1.zen_reward_master' doesn't exist
in:
[SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='2574' AND p2c.products_id='2574' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]

and now my Rewards Point Page says it doesn't exist. Here is my site in case you need it http://www.frompropertorocker.com

Thanks!

Okay I got that error off too. I just re added the module again and now it works. :clap:

Alright I lied. I thought I had everything fixed but now in my admin area under Catalog-Reward Points I get this error

1146 Table 'fromprop_zc1.zen_reward_master' doesn't exist
in:
[SELECT * FROM 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.

I re added everything to make sure I didn't miss a file but I still get this message.

I also get this message when I go to Customers-Reward Points

1146 Table 'fromprop_zc1.zen_reward_customer_points' doesn't exist
in:
[UPDATE zen_reward_customer_points cp, zen_reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL((SELECT SUM(rp.reward_points) FROM 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.

These ones I am completely stumped on.

These ones I am completely stumped on
Unfortunately, I'm not the author of the mod so I'm as stumped on as you. However, it doesn't seem to be something difficult to fix with the help of someone who knows sql and can probably guide you to clear corrupt entries and run the sql file again. Good luck :yes:

Athens Collectibles:

Unfortunately, I'm not the author of the mod so I'm as stumped on as you. However, it doesn't seem to be something difficult to fix with the help of someone who knows sql and can probably guide you to clear corrupt entries and run the sql file again. Good luck :yes:

Thanks! Is there a way to completely unistall it? I tried to run the unistall.sql but I just got this error lol

1146 Table 'fromprop_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
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.

Maybe if I just delete all the files out of my server it will go back to normal?

Nevermind lol. I got it. I added the new install.sql and it works now. I think I am going to stop messing with this for a while lol. Thanks for your help. :)

Glad that you sorted it out. Well done! :D

The product pages display "0 reward points". I suppose it's because you haven't configured the mod yet.

The link to your Reward Page works fine, you just have to define the page contents now. It's a long task but think of me who had to do it in two languages!

Athens Collectibles:

Glad that you sorted it out. Well done! :D

The product pages display "0 reward points". I suppose it's because you haven't configured the mod yet.

The link to your Reward Page works fine, you just have to define the page contents now. It's a long task but think of me who had to do it in two languages!

Thank you!:D

Yeah I haven't figured out how I want them set yet lol. I got a headache from just trying to fix what I screwed up and I think I will wait until tomorrow to figure out how I want everything else.

Hi

Is there somewhere an explanation on how to export OScommerce customers rewards points to Zencart rewards points?

thanks

pat
:lookaroun

wirefram:

Hi

Is there somewhere an explanation on how to export OScommerce customers rewards points to Zencart rewards points?

thanks

pat
:lookaroun

Yes but it will be difficult as I have tried it LOL. I have over 5K customers and have to do each one manually, UGH!

You MAY ask skipwaters here on the board.

doing it by hand is not an option, this is best way to make errors, what is really confusing to me is the field "rewards_points" in both table rewards_customers_points and reward_status_track.

looks like reward_status_track = customers_points_pending (osc)

but in OSC there is only one field customers_points (i assume it becomes rewards_points in Zen) not 2 like in Zencart....

did you figure this out?

:censored:

There are some things best done by hand. :)

Hi

I am lost trying to configure the points value:

I want 200 points = 20 euros and i always end up with

200 points = 2 euros

i have try to modify everything related to points but can't get it to work...

What should i do?

Thanks
:unsure:

In Customers > Group Reward Redeem > Enter global points ratio, change the value in the box from 0.0100 to 0.1000 and this should do what you want (I hope) :unsure:

How do I know what the points value at? I am really lost when it comes to that part lol.

How do I know what the points value at?
It depends on your settings. Go to Catalog > Reward Points and look at the box ot the top right corner. If it says "Set Global Reward Point ratio: 5.0000", then it's 5% of the product value. You may change that with the Edit button below.

In any case, create a test customer and place a test order. then go to Customers > Reward Points and see if the points are earned or pending. If they are pending, edit the customer and move the points to earned.

Next, place another test order for this customer. When you go to checkout, you will see the value of earned points in money and you will be asked how many of them you want to redeem. Whatever number of points you select will be converted to cash and will be deducted in the next screen.

It's not difficult. If you place various test orders and play around, you will get used to how it works.

Athens Collectibles:

It depends on your settings. Go to Catalog > Reward Points and look at the box ot the top right corner. If it says "Set Global Reward Point ratio: 5.0000", then it's 5% of the product value. You may change that with the Edit button below.

In any case, create a test customer and place a test order. then go to Customers > Reward Points and see if the points are earned or pending. If they are pending, edit the customer and move the points to earned.

Next, place another test order for this customer. When you go to checkout, you will see the value of earned points in money and you will be asked how many of them you want to redeem. Whatever number of points you select will be converted to cash and will be deducted in the next screen.

It's not difficult. If you place various test orders and play around, you will get used to how it works.

Okay thanks! What if I want it to be 0.5000. What would that equal out to be?

Okay I think I got it. I have mine set to 0.5000 and I have 512 points in my account and it says the value is $5.12.

I seen this on someones site "Reward Points are redeemed at a value of $0.01 for every point. This means that 1000 points are worth $5.00 towards a purchase." How would I word this to fit what I have above?

Thanks!

Don't confuse the number of points awarded per $ spent with their value when redeemed.

Your 512 points valued at $5.12 means that each point is worth $0.01 but the statement "Reward Points are redeemed at a value of $0.01 for every point. This means that 1000 points are worth $5.00 towards a purchase" is wrong because, if points are redeemed at $0.01 as stated, then the 1000 points are worth 1000 x $0.01 = $10.00 (not $5.00).

Athens Collectibles:

Don't confuse the number of points awarded per $ spent with their value when redeemed.

Your 512 points valued at $5.12 means that each point is worth $0.01 but the statement "Reward Points are redeemed at a value of $0.01 for every point. This means that 1000 points are worth $5.00 towards a purchase" is wrong because, if points are redeemed at $0.01 as stated, then the 1000 points are worth 1000 x $0.01 = $10.00 (not $5.00).

Gotcha thanks! :D