Reward Point Mod beta now available

Fields

rewards_products_id: General unique record identifier.

scope: Can be '0' for Global (all products), '1' for 'Category' or '2' for 'Product'.

scope_id: If scope is set to Category or Product then this contains the categories_id or products_id of the record it relates to. It is set to 0 for Global.

point_ratio: The ratio of reward points to base price. If you had a product costing €15 and the ratio was set to 1 then you will recieve 15 reward points. If the ratio is set to 2 then you would get 30 reward points. If it was 0.5 then you would get 8 reward points (7.5 rounded up). The calculation is: reward_points=products_price * reward_point_ratio.

bonus_points: For future development.

Indexes:

PRIMARY KEY ( rewards_products_id ) : The primary index.

UNIQUE unique_id ( scope , scope_id ): Only one record of a specific scope/scope_id is allowed to exist.

The system works on a fallback basis. If a product has a corresponding reward point record (that is the scope is '2' and the scope_id==product_id) then that records ratio is used. Otherwise if the category has a corresponding record (scope='1' and scope_id=category_id) then that ratio gets used. Otherwise the Global (default) ratio is used.

yellow1912:

hem, Im working my way thru yours and numinix's code, make progress bit by bit, for instances:

1. I think it's better to name the mod "store credit", since owners can just assign customers additional store credit for refund-etc.... (which is also a nice feature later, refund go to store credit instead of cash/cc/....)

This is why I think my mod and Numinix's are different. I'm writing a Reward Point mod and Numinix is writing a Store Credit mod. True there is some overlap but I think at the end of the day there is enough differences to make them two separate entities.

At the end of the day, we want to use a single table to store the credit, which can be applied using a single field. That's why I think it's appropriate to merge the 2

yellow1912:

Also, a product can belong to multiple categories, which cat will be used to calculate ratio? Master cat?

I have it set to work in the customers favour a select the ratio which returns the best ratio at the moment. This may be subject to change.

yellow1912:

At the end of the day, we want to use a single table to store the credit, which can be applied using a single field. That's why I think it's appropriate to merge the 2

That's fine. The way I see it:

Me: Reward Point Mod.
Numinix: Store Credit Mod.
You: The Hybrid Mod

:bigups:

Update:

New version now available:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_id=911

Anxious to implement a Rewards-type program, I've been watching the progression of these three modules. However, none of them are exactly what I was thinking of. In short, I'd like to offer an annual paid club membership that gives a 10% discount on everything they buy. Is there already a module in existence that would do this for me?

Thanks!

MeltDown:

Anxious to implement a Rewards-type program, I've been watching the progression of these three modules. However, none of them are exactly what I was thinking of. In short, I'd like to offer an annual paid club membership that gives a 10% discount on everything they buy. Is there already a module in existence that would do this for me?

Thanks!

Have u checked the group discounts mod which is part of Zen Cart out of the box? You could create a certain group and set it up for 10% discount, then move any members you want into that group. Whenever they buy anything, anyone in that group would get 10% off automatically. Only draw back I can see is, there is no way (I know of) to set certain items off limits to the discount, such as items that are already on sale.

OsC has a mod that does what your looking for and more (Separate Pricing Per Customer), too bad it couldn't get ported over to zen cart.

pinetreecandles:

Have u checked the group discounts mod which is part of Zen Cart out of the box? You could create a certain group and set it up for 10% discount, then move any members you want into that group. Whenever they buy anything, anyone in that group would get 10% off automatically. Only draw back I can see is, there is no way (I know of) to set certain items off limits to the discount, such as items that are already on sale.

OsC has a mod that does what your looking for and more (Separate Pricing Per Customer), too bad it couldn't get ported over to zen cart.

I don't want to take over this thread but what do you mean by the group discounts mod? I've used the quantity discounts that is native to Zen but that is a by-the-item module. Can you point me in the right direction to find out more about group discounts? It sounds like it might be just the ticket. Especially since I just found a slick little mod called Shopping Cart Original Price that shows the original item price on the shopping cart page for items that have been discounted. With that the club member can watch as the discounts pile up. The more you spend, the more you save! :P

Sorry - My bad! I've just located the Group Discounts in admin/modules/order total. I'll install it and give it a whirl. (Although I don't quite see how to implement it once installed...Hmmm - Anyway, I'll give it a try)

Thanks for the tip!

Andrew,
Thanks for the mod :clap: I downloaded, but haven't installed yet. I was looking at the screenshots you included and on the pic of the checkout It looks like some of the reward points were redeemed AND they also earned points for that purchase.

Say someone buys an item that is 10.00 and they have 10.00 in reward points. They could use those points to pay the total AND earn reward points for that purchase. That is great for the customer, but that could become a nightmare for the owner.

Does it allow you to earn points off purchases made with points? If so do you think a future version could make that an option to be set from admin. Some thing like 'Let users earn points with redeemed points" Yes or No

Just my two cents :cool:

Thanks for the feedback. Right now points earned during a purchase are "Pending" until the orders status chances from 'Pending'. So you cannot redeem points against an order that you have just earnt.

But you are right- an option in Admin to disallow earned points from an order that has been redeemed against is a good idea. The other thing I need to think about is a similar Admin option to allow points earned against free items.

But hey, it's a work in progress. I hoping with feedback (such as yours) to craft something that everyone can use.

Hi Andrew-

Installed the mod today and did some testing. After I added an item to the shopping cart and clicked the "Go to checkout" button the following error popped up: ```
Fatal error: Call to undefined method ot_reward_points::get_order_total() in /home/xxxxxxxx/public_html/store/includes/classes/order_total.php on line 181

I went over the install a couple times and I don't think I missed anything.  The only place I had any trouble was Order.php. Mine has been modified a couple times already and I used a compare program, but your file varied greatly from mine.  I actually only found two things I knew had to be added.  I don't know if that has anything to do with the error or not, but thought I would mention it.

Also when I set a global ratio in admin >>catalog>>Reward Points and click update it populates the fields with what I put in, but if I leave that page and come back, the fields are empty again.  The correct amount of points are showing on the customers end when viewing the Rewards Points sidebox for items in the cart.

About all the info I can give you.  Any ideas as to what may be causing the error?

Update:  The error comes up when the checkout_payment page loads.

Hi PineTree- is this with the latest version??? (v1.00)

yes, 1.00a

I forgot to mention that under admin>>Modules>>Order Total there are two entries; Reward points and reward points earned. Im able to configure the Reward Points, but I can't do anything with the Reward Points earned(ot_reward_points_display). when I clicked on it, to set it up, it shows the Remove and Edit buttons. If you click on the edit button, two blank fields show up and there is no other info in the box. Is it supposed to be like that or is somethig missing?

pinetreecandles:

I forgot to mention that under admin>>Modules>>Order Total there are two entries; Reward points and reward points earned. Im able to configure the Reward Points, but I can't do anything with the Reward Points earned(ot_reward_points_display). when I clicked on it, to set it up, it shows the Remove and Edit buttons. If you click on the edit button, two blank fields show up and there is no other info in the box. Is it supposed to be like that or is somethig missing?

Sorry for multiple posts...edit button is only for 7 minutes :censored:

After looking at the (ot_reward_points_display.php) it looks like the info is not getting inserted. It looks like it should have a sort order of 1000 and there is no sort order that is showing. Also the status light next to it stays red and no way to turn it green.

After looking at the (ot_reward_points_display.php) it looks like the info is not getting inserted. It looks like it should have a sort order of 1000 and there is no sort order that is showing. Also the status light next to it stays red and no way to turn it green.

Last post for now, I promise:blush:

Ok I fixed the above problem in the Orders Total area. Although I did this before and it made no difference, I uninstalled the mods and then reinstalled them again and it worked this time.

Still the remaining problem of the error on the Checkout Payment page.

Had a look at the order_total.php under includes\classes- First off, it's one of the core files and this mod does not change or replace it. I looked at line 181 as per your message and it's a comment line. A further check for calls on a get_order_total function yielded no results either. Then I realised that my test platform was running 1.3.7. So a quick update later and I'm just going through the test procedure on v1.3.8a- I'll get a new version up shortly.

Thanks for the feedback.

I have a reward point on my site that I got from XModule. The problem is that when the person uses Paypal it won't give them their points because they go off the site to pay.
So my question is if the person pays with Paypal will they get their points? This has become a real issue with customers not receiving their points.