I've done my best to read through what's in this post, but it is greater than I. Here's the spiel...
Problem: Pending Rewards Points will not Transfer to Earned After Order Status Change
(Yes, I have it configured in Configuration/Reward Points- I tried a multitude of different configurations with both Advanced and Simple selections and it did not effect the issue.)
http://www.primevapor.com/pvtestbed
(pvtestbed is a clone of the live site)
Zen Version: 1.3.9h
(running the classic (default) template)
Site Mods:
Stock By Attributes V. 1.4.13
Rewards Points V 1.33
Tidy Zen Cart Backup V1.0.7
Zen Master Password V 1.0
Super Orders V 3.0
Custom source code was written in for public_html/includes/classes/order.php to allow Super Orders and Stock By Attributes to work simultaneously.
Completed Troubleshooting As Of 9/8/2011-
Problem: Pending Rewards Points will not Transfer to Earned
-
Vanilla version of zen installed with super orders, stock by attributes, and rewards points on seperate testbed directory. All mods worked as intended (when we include our customer includes/classes/order.php) This proves it can work. - located on public_html/pvtestbed3 - this test site is currently under maintenance except for our main office IP, if you would like to use this, we'll need an IP to add to our exclusion list.
-
As our site has undergone a large SQL database conversion from the last site transfer, we re-installed the Rewards Points mod several times. My boss noticed that the uninstall.sql provided in Rewards Points 1.33 didn't seem to remove the tables it was calling for. My boss removed these tables with his SSH client and I uploaded the SQL patch 'new.sql' with no change in effect.
-
We repeated the first uninstall again with another cloned testbed from the live site. The issue persisted.
-
I have personally gone over all of the files in Rewards Points module. I have noticed that the Rewards Points mod does share some of its files in the same override folders as Super Orders, but I don't think that's the cause of the issue due to the scripts available in those shared folders. Ultimately, I'm unsure.
-
Since I cannot find any of the files on the site to be the source of the issue, my theories have begun to center around the SQL conversion that we executed, but that is also speculation.
This is as far as I have gotten. Any and all advice or suggestions would be greatly appreciated.
Thank you again in advance for a great mod and the support to back it up.