-
Re: Store credit and reward point module
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!
-
Re: Store credit and reward point module
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
-
Re: Store credit and reward point module
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
-
Re: Store credit and reward point module
nm.
uninstalled this add-on
-
Re: Store credit and reward point module
Quote:
Originally Posted by
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
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.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
spikescot2005
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).
-
Re: Store credit and reward point module
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.
-
Re: Store credit and reward point module
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
-
Re: Store credit and reward point module
There's bug in SQL statement in
PHP 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;
}
it should be
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 added "(customers_id, amount)" in sql statement after TABLE_STORE_CREDIT.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
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
I can confirm this same problem... any idea how to fix?
-
Re: Store credit and reward point module
Hi,
I have running SCM in my site, everything OK. but now I need help with something.
I need to set the reward point for only one Zone (country) is this possible? or there is an option I can set which costumers have the reward program and which not? Most modules have a Zone option or a "on/off" button.
Thanks for the help!
-
Re: Store credit and reward point module
I keep getting this error when i try and apply the reward points...
1054 Unknown column 'created_on' in 'field list'
in:
[INSERT INTO sc_customers (customers_id, amount, created_on, modified_on) VALUES ('1', '6.5', '1257068510', '1257068510') ON DUPLICATE KEY UPDATE amount = (amount + 6.5), modified_on = 1257068510;]
-
Re: Store credit and reward point module
I just upgraded to the latest version, it seems to be working better then the old version, however it is saying this on the store
"Reward Points
Your balance is $0.00
--------------------------------------------------------------------------------
You have $49.98 in pending rewards points"
But i cant find anywhere to switch them from pending to the account.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
Delights
I just upgraded to the latest version, it seems to be working better then the old version, however it is saying this on the store
"Reward Points
Your balance is $0.00
--------------------------------------------------------------------------------
You have $49.98 in pending rewards points"
But i cant find anywhere to switch them from pending to the account.
Nevermind, i just ran the con.
-
Re: Store credit and reward point module
AnyWAnt word on the group pricing bug? Seems like many people would need this fixed?
Posted via Mobile Device
-
Re: Store credit and reward point module
I Installed this mod.
Everything looks okay. I can add amounts in the backend.
However the credit is not showing on the cart side.
Any Suggestions on how to proceed?
-
Re: Store credit and reward point module
The store credit won't automatically update points when my customers purchase products..... I can manually insert it... but it's hell to do so....
I am not php expert... nor zen cart expert...
Anyone... any advice for why it is not update the points automatically?
THANK YOU THANK YOU for helping!
-
Re: Store credit and reward point module
Quote:
Originally Posted by
numinix
Once we get around to releasing the referrals module, it will be able to be used with either the store credit or rewards module. Currently the referrals mod is being used on the Numinix website only.
Great idea to give points for referrals.
When will the mod be released?
Also, some more ideas for the future: points for writing reviews, points for creating an account, points for subscribing to a newsletter, etc
thx!
-
Re: Store credit and reward point module
Quote:
Originally Posted by
koalabids
Hi, I have seen many posts about the following problem in this thread. Obviously it is a common problem, but there is no answer to fix it. I am desperate. I added this mod as the last thing before making my site go live, and now I can't, due to the error. It is not possible to checkout at all.
The error is:
1146 Table :[DBNAME].sc_customers' doesn't exist
in:
[select amount from sc_customers where customers_id = 2
I have uninstalled all the files, and removed the appropriate tables from my database. But I am still getting the error.
I spent over a week uploading over 350 products to my website, and realising this is a database problem, I do not want to have to reload my whole zencart. I have searched this forum, google etc. looking for an answer, but cant find one.
I am desperate, please did anyone find a fix? Any help would be very appreciated.
so, for all other people who may be having the same problem.
I have a busy shop. So, its advice that you install modules and what when your site is not busy.
BACK UP! BACK UP your database.
Here is the FIX that worked for me:
1.if you have a good database restore point, before the installation of this mod...revert to that.
2. now your database is clean of all 5 mod files.
3. Reinstall the sql patch
its worked for me, and hopefully it does for you as well.
Good luck
Samar
-
Re: Store credit and reward point module
I would like to exclude a product from receiving points, and also exclude that same product from being able to use points to pay for it. Is that possible without too much headache? Can someone point me in the right direction to make the code change? Ideally, there would be an "exclude" field in the admin, but I am ok with hard coding it, because it will not change.
TIA!
Sara
-
Rewards for specific order statuses only
This is a great plugin, but there was a one small issue for me - it would give reward points to all orders with status id >= than the one specified. Unfortunately, this is not practical in my shopping cart as I have scattered statuses for which I need to give reward points. I believe this is the case for most carts with default setup (Cancel status = 5 , which is less than Shipped status = 3 , etc. )
I figured out a fix, so if anyone else is interested, you can do the same:
1. Replace function "_check_order_status" in store_credit.php file with:
Code:
function _check_order_status($orders_id) {
global $db;
$order_query = "SELECT orders_status FROM " . TABLE_ORDERS . "
WHERE orders_id = " . $orders_id . "
LIMIT 1";
$order_status = $db->Execute($order_query);
$order_status_rewarded = explode(",", MODULE_ORDER_TOTAL_SC_ORDER_REWARD_STATUS);
if (in_array($order_status->fields['orders_status'], $order_status_rewarded)) {
return true;
} else {
return false;
}
}
2. Run this SQL on your DB:
Code:
UPDATE zen_configuration
SET use_function=NULL, set_function=NULL
WHERE configuration_title = "Required Order Status"
3. Go to Admin -> Modules -> Order Total -> Store Credit -> Edit -> in Required Order Status field, write the order ids delimited by comas for which you'd like to give rewards (for example: "3,102")
good luck
-
Re: Store credit and reward point module
Quick correction for the above. This is a more proper way to do it.
Instead of 2nd step, do the following:
- in /includes/modules/order_total/ot_sc.php file, replace
Code:
//$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Required Order Status', 'MODULE_ORDER_TOTAL_SC_ORDER_REWARD_STATUS', '2', 'What order status is required to receive reward points?', '6', '4', 'zen_cfg_pull_down_order_statuses(', 'zen_get_order_status_name', now())");
by
Code:
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Required Order Status', 'MODULE_ORDER_TOTAL_SC_ORDER_REWARD_STATUS', '2', 'What order status is required to receive reward points?', '6', '4', now())");
- under Admin -> Modules -> Order Total -> Store Credit -> click "Remove" followed by "Install"
-
Re: Store credit and reward point module
First, I apologize that I am really out of my depth with this module. I believe I installed it per the instructions.
In Admin->Order Total, I had a conflict between my gift voucher GV sort order of 840 which was also the default sort order for the store credit module, so I put the store credit sort order at 850, thinking if the gift voucher is used the store credit would not be used--a wild guess. I selected the default where I could, and true to show the store credit box.
I installed the .sql patch by cut and paste, as per instructions, instead of uploading; and when I installed the 3.x .sql patch, per the instructions, the program feedback said it was already installed.
I went to my store to see the changes, and now the print is large in my store and the following message appears on top of my "Authorize Net is in test mode" message:
'); 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, I placed the chron file in my www directory where the next step up are the Admin and Includes directories, but didn't actually understand where it was supposed to go, so that was a guess. Then I read online about cron jobs and it refers to Unix and Linux which I do not have; I am working on a test WAMP server in a Windows environment. It may be that my online web host uses Unix or Linux, though. So I really do not know where to start in using cron, or if it will work on my WAMP server. Cron is totally new to me, and I do not know what it means to "run" it.
I really do not know whether I should be asking for instructions here as maybe I am too ill-prepared to really figure out a mod with instructions that seem to be directed to more knowledgeable persons. Shall I uninstall or is there hope for me getting this running? I am seeing in the instructions and the forum that people are figuring things out but not stating what they figured out, and sometimes only responding to parts of questions.
Is there anything basic to read on how to proceed and how to really work with this module? Does anyone know what I might have done to alter my site as stated above? (I do have a backup.)
Thanks.
-
Re: Store credit and reward point module
Still working on getting rid of the stray messages that came up when I installed this module:
'); 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 */ ?>
in the admin screen:
BOX_CUSTOMERS_CREDIT, 'link' => zen_href_link(FILENAME_STORE_CREDIT, '', 'NONSSL')); ?>
I have tried to wipe the above error messages out by performing a backup of the root database and the store, and then 2 entire WAMP backup restorals from different backup dates, and although my other changes disappeared with the restoral of earlier versions of my website and local test WAMP server, the above two error messages have persisted, and the Store Credit Module also persisted.
I have cleared my browser's cache and the Zen Cart cache, and have used the developer's tool to compare my files with the original download files with Winmerge, and the compared files are identical.
Where would I look for the Admin headers to remove the BOX_CUSTOMERS_CREDIT....that appears there?
Where would I look for text appearing on my home page above the Authorize Net is in testing mode message?
Are these messages more likely to be in php files or in the MySQL database?
Thanks.
-
Re: Store credit and reward point module
This probably has nothing to do with installing this module, but to get authorize.net out of Test mode:
ADMIN -> Modules -> Payment -> Authorize.net -> Edit -> Transaction Mode -> Production.
Your other errors seem very odd.. i suggest to completely uninstall the module and reinstall it ..
you can also check this file:
/store/includes/languages/english/extra_definitions/store_credit_definitions.php to make sure everything looks right there. it looks as if you went to modify it and accidentally pressed enter before " '); " on this line:
define('TEXT_SC_CRON_COMPLETED', 'Completed in %s seconds.<br>');
good luck
Quote:
Originally Posted by
notageek
Still working on getting rid of the stray messages that came up when I installed this module:
'); 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 */ ?>
in the admin screen:
BOX_CUSTOMERS_CREDIT, 'link' => zen_href_link(FILENAME_STORE_CREDIT, '', 'NONSSL')); ?>
I have tried to wipe the above error messages out by performing a backup of the root database and the store, and then 2 entire WAMP backup restorals from different backup dates, and although my other changes disappeared with the restoral of earlier versions of my website and local test WAMP server, the above two error messages have persisted, and the Store Credit Module also persisted.
I have cleared my browser's cache and the Zen Cart cache, and have used the developer's tool to compare my files with the original download files with Winmerge, and the compared files are identical.
Where would I look for the Admin headers to remove the BOX_CUSTOMERS_CREDIT....that appears there?
Where would I look for text appearing on my home page above the Authorize Net is in testing mode message?
Are these messages more likely to be in php files or in the MySQL database?
Thanks.
-
Store Credit , FEC , and Gift Certificate not updating - RESOLVED
-
Re: Store credit and reward point module
Greenhat,
I really appreciate your comments. It was getting very lonely talking to myself.
You will be glad to hear that I just resolved the stray message problem.
On Numinix's site on page 7 relating to the Store Credit Module, spikescot2005 had posted the problem and I had felt slomojojo's response was a sort of "jerryrig" solution, and completely missed his clarification #107.
Slomojojo's solution reveals that there is more than one type of tag in PHP: apparently Store Credit Module uses a short opening php tag: <?.
Slomojojo stated he went into each of the files (there are many) and searched for <? and replaced it with <?php.
When I read his clarification today that (thank you so much, slomojojo), the same thing is accomplished on a test WAMP server by simply opening PHP settings and enabling "short open tag" if it's off, it finally made sense to me as being a PHP tag problem.
That did indeed fix the error everywhere AT ONCE.
I am so worn out from spinning my wheels for days (despite all the extraneous learning I accomplished) the fix seems anticlimatic, but I am so greatly encouraged by your having taken the time to try to shed some light on my problem.
-
Re: Store credit and reward point module
no problem.. i can see that it wasnt really helpful..
great that you figured it out and posted the solution here.. i think i ran into this problem a long time ago also . a lot of people probably do .
-
Re: Store credit and reward point module
Hello,
I installed without issues, activated sidebox. Issued my test account a credit, credit showed fine in sidebox. My issue is that when trying to use the credit and the total in the cart (with shipping and tax) is a lower dollar amount it still asks and requires that I choose a a payment method even though the store credit is greater than the total purchase.
I do have the box checked that says "do you want to apply your store credit"
Any ideas?
Thanks,
Tom
-
Re: Store credit and reward point module
is 3.05 the latest version? I saw reference somewhere to a 3.1 version. Thanks
-
Re: Store credit and reward point module
does this module work with Paypal IPN? please note that the old mode” Reward Point Full Sui” don’t work with it. I attached what the author said here:
##############################_
The official status of this issue is: The mod works with PayPal- just not with PayPal IPN. Hopefully this will change when ZenCart 2.0 is released.
but the PayPal IPN mod does this without calling any of the ZenCart notifiers. And as the RP award mod is attached to one of these notifiers, PayPal IPN does not let the RP mod know that there are points which need to be stored. Hence the problem. Contrast to this Google Checkout which runs the same way as PayPal IPN under ZenCart- It makes the correct calls and points are stored.
.
-
Re: Store credit and reward point module
We want customers to be able to view their current rewards credits and pending credits by checking their own account. I followed the following and added the code to the end of includes/templates/YOUR_TEMPLATE/templates/ tpl_account_history_info_default.php
But it showed nothing about credits. I guess I need more codes. I am willing to pay for it. Please contact me dancingever###################### thanks.
++++++++++++++++++++++++++++++++
• Display a customer's current store credits/rewards
In includes/templates/YOUR_TEMPLATE/templates/[select_a_template_file_of_your_choice].php, add the following to an appropriate location in your template file:
<!-- bof Store Credit Display -->
<?php
if (MODULE_ORDER_TOTAL_SC_ORDER_PRODUCT_POINTS == 'true') {
require_once(DIR_WS_CLASSES . 'store_credit.php');
$store_credit = new storeCredit();
echo $store_credit->retrieve_customer_credit($_SESSION['customer_id']);
}
?>
<!-- eof Store Credit Display -->
-
Re: Store credit and reward point module
I think I am also needing someone to install this for me. I am willing to pay. Can someone please contact me at lauriesscraps(at)live(dot)com? Thank you!
-
Re: Store credit and reward point module
I think I got it all installed with just a few things that I think I can fix with help..... so I won't need someone to install.
Quote:
Originally Posted by
numinix
Apologies, the documentation has been corrected.
I am having the same problems. All the documentation says is this:
Quote:
Find (around line 70)
if ($credit_covers) {
Quote:
Replace With
// BEGIN REWARDS POINTS
// if credit does not cover order total or isn't selected
if ($_SESSION['credit_covers'] != true) {
// check that a gift voucher isn't being used that is larger than the order
if ($_SESSION['cot_gv'] < $order->info['total']) {
$credit_covers = false;
}
}
// END REWARDS POINTS
if ($credit_covers) {
So does this mean that I add all this right above if ($credit_covers)? If I do that my check out page does not show up. Please advise. Thank you.
-
Re: Store credit and reward point module
Hi, yellow1912
Thank you for the mod, I tested and running well.
Only one Bug I found is:
I set a 5% discount group in the admin.
Add a member to this group.
Issue $500 store credit to this member.
This member place $200 order and check out.
Here is a mistake:
Sub-Total: $200
Group Discount: -$10
Store Credit: -$200
Total : $-10
The store credit doesn't subtract the Group Discount before apply. Store credit direct apply the Sub-Total, omit the Group Discount.
If finish checkout, there is only $300 store credit in member's account.
The correct store credit should be $310, I owe this member $10.
and the invoice displays Total : $-10.
This mistake only happen if the group member has enough store credit.
and only happen on the group member.
Maybe the mod omit the group pricing.
Would you please have a look?
Thank you.
-
Re: Store credit and reward point module
2. I found another bug:
sometimes, after member applied the store credit to check out, I found in the admin-store credit, Credit Balance-display 0, but when click the member's name - edit, it displays " 7.62939e-07 ", it's strange number.
Do you know why?
thanks
-
Re: Store credit and reward point module
I have a question. Under admin/customers/store_credit when I click on a customer to give them a store credit it want let me. It shows this kind of stuff. Can anybody help me. Thank You
Customers Balance
customers_firstname); ?> customers_lastname); ?>
Store Credit Balance amount==null || is_nan($cInfo->amount)) $cInfo->amount = 0; $amount = number_format($cInfo->amount, 2); $str_balance = "".($amount); echo zen_draw_input_field('customers_balance', $str_balance); ?>
-
Re: Store credit and reward point module
Hi,
Installed the latest version but when I go to Customers > Store Credit, I am getting the following error. Please help.
1054 Unknown column 'pending' in 'field list'
in:
[SELECT customers_id, pending FROM zen_sc_customers WHERE customers_id = 3 LIMIT 1]
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.
-
Re: Store credit and reward point module
when a customer check out with paypal IPN (not paypal express checkout), will he get store credit automatically? Does anyone has ever make this module work with paypal IPN before?
-
Re: Store credit and reward point module
Quote:
Originally Posted by
silkhouse
when a customer check out with paypal IPN (not paypal express checkout), will he get store credit automatically? Does anyone has ever make this module work with paypal IPN before?
I use it with PayPal IPN without any problems. The customer has the choice of using his available credit before the total is finalized, so the store credit module should be compatible with any payment system.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
paul3648
I use it with PayPal IPN without any problems. The customer has the choice of using his available credit before the total is finalized, so the store credit module should be compatible with any payment system.
It just occurred to me that you might be talking about a reward credit - a certain amount of points rewarded for each purchase. I don't use this function so can't say whether or not it works with Paypal.
I use this module for returns - rather than refund the credit card, I give them store credit which can be used on their next purchase.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
paul3648
It just occurred to me that you might be talking about a reward credit - a certain amount of points rewarded for each purchase. I don't use this function so can't say whether or not it works with Paypal.
yes, I was talking about a reward credit - a certain amount of points rewarded for each purchase.
-
Re: Store credit and reward point module
Anyone else getting a problem where the Store credit isnt comming of the total for the next order ?
-
Re: Store credit and reward point module
I have just installed the the store credit module which works fine until the customer needs to checkout.
Although the order value is below the amount of credit it won't bypass the payment method.
What have I done wrong?
Thanks in anticipation.
Regards
Mel
-
Re: Store credit and reward point module
I saw this asked back a number of pages, but without an answer.
Is it possible to set the amount of points rewarded on a per product basis.
I have a zen site were the customers purchase store credit to use on other items in the store. I would love if when they purchased store credit via a product that the credit would be credited to their account automatically. This would mean that my site would truly be automatic and all services on it available 24hrs, instead of people having to wait until the morning for me to start work to add the purchased credit to their accounts.
If this is possible, please let me know.
All the best
DB
-
Re: Store credit and reward point module
Does anyone know if it is possible to stop a customer ordering if they have no store credit.
We only want customers toorder using their store credit - once that has run out we need to be able to prevent them from ordering.
Thanks.
Mel
-
Re: Store credit and reward point module
How do I remove this module? I removed all the PHP files, but the tables created from the SQL files are still there.
-
Cannot get Sidebox to display
Hi,
I have this module installed but cannot get the sidebox to display. I have set the sidebox to on in the tools menu for the sideboxes.
Cheers,
Peter.
-
Re: Store credit and reward point module
Hi,
I just installed the Store Credit plugin and in testing I noticed it is not compatible with Quantity Discount plugin given here http://www.zen-cart.com/index.php?ma...roducts_id=235 which is also installed on my site.
What I noticed if we use store credit then it is not considering the discount applied to Quantity Discount as given below example:
Product------------- Price ------------ Total
4 x Product A ------ $10 -------------- $40
10 x Product B ----- $5 --------------- $50
Sub-total ------------------------------ $90
Quantity Discount ---------------- -$5
Store Credit ---------------------- -$90
Total ------------------------------ -$5
As you can see in above example the final billing value in place $0 it is now -$5 that is Negative Value.
Please let me know what can be done to debug this.
~ Time
Zencart v1.3.8a
-
Re: Store credit and reward point module
Quote:
Originally Posted by
countrycharm
I have a question. Under admin/customers/store_credit when I click on a customer to give them a store credit it want let me. It shows this kind of stuff. Can anybody help me. Thank You
Customers Balance
customers_firstname); ?> customers_lastname); ?>
Store Credit Balance amount==null || is_nan($cInfo->amount)) $cInfo->amount = 0; $amount = number_format($cInfo->amount, 2); $str_balance = "".($amount); echo zen_draw_input_field('customers_balance', $str_balance); ?>
I have the same problem. Can anyone help with this issue? I have been trying to figure it out for hours, but in vain. Please kindly help. Thanks million!
Using v1.3.9h
-
Re: Store credit and reward point module
I have also experienced the problem with the Store Credit mod conflicting with the Group Discount Pricing. It only works if you sort the store credit BEFORE Group Pricing. Sorted AFTER, it generates a negative order total. And the Group Pricing is omitted if you have available store credit that covers the total amount of the order. Then Group Pricing is never considered. I want the store credit to work as the Gift Voucher would (all discounts are calculated first and then the GV or Store Credit is deducted), but it doesn't. Did anyone ever find a fix to this?
-
Re: Store credit and reward point module
Will this plug-in work with zc V1.5? We would like to use it but have had some major issues with older plugins. Would you recommend installing an older version of zc?
-
Re: Store credit and reward point module
Will I be able to upload a list of say 30-50 customers and give them each a different amount of store credit. I currently send 30-50 out each week as gift vouchers but then they need to add them to their account. Some have never figured out how to do that yet. I spend a great deal of time talking them through each step. If I could upload a csv file my life would add on two or more hours a week of free time.
Will this module do that?
Oh, the Numinix site looks like the module doesn't work with ZCv1.5. The download site looked like it did. I am a bit confused here. supported? or no?
-
Re: Store credit and reward point module
I have this module running on in my admin site. Unfortunately I am the operator of my site and I know enough to get things working but not perfect or as intended so I have to type in the url just to get to the store credit page. For me its the only option as it works. I want to be able to sell store credit. I want to create a virtual product that allows a customer to select a price say $10 and they get $20 store credit. Is there a way to do this that will automatically give the customer this credit or will I have to manually put it in?
-
Re: Store credit and reward point module
Hi
Have installed this module on my site but store credit is not appearing in my customers menu. The side box appears okay but I am unable to add credit to any accounts.
I am running zencart V1.5.0 and have double checked I have uploaded all the correct files in the right place.
Has anyone else had this problem?
-
Re: Store credit and reward point module
Quote:
Originally Posted by
MelodyW
Hi
Have installed this module on my site but store credit is not appearing in my customers menu. The side box appears okay but I am unable to add credit to any accounts.
I am running zencart V1.5.0 and have double checked I have uploaded all the correct files in the right place.
Has anyone else had this problem?
I am having the same problem in 1.5.1 - it doesn't show up in the "Customers" menu. It does work - if I set it to automatically add store credit to new accounts, it does that just fine - but I can't edit the store credit or anything in the Admin tools. It looked to me like it was missing an initialization .php file for adding it to the menu, which apparently became a thing with 1.5, so I attempted to create one. I called it init_store_credit.php, stored it in admin/includes/functions/extra_functions and put the following into it:
Code:
<?php
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
//----
// If the installation supports admin-page registration (i.e. v1.5.0 and later), then
// register the New Tools tool into the admin menu structure.
//
if (function_exists('zen_register_admin_page')) {
if (!zen_page_key_exists('toolsStoreCredit')) {
zen_register_admin_page('toolsStoreCredit', 'BOX_CUSTOMERS_CREDIT', 'FILENAME_STORE_CREDIT','' , 'customers', 'Y', 20);
}
}
Doesn't seem to have had any effect, though. Did I use a wrong option or name, or is that not the problem anyway?
-
Re: Store credit and reward point module
open \YOUR_ADMIN_NAME\includes\extra_datafiles\store_credit_filenames.php
add:
PHP Code:
define('BOX_CUSTOMERS_CREDIT', 'Customers Credit');
then in ADMIN > TOOLS > INSTALL SQL PATCHES
copy/paste the following:
PHP Code:
# Register the configuration page for Admin Access Control
INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configCustomerCreditRewards','BOX_CUSTOMERS_CREDIT','FILENAME_STORE_CREDIT',CONCAT('gID=',@configuration_group_id),'customers','Y',@configuration_group_id);
BACKUP, BACKUP, BACKUP!
-
Re: Store credit and reward point module
Quote:
Originally Posted by
countrycharm
I have a question. Under admin/customers/store_credit when I click on a customer to give them a store credit it want let me. It shows this kind of stuff. Can anybody help me. Thank You
Customers Balance
customers_firstname); ?> customers_lastname); ?>
Store Credit Balance amount==null || is_nan($cInfo->amount)) $cInfo->amount = 0; $amount = number_format($cInfo->amount, 2); $str_balance = "".($amount); echo zen_draw_input_field('customers_balance', $str_balance); ?>
If someone has found a fix for this question, please post it.
I found a work around. Go to the sc_customers table in phpMyAdmin and find your customer's id. Edit the information there and save. It is not ideal, but it does give your customer their Store Credit.
-
Re: Store credit and reward point module
Note: About question from countrycharm - I did receive that same code on my home test version, but the program worked fine the online website. I use EasyPHP at home.
-
Re: Store credit and reward point module
Hi,
I loaded the module on 1.3.9h and everything loaded without a hitch. I can add a store credit for a customer via admin but the side box won't show up and the credit doesn't show during checkout either when logged in as the customer. The sidebox entry shows up in the layout area and I've enabled it accordingly but still no show. I've sure I've missed something simple since my cart runs so smoothly I always forget the simple things. Any direction would be most helpful. Thanks.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
voltar
Hi,
I loaded the module on 1.3.9h and everything loaded without a hitch. I can add a store credit for a customer via admin but the side box won't show up and the credit doesn't show during checkout either when logged in as the customer. The sidebox entry shows up in the layout area and I've enabled it accordingly but still no show. I've sure I've missed something simple since my cart runs so smoothly I always forget the simple things. Any direction would be most helpful. Thanks.
Update to post:
I assume that the boxes and checkout information is not showing up possibly because the Store Credit module is not seeing the credit that was entered? Could another addon be in the way? The credit is shown correctly in the db under sc_customers amount and pending is 0. I am stumped so any advice pointing me in the right direction would be helpful. Thanks.
-
Re: Store credit and reward point module
Quote:
Originally Posted by
voltar
Update to post:
I assume that the boxes and checkout information is not showing up possibly because the Store Credit module is not seeing the credit that was entered? Could another addon be in the way? The credit is shown correctly in the db under sc_customers amount and pending is 0. I am stumped so any advice pointing me in the right direction would be helpful. Thanks.
I couldn't figure it out so I unloaded the module. It must be conflicting with an addon that I already have running.
-
Re: Store credit and reward point module
I loaded everything, as ordered...ran the script. I can see the module under Layout Boxes Controller, but the main admin link to let me work on it under Customers (I believe it should be?) is not there. I've checked every dropdown across, and no sign of this module for me to give credit or set up reward points for my store. Any idea what might have been missed or needs tweaked to bring that up for me? I'm using 1.5.1, BTW. Thanks in advance.
DML
-
Re: Store credit and reward point module
It looks like my message glitched, but... I loaded everything and ran the script. I see the module loaded under Tools> Layout Boxes Controller and managed to set some rules under Modules> Order Total, but I do not see the Customer section (I believe it should be?) to manually control reward points and store credit. Any clue what I might have missed/have to tweak to fix this? I'd appreciate any help you can give.
DML
-
Re: Store credit and reward point module
Quote:
Originally Posted by
DMLyons
It looks like my message glitched, but... I loaded everything and ran the script. I see the module loaded under Tools> Layout Boxes Controller and managed to set some rules under Modules> Order Total, but I do not see the Customer section (I believe it should be?) to manually control reward points and store credit. Any clue what I might have missed/have to tweak to fix this? I'd appreciate any help you can give.
DML
The issue is that this module hasn't been upgraded to the latest version of Zen Cart.
Therefore two changes are needed to the out of the box version:
1) adjust any and all files that start with <? to be <?php
2) 'Register' the admin page. Here are instructions:https://www.zen-cart.com/content.php...e-v1-5-0-admin
For the parameters mentioned in that link use these:
Page Key: Store Credit (if you get an error use StoreCredit)
Page Name: BOX_CUSTOMERS_CREDIT
Page Filename: FILENAME_STORE_CREDIT
Menu: Choose where you want it to appear
Sort Order: 20
-
Re: Store credit and reward point module
Installed dual pricing and now when I activate wholesale accounts that persons ability to apply credit has disappeared. Zen version 1.5.1
-
Re: Store credit and reward point module
Hi All,
So I have this working with ZC1.5.5. Just had to change the two mysql_affected_rows to mysqli_affected_rows. So everything is working with one exception. On the checkout page when credits are applied it's actually being applied twice. In the function get_order_total function I added a line
Code:
echo 'ot: ' . $order_total . ' td:' . $this->deduction . '<br />';
Now on the checkout page I see this three times. First above header, second in cart contents box and third just above store credits box.
The first shows ot: 71 td:
The second ot: 71 td: 71
The third ot: -71 td: -142
in the totals area of the cart contents the sub-total is $71 (correct), no tax(correct), no shipping(correct), store credit -142, total -71.
This only happens when the available credit amount is greater than the order total amount. if the available credit is $200 and the cart total is $50 the entire available credit is wiped out and set to $0.
I am really having a hard time with this one. I can not figure out why this is happening. Your help is greatly appreciated.
Thank You,
John
-
Re: Store credit and reward point module
I have found a solution. So far (good bit of testing) I'm pretty sure this is the fix.
In includes/modules/order_total/ot_sc.php the last line of function get_order_total() is to return $order_total + $this->deduction;
I changed this to return $order_total; and it works. I have spent quite a bit of time going through this file and this is the best solution I've found.
Thank You,
John
-
Re: Store credit and reward point module
Thank you for this fix!
I applied the fix and ran the SQL update.
I am able to add credits now through the admin, but when I press "update", I get a blank page.
If I use the back arrow on the browser, the credit is added, and the customer gets an email.
The error log reads, in part: PHP Fatal error: require(): Failed opening required 'includes/modules/prod_cat_header_code.php'
This file does not exist and is not part of the store credit / rewards module.
Version 1.5.7b - upgraded from v1.5.2
-
Re: Store credit and reward point module
Quote:
Originally Posted by
4tinak
Thank you for this fix!
I applied the fix and ran the SQL update.
I am able to add credits now through the admin, but when I press "update", I get a blank page.
If I use the back arrow on the browser, the credit is added, and the customer gets an email.
The error log reads, in part: PHP Fatal error: require(): Failed opening required 'includes/modules/prod_cat_header_code.php'
This file does not exist and is not part of the store credit / rewards module.
Version 1.5.7b - upgraded from v1.5.2
That plugin has not been upgraded (obviously) to use the zc156+ base; the highlighted admin file was removed as part of the category/product restructuring that took place in zc156.
-
Re: Store credit and reward point module
This module has long since been abandoned; I would not recommend it for use.