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 621 to 640 of 882
23 Jul 2013, 2:47 AM
#621
jeking avatar

jeking

Totally Zenned

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

Sales report 2.0

The Sales Report will add a new item under your Report Menu called Sales Report. The default Zen Cart does not have such a menu item.

If you see Sales Report (and the admin url will end with /stats_sales_report.php), then it's installed correctly.

Jim
Wheaton Website Services

28 Jul 2013, 7:30 AM
#622
tinderbox avatar

tinderbox

New Zenner

Join Date:
Jun 2013
Location:
Perth Western Australia
Posts:
20
Plugin Contributions:
0

Re: Sales report 2.0

Hi,

I have installed the module and found it under the report tab in the admin area but when I click on it it gives me a 404 page not found error?

404 Page Not Found

Sorry! The page you requested is unavailable. Please use your browser's Back button, or go to the home page.

Is there something I have missed in the install?

Thanks

28 Jul 2013, 10:05 AM
#623
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Sales report 2.0

Tinderbox:

Hi,

I have installed the module and found it under the report tab in the admin area but when I click on it it gives me a 404 page not found error?

404 Page Not Found

Sorry! The page you requested is unavailable. Please use your browser's Back button, or go to the home page.

Is there something I have missed in the install?

Thanks

I would suggest you open the zip then manually upload each and every file, making absolutely sure you put it in the right place.

sometimes a file will corrupt on upload. you might have one of these.

make sure you upload the loose file that sits inside the main admin folder too

24 Aug 2013, 10:18 AM
#624
kalastaja avatar

kalastaja

Zen Follower

Join Date:
Mar 2010
Location:
Finland
Posts:
465
Plugin Contributions:
0

Re: Sales report 2.0

I have installed the module and it looks fine. The output is almost perfect for me!

The one thing missing (for me) is a separation of the different taxes based on the orders_total title! This is because I have two areas, so I need separate totals for both. Do I stand a chance?

30 Aug 2013, 4:01 AM
#625
kalastaja avatar

kalastaja

Zen Follower

Join Date:
Mar 2010
Location:
Finland
Posts:
465
Plugin Contributions:
0

Re: Sales report 2.0

The CVS format somehow messes up - I can't get to be proper CommaSeparatedValues!

30 Aug 2013, 5:03 AM
#626
kalastaja avatar

kalastaja

Zen Follower

Join Date:
Mar 2010
Location:
Finland
Posts:
465
Plugin Contributions:
0

Re: Sales report 2.0

HELP! I used custom time and lost many values - tax values among others! How can I get them back?

6 Sep 2013, 4:53 PM
#627
justynp avatar

justynp

New Zenner

Join Date:
Aug 2012
Posts:
17
Plugin Contributions:
0

Re: Sales report 2.0

I am having some issues. I need to include the following information:

Order ID, Product Name, Quantity, Price Sold for, Additional Fees, Total, Additional Discounts, Grand Total.

Currently, I have it showing all the above HOWEVER, if there were two orders the same day for the same product, it only shows 1 order number but adds both the orders together. I need it to show each and every product and order number... Suggestions? I have been trying to figure this out now for about 2 weeks to no avail.

Thanks.

6 Sep 2013, 8:09 PM
#628
justynp avatar

justynp

New Zenner

Join Date:
Aug 2012
Posts:
17
Plugin Contributions:
0

Re: Sales report 2.0

I can clearly see there is no support for this plugin.

5 Oct 2013, 10:53 PM
#629
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

If I were to want the report to show at the top of the page instead of under the Gather & Filter data table, can someone provide the code I need to move.

I thought it was ```
if ($timeframe_sort == 'desc') {
krsort($sr->timeframe);
}

// determine whether or not there are taxes
$display_tax =  ($sr->grand_total['goods_tax'] > 0 ? true : false);
// DEBUG
//$display_tax = true;

// determine if lines should have the rollover effect
$rollover = "";
if ($output_format == 'display') {
  $rollover = 'onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)"';

?>

<tr> <?php if ($_GET['doCustInc']== 'on' || $_GET['doProdInc']== 'on') { // if reporting for a specific product, build up a string of product descriptions $i = 0; $header_string = ""; $include_products = explode(",",$_GET['prod_includes']); if ($_GET['doProdInc']== 'on' && DISPLAY_TABLE_HEADING_PRODUCTS) { foreach($include_products as $cID) { $tempAry = $db->Execute("select distinct pd.products_name from " . TABLE_PRODUCTS_DESCRIPTION . " pd where products_id = " . trim($cID)); if ($i == 0) { $header_string = $tempAry->fields['products_name'] ; }........ ``` To the top by the </head> but the <tr> without a preceding <table> tells me I must have this wrong. Thanks for your help!
5 Oct 2013, 11:32 PM
#630
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

Try this - in admin/stats_sales_report.php, move the table that draws the header to after the table that draws the data. In abstract, this file:
Calculates stuff
Prints out the header
Prints out the data

Take this (around line 325 - 582 - page numbers might not be exact based on revision etc, but should be close)

****** start here *******
  // display the print header
  if ($output_format == 'print') {
    if ($auto_print) {
      echo '<body onload="print();">';
    }
?>
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <!-- PRINT HEADER -->
.
.
.
  <tr>
    <td align="left"><?php echo zen_draw_separator('pixel_trans.gif', 1, 15); ?></td>
    <td align="right" valign="top" id="td_wait_text" class="alert" style="font-size:12px; visibility:hidden"><?php echo SEARCH_WAIT_TEXT; ?>  </td>
  </tr>
<?php
  }  // END <?php if ( (!$output_format || $output_format = 'display') && $output_format != 'print')
****** cut here ********

And move it after around line 1140

.
.
.
  <tr>
    <td valign="bottom" class="smallText"><?php printf(TEXT_PARSE_TIME, number_format($parse_time, 5) ); ?></td>
    <td><?php echo zen_draw_separator('pixel_trans.gif', 1, 20); ?></td>
  </tr>
<?php
    }
  }  // END if ($output_format == 'print' || $output_format == 'display')
****** insert here *******
5 Oct 2013, 11:47 PM
#631
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

Exactly what I was trying to say and do but in a much easier and understandable way.

Thank you!

6 Oct 2013, 4:46 AM
#632
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

I keep getting syntax errors. Can someone please post the correct code for this?

Thank you!

6 Oct 2013, 3:38 PM
#633
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

I can't without knowing the exact version you're using, any mods made, etc. My own version is modified, so it might not work with the other files that make up the addon.

If you PM me that file, I could edit and return but probably couldn't test it. Or, let me know what syntax errors you're having.

One of the things I was watching for is whether you're inside a <php block or not at the points where you cut and paste. If this is mismatched, you'll have something like:

**php code**
<?php   ** start of php block

?>
6 Oct 2013, 5:43 PM
#634
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

I sent the pm over to you I think. When I check my sent box it is empty though. :( If you didn't get it the file is zipped at http://www.southshorepizza.net/stats_sales_report.php.zip

I only made one mode which was a meta refresh in the html header. I'm running Zen 1.5.1 with sales report 3.1.

thank you for your help!!

6 Oct 2013, 6:42 PM
#635
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

Got it - From your pm it looks like a misalignment of <?php blocks. I PM'd a reply

25 Jan 2014, 5:16 PM
#636
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

Goods value doesn't seem to add up correctly. I assume that goods value = all products full retail price added together. However order 18755 for example has $13.49+$6.50+$1.65+$7.99 for a subtotal of $29.63 before discounts. Then the emailed receipt has shipping of $2.50, discount of $1.00, Sales Tax of $2.19 and Total of $36.32. However Sales report has Goods Value of $27.55, Tax of $2.19, Shipping of $2.50, Discount of $1.00, Order total of $31.13. I don't understand how mathematically we go from $27.55-$1.00+$2.50=$31.13 My calculator always tells me that equals $29.05. What doesn't get calculated into Goods Value in a product and how do I correct that?

27 Jan 2014, 3:13 AM
#637
renz avatar

renz

Zen Follower

Join Date:
Jun 2006
Posts:
439
Plugin Contributions:
0

Re: Sales report 2.0

Hi There,

can anyone help with my Store Credit, plug in issue....and sales report 2. It would appear that any store credits, are not recorded by the report.

Any assistance would be appreciated.

Thanks
Regards
Renz

27 Jan 2014, 2:46 PM
#638
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

@southshorepizza, First, my math doesn't agree anyway - where you said $36.32, I calculated $33.32.

I suspect there's a discrepancy in the tax - I have a non-profit so I don't deal with tax, so I'm not totally clear here. Also, the $2.08 missing from the goods_total is suspiciously close to the tax value.

It looks like SR both calculates its own tax, and also uses the tax from the orders table. I'd probably need to walk through step by step to see what's calculated during the order process, how it's stored in the database, and how those values are extracted by SR and used in the output.

Another suggestion would be to make some test orders with values like $10, $100, $1000 - to see how different values are calculated and used. Best if you have an offline system that you can play with.

27 Jan 2014, 2:52 PM
#639
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

@renz, I'm not familiar with the store credit plugin. If you're looking to show accumulated credits on the report, that'd be a programming task. It might be tough, as the report is order oriented, not customer oriented.

If you want to see credits when they're applied to orders - this should work if the store-credit plugin is utilizing gift-certificates or coupons. I've used both of these and the outputs are there. If it uses another mechanism, it'd be another programming task but I think this would be easier since coupons are already supported.

27 Jan 2014, 3:18 PM
#640
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

@carlvt88 $36.32 included a $3.00 tip. But that isn't an issue as this happens with or without the tip being involved.

I guess what I'm not following is in order confirmation it looks as though includes/classes/order.php that saves the order and generates the emailed receipt saves everything to table_order_totals But the SR does not use that instead it uses table_orders as shown in admin/includes/classes/sales_report.php. It looks at each ordered product and then recalculates the subtotals. However it appears to be missing something.