Quote Originally Posted by ibuttons View Post
I would also like to be able to exclude orders from the Sales Report based on the current order status, however...

the change shown below doesn't accomplish that. Instead, the drop-down field used to select the Current Order Status no longer contains the orders_status_id of 5, but the report still includes orders with a current orders_status_id of 5. This is not what I want at all!



Here is what I need ...
  1. I'd like to be able to exclude any order that has a current orders_status_name that contains a string like %test%, %unused%, %voided%, or %RMA%.
  2. Ideally, I'd like to have a new text field I can type into, kind of like the field called: Only include specific Customer IDs (comma separated list), only this new one would be called: Exclude current orders_status_names that contain.
  3. In this new field, I would enter the following: test, unused, void, rma.
  4. Also, I would like to be able to setup a default for it so I don't have to type those in all the time.
  5. And I would like to be able to specify if my strings are case-sensitive or not.


Anybody have any idea about how to do this? Any/all help/suggestions would be graciously appreciated.

BTW: here are the specs of my cart:
  • www.KeylessEntryLocks.com
  • Zen Cart 1.5.1
  • Sales Report - Version: 3.1.0
  • Linux 2.6.32-279.19.1.el6.x86_64
  • PHP Version 5.3.21
  • Database Patch Level: 1.5.1
  • anthing else you need, ju
This is a pretty extensive customization, and I'm not sure you're gonna find anyone that is gonna post this kind of solutution here on the forum. You may have to consider hiring someone to code these modifications for you..