To post a new support question, click the Post New Topic button below.
Current Version: 4.8.5 | Sytist Manual | Common  Issues | Feature Requests

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Expired Credits Suddenly Showing And Being Redeemed

A
124 posts
Sun Jan 14, 18 3:04 PM CST
Hi, I'm coming across a new issue where account credits that are long expired are suddenly showing on the front end of clients' accounts, and are being used to make purchases.

Ex: the attached screen grab shows a credit that expired in June of last year but the client is able to see the credit and apply it at checkout.

We're now having to honor credits that have long expired and should no longer be available. How do we fix quickly please?

Thank you!
Attached Photos

16,148 posts (admin)
Tue Jan 16, 18 4:29 AM CST
Click on Settings in the main menu.

Then under the left menu click edit config file.

See if you have added this line of code:

$setup['no_expired_print_credits'] = true; // Do not calculate expired print credits

If so, that could be causing it.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
A
124 posts
Tue Jan 16, 18 9:41 PM CST
I did have that line in place. I removed it, and the issue seems to have gone away. Thank you!
A
124 posts
Thu Jan 18, 18 10:16 PM CST
Ok, now I'm having the opposite problem, After removing that line, the expired credits are deducting from the active credits when they shouldn't be. For example, in the attachment, the available credit should be $110 but because there was an expired $75 credit, there is only $35 credit available to the client. This is happening across all client accounts and I believe the line that was in place (that I removed) was there to correct this issue. How do I fix please?
Attached Photos

16,148 posts (admin)
Sat Jan 20, 18 4:53 AM CST
I have been trying to come up with a solution for this with the calculations but hit a wall. The problem is there is nothing in the database that connects a credit to a used credit.

So with the credit being used (the $75 one) and now expired it throws it all off.

The only solution I can come up with right now would be to either delete both of those $75.00 ones in your screenshot or edit the expired one and remove the expiration date. Unless you have another idea.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
A
124 posts
Sat Jan 20, 18 8:01 PM CST
I have too many credits in different stages to manually track and remove them. That's an unworkable solution, unfortunately.

The $setup['no_expired_print_credits'] = true; was working until recently, until we started running into the above issue.

Could you write a script that compares the expiration date of each credit to today's date, and if credit exp date < today's date, set the value of the credit to $0, and have it not display on the front end? In the admin, I'd still want to be able to see how much the credit was worth when active, but for calculation purposes if a credit is expired its value would be set to 0.
16,148 posts (admin)
Mon Jan 22, 18 5:14 AM CST
Adding the $setup['no_expired_print_credits'] = true; basically does the same thing as setting the value to 0.

The problem comes in when someone has an expired credit that they didn't use.

What might work is me writing some code to look for expired credits in accounts and check to see if a credit was used, and if not, setting the value to 0 of the expired unused credit. Basically, like the scenario in the screenshot in your first post. What do you think?

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
A
124 posts
Tue Jan 23, 18 9:27 PM CST
Yes, that should work perfectly as described for my purposes. Ideally, I'd still want to be able to see how much the credit was worth when valid, even if its mathematical value in it's expired state is $0. And if I took a credit that expired yesterday for example, and set it to expire a week from now (made it a present credit again), I'd want the client to be able to use the credit at its value until it expires again, if that makes sense.

Could you let me know when a solution is ready? Thanks!
16,148 posts (admin)
Thu Jan 25, 18 4:02 AM CST
I've got some code ready to do that. If you can send me FTP access to your site, I can upload a file so you can preview it first. Then we can make it change the expired credits to 0.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
A
124 posts
Thu Jan 25, 18 11:52 PM CST
Thank you! I don't mind doing the FTP, would you be able to email me the file? Otherwise I'll provide the info needed.
10 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 899 times
Category: Payment Options
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close