Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Custom Sales Reports by Product (item total and by qty)

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #91  
Old 04-10-2011, 06:48 AM
 
Learner Learner is offline
 

X-Adept
  
Join Date: Dec 2008
Posts: 807
 

Default Re: Custom Sales Reports by Product (item total and by qty)

Quote:
Originally Posted by Charon
I am close to completing add-on module for report development and export. It is taking so long since I have my many regular jobs that take priority. I hope to have it done in the next month. When I do I will let anyone interested know here in this forum.

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.
__________________
4.6.1 Platinum


Reply With Quote
  #92  
Old 04-26-2011, 09:44 PM
 
xtech xtech is offline
 

X-Adept
  
Join Date: Jun 2010
Posts: 605
 

Default Re: Custom Sales Reports by Product (item total and by qty)

Quote:
Originally Posted by Charon
I am close to completing add-on module for report development and export. It is taking so long since I have my many regular jobs that take priority. I hope to have it done in the next month. When I do I will let anyone interested know here in this forum.

Let me know when you release your mod...
__________________
X-cart Platinum
4.6.1
Reboot template
Reply With Quote
  #93  
Old 07-12-2011, 01:04 PM
 
phrayzer phrayzer is offline
 

Member
  
Join Date: Oct 2005
Posts: 16
 

Default 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
Reply With Quote
  #94  
Old 07-20-2011, 05:48 PM
 
phrayzer phrayzer is offline
 

Member
  
Join Date: Oct 2005
Posts: 16
 

Default 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
Reply With Quote
  #95  
Old 07-20-2011, 06:14 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default 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
Reply With Quote
  #96  
Old 07-23-2011, 10:07 AM
 
phrayzer phrayzer is offline
 

Member
  
Join Date: Oct 2005
Posts: 16
 

Default Re: Custom Sales Reports by Product (item total and by qty)

Quote:
Originally Posted by cflsystems
Email me with details what you need and I can give you a 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
Reply With Quote
  #97  
Old 10-10-2012, 08:03 AM
 
Dougrun Dougrun is offline
 

X-Adept
  
Join Date: Apr 2012
Posts: 895
 

Default 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
Reply With Quote
  #98  
Old 08-01-2014, 03:52 AM
 
katfal36 katfal36 is offline
 

Member
  
Join Date: May 2012
Posts: 24
 

Default 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
Reply With Quote
  #99  
Old 09-04-2014, 08:00 PM
  while.e.kyote's Avatar 
while.e.kyote while.e.kyote is offline
 

Senior Member
  
Join Date: Mar 2013
Posts: 136
 

Default 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.
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 07:31 AM.

   

 
X-Cart forums © 2001-2020