| ||||||||||
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 |
#91
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
Quote:
Hi Charon, I have sent to my requirements and pm you but cannot get any answer..Ok I am still waiting for your new release of the modules regarding advance report manufacturer wise so and so. Kindly let me know your release date and where to purchase the mod. Thank you. |
|||||||
#92
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
Quote:
Let me know when you release your mod...
__________________
X-cart Platinum 4.6.1 Reboot template |
|||||||
#93
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
Can anyone tell me if this script works for 4.4.2? Or could they post the script that works for 4.4.2?
I just want a simple report per month of the # of each item sold. We don't have variants. Also can someone confirm that it does not write to the database, only read from it? Thanks!
__________________
X-Cart version 4.4.2 |
|||||||
#94
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
I'm willing to pay someone for this script!
Don't need anything fancy, just looking for the total # of each item sold per month in an easy to generate report. Thanks, Fraser
__________________
X-Cart version 4.4.2 |
|||||||
#95
|
|||||||||
|
|||||||||
Re: Custom Sales Reports by Product (item total and by qty)
Email me with details what you need and I can give you a quote
__________________
Steve Stoyanov CFLSystems.com Web Development |
|||||||||
#96
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
Quote:
Really it is simple: Just looking for the total # of each item sold per month in an easy to generate report I can print out. If it could be downloaded as a CSV it would be best. It seems that this thread describes what I am looking for but has a ton of modifications over time. Thanks!
__________________
X-Cart version 4.4.2 |
|||||||
#97
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
did this ever get completed?? I'm on 4.5.3
I can get the selection page to load but anything i select just returns me to the selection page, no report results. no error message.
__________________
4.7.x xcart store Business 5.4xx |
|||||||
#98
|
|||||||
|
|||||||
Re: Custom Sales Reports by Product (item total and by qty)
Hi, yes this thread is a couple years old I have tried some of the code here, so far haven't gotten it to work though
We want to upgrade eventually to multivendor version of xcart, but need this in a hurry for one user provider that doesn't need to see all the info in the backend and doesn't need to see order info either, but want to see sales of his one product. My thought is to place his products in it's own category and show sales stats of products in this category only in a restricted admin, which I was able to create using this code http://forum.x-cart.com/showthread.php?p=375730#post375730 Has anyone done such a customization? Most of what I have seen by way of upgrade or mod have way too many features that aren't needed presently and I was hoping to do a quick view for one person to see sales from one category.
__________________
X-Cart Gold 4.5.1 Linux Dedicated Server Mods: XMenus., XBanners, BCSE Testimonials, BSCE Abandoned Cart |
|||||||
#99
|
|||||||||
|
|||||||||
Re: Custom Sales Reports by Product (item total and by qty)
Run this sql at the end of the month -- cronjob for just before midnight works best tested on 4.5.4 - YMMV
select a.orderid, from_unixtime(b.date), a.productid, a.productcode, a.product, a.price FROM xcart_order_details a, xcart_orders b WHERE a.orderid in ( select orderid from `xcart_orders` where status in ('S','P',' ') and EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date)) = EXTRACT(YEAR_MONTH FROM SUBDATE(CURDATE(), INTERVAL 1 DAY)) ) and a.orderid = b.orderid; Or this one daily .. select a.orderid, from_unixtime(b.date), a.productid, a.productcode, a.product, a.price FROM xcart_order_details a, xcart_orders b WHERE a.orderid in ( select orderid from `xcart_orders` where status in ('S','P',' ') and EXTRACT(YEAR_MONTH FROM FROM_UNIXTIME(date)) = EXTRACT(YEAR_MONTH FROM SUBDATE(CURDATE(), INTERVAL 1 DAY)) and EXTRACT(DAY FROM FROM_UNIXTIME(date)) = EXTRACT(DAY FROM SUBDATE(CURDATE(), INTERVAL 1 DAY)) ) and a.orderid = b.orderid;
__________________
X-Cat 4.5.4 & (1/2) Live June 1, 2013. |
|||||||||
|
|||
X-Cart forums © 2001-2020
|