Sales report 2.0

**carlvt88** · 6 Oct 2013, 12:32 AM

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)

Code:

****** 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; ?>&nbsp;&nbsp;</td>
  </tr>
<?php
  }  // END <?php if ( (!$output_format || $output_format = 'display') && $output_format != 'print')
****** cut here ********

And move it after around line 1140

Code:

.
.
.
  <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 *******

**southshorepizza** · 6 Oct 2013, 12:47 AM

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

Thank you!

**southshorepizza** · 6 Oct 2013, 05:46 AM

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

Thank you!

**carlvt88** · 6 Oct 2013, 04:38 PM

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:

Code:

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

?>

**southshorepizza** · 6 Oct 2013, 06:43 PM

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...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!!

**carlvt88** · 6 Oct 2013, 07:42 PM

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

**southshorepizza** · 25 Jan 2014, 06:16 PM

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?

**Renz** · 27 Jan 2014, 04:13 AM

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

**carlvt88** · 27 Jan 2014, 03:46 PM

@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.

**carlvt88** · 27 Jan 2014, 03:52 PM

@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.

Thread: Sales report 2.0

Thread Tools

Search Thread

Display

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Re: Sales report 2.0

Similar Threads

v139b Sales Report

Sales Report

Sales report

Posting Permissions