Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Reward Point Report. Rate Topic   * * * * - 1 votes

 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 07 September 2015 - 02:56 AM #1

Maybe it's just the way my head is screwed on but I can't see an easy way

to find the total Reward Points across all users. Sure I can check each

individual customer's total usable points but I can't see a way of getting

a total for all users. 



 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 06 October 2015 - 11:51 PM #2

How about a custom report showing members and their current Reward Points total.



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11443 posts

Posted 07 October 2015 - 12:09 AM #3

Better yet, have it be part of the customer listing (if addon is enabled) and then it becomes a sortablle column...


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 07 October 2015 - 12:58 AM #4

Excellent idea tbirnseth.

You would know better than I but surely adding a column couldn't be

that difficult. 



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11443 posts

Posted 07 October 2015 - 01:35 AM #5

There are hooks in the profiles manage view. The addon could be adjusted to provide that info.

 

And yes, it should be totaled at the bottom of the listing.

 

But good luck getting them to do it.  You're a lone voice right now! :-)  You might get lost in uservoice hell.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 09 November 2015 - 04:28 AM #6

I don't understand why this CS-Cart mob don't tweek the Reward Point add on

so that a store owner knows how much of his money is out on a swing.

For a very large store there might be a financial disaster in the making.

Instead of being able to coax some point usage out of big spenders the poor

owner is left continually in the dark.

Of course the store owners can spend days manually checking each member's account

but why should they have to ?

Come on guys, it CAN'T be that hard.

Maybe Reward Points is going down the deprecation path to pop up as

yet another paid add on.

A little bit sucky is the Simtech business model.



 

Posted 09 November 2015 - 01:14 PM #7

This is how we do it..

Fix is from EComLabs....    Works great..

 

OK. Just create the app\addons\reward_points\schemas\exim\users.post.php file with the following content:

 

<?php

function fn_exim_set_user_points($user_id, $amount)
{
$current_amount = fn_get_user_additional_data(POINTS, $user_id);

$action = ($amount >= $current_amount) ? 'A' : 'S';
$diff = $amount - $current_amount;

fn_change_user_points(($action == 'A') ? abs($diff) : -abs($diff), $user_id, __('import'), $action);
}

$schema['export_fields']['Reward points'] = array (
    'linked' => false,
    'process_get' => array('fn_get_user_additional_data', POINTS, '#key'),
    'process_put' => array('fn_exim_set_user_points', '#key', '#this')
);

return $schema;
 

Elkhorn Graphics LLC
Cs-Cart 4.11.2


 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 23 November 2015 - 08:22 AM #8

Thanks for pointing that out Car Stickers and Decals.

Big thanks to the super guru in the North ( EComLabs ).

I still have to do some clicking but but only one click

instead of 3. A big time saver.

Thanks again.

 

Pushing it I know but is there a way to have these Reward Point

totals visible on the customer line ( no clicking involved ) ?

ID   Name  Email Registered Type Reward Points Status 



 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2318 posts

Posted 23 November 2015 - 08:49 AM #9

Please vote: http://cscart.uservo...-customer-listi


When life hands you lemons, bring on the Tequila baby!


 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3381 posts

Posted 24 November 2015 - 09:16 AM #10


Pushing it I know but is there a way to have these Reward Point

totals visible on the customer line ( no clicking involved ) ?

ID   Name  Email Registered Type Reward Points Status 

 

Create 2 files:

1. design/backend/template/addons/my_changes/hooks/profiles/manage_header.post.tpl

2. design/backend/template/addons/my_changes/hooks/profiles/manage_data.post.tpl

 

The first one should contain the following code:

<th class="right">{__("points")}</th>

The second file should containt this:

<td class="row-status">{if $user.points}{$user.points|@unserialize}{else}0{/if}</td>

Make sure the 'My changes' add-on is activated. Switch in off and on so that the hooks are loaded


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 24 November 2015 - 09:38 AM #11

Thank you Simtechdev.

To make clear.

1. My Changes > Active

2. Create the 2 files.

3. My Changes >Disable

4. My Changes > Active



 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3381 posts

Posted 24 November 2015 - 09:57 AM #12

Thank you Simtechdev.

To make clear.

1. My Changes > Active

2. Create the 2 files.

3. My Changes >Disable

4. My Changes > Active

 

Point 1 is not necessary, but yes. Also 'Reward points' add-on should also be active (of course)


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 08 December 2015 - 12:28 AM #13

Thank you Simtech but tinkering with code is my least favourite sport.

Any chance that this code modification could be made part of future releases ?

 

Flow...You got 3 votes from me. I am amazed that more users haven't voted.



 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3381 posts

Posted 08 December 2015 - 07:06 AM #14

Thank you Simtech but tinkering with code is my least favourite sport.

Any chance that this code modification could be made part of future releases ?

 

 

I don't think CS-Cart includes this in nearest releases. But this code modification is slight and should not damage any part of your store.


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 09 December 2015 - 08:55 AM #15

Thank you again Simtech but even 'slight' modifications scare the willies out of me.

I may try copying my site on the server to tinker with.



 
  • termalert
  • Senior Member
  • Members
  • Join Date: 14-Jan 09
  • 972 posts

Posted 02 January 2016 - 02:34 PM #16

Thanks again eComLabs and Car Stickers Decals but

it just stopped working.

Can I simply delete

app\addons\reward_points\schemas\exim\users.post.php

???

 

Took another look today and it's working again.

Software should NOT behave like this.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19983 posts

Posted 05 January 2016 - 09:25 AM #17

What do you mean by "it just stopped working"? Did you receive any error message?


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • imac
  • Head of Product
  • CS-Cart Architects
  • Join Date: 22-Nov 05
  • 2074 posts

Posted 06 January 2016 - 12:02 PM #18

I don't understand why this CS-Cart mob don't tweek the Reward Point add on
so that a store owner knows how much of his money is out on a swing.
For a very large store there might be a financial disaster in the making.
Instead of being able to coax some point usage out of big spenders the poor
owner is left continually in the dark.
Of course the store owners can spend days manually checking each member's account
but why should they have to ?
Come on guys, it CAN'T be that hard.


It's not so hard, but do CS-Cart users really need this? How many store owners use Reward Points?
3 months - 7 votes. I'm not sure there are more than 3-4 people who would even note these changes.
Ilya Makarov,
CS-Cart Architect Team
Suggest and vote for new features | Report a bug

 
  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2318 posts

Posted 06 January 2016 - 02:05 PM #19

It's not so hard, but do CS-Cart users really need this? How many store owners use Reward Points?
3 months - 7 votes. I'm not sure there are more than 3-4 people who would even note these changes.

 

3 months? It's only been 1,5. Every shop using reward points that grows needs this to manage their finances. But more importantly, this feature can be used as an incredibly strong marketing tool. That we can't email people the amount of reward points they have is simply stupid, don't you agree?

 

It's just one of those things that can be quite easily implemented and will make cs-cart a lot better.


When life hands you lemons, bring on the Tequila baby!


 
  • Magpie Don
  • Senior Member
  • Members
  • Join Date: 01-Apr 09
  • 825 posts

Posted 06 January 2016 - 10:18 PM #20

I've been using Reward Points since 2009.

ANY improvement to Reporting the liability that I have out there of Available Points would be great!

ANY ability to "capitalize" on 6 years of customers with Available Points would be welcome. Building a simple Reward Points notification function into the Newsletter (or within the Addon) seems like it should be a requirement to "claim" to support Reward Points.

But, the Newsletter addon is so primitive, I can't even include a "customer's name" in an email, so I added a small banner to my new design that shows in the cart, on checkout and on the home page, it notifies the customer that they earn Reward Points and links to a page explaining how to redeem them.

 

I started tracking Reward Points Redeemed in QuickBooks (edited the QB export, separated it from Discounts), as a "customer retention" tool it is strong and provides a competitive advantage. I think I could do better- I redeemed more money in "Discounts" using coupons.

 

I don't get that CS-Cart thinks no one uses Reward Points... I don't get that.


CS-Cart Ultimate ver 4.9.3 SP1