Reward Points Module for ZC v13x

noppie:

thank you so much.. duh.. No I reaLLY FEEL STUPID.
THANK YOU SO MUCH.

Your very welcome glad to help...

Because issue when change status when click "detail" it's not move the points to earn ( i have super order mod ) . just if i edit the order move the points to earn . i see that only now after 300 orders .

how can now move all 1 time all customers points from pending to earn ?

thank you.

dmagic:

Because issue when change status when click "detail" it's not move the points to earn ( i have super order mod ) . just if i edit the order move the points to earn . i see that only now after 300 orders .

how can now move all 1 time all customers points from pending to earn ?

thank you.

You would need to make some kind of SQL statement to reflect this. Is this for all orders before a certain date or specific orders in general?

Ok i really like this module. I just have a few questions i need help with. I am testing this module with a POS module but any purchases made through the POS doesn't add any of my reward points. If a purchase is made through the website, these purchases doesn't show on the POS customer History, but everything shows under the customer purchase history. My question...is there a way i can combine the POS with the Rewards? I want to allow rewards to be sent to customers accounts if they make a online purchase or if a pos purchase is done (store).

islandboii242:

Ok i really like this module. I just have a few questions i need help with. I am testing this module with a POS module but any purchases made through the POS doesn't add any of my reward points. If a purchase is made through the website, these purchases doesn't show on the POS customer History, but everything shows under the customer purchase history. My question...is there a way i can combine the POS with the Rewards? I want to allow rewards to be sent to customers accounts if they make a online purchase or if a pos purchase is done (store).

This will require modification of the module that is adding the order in the backend. This is because when your module (in the admin backpanel) runs, it is not triggering normal order total mods like reward points since there is no call to it. You would have to modify that module to call the necessary parts of reward points suite and run as normal. Which POS module is this?

ZenCart POS by Magnetic One

I spoke to them and they told me there is a database table that the pos is using, but their entire module code is encrypted.

Is there a solution that allows reward points to be added to an account if i installed a POS Module into Zencart?

Hi everyone,
this thread is sooo long :blink:
Anyways, does someone know (or can someone point me to the right direction?) how to show the amount of the reward points instead of the points itself?

For example, I want to show '$5 Earned' instead of '500 points earned' (as 500 points are worth $5). Any help would be appreciated. Thank you :) photo attached below

Can anyone assist me with converting a order total that was completed by a POS module into Reward Points? For example, i place a order to a customer account in the POS Module, the order goes through but no points gets transferred. If i place an order through that customer account to the store front end, reward points is then added. Can anyone assist me with creating a tweak or code that allows me to turn POS Orders into Reward Points...perhaps using a click button and some php calculation codes?

Please help me.. :(

I installed the Rewards Point module, and it works fine but does not issue the correct amount of point when using Quantity Discounts. It still give the points of a single price. Example:

qty 1 @ $8.58 = 9 reward points
qty 10 @ 7.03 gives 90 reward points which should be only 70 reward points awarded

How can i combine Reward Points Module with Edit Orders Module?

islandboii242:

How can i combine Reward Points Module with Edit Orders Module?

Reward Points already work with Edit Orders. The only thing is when looking or editing a order reward points does not show. The reward points changes from pending to earn when a order status is change. The reward point will show on the invoice and order emails.

The reason the reward points in admin/customers/orders/edit order will not show is because, the reward points is different with the total of,
100 points = $1 so the reward points can not save the points value in database so you see it's 0.00

Check the orders_totals table and you will understand whats going on.

I know it is hard to understand but that's the best I can explain it.

Did anyone get any other additional modules to work with Reward Points? I have tried Edit Orders just by itself and i am having trouble with this. Can anyone explain to me how can i get a third party module that is used to "Place Orders" to be recognized by Reward Points Module? Does RPM pulls orders from the database? Can i make adjustments to RPM to calculate points from the third party module? If i installed Admin New Order..will placing an order then be recognized by RPM?

I don't think most would want it to issue additional points every time you edit an order. If you add to an order why don't you just add additional points? You shouldn't be adding to that many orders. If you are there is something wrong. I run a pizza delivery company off Zen-cart and out of approximately 75 orders a day we may only change 1 or 2 orders max.

Hello Everyone, Just wanted to suggest an improvement and let everyone know how to fix an issue.

The Problem:
You have a lot of orders and a lot of customers using the system and one day you get a 500 error trying to log into your admin system.

Why is this happening?!:
After a couple hours of trying to figure out which script was the problem I found it was the update mechanism in the store/admin/includes/extra_functions/reward_points_functions.php file. The query that updates the points was taking ~a minute to execute. Whew - I found the problem.

Great now how do I fix it?:
Simple actually. Add an index to the reward_status_track table. My table prefix is zen_ so your query may differ - here's mine
ALTER TABLE zen_reward_status_track ADD INDEX ( customers_id )

Now the query takes ~.003 seconds - Hooray!

Thanks again for this awesome zen cart add on and I hope my frustrations help someone else avoid a trip down the rabbit hole to debug this.

bryan22:

Hello Everyone, Just wanted to suggest an improvement and let everyone know how to fix an issue.

The Problem:
You have a lot of orders and a lot of customers using the system and one day you get a 500 error trying to log into your admin system.

Why is this happening?!:
After a couple hours of trying to figure out which script was the problem I found it was the update mechanism in the store/admin/includes/extra_functions/reward_points_functions.php file. The query that updates the points was taking ~a minute to execute. Whew - I found the problem.

Great now how do I fix it?:
Simple actually. Add an index to the reward_status_track table. My table prefix is zen_ so your query may differ - here's mine
ALTER TABLE zen_reward_status_track ADD INDEX ( customers_id )

Now the query takes ~.003 seconds - Hooray!

Thanks again for this awesome zen cart add on and I hope my frustrations help someone else avoid a trip down the rabbit hole to debug this.

Thank you for your fixed. Maybe it will be useful to some who are having trouble.

Hi, everyone, got some question here,

1. how to not allow given reward point out when customer use the in their account point to pay the order? Example, if customer have 10 dollar value reward point, and he make a 30 dollar order, after use the points he pay the rest 20 dollar for his new order. the new purchase 20 dollar will have reward, but not the 10 dollar he use the point to pay. Can we make a setting like that?

2. any function allow customer control how many points he can choose to use for each order?

Thanks for this great module and your help

I figure out question 2 is in> Order Total Modules, but still cannot find anything on question, please help.

Thanks,

ok, ....I test the mod carefully, all function I need is already there! thx

Hello,

Great module but have 2 issues:

1: looks like the module didn't load up correctly. Shouldn't it be written "Reward Point" instead of PRODUCT_REWARD_POINT_TAG on each product reward title?
Did 2 clean install, yet with the same issue. Don't mind to edit it manually if someone can tell me which file pls.

#point PRODUCT_REWARD_POINT_TAG (underneath each product title) :lookaroun

2: when an order is made, Reward point are set to zero on the admin order page, however, when I load the invoice, rewards appear as well as in the reward pending/earned page. Missing something?

all files have been uploaded correctly to my FTP even twice.

All comments appreciated

Thanks,

Dan