Printable View
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!
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
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
nm.
uninstalled this add-on
There should be a file called store_credit_filenames.php in includes/extra_datafiles/ which contains the table definition.Quote:
Originally Posted by ams30gts
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.
I got that too. I ran a search on every file in the download for the short opening php tag:Quote:
Originally Posted by spikescot2005
<?
and replaced it with this one:
<?php
Don't know if that's kosher php, but it fixed all the errors (ver 3.05).
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.
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. :shocking:
I did run the cron file and it said 0 orders updated and 0 products updated. :no:
Is there something else I need to do or something that is missing? :oops:
Blessings,
Krisann
There's bug in SQL statement in
it should bePHP Code: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;
}
I added "(customers_id, amount)" in sql statement after TABLE_STORE_CREDIT.PHP Code: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 can confirm this same problem... any idea how to fix?Quote:
Originally Posted by karazy