Points System For Zencart

Has somebody now this contrib. Please add me!

Thanks a lot. :clap:

Lissy

Cant wait until this contrib would be ready ... was tryin to update some older and older version but there was still some problems with anything ...

if this contrib would come it would be very very great :)

Hi

Any news on this yet? Do we have a download???

Hi. Please add me to the list. Am VERY interested in this too! Would love updates or a pm when this is ready! Thanks!!!!!!!!!!!:clap:

Just throwing my hat in the ring, as well. Looks like it could be quite the popular add-on!

me to, I'm very interested in this, any work being currently done ? thanks..

Did this ever appear??? Is anyone working on it???

I ask because if no-one else is doing it I'm prepared to give it a go- I'm on holiday from the end of this week till the 3rd of January so I'll have a bit of spare time.

Yeah, this would definitely be a good way of selling up to users.

For maximum effect it probably also needs to be linked in to the newsletters, so that previous customers can be remined of their potential discounts.

Any mod would need things like multiple points special days.

And really this needs to be integrated into the shopping cart so that customers know how many points they will earn at the point of purchase.

The points should only be added to the user's account after payment has been confirmed to prevent scamming.

It sounds like a lot of work to do this properly; traking the points is probably faily easy, but utilising them as a sales tool is the hard part.

Maybe the idea would be to create a core mod on which we can build other modifications...

Yeah, that is what I was thinking. The first thing to do is to write a mod which allows customers to accumulate points at the point of purchase, after the transaction has completed.

If this was accompanied by a rewards points php class that offered easy access to these points (ie, points per item, customers points, etc..) then it would make it fairly straightforward to integrate this into various parts of the site.

This almost needs to be part of the core implementation, the more I think about it the more I realise what a headache it would be.

How can we help to make this module work?

I don't think it would be that difficult. The Notifier system would make a lot of the coding non-intrusive to the core. Right now I think that all that needs to be done to get the basics up and running would be:

1. Create 2 new tables- Product Reward Points and Customer Reward Points.

2. Add capability to Admin->Products to add/amend the points awarded per product. Also whether this product can be redeemed against using the points and how many points that would cost.

3. Change the 'zen_get_products_display_price' function to also show points per product. This would be a lot easier than having to code in a points display into every custom page that displays the price.

4. Create a new order_total module to display number of points rewarded.

5. Add a notifier to update the customer reward table when the transaction is successful.

And that would be phase 1. Phase 2 is the more interesting- Redeeming the points against purchases.

I think it is maybe usefull to use the Rewards Points Module_1.zip from osCommerce and translate this one to ZenCart.

I attached the Rewards Points Module_1.zip

Attention: THIS WON'T WORK IN ZENCART, MUST BE TRANSLATED

Interesting- that mod works by points per $ spent rather than setting points per product. However it looks like it falls over if you change to a different currency (you get more/less points depending on whether the other currency is weaker/stronger that the dollar).

hem:

I don't think it would be that difficult. The Notifier system would make a lot of the coding non-intrusive to the core. Right now I think that all that needs to be done to get the basics up and running would be:

1. Create 2 new tables- Product Reward Points and Customer Reward Points.

2. Add capability to Admin->Products to add/amend the points awarded per product. Also whether this product can be redeemed against using the points and how many points that would cost.

3. Change the 'zen_get_products_display_price' function to also show points per product. This would be a lot easier than having to code in a points display into every custom page that displays the price.

4. Create a new order_total module to display number of points rewarded.

5. Add a notifier to update the customer reward table when the transaction is successful.

And that would be phase 1. Phase 2 is the more interesting- Redeeming the points against purchases.
Good thinking Batman!

modifying zen_get_products_display_price is a good idea for a quick fix, but it wouldn't allow the points to be styled flexibly on the page. How about adding an admin flag to the function so that this can be switched on or off and then writing a small class which could be built on later that allows the individual points of a product to be accessed?

@raimond <- hacking up a hack sounds like a dubious plan, better to start fresh.

banswidthjunkie:

modifying zen_get_products_display_price is a good idea for a quick fix, but it wouldn't allow the points to be styled flexibly on the page. How about adding an admin flag to the function so that this can be switched on or off and then writing a small class which could be built on later that allows the individual points of a product to be accessed?

So this would be basing reward points as a percentage of the total price rather than applying a value directly to each product???

@raimond <- hacking up a hack sounds like a dubious plan, better to start fresh.

I've gone through some of the osC code and I think a fresh start would be better too.

Andrew

hem:

So this would be basing reward points as a percentage of the total price rather than applying a value directly to each product???

No not at all the points should be assignable individually. The class would be able to access the points for an individual product by passing in the product id.

However, the shop administrator should probably have the choice to award points to a product by both:

1. A multiplier of price (calculated from the default currency).
2. Individually assignable constant value.

The default value should probably be a globally fixed multiplier of price, then this could be overridden on a product by product basis.

My suggestion for the product_reward_points table would be to have 3 columns

1. product_id: INT, PRIMARY KEY, NOT NULL
2. points_type: SET{fixed, multiple, global}, NOT NULL
3. value: FLOAT

If "global" is set then "value" is ignored. Although this will contain redundant data, it seems better than doing it the proper way (probably saves space too)

The default multiplier should be able to be set from the admin.

Personally I don't think it is a great idea to have points associated with products simply because if you have many products, that would be hell to assign. Instead, points should exchange to a dollar value where it can purchase products. For example earning 2000 points you are entitle to $40 value and can checkout with that. This way, you also save the calculation of checking to see whether the points earned can purchase a certain item.

nrg77:

Personally I don't think it is a great idea to have points associated with products simply because if you have many products, that would be hell to assign. Instead, points should exchange to a dollar value where it can purchase products. For example earning 2000 points you are entitle to $40 value and can checkout with that. This way, you also save the calculation of checking to see whether the points earned can purchase a certain item.
That might be true, but what we are discussing at the moment is how customers earn points.

Working out how they spend them is the next step.

maybe is translating not the best way to do it. But i've seen the working of this module of OSC and it works very nice.