Printable View
ok, did that Kathy, will look at the report and see what difference that made..thank you...
The coupon codes weren't "figured" in the old report...you still had to go in and see which one was discounted...but when you went into paypal ipn it took all the zero balances off...this new one was leaving in coupon codes that the dt was using to get kits...not sure I understand why...
I am having the same problem with the report--- I have included a little snippet, showing what is happening. I tried Kathy's suggestions and turned off the stock counting features in the admin panel.
--------------------------------------
Prod ID Product Name 2 Model No. 1 Base Price Qty. Product Total
49 Frame Freebie KSHUL_frame $0.00 100 $0.00
144 Simply Christmas KSHUL_simply-christmas $5.99 0 $0.00
117 Fast Scrap - Collection # 1 KSHUL_template-set1 $2.99 100 $299.00
136 Fast Scrap - Collection # 2 KSHUL_templates-set2 $2.99 100 $299.00
--------------------------------------
144 Simply Christmas KSHUL_simply-christmas $5.99 0 $0.00 ---- on this one I went in and changed the stock to "zero" manually to see what would happen-- and the product Total is now showing up as a zero. So, it IS multiplying the Base Price by the Quantity.
Any idea how to fix this?
Thanks in advance!
Kelly
Wow Kelly! Thanks for checking that! It sure looks like that's what it is doing huh...
Yes, the way I used to pull the coupon discounts out was by running it by paypal ipn and by going through and manually checking all the invoices with discounts on them. I was trying to say that I 'wished' that it would automatically deduct the coupons/discounts from the sales totals, not that I had ever had that capability.
Well, I learned two new things today. First I learned that the field name "products_quantity" is used for both stock quantity (products table) and quantity purchased (orders_products table). Guess I never noticed it.Quote:
Originally Posted by kellyshults
Then I learned that, unless specified, field values output by MySQL in a join default to the one in the first listed table, if not specified.
In other words, adding the products table to the query (where the manufacturer is stored) introduced a second field with the same name, resulting in calculating with the wrong quantity. It's always the little things.
So, the bug is found and fixed (finally!). Thanks to kellyshults et. al. for your continued feedback. Like I said I don't use manufacturers, so I never would have found it myself. Your support is definitely appreciated! :thumbsup: I'll submit a new version (rev 104 or higher) later tonight, so look for it in the next day or so (has to get approved).
I love learning! :blink:
FANTASTIC! Thanks for checking on this! Can't wait to get the fixed version.
Thanks so much!
Just saw that the new version is posted. Enjoy.
Great news and again a big thanks to Blindside for this excellent sales report, and now consistent & powerful filter by manufacturer!
We are a company that sells by numerous manufacturers and will eliminate all of the excel list sorting to work out how much and by whom!
wantthelook.com (wtl)
Glad you found it so useful, wtl. There is donation info at the bottom of the README. :wink2:
Haven't seen this specific issue posted. Report appears to be presenting two different values for tax. In attached file, note that 6% tax on 39.90 IS $2.39 and shows and calculated correctly in the timeframe line, BUT same tax is being reported and calculated into the total as only $2.00.
This is on a fresh install of 1.3.5 with the following installed:
superorder2
ty pkg tracker
Sql Backup
cc_accept sidebox
mfgr sidebox
sitemap sidebox fix
column layout
email archive
email addr exporter
encypt passwd
EZ populate
image handler 2
impr attrib controller
paypal session viewer
quick updates
scrolling specials
user tracker
I am having issues with the Sales Report module booting me out of the system when I run a Report. I gather and filter my data by inputting the date ranges, set time frame to "DAILY" and then choose GENERATE REPORT, "Show me the Money".
At that point is generally where the log-in page comes up again. This happens, I would say 90 percent of the time.
Is this related to a Session setting in the Admin CP?
Thanks again,
Kristen
Do you have any products ignored? From the comments in the language file, pay attention to the bolded portion...Quote:
Originally Posted by docfx
Code://////////////////////////////////////////////////////////
// EXCLUDE SPECIFIED PRODUCTS
// Prevents specified products from appearing on the sales
// report at all. **ADDING PRODUCTS TO THIS DEFINE WILL
// IMPACT TOTALS CALCULATIONS!**
//
// The value of the product will be excluded from totals
// for gc_sold, gc_sold_qty, goods, num_products, and
// diff_products.
//
// The values for gc_used, gc_used_qty, discount,
// discount_qty, tax, and shipping all come from the
// orders_total table, and so CANNOT be excluded based
// on product ID.
//
// If an order is made up entirely of excluded products,
// and has no shipping, discounts, tax, or used gift
// certificates, it will have a total of 0. In this
// situation, the order will not be displayed in the results.
Possibly. The report does nothing with session settings, and this issue has been reported many times by many users across different pages in the Admin. Do some forum searching to look for possible solutions.Quote:
Originally Posted by krizzle
thanks blindside for the reply. Unfortunately, no... there are no excluded products. I had run into that tidbit in an earlier thread and have already removed the items in there from the rev 95 version I had previously installed. I've sinced upgraded it to rev 104.
This is a test cart w/ only the one product. The /admin/includes/languages/stats_sales_report.php file shows:
define('EXCLUDE_PRODUCTS', serialize(array( )) );
The error in the report appears to be specific to one section of the report. Tax is shown correctly in the timeframe header section, NOT correctly when '+Product Line Items' is selected, shown correctly when '+Order Line Items' is selected, and correct in the grand total section. If I had to guess, it might be coming from the /admin/includes/classes/sales_report.php script, where it seems that tax is getting calculated.
I've completed a 2nd test w/ similar, albeit worse results.
1st order, 2 items @ $19.95 = 39.90 + 6% (should be $2.39) +ship of $0. Prod line shows $2.00
2nd order, 4 items @ 19.95 = 79.80 + 6% (4.79) + ship of $7. Prod line shows a tax of $5.00
The grey timeframe report sections both show tax correct. The brown prod sections do not, the green total shows correct. If I didn't know better, it looks to be rounding to an even dollar amount.
yes, i've been looking...thanks.
This is a great mod with a lot of promise, however as docfx said it has some issues calculating the tax. Also I can not seem to see the shipping costs in the reports either. In a perfect world I would like to see the products name, sub total, tax, shipping, and total. right now with no shipping costs and the miscalulated tax it is not usefull for my purposes. does anyone have a fix for this? If not any alternatives?
Thanks
I notice that when I use +order line Items that the tax is correct and shipping is also included, but using that method I can not sort by product as I can using the +product line Items. My point is that Im hoping that the answer to the miscalculated tax and lack of shipping lies in the +order line item as it seems to be fine.
Great job on Sales Report Blindside.
Do you know if when I click on an order line I can get it to open in a new window instead of the same window?
Also I tried changing the DisplayInformation to +order by default but it does not work. Any ideas. I changed it in the language file.
Thanks.
@ docfx & wapnoj:
I went through the code and couldn't find anything that would cause the tax discrepancy you are seeing. However, I did realize that the Sales Report uses zen_calculate_tax() to process the tax values per product, and remembered that the most recent version of Zen Cart had bug fixes to rounding errors with taxes. So, what version are running? If it's not v1.3.6, at least download it and pull the latest version of zen_calculate_tax() into your installation. You'll need to edit includes/function/functions_taxes.php.
Thanks! :happy:Quote:
Originally Posted by m8trixdg
Yes it's possible but will require some editing and some JavaScript chops. You have to edit the admin/stats_sales_report.php file. Look for the following comment code:Quote:
Do you know if when I click on an order line I can get it to open in a new window instead of the same window?
Then, go down about 20 lines from there and find this line:Code:<!--ORDER LINE ITEM HEADER-->
See, because it's an "onclick" event, you can't just use target="_blank". You'll need to include a popup window JS function, then wrap everything inside the onclick within it. So it would look something like the following (new stuff in bold)...Code:<tr class="lineItemRow" <?php echo $rollover; ?> onclick="document.location.href=<?php echo '\'' . zen_href_link(FILENAME_ORDERS, 'oID=' . $o_data['oID'] . '&action=edit', 'NONSSL') . '\''; ?>">
Code:<tr class="lineItemRow" <?php echo $rollover; ?> onclick="mypopup(document.location.href=<?php echo '\'' . zen_href_link(FILENAME_ORDERS, 'oID=' . $o_data['oID'] . '&action=edit', 'NONSSL') . '\''; ?>)">
It must match exactly as it appears in the comments next to the default defines. For order line items you need the following...Quote:
Also I tried changing the DisplayInformation to +order by default but it does not work. Any ideas. I changed it in the language file.
Code:define('DEFAULT_DETAIL_LEVEL', 'order'); // ['timeframe'], 'product', 'order', 'matrix'
Quick question that may be a 'silly' one but... here goes... after reading the forums for several hours on this matter I have no better ideas than to bug you
;-)
If I run the sales report and do not see the 'tax' column does that mean there was no tax charged? I do not even see a column for tax, though screen shots of this mod imply that I should see a column for taxes even if they =0
So, since I do not see a column, what do I need to check, or... where did I go wrong...?
I was using the 'old' version of this mod and recently upgraded - not sure if it used to show up (though I THOUGHT it did) but now it is time to run those reports and I can find no tax info. Any help would be appreciated, especially if it is some dumb move on my own part which led to this.
:-)
Thanks!
Well it's a good thing I don't have anything better to do. :PQuote:
Originally Posted by redheads
Incorrect. Tax columns do not display if there are no taxes at all for the given timeframe. So if your timeframe has 3 orders, and 1 has taxes, all will show the tax columns. However if all three orders have no taxes, no tax column is displayed.Quote:
If I run the sales report and do not see the 'tax' column does that mean there was no tax charged? I do not even see a column for tax, though screen shots of this mod imply that I should see a column for taxes even if they =0
You went wrong with your tax setup, since it would seem that taxes aren't being charged on your orders in the first place. A quick look at your order details for one of these orders would confirm. Hit the FAQ section and look up the tax documents.Quote:
So, since I do not see a column, what do I need to check, or... where did I go wrong...?
Ok, that is what I needed to know. Thanks!:DQuote:
So if your timeframe has 3 orders, and 1 has taxes, all will show the tax columns. However if all three orders have no taxes, no tax column is displayed.
Or that we did not sell to anyone in CA that week - I hope that is the problem, :unsure: certainly possible. Will track it down and pay the tax folks. :ohmy:Quote:
You went wrong with your tax setup, since it would seem that taxes aren't being charged on your orders in the first place. A quick look at your order details for one of these orders would confirm. Hit the FAQ section and look up the tax documents.
THANK YOU!!
Oh, and since you have nothing else to do... LOL
Is it also true that I should have some way of reporting/sorting by state? That would simplify this tax search, and it seems quite a few people mentioned sorting by state... am I on the right mod? I did read every thread in the forum last night and might be a bit lost - :P
Thanks!
If you only collect CA taxes, then I'd say that's definitely the scenario.Quote:
Or that we did not sell to anyone in CA that week - I hope that is the problem, certainly possible. Will track it down and pay the tax folks.
I'm afraid you're probably thinking of another report. This sorts by manufacturer, but not by state.
I suppose it could, but that would definitely get ugly. What if billing and shipping are different states, for example...
I'm running v1.3.5, but grabbed the latest 1.3.6, compared the two php scripts. I see nothing different betwixt the two, but my eyesight aint whut is once was. Nonetheless, I swapped the v1.3.6 code for the 1.3.5 code and no change. Sample order of 4 items @ $19.95 ea w/ MI 6% tax on $79.80 should be $4.79 (which is does show in the actual order). But the same item in Sales Report is showing as $5.00.Quote:
Originally Posted by BlindSide
Okay, I'll keep looking. Meantime I should remind everyone that this is all volunteer effort, so you should always be looking to solve your own problems. Please don't take that the wrong way (especially you, docfx), I just get some requests for immediate support on issues in a very precise scenario that I could never recreate.
In short, I'm happy to help, but it's still your store, and you're not paying me. :wink2:
Blindside:Quote:
Originally Posted by BlindSide
no offense taken... many lose sight that this is all volunteer and to the benefit to all to werk together to make zen even better. That said... I went back into the suspect code in /admin/includes/classes/sales_report.php and stomped around your code a bit more... and got it to calculate tax correctly by changing the following in the "// build product line items (if requested)" section :
changed this:
$product_tax = (zen_calculate_tax($onetime_charges, $tax)) +
(zen_calculate_tax(($final_price * $quantity), $tax));
to this:
$product_tax = (zen_calculate_tax(($final_price * $quantity), $tax));
to my knowledge, I have NO one-time charges applicable here. I DO have a one-time charge attached to an attribute OF this item - BUT have not ordered the item WITH that attribute (ie T-shirt in XXXL is +$1.00, but I've only ordered the XL so the additional $1 is or shouldn't be in play).
However, if you follow the logic of this sample order... 4 items @19.95 = 79.80 => 6% tax = 4.78. If, I add the 4 unused one-time charges of $1 each (for the XXXL shirt that I'm NOT ordering I get another $0.23 in tax (or much closer to reported $5.00 tax.
The test item IS set to be priced by attribute, w/ a base price $19.95. Only the attribute of XXXL add a buck.
Hence, when I remove the code, the report shows tax correctly. This is not a fix, but is, perhaps, a symptom to look at.
Definitely a place to start! Thanks and good work!
Sorry, this is a blind alley... didn't fix the symptom after all. Problem still exists in PROD section of report, but not in the TIMELINE or ORDER sections of report. Turned on the "DISPLAY ONE-TIME FEES" category in the report and it shows 0 in fees.Quote:
Originally Posted by docfx
<sigh>back to the drawing board</sigh>
BlindSide,
Just an FYI - I needed a quick tax report by region, so I started with your Order Line Items report and modified it to print tax region line items. Each line item is a sum of all taxable sales in a region over that timeframe.
The result is a report that lets you see your total sales and taxes for each region where you have to remit taxes. I'd be happy to share the code if anyone else would find this useful.
Scott
Sure! PM me with the details, I'll give you an e-mail address where you can send files (if necessary).
I was wondering if there was some way to do this:
I want to feed a URL to my ezpages so that a manufacturer (actually an author but, hey!), could access their designated ezpage and have a sales report run for the, month to date would be fine.
So what I am asking for, is there some way to generate the sales report via the URL, with the report defaults built into it? (say, monthly, manufacturer)
Sure, run the report, then take a look at the URL. :wink2:
Blah, must be one of those kinda days for me <s>.
Any way to lose the report header (allowing someone to re-run the report? I just want to display the data.
I would gather I could display it frm the CSV, but that is outta my ken right now.
Please excuse me if I missed thi ssomewhere in the past 14 pages.
I have some custom fields added to my products that I need to show up on sales reports. Does this reporting system pull all info from sales? For example I have added a redular field for UPC code, and in my attributes for downloads have also added a place to put UPC codes and ISRC codes (needed on every song). The ISRC codes from sales need to be transmitted daily to an agency.
We hired a programmer, however he disappeared after putting in the fields for the UPC and ISRC and never installed the reporting system.
thank you,
betty
Well obviously for your needs, you'll need to modify the basic contrib. Fortunately for you, all the calculations are done in an independent class file; you'll just need to call and feed it the necessary info, then handle the output. I think you're going to need a pretty solid PHP foundation for this project; and if you don't have one, this will definitely supply it.Quote:
Originally Posted by wmarcy
There's no "plug-in" way to add fields, it's all custom. However if you've added the fields to the product table, you should be able to add them without much trouble. You'll need to modify the class file to find and collect the field, then the display file to actually output it. It will require basic programming knowhow, however.Quote:
Originally Posted by bettysue
I hear stories about disappearing programmers way more than I should, it's a real shame. I promise we're not all like that. :smile:Quote:
We hired a programmer, however he disappeared after putting in the fields for the UPC and ISRC and never installed the reporting system.
Blindside,
Is there a proper method to do the following in your contribution?
I've search quite a bit in the language file and this forum, but I can't find all the info I need.
1. I'd like to remove the following columns from the screen display and maybe the csv output.
Base Price, Tax, Total, Product Total
I just need Product ID, Product Name Model No. and Quantity to show for output to my suppliers for sales.
I know I can delete columns when it gets to Excel, but I'l trying to see if I can streamline it and get it right on the first pass.
2. Is there a way to modify the output from csv to text.
I have various product names that have commas in them.
When I open the csv file in Excel, the items with the extra commas get pushed over to the next Excel column with each comma in the name.
This probably won't happen in a text output.
3. Is there a way to look up multiple manufacturers at once if I modify the URL? I tried it a couple times, but it only found the first one.
Is it only set up to do 1 manufacturer or all?
thank you for your time.....
Jeff
i have a quantity discount module running and i just noticed that on a report it doesn't show this discount at all? is there a way i can do this? it only shows the group discounts and becasue of this the reports are wrong
Simple, just find those outputted columns in the report and comment them out. The regular and print displays will be in admin/stats_sales_report.php, and the CSV is located within the class, admin/includes/classes/sales_report.php. Don't forget to comment out the header column as well.Quote:
Originally Posted by jeffmic
By it's very nature, you can't have commas in a field in CSV files. SO you can either (1) remove all the commas through the admin, or (2) dynamically remove commas from product names when running a CSV. I'll assume you voted for the latter. Open the class file (see above) and find this line:Quote:
2. Is there a way to modify the output from csv to text.
I have various product names that have commas in them.
When I open the csv file in Excel, the items with the extra commas get pushed over to the next Excel column with each comma in the name.
This probably won't happen in a text output.
Change it to read as follows (new code in bold):Code:echo $p_data['name'] . CSV_SEPARATOR;
Repeat for any other fields where you use commas.Code:echo str_replace(',', '', $p_data['name']) . CSV_SEPARATOR;
The manufacturer filter was added specifically for users who generate per manufacturer reports to deliver to their contracted suppliers. In that case you only ever need to see one. I suppose I could add the ability to do one or more, but that's more logic that I just don't have time for right now...Quote:
3. Is there a way to look up multiple manufacturers at once if I modify the URL? I tried it a couple times, but it only found the first one.
Is it only set up to do 1 manufacturer or all?
Best best is to not use the filter, and instead sort by manufacturer in the product line item display.[/quote]
Your welcome! :smile:Quote:
thank you for your time.....
The report calculates based on actual quantities sold and purchase price, so any per product discounts should automagically be calculated in.Quote:
Originally Posted by MB1
Try this. Run the report for a timeframe that includes several orders for your qty-discounted product, and use per product line items. Take a look at the Base Price, Qty., and {B]Product Total[/B] fields. The math probably doesn't match up, which I think prompted your post.
But what you don't realize is that the Product Total field actually contains the correct value. Base Price is gathered the first time a given product_id is hit upon. It obviously could be different, but I can't display every base value for the the product on a single line. So it's a bit of an assumption, but it's usually correct, and when it's not the Product Total is always correct. Check the math if you're still unsure.
no it's all off it calculates the group discount but not the quantity discount. and when i tallied up the product totals it was way off.
for yesterdays single order the main total was right if you took off the quantity discount, as for the individual product totals they were to high the totals were bang on.
invoice total was 1,725, the sales report total was 2035.82 (if you took off the quantity discount of 310.59 it would be aok) and if you calculate the product totals you get 2443.58.
anysugestions?
Thanks so much for your help.
I was able to customize my screen and csv layouts exactly as I needed.
This is a wonderful add on!
Jeff
anyword on how i can get the quantity discount to show as default?
Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.
Doh! Never mind. Forgot I re-named my admin folder for security reasons.:blush:Quote:
Originally Posted by candywrap
I just installed Sales Report (rev 104) on a fresh copy of Zen-cart 1.3.7. When I click on Sales Report from the admin/reports/ menu I get a blank screen. Any thoughts or help would be appreciated.
BlindSide.
I have just installed Sales report an on running a report get the foll0wing error.
1406 Data too long for column 'page_parameters' at row 1
in:
[insert into fmadmin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_target=status&date_status=2&pa yment_method=¤t_status=&manufacturer=&timeframe=day&timeframe_sort=asc&det ail_level=product&li_sort_a=model&li_sort_order_a=asc&li_sort_b=name&li_sort_ord er_b=asc&output_format=print&', '192.168.30.21')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Any thoughts
Thanks
Mikey G
Go to the Tools ... Install SQL Patches ...
Does this correct the problem?PHP Code:ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TINYTEXT NULL DEFAULT NULL;
Ajeh,
Unfortunately not still getting the error.
Regards
MG
Check your database table via phpMyAdmin ...
How many tables do you see?
On the table:
admin_activity_log
did it update the field?
Check that your admin and catalog are both using the same server, database, username, password in the files:
/includes/configure.php
/admin/includes/configure.php
Ajeh
It appears to have recorded this activity in the log and certainly that field data type when you look at the table structure appears to say tinytext.
If I have understood this right then it appears to have run okay
Cheers
MG
If I go to the Tools ... Install SQL Patches and enter:
I cannot reproduce the error ...PHP Code:insert into fmadmin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_ target=status&date_status=2&payment_method=¤ t_status=&manufacturer=&timeframe=day&timeframe_so rt=asc&detail_level=product&li_sort_a=model&li_sor t_order_a=asc&li_sort_b=name&li_sort_order_b=asc&o utput_format=print&', '192.168.30.21');
NOTE: I did adjust mine for the table name as mine is admin_activity_log and not fmadmin_activity_log
Mikey G
I sometimes get this same error on my test machine using mysql 5.24 but not on my domain which runs mysql 5.27. What version of db are you running?
Hello,
Thanks for this awesome Sales Report system. I'm only having one problem when I try to export my CSV files. I keep getting consistent and unsightly errors in my sheet. It's probably something simple, hopefully someone can help.
Here are my settings.
Custom Date Range
Order Purchased
+Product Line Items
CSV Export
Column Titles in First Row
And I keep getting this error every few Rows..
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />
or this one...
<b>Warning</b>: array_multisort() [<a href='function.array-multisort?zenAdminID=4baf46482870f18dcf2411f16f568494'>function.array-multisort</a>]: Argument #1 is expected to be an array or a sort flag in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>915</b><br />
or this one...
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />
Sorry, I'm new to this stuff, so I dunno what it means.
THanks,
-Dave
Here's my store if you need that...
http://www.strandland.com/digitalstore
I am having trouble using this sales report tool. I am trying to use it and it doesn't generate any reports. I have double checked to make sure everything is in its proper location. So I am not sure what I am doing wrong...
Might need to add a filter:
State
to pull out sales data on a per-state basis.
Any suggestions on how to do this?
Many thanks :smile:
@davestrand:What version fo PHP are you using? Your errors typically happen when an older version of PHP is being used. You need to be running at least 4.2.2.
@linuxw00t: That tells me nothing, so it's pretty hard for me to help you. Does the search come up at all? When you submit a search, does the screen refresh, or just hang? Does a new page come up totally blank? Give me details about exactly what behavior you are experiencing.
@DogTags: Off-hand I'd say that a per state filter would require some serious adjustments to the report, as that kind of filtering happens in the core of the data mining process. You'll need to know what's happening in the sales_report class.
Blindside, like @linuxw00t: the search screen appears and then does nothing when you click Show me the money! No screen refresh. It just hangs.
Zen version 1.3.7
Sales Report 2.0
Does the progress indicator on your browser move at all (it should)? What browser and version are you using?
I try using it using the different options and then I click the 'show me the money' button and it doesn't do anything its just as if I made a button just to click. The browser progress doesn't do anything. Just like if I said 'click here' and you tried to click it. I have the correct software and everything is in its proper place.
I'm using Firefox 2.0 and Safari. No, the progress bar does not move or even show for that matter.
Thanks for the help.
J
Sounds like Safari doesn't like the JavaScript being used with the submit button. Can you try it with Firefox to confirm?
does this work with the latest 1.3.7?
Yes, the Sales Report works with all versions of Zen Cart 1.3.x.
excellent, thanks for the reply BS
quick question.... is there anyway that instead of having this report on manufacturers, to have it report on record label/record artist instead?
It's not a drag-n-drop kind of feature, it would require customizing the report, both the class file (does the searching/calculations) and the admin page (search and report output).
Doesn't work with either Firefox of Safari.
Thank you
Make sure that the JavaScript file, sales_report.js.php, is in it's place in the admin/includes/javascript folder. For that matter, I would check the entire file upload.
OK, I reloaded it again. Triple checked the locations. Now I have this error:
Parse error: syntax error, unexpected $end in /Library/WebServer/Documents/tc/admin/stats_sales_report.php on line 1187
Thanks for the help.
What version of PHP are you running? Windows or Linux?
PHP Version 5.1.2
running on Mac OS X
[FONT=Arial Narrow]I'd kind of like to know why mine isn't working. I've uploaded everything correctly.
[/FONT][FONT=Arial Narrow] Zen Cart 1.3.7[/FONT]
[FONT=Arial Narrow][/FONT]PHP Version 4.3.11
Server OS: Linux 2.4.21-47.0.1.ELsmp
Database: MySQL 4.0.27-max-log
HTTP Server: Apache
Here's the fix for this error...Quote:
Originally Posted by FullUp
On both lines 693 and 1029, change "<?" to "<?php".
Some PHP servers are configured such that they will choke if "<?" is used instead of "<?php" to begin PHP script.
Enjoy your sales report. :D
Also, the "Show me the money!" button not doing anything can be fixed by going into sales_report.js.php and doing the following replaces:
1) Replace all "<?php////////////" with "////////////".
2) Replace all "///////////////?>" with "///////////////"
In my case, I was seeing the same error, but tinytext wasn't large enough, so instead I did the alter table like so...Quote:
Originally Posted by Ajeh
Perhaps TEXT is too big, but I was lazy and just wanted it to work without too many steps. :DPHP Code:ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TEXT NULL DEFAULT NULL;
Hey Steve,
Thanks a bunch. Your changes fixed everything.
Jim
stats_sales_report.php
On both lines 693 and 1029, change "<?" to "<?php".
sales_report.js.php
1) Replace all "<?php////////////" with "////////////".
2) Replace all "///////////////?>" with "///////////////"
My pleasure. It was just a result of my minor struggle to get it working for myself, and I figured I would help spare everyone else the pain.Quote:
Originally Posted by FullUp
It looks like a great mod. I can't wait to make some use out of it. Thanks BlindSide!
Huh, well my apologies to everyone on that one. The goal of the odd tags and comment slashes was to make the description appear when viewing the code but leave it out when the file was included at page load. I'll take it out for the next release.
Did that solution work for you, linuxw00t?
BlindSide, your report is awesome and we all appreciate your sharing it and the time you spend keeping it up to date. Zen-cart is a great community.
Thank you!!!
Jim
Blind side
Just got this working having changed the admin log to text as above (Steve's fix - Thank you)
I have noticed that if I customise my date selection my start date is UK format (d-m-y) but the end is in US (m-d-Y) format. So If I choose 1st Jan to 2nd Jan I in fact get a report that finishes on 1st Feb.
Where can I fix this to be UK (d-m-y) format for everything.
I have changed the language file to get the reports showing the correct date format, it appears to be just this end date selection box which interprets the selection in the wrong way.
Thanks
MG
Your welcome. Glad you like it! :DQuote:
Originally Posted by FullUp
This problem has been reported in the past. Currently, there is no way to change the date format accepted in the date search boxes. You must either enter the date manually in US m-d-y format or use the JavaScript calendar dropdown to set it for you automatically. An oversight on my part that I'll correct in a future release, my apologies.Quote:
Originally Posted by MikeyG
Blindside,
I'd also like to offer you my thanks for a module that is now something I use on almost a daily basis (an addict ... moi!). I know you receive a lot of features requests but if you don't mind I'd like to offer a few of my own:
1. Multiple selection for Payment Method, Manufacturer and Current Order Status.
2. An option to show orders by discount code or code(s) used.
3. Finally I'd echo my support for a UK date format!!
Thanks for all the continued work.
Hello,
I had the same warnings and found a fix that works on my install. I submit it here in case it is usefull to Dave or others. BlindSide, please review the fix and include it in next release if appropriate.Quote:
Originally Posted by davestrand
In admin\includes\classes\sales_report.php around line 857, find :
Add this line after the unset line:PHP Code:unset($dataset1, $dataset2);
foreach($timeframe['orders'] as $oID => $o_data) {
In the CSV output, I also had blank lines between different days with daily timeframe. Here is the fix:PHP Code:if (!is_array($timeframe['orders']) ) continue;
In admin\includes\classes\sales_report.php around line 903, find:
and comment it (or remove):PHP Code:echo CSV_NEWLINE;
PHP Code://echo CSV_NEWLINE;
I was wondering whether there was a fix for this as I have just loaded the latest report mod running on 1.3.7 and the tax shows as $1 which is incorrect under the product line items filter but correctly at $2.97 under the orders filter.Quote:
Originally Posted by wapnoj
Thanks Blindside for a great mod nevertheless.
Hello 'Blindside',
I am running the latest version of zen cart and have downloaded and installed your mod into the top level, as usual. When I go into the admin, I find sales report. When I click on it, I get a blank page. I have downloaded your mod twice and reinstalled it. Everything seems in order.
I am running a local apache webserver on my laptop.
Any ideas? Thank you!
Check out my recent previous posts where I describe fixes you can apply. Maybe doing these fixes will work for you.Quote:
Originally Posted by Mountain Mama
Hello Steve,
I tried them all, but still a blank page!
Hi,
Just tried this module out this morning and it's pretty handy - thanks! :clap:
Being from Ireland, the date formatting issues were a little irritating, but they were extremely simple to fix.
For anyone from the UK/Ireland, this is all you need to change:
In admin/includes/classes/sales_report.php change lines 58 and 59 from:
to:PHP Code:$this->sd_raw = mktime(0, 0, 0, substr($sd, 0, 2), substr($sd, 3, 2), substr($sd, 6, 4) );
$this->ed_raw = mktime(0, 0, 0, substr($ed, 0, 2), substr($ed, 3, 2), substr($ed, 6, 4) );
PHP Code:if (strtolower(DATE_FORMAT) == 'm/d/y') {
// Use US date format (m/d/Y)
$this->sd_raw = mktime(0, 0, 0, substr($sd, 0, 2), substr($sd, 3, 2), substr($sd, 6, 4) );
$this->ed_raw = mktime(0, 0, 0, substr($ed, 0, 2), substr($ed, 3, 2), substr($ed, 6, 4) );
} else if (strtolower(DATE_FORMAT) == 'd/m/y') {
// Use UK date format (d/m/Y)
$this->sd_raw = mktime(0, 0, 0, substr($sd, 3, 2), substr($sd, 0, 2), substr($sd, 6, 4) );
$this->ed_raw = mktime(0, 0, 0, substr($ed, 3, 2), substr($ed, 0, 2), substr($ed, 6, 4) );
}
And in admin/includes/english/stats_sales_report.php change lines 114-118 from:
to:PHP Code:define('TIME_DISPLAY_DAY', 'n-j-Y');
define('TIME_DISPLAY_WEEK', 'n-j-Y');
define('TIME_DISPLAY_MONTH', 'n-j-Y');
define('TIME_DISPLAY_YEAR', 'n-j-Y');
define('DATE_SPACER', ' thru<br/> ');
PHP Code:if (strtolower(DATE_FORMAT) == 'm/d/y') {
// Use US date format (m/d/Y)
define('TIME_DISPLAY_DAY', 'n-j-Y');
define('TIME_DISPLAY_WEEK', 'n-j-Y');
define('TIME_DISPLAY_MONTH', 'n-j-Y');
define('TIME_DISPLAY_YEAR', 'n-j-Y');
define('DATE_SPACER', ' thru<br/> ');
} else if (strtolower(DATE_FORMAT) == 'd/m/y') {
// Use UK date format (d/m/Y)
define('TIME_DISPLAY_DAY', 'jS-M-y');
define('TIME_DISPLAY_WEEK', 'jS-M-y');
define('TIME_DISPLAY_MONTH', 'jS-M-y');
define('TIME_DISPLAY_YEAR', 'jS-M-y');
define('DATE_SPACER', ' to<br/> ');
}
Of course, the above is assuming that you have changed your admin/includes/language/english.php file to use:
PHP Code:define('DATE_FORMAT', 'd/m/Y');
define('DATE_FORMAT_SPIFFYCAL', 'dd/MM/yyyy');
Also, I've used jS-M-y as my preferred date output format... this affects the CSV output as well.
Some of you may prefer to use j-n-Y for more numerical formatting.. it's up to you (check PHP's date function documentation for more formatting options!).
Hope that is of help! :yes:
A note to blindside while I'm here...
First off, a great big thanks! :)
Secondly, the lines 693 and 1029 in the main stats_sales_report.php really need changing from <? to <?php - it seems silly to leave these as they are forcing users to have to make modifications. :blink:
Lastly, the comments in the Javascript should have the <?php and ?> tags removed from being around them, they result in parse errors here which causes the javascript to fail. Which is a pity because it makes it look as if the module doesn't work out of the box.
Thanks once again!
All the best...
Conor
ceon
Hi,
Sorry, hadn't tested the above with a day of the month after the 12th so missed out on noticing that the javascript has to be updated also.
Again it's quite a simple change... if you've done the above, just change the following file as well in the manner described below:
admin/includes/javascript/sales_report.js.php
Change lines 427-429 from:
to:PHP Code:if (isDate(sd_array[1], sd_array[0], sd_array[2]) &&
isDate(ed_array[1], ed_array[0], ed_array[2]) ) {
// the array is in mm-dd-yyyy format, but isDate needs it in dd-mm-yyyy
Wee buns!PHP Code:<?php
if (strtolower(DATE_FORMAT) == 'm/d/y') {
// Use US date format (m/d/Y)
?>
if (isDate(sd_array[1], sd_array[0], sd_array[2]) &&
isDate(ed_array[1], ed_array[0], ed_array[2]) ) {
<?php
} else if (strtolower(DATE_FORMAT) == 'd/m/y') {
// Use UK date format (d/m/Y)
?>
if (isDate(sd_array[0], sd_array[1], sd_array[2]) &&
isDate(ed_array[0], ed_array[1], ed_array[2]) ) {
<?php
}
?>
Happy Easter Everyone! :clap:
Conor
ceon
I just installed Sales Report 2.0 on zc1.3.7. First on my test server. It went smooth and appeared to function perfectly. Then on my live server. It installed smooth, but the page is different with mission functionality. The 'sort product by' and 'then sort product by' are missing.
I've attached the two different screen shots.
Thanks,
Airtime.
Just change the "Displayed Information" dropdown; the additional options appear/disappear based on your selection in that box.Quote:
Originally Posted by airtime
Thanks Conor for updating Frank's "super" sales report!!
Just reporting back everything is great now!!
Thanks again you two.
Craig
why I get always an error with dates if I try to select custom timeline?
Have you tried the adjustments Conor suggests on the previous page.Quote:
Originally Posted by poosk
I'm in the UK and use the day/month/year format and Conor's solution works fine for me.
Craig
Hi Blindside,
I have installed this mod on my test site and i get the following error after pressing "show me the money":-
1406 Data too long for column 'page_parameters' at row 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '3', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_target=status&date_status=1&pa yment_method=¤t_status=&timeframe=day&timeframe_sort=asc&detail_level=timeframe& li_sort_order_a=asc&li_sort_order_b=asc&output_format=display&new_window=1&', '62.105.176.92')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Can you help Please?
Run this SQL on your Zen Cart database:Quote:
Originally Posted by jamie2k
Code:ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TEXT NULL DEFAULT NULL;
:) Big smiles... thanks for such a quick reply... worked like a dream.Quote:
Originally Posted by Stevietheman
My pleasure. This one was easy, as it's already been answered before. :clap:Quote:
Originally Posted by jamie2k
Stevie,
I am sure if you have done as much of this as i have you'll agree; once you have looked at the zen forum for longer than an hour, after a full days work, at 11pm; your eyes decieve you and even though you know how to find the answers, they seem to evade you.
I really need another pair of hands and eyes for this time of day... I'm shattered, been hard at it for time... so should think about bed now.
Many thanks again,
kind regards
Jamie
PS. R U UK Based ?
Jamie, I understand how that goes. I've been there many times myself. I've even already asked a question in these forums that I smacked my head about afterwards.
I'm based in Louisville, KY, home of the Queen's recent visit. :cool: It's only about five hours behind here (and I speak a version of English), so I theoretically could work on UK projects.
I'm confused about the version of this contribution. If I follow the link it takes me to the download section where this contribution is listed as:Quote:
Originally Posted by BlindSide
Zen Cart™ Version: v1.3.6
Version: rev 104
Last Updated: Nov 11 2006
Author: BlindSide
There is no mention of Sales Report 2.0 (just Sales Report). I installed it anyway and it looks good!
My two questions are:
Is the above rev 104 the latest version of Sales Report 2.0?I installed on ZenCart Ver. 1.3.7 and haven't had any problems.
Is there a way to display the State where the order is shipped (for completing sales tax reports)?
Ron