| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Custom Sales Reports by Product (item total and by qty) | ||||
|
|
Thread Tools | Search this Thread |
#41
|
|||||||
|
|||||||
It very well could be that you are using v4.x. I have only been able to test this on 3.4.x. Maybe other users that have run this script on 4.x can give some advice?
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#42
|
|||||||
|
|||||||
Hey Jeremy
I just got it to work! I took out the first four lines (the logging in part)...what negative effects would this have on my site? Would hackers be able to get through via this channel? Thanks!
__________________
... v 4.0.18; 4.1 |
|||||||
#43
|
|||||||
|
|||||||
First, they would have to know the exactly name of the reports file. You can check this by logging out of your admin area and open up a new browser window and type in the reports URL directly and see if the reports come up. If they do, the report is not secure.
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#44
|
|||||||
|
|||||||
I have found that if you remove the first two require lines from this page it will then work with the 4.XX branch.
Hope this helps.
__________________
Xcart Version: 4.1.6 |
|||||||
#45
|
|||||||
|
|||||||
I have found that if you remove the first two require lines from this page it will then work with the 4.XX branch and it still requires auth to use it.
Hope this helps.
__________________
Xcart Version: 4.1.6 |
|||||||
#46
|
|||||||
|
|||||||
Quick Question. I have modified this form to include the ability to specify the sku number that I want to look at. Can anyone think of an easy way to specify a range of sku's?
For example instead of typing 38-9005 I could type 38-* or a range like 38-9000 - 38-9999. This would be a big help! Thanks.
__________________
Xcart Version: 4.1.6 |
|||||||
#47
|
|||||||
|
|||||||
Quote:
Thanks for the update. I'm sure other users will appreciate that.
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#48
|
|||||||
|
|||||||
Hey, regarding your SKU question, that should be easy enough.
Modify the main SQL query to something like : Code:
That will specify all products that start with "38-" (the % is wildcard). I'm not sure the range query will always work, but you could try: Code:
Hope that helps.
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#49
|
|||||||
|
|||||||
Ok here is the query that I have but it does not seem to work.
Code:
I am not experienced with the LIKE portion of this query so I am sure that I am doing it wrong. if I change this Code:
to look like this Code:
It will work. But I do not want to hard code the 38- portion because we have a large number of sku's that start with a range of numbers. Where did I go wrong? Thanks! Cameron
__________________
Xcart Version: 4.1.6 |
|||||||
#50
|
|||||||
|
|||||||
Ok here is the query that I have but it does not seem to work.
Code:
I am not experienced with the LIKE portion of this query so I am sure that I am doing it wrong. if I change this Code:
to look like this Code:
It will work. But I do not want to hard code the 38- portion because we have a large number of sku's that start with a range of numbers. Where did I go wrong? Thanks! Cameron
__________________
Xcart Version: 4.1.6 |
|||||||
|
|||
X-Cart forums © 2001-2020
|