| ||||||||||
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 |
#21
|
|||||||
|
|||||||
Quote:
Exactly what SQL query are you using, and what error is it giving you?
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#22
|
|||||||
|
|||||||
Code:
I am using this sql query , the page not finishing when I run this. But in the first example the page works fine , I only need to eliminate status C and P position in sql query. |
|||||||
#23
|
|||||||
|
|||||||
You are ok, it's no biggie. I think the reason is because the database structure is different in your version. If you want, look in your orders table and find the column that lists C, P, Q, etc. It may be named different, but I don't have your version so I can't check.
Let me know if you need more assistance.
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#24
|
|||||||
|
|||||||
its writen same 'status'
|
|||||||
#25
|
|||||||
|
|||||||
Quote:
You can just ignore the status == C and status == P part of the query. This was not in the original code, someone else suggested this, so you will be fine without it in there. Jeremy
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#26
|
|||||||
|
|||||||
But I need to use P and C filter
|
|||||||
#27
|
|||||||
|
|||||||
Can anyone using 3.3.3 check the database structure for the status of orders? Is the table/field name xcart_orders.status? Have the abbreviations changed (are they different from C,P,Q,D,F,etc)?
As I do not have 3.3.3 I am stuck here. Any help? Jeremy
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#28
|
|||||||
|
|||||||
Quote:
Hi, People seem to be having trouble implementing this, I just wanted to let you know that it works perfect for me so you wouldn't feel that the script only worked on your server. Couple of comments though, the above code I mentioned above does not work, it will cause the script to only list one product and credit it with insane sales of 99 in qty and 300,000 in total. The right code is: Code:
I don't think it would be that difficult to implement this into xcart's admin area, you just have to take out the non php related material and save that as the tpl file, create a link in the menu, and link it in the home.tpl area. I'm pretty sure someone will crack it. Thanks for the mod, its excellent! |
|||||||
#29
|
|||||||
|
|||||||
Thanks for the SQL update. I appreciate it. Glad it's working on your site...
__________________
Jeremy X-Cart Gold v3.4.14 [Linux/Apache] Heavily Modded |
|||||||
#30
|
|||||||
|
|||||||
When i try to run it i get this error message:
Report Range: .. through .. Product Item Total Quantity Error in query.You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc' at line 1 The year are falling back to 0000 and there's no other year to choose. |
|||||||
|
|||
X-Cart forums © 2001-2020
|