Store credit and reward point module

[gsdcypher]

Can this reward points mod be set up for the following?

1) Is is possible to have the reward points = %off rather than $off?

2) adjust the point value per product, per category or globally?

3) is it possible to set levels and limits?
1000 points = 5% off
2500 points = 10% off
5000 points = 15% off (max limit)

Thanks!

[karazy]

Just one thing I noticed about this module, it is a good module but I found a bug. This has to do with "Group Pricing". I'm the Admin and I gave myself a 25% discount when I check out everytime with the "Group Pricing" and $20 in store credit. I choose a product for 15.99 and a preferred shipping method "Parcel Post"

Before I add the store credit


Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Total: $19.67

After I add the store credit by clicking the check box.

Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Store Credit: -$20.00
Total: -$0.33

I think there might be a problem with this why it gave me the whole $20 than $19.67 which would of given me $0.00. This is a problem I bumped into please let me know if this is on my end or if this is a universal problem and I did update to the latest version.

This only happened with "Group Pricing" customers

[ams30gts]

having trouble with install.

followed the instructions perfectly til step 4. (where you setup configurations)

got this error in admin when trying to access the configurations

1146 Table 'XXXXX-XXX.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 6]
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.

my store is live, so hopefully can get this working by tonite

[ams30gts]

nm.

uninstalled this add-on

[numinix]

having trouble with install.

followed the instructions perfectly til step 4. (where you setup configurations)

got this error in admin when trying to access the configurations

1146 Table 'XXXXX-XXX.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 6]
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.

my store is live, so hopefully can get this working by tonite

There should be a file called store_credit_filenames.php in includes/extra_datafiles/ which contains the table definition.

Update: I see that it has been commented out for some reason. We'll release a patch with the correction today. Anyone else experiencing this problem can quickly resolve the issue by uncommenting the definition.

[slomojojo]

I have installed this today but get the following error:

); define('TEXT_SC_CRON_ORDERS_UPDATED', '%s order(s) updated.'); define('TEXT_SC_CRON_PRODUCTS_UPDATED', '%s product(s) updated.'); define('TEXT_SC_PRODUCTS_INFO', 'Earn up to %s in rewards points when you purchase this product!'); /* End Store Credit Order Total Module */ ?>

Also in the admin cp i get this -

BOX_CUSTOMERS_CREDIT, 'link' => zen_href_link(FILENAME_STORE_CREDIT, '', 'NONSSL')); ?>

I got that too. I ran a search on every file in the download for the short opening php tag:

<?

and replaced it with this one:

<?php

Don't know if that's kosher php, but it fixed all the errors (ver 3.05).

[slomojojo]

A clarification to my last post. If your using wamp on a test machine, open your PHP settings and enable "short open tag" if it's off. That should fix the errors without having to mess with any code.

[shartlesville]

I have installed it and if I manually award points it works perfectly. However, I cannot get it to add points to previous orders.

It is showing all the customers but it is showing them without any orders. If I click on a customer the information under their names is blank as if there are no orders.

I did run the cron file and it said 0 orders updated and 0 products updated.

Is there something else I need to do or something that is missing?

Blessings,
Krisann

[data_digger]

There's bug in SQL statement in

function update_customer_credit($customers_id, $amount){
        global $db;
        $sql='INSERT INTO '.TABLE_STORE_CREDIT.' VALUES (\''.$customers_id.'\', \''.$amount.'\') ON DUPLICATE KEY UPDATE reward_points=reward_points+'.$amount.';';
        $db->Execute($sql);
        if(mysql_affected_rows($db->link) == 1)
        return true;
        return false;
    } 

it should be

function update_customer_credit($customers_id, $amount){
        global $db;
        $sql='INSERT INTO '.TABLE_STORE_CREDIT.'(customers_id, amount) VALUES (\''.$customers_id.'\', \''.$amount.'\') ON DUPLICATE KEY UPDATE reward_points=reward_points+'.$amount.';';
        $db->Execute($sql);
        if(mysql_affected_rows($db->link) == 1)
        return true;
        return false;
    } 

I added "(customers_id, amount)" in sql statement after TABLE_STORE_CREDIT.

[swamyg1]

Just one thing I noticed about this module, it is a good module but I found a bug. This has to do with "Group Pricing". I'm the Admin and I gave myself a 25% discount when I check out everytime with the "Group Pricing" and $20 in store credit. I choose a product for 15.99 and a preferred shipping method "Parcel Post"

Before I add the store credit


Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Total: $19.67

After I add the store credit by clicking the check box.

Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Store Credit: -$20.00
Total: -$0.33

I think there might be a problem with this why it gave me the whole $20 than $19.67 which would of given me $0.00. This is a problem I bumped into please let me know if this is on my end or if this is a universal problem and I did update to the latest version.

This only happened with "Group Pricing" customers

I can confirm this same problem... any idea how to fix?