Store Credit Module

[gonewild]

Well, I have it working after some tweaking. The only thing i can suggest for the above sql problem is in the ot_sc.php module in order_totals you might try someting like this

function get_user_balance(){
global $db;
if(isset($_SESSION['customer_id'])){
$check_query = $db->Execute("select amount from " . TABLE_STORE_CREDIT . " where customer_id = ".$_SESSION['customer_id']);
$amount = $check_query->fields['amount'];
return $amount;
}else{
$amount = 0;
}
}

This may not work. I honestly can't remember what I did to fix the issue earlier lol. Sorry. If this doesn't work and I remember for sure I will post it. At this point its been a long night.

WHAT I REALLY NEED FOR THIS DEAL TO DO IS allow the customer to select how much of the credit they want to use. If anyone knows how to do that I would really appreciate it. I will continue working on this option myself but any input would be great.

Tried it. Did not make a difference. Still the same problem. Thanks for trying.

Does it make a difference what the sort order is set to in the Orders Total Module in Admin?

[cmessa]

How nice it would have been to know this was not working before I installed it... anyone got sql code to remove the changes that were made with this module? It looks like everything else works, but with no store credit it fails. Bummer.

corbett

[cmessa]

This seems to be the offending code:

function apply_credit() {
global $db;
$db->execute("update " . TABLE_STORE_CREDIT . " set amount = amount - " .$this->deduction. " where customer_id=".$_SESSION['customer_id']);
}

Something is wrong with this SQL statement. I am no expert, but I will take a look and see what I can figure out. Any experts out there got some ideas. This is the last hurdle to fix this the way it currently is.

After looking at it more, this part of the code looks to be blank when you get the sql error

.$this->deduction



Corbett

[gonewild]

How nice it would have been to know this was not working before I installed it... anyone got sql code to remove the changes that were made with this module? It looks like everything else works, but with no store credit it fails. Bummer.

corbett

I simply uninstalled the store credit in Admin Orders Total and it does not seem to cause any problem. I have no idea how to remove the changes.
Hopefully it will get fixed.

[cmessa]

Thanks, that worked. I am looking at the code and can see the problem, but not sure how to fix. I keep messing with it and see what happens.....

corbett

[gonewild]

Thanks, that worked. I am looking at the code and can see the problem, but not sure how to fix. I keep messing with it and see what happens.....

corbett

Good! I don't know enough about how to fix the code, but I'm good at finding what doesn't work! I tried some variations without luck. If I can help you in any way let me know and I'll try.

[funtimesx]

I just wanted to say I've not disappeared, and I will make a best effort to read through this thread and have a look at people's issues, however as yet I've not been able to reproduce any of them (the store credit module is working fine in my store, with and without a credit balance).

If you are still having issues and are happy for me to correspond with you privately when I have fixes to test, please PM me and let me know.

I apologise for the delays - my family and I are currently in the process of moving interstate and with 17 month old twins and a business to run, it hasn't left me much spare time!

[gonewild]

I just wanted to say I've not disappeared, and I will make a best effort to read through this thread and have a look at people's issues, however as yet I've not been able to reproduce any of them (the store credit module is working fine in my store, with and without a credit balance).

If you are still having issues and are happy for me to correspond with you privately when I have fixes to test, please PM me and let me know.

I apologies for the delays - my family and I are currently in the process of moving interstate and with 17 month old twins and a business to run, it hasn't left me much spare time!

I'm not complaining, you have nothing to apologize for!
I like the module and want to get it working and will keep trying as long as someone is around to help.

The only issue I have now is the module has an error during checkout that stops the pages from completing, but the order is process and charged to the credit card. The customer just does not know it and sees the error message. This only happens when the customer does not have credit. When the customer has credit the whole process works perfectly.

I'm using ZCv1.3.6

I will PM you also, again thanks.

[funtimesx]

The only issue I have now is the module has an error during checkout that stops the pages from completing, but the order is process and charged to the credit card. The customer just does not know it and sees the error message. This only happens when the customer does not have credit. When the customer has credit the whole process works perfectly.

Ah - now that one I do remember seeing in my store (and fixing).

I'm hoping over the next few days to get some time and I'm going to download the code that's running in my store and diff it with the latest code I uploaded to ZC. I'm then going to try installing the merged result on a fresh ZC install (probably 1.3.7 for the sake of currency), and see what it does. Hopefully I'll be able to reproduce some of people's problems and fix 'em :).

[cmessa]

I just checked and all my orders went through alo, I did not notice this before.

Corbett