-
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)
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; ?> </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 *******
-
Re: Sales report 2.0
Exactly what I was trying to say and do but in a much easier and understandable way.
Thank you!
-
Re: Sales report 2.0
I keep getting syntax errors. Can someone please post the correct code for this?
Thank you!
-
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:
Code:
**php code**
<?php ** start of php block
?>
-
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...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!!
-
Re: Sales report 2.0
Got it - From your pm it looks like a misalignment of <?php blocks. I PM'd a reply
-
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?
-
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
-
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.
-
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.
