Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

Started by blindside on 29 Aug 2006, 2:41 AM · Views: 248,185

Results 421 to 440 of 882
22 Apr 2010, 12:36 PM
#421
beinart avatar

beinart

New Zenner

Join Date:
Sep 2009
Posts:
11
Plugin Contributions:
0

Sales report 2.0

carlvt88:

Yes it does. You can specify a date range (choose date of purchase, or another date such as date shipped / rejected / status changed). Then within that date range (grouped by day / week / month / year), you can summarize, or list sales per part number, or sales per order.

I've done some customization on my own to add check boxes so I can list only particular items. Works for me because I only have about twelve part numbers.

You can also export the report to a csv file.

Thank you! I would only be interested in listing particular items as well. I'd like to pay someone to install this addon for me. Would you be interested in installing this on my site with your customization? I'm worried that I'll stuff it up.

22 Apr 2010, 2:21 PM
#422
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Yes - I'll send you a PM to discuss

25 Apr 2010, 2:16 PM
#423
jamie2k avatar

jamie2k

New Zenner

Join Date:
Oct 2006
Location:
Suffolk UK
Posts:
55
Plugin Contributions:
1

Re: Sales report 2.0

wolfderby:

If you'd like to remove "cancelled" orders from the sales report data (marked "cancelled" through a manually created order status, under admin > localization > order status > "insert")...

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

$orders_status = $db->Execute("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . "
                               where language_id = '" . (int)$_SESSION['languages_id'] . "'
                               order by orders_status_id asc");
> ```
$orders_status = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . "
                                   WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND NOT (orders_status_id = 5)
                                   ORDER BY orders_status_id asc");
```(note: my cancelled order status was the 5th possible status under order status, if your status has a different id number you'll have to change the orders_status_id to the appropriate number)
> 
> for other information regarding cancelled orders check here:
> <http://www.zen-cart.com/forum/showthread.php?t=151168>


**Shout if i am wrong but... This does not remove the canceled  orders from the report, it simply removes the canceled orders from the  list of choices in the drop down... 

Anyone have the actual code edits to not only remove canceled orders  from the choices, but also to remove them from the report results ???**
25 Apr 2010, 2:25 PM
#424
jamie2k avatar

jamie2k

New Zenner

Join Date:
Oct 2006
Location:
Suffolk UK
Posts:
55
Plugin Contributions:
1

Re: Sales report 2.0

psr racing:

Does this happen for anybody else? Any way to fix it or modify it so it just adds the order totals together?

I am having the same issue here !! Has anyone worked out a solution to this issue ?

25 Apr 2010, 3:06 PM
#425
jamie2k avatar

jamie2k

New Zenner

Join Date:
Oct 2006
Location:
Suffolk UK
Posts:
55
Plugin Contributions:
1

Re: Sales report 2.0

jamie2k:

I am having the same issue here !! Has anyone worked out a solution to this issue ?
It appears this has been fixed with the latest release :) Sales Report 2.2

Thanks guys... great MOD :)

4 Jun 2010, 4:43 AM
#426
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Sales report 2.0

suksuk:

Hello!

I installed version 2.2.0 and can see that I can group orders by month, but I would also like to further separate them by customer ID. Is this possible?

If not, does anyone know if there is a similar contribution that can do this, i.e. "view orders by customer per month"?

Thanks!

edit: I see that I can already display by "Order ID" - is it possible to group the results together that are by the same customer? I have a bit of PHP/MySQL experience so am prepared to do some hacking if needed - just need to be pointed in the right direction!

Bump.

Any info on how to do this. Viewing orders by customer would be very helpful.

Jim
Wheaton Website Services

4 Jun 2010, 12:37 PM
#427
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

You can now group by order ID, and sort by cust lastname. Is this close enough to where you need to be, or do you need to group by customer?
My approach would be to follow the model of the current groupings - that is, in addition to 'product line items' and 'order line items', I'd make a 'customer line items'. Then collect the details in includes/classes/sales_report.php:build_timeframe. You'd need to add a function build_li_customers (similar to build_li_products). In the main php file, you'd need to add the option to the menus and the html for displaying properly.

4 Jun 2010, 1:15 PM
#428
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Sales report 2.0

carlvt88:

You can now group by order ID, and sort by cust lastname. Is this close enough to where you need to be, or do you need to group by customer?
My approach would be to follow the model of the current groupings - that is, in addition to 'product line items' and 'order line items', I'd make a 'customer line items'. Then collect the details in includes/classes/sales_report.php:build_timeframe. You'd need to add a function build_li_customers (similar to build_li_products). In the main php file, you'd need to add the option to the menus and the html for displaying properly.

It gets me very close. The sort by cust lastname report doesn't include the products the customer ordered and that's what I need. A report the lists the customer and how many or what items they ordered in a certain time frame.

The current set-up separates product line items and order line items. If I could just combine both lists so I can select one item from product line and one from order line, I think that would do it. Can that be done?

Jim
Wheaton Website Services

4 Jun 2010, 11:19 PM
#429
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

I have a module that might do it for you - would you be willing to test it?
It allows you to run the usual sales report options (timeframe, order detail, product detail, sorting, etc) but allows you to limit the results to one or multiple customer IDs and/or product IDs.

4 Jun 2010, 11:26 PM
#430
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Sales report 2.0

Absolutely, I'll send you a PM.

Jim
Wheaton Website Services

9 Jun 2010, 2:24 AM
#431
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Jeking - Thanks for your help in testing and giving good feedback. I've submitted a final copy as an update to the sales report package.

Beinart - This should provide the functionality you're looking for too.

It's based off of the 2.2.0 release, so it should have those bug fixes in as well.

18 Jun 2010, 6:35 PM
#432
lpettyjohn avatar

lpettyjohn

New Zenner

Join Date:
Jun 2010
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

I need the reporting by customer as well. I have yearly maximums set for each of my products and need to generate reports to show the quantity of each item a specific customer ordered over a calendar year.

If the current version of Sales Report can generate such a report, can anyone provide instructions on how to do so? Or, if the updated version of Sales Report 2.0 is ready for use, where can I download it? The latest version available was posted in December 2009.

I'm really looking forward to this reporting. It is an integral part of the management of my store.

~Lindsey

18 Jun 2010, 6:48 PM
#433
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

The latest version allows you to specify one or more customers and it merges them together. If this is good, PM me and I can send you a copy.

I posted it to the add-ons section. It said it would take a week to get approved, but this was a while ago now.

What it doesn't do is break out the list by customer, in the way it breaks it out by product number or order number.

18 Jun 2010, 7:29 PM
#434
lpettyjohn avatar

lpettyjohn

New Zenner

Join Date:
Jun 2010
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

I'm looking for a report where I can display the following:

  • Pull data and generate report by customer name or ID
  • Displays the all individual product names the customer ordered
  • Displays the quantity of each product the customer ordered
  • Report sorted by the date order was placed, date range specific.

Is this what your add-on update can do?

19 Jun 2010, 9:31 PM
#435
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Yes, it can do this.

29 Jun 2010, 10:23 PM
#436
osaeed avatar

osaeed

New Zenner

Join Date:
Jan 2010
Posts:
51
Plugin Contributions:
0

Re: Sales report 2.0

when I click on this Yesterday (June 28) and click show me the money.. It shows todays sales (june 29th)

Now I dont have any orders on June 28th, because I deleted them.

If i specify a date like June 1 2010 - june 28th 2010.. i just get todays date showing.

Does it only show orders that were made on a specific day?

Because i had a test order on june 28th and today i went to see if it would show anything on June 28th, and nope it didnt. It would just list June 29th 2010 only..

Also, i like specified a custom date and I just get this

6-29-2010 thru
6-29-2010

is that normal?

thanks

30 Jun 2010, 12:20 AM
#437
osaeed avatar

osaeed

New Zenner

Join Date:
Jan 2010
Posts:
51
Plugin Contributions:
0

Re: Sales report 2.0

WOW! Holy Crap it works.

I deleted all the files for sales report, installed it. Then I had two test orders I made today June 29. So one of the test orders I went into the database via phpmyadmin, and changed the data from june 29 to june 28 and went back to sales report and click on Yesterday and the report showed the order june 28 and I WAS OH MY GOD THIS WORKS!

Thank you. Now I just need to understand how to use some of the options.

30 Jun 2010, 1:01 AM
#438
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Glad it's working. Just for fun, I dug in and found where the dates entered are used. They generate an SQL query that's >= to the start date AND < the end date+1. All times assume midnight, so your custom date would be ```
SELECT DISTINCT o.orders_id from zen_orders o
WHERE o.date_purchased >= '2010-06-29 00:00:00' AND o.date_purchased < '2010-06-30 00:00:00'
ORDER BY o.orders_id DESC


If you're using presets, and it says "Yesterday (6/29)", it'll do the search for transactions marked in the database 6/29.

My host is actually in a different timezone, those are the times entered in to the database when the transactions happen.
16 Jul 2010, 4:17 PM
#439
beatmaker avatar

beatmaker

New Zenner

Join Date:
May 2007
Posts:
91
Plugin Contributions:
0

Re: Sales report 2.0

Please excuse my ignorance if this has already been discussed... but one feature of the Sales Reports that would absolutely be phenomenal would be the option to show 'attributes'.

For example. I run a store that sells apparel items. Often I want to know what is my best selling sizes. I'd love to be able to select a group of item, and see what the best selling size is for those items (i.e. mens tshirts).

Also, one thing that always bugged me was there is no 'forever' option on the sales reports. I can pull a sales overall report by day, week, month, and year... but there is no 'forever' option to show all sales reported for the entire time I started running my store up to today. That would be incredibly useful. Especially given the option above... say I wanted to see how many XL's I've sold since I started the store.

Can someone clue me in? Is this possible? Or can it be?

16 Jul 2010, 5:40 PM
#440
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

BEatMaKeR:

Please excuse my ignorance if this has already been discussed... but one feature of the Sales Reports that would absolutely be phenomenal would be the option to show 'attributes'.

For example. I run a store that sells apparel items. Often I want to know what is my best selling sizes. I'd love to be able to select a group of item, and see what the best selling size is for those items (i.e. mens tshirts).
The Sales Report is designed to exactly that, report sales. Reporting based on attributes of a given product is completely different, logically speaking. Without getting into the nitty gritty, what you're looking for would require a complete rewrite to logic at work in building the report.

Also, one thing that always bugged me was there is no 'forever' option on the sales reports. I can pull a sales overall report by day, week, month, and year... but there is no 'forever' option to show all sales reported for the entire time I started running my store up to today. That would be incredibly useful. Especially given the option above... say I wanted to see how many XL's I've sold since I started the store.

Can someone clue me in? Is this possible? Or can it be?
That's a deliberate decision. The Sales Report queries are massive. If you don't specify a range you are very likely to hang and possibly crash your database. Unless things have changed since I last touched the code, there's actually a max date range limit hardcoded into it, to avoid screwing yourself. :)

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com