Thank you for responding!
Printable View
Thank you for responding!
I am having a slight problem
the shipping totals are not adding right if I am looking for specifics.
Like all from a manufacturer. It gives me the shipping for the entire
range and not just the specifics I asked for.
That's correct. Shipping costs are recorded per order, not against individual items in the order. And since there is no explicit record of how the shipping costs were calculated (was it by weight, number of items, flat rate, delivery type, etc?) Sales Order doesn't know how to apportion them either, so it can only report the information it has.Quote:
Originally Posted by milobloom
Where's the 2.2 version? I haven't made an official release beyond the "2.0 rev 104" as available in the DL section. If someone's made changes, send them my way, I'll incorporate into my SVN, and upload the new version with a credit.Quote:
Originally Posted by kitcorsa
In post 239.Quote:
Originally Posted by BlindSide
Ok basic question from a newbee here! Do you have to have manufacturers? As havent had a need to input that data, will this module work without it? Also do I need to have super sales module? So far we only have the edit order module installed? Thanks
No, you do not need to use manufacturers. I don't use them in my store, I included the functionality for others.
Thanks for the post number, kuroi. :thumbsup:
Is this module easy to install, I would need to pay a freelancer, I just noticed how much some of you are having to change things around and wondered how time consuming it was along with difficulty. Thanks
This module is completely plug and play, you don't have to change anything around (where do you get that idea from?).
If you follow the install instructions included in the zip, you should have no problem doing this yourself. All the files simply plop into your admin folder. The next time you open the admin, you'll find the Sales Report listed in the "Reports" section.
I'd like to start by saying that this module rocks! what i'm trying to do is generate sales reports by category and even by item. is there a way to do this?
example...
Mens shirts sold = 10 @ $10 = $100
mens black sold = 5 @ $10 = $50
mens white sold = 5 @ $10 = $50
Womens shirts sold = 10 @ $10 = $100
womens black sold = 5 @ $10 = $50
womens white sold = 5 @ $10 = $50
Hi there!
I love this mod! but I don't know why is not working for me... :huh:
when I choose only PayPal like Payment Method, only for 1 manufacturer, I receive all payment methods report... why?
I like to know if is possible, have a report with all payment methods but with one more column that said if is: gift certificate, coupon, paypal, etc.
Another problem.... if I choose Output Format, CSV Export, my browser said: to help protect your security bla bla bla... I chose Download File, but the download never start....:(
I have zen cart 1.3.8 and sales report 2.2
thanks in advance!!!!
Great mod, however I have a question that I can't figure out.
I want to create a report for products sold in a month based by attribute.
For example, a red shirt, would be seperate from a blue shirt.
So if in a month 5 shirts were bought, however 2 were red attribute, 1 blue, and 2 yellow it would show like
2 Red
1 Blue
2 Yellow
instead of just
5 shirts.
Is it possible with this mod? Or is there another mod that this is possible with?
[edit] never mind, I just noticed a couple pages back that it isn't possible.
I guess I will have to write my own reporting tool, or modify this one to do that.
I'm asking the same question....
hopefully someone can answer us.
With over 300 posts in this forum, it would be helpful if you would be more specific about which question you believe to be unanswered.Quote:
Originally Posted by zerocrew
@zerocrew & mipavluk
Guys, I'm here to help, but you have to do your own homework:
http://www.zen-cart.com/forum/showpo...&postcount=264
Search the thread next time, please? :smile:
I may work on a Report mod that calculates total based off attribute, so stay tuned.
It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this
ugg formatting screwed up... but you get the ideaPHP Code:Product Attribute Amount Sold Total
Shirt $24
Red 2 $16
Green 1 $8
Pants $60
Black 2 $40
Orange 1 $20
I'm having a small problem with version 2.2. The report is generating incorrect order totals. It is adding the product cost (ex tax) to the shipping cost (inc tax) and giving a total figure that doest match the order.
All I'm looking for with this add-on is to be able to obtain a total $ value of all orders between two dates. I need the order totals (including shipping and tax ie what the customer pays) for all orders so I have a 'total income'. Showing tax would also be a bonus but not essential as I can just divide the total by 11 (Aus GST 10%).
Like I've said before, the first version of the Sales Report attempted this, and I took it out when I took over the project because it simply didn't work well. But I'm looking forward to seeing what solution you might come up with.Quote:
Originally Posted by Vladimir7
A few things you'll want to keep in mind:
- Attributes currently have no associated quantity, so you'll need to do your own counting.
- How will you handle text attributes? Remember that they are often completely different values (hence no counting).
- You'll probably want to ignore file upload and read-only attributes, but only if they do not have a currency value associated with them.
:clap: all i have to say is if you can do this it would F!@$$# rock!Quote:
Originally Posted by Vladimir7
thanks for trying man.
Hi there,
I haven't read through this entire thread, but I was experiencing an issue with rev 104 where, when I filtered by manufacturer, it would still show a date with orders, where that manufacturer had no orders, as having orders on the report. The product totals were zero, but the tax and discounts were still there, throwing off numbers. Additionally, I did not want to see any orders for the time period if that manufacturer had no orders.
So, I changed the query that retrieves the order numbers to consider the manufacturer filter and it appears to have resolved the issue. This is a code snippet starting at line 164:
Hope this helps someone else in the same predicament. Thanks for the great report! :bigups:PHP Code:// build the SQL query of order numbers within the current timeframe
$sql = "SELECT DISTINCT o.orders_id from " . TABLE_ORDERS . " o \n";
if ($this->date_target == 'status') {
if ($this->manufacturer) {
$sql .= "INNER JOIN " . TABLE_ORDERS_PRODUCTS . " op on o.orders_id = op.orders_id \n";
$sql .= "INNER JOIN " . TABLE_PRODUCTS . " p on p.products_id = op.products_id and p.manufacturers_id = " . $this->manufacturer . " \n";
}
$sql .= "LEFT JOIN " . TABLE_ORDERS_STATUS_HISTORY . " osh ON o.orders_id = osh.orders_id \n";
$sql .= "WHERE osh.date_added >= '" . date("Y-m-d H:i:s", $sd) . "' AND osh.date_added < '" . date("Y-m-d H:i:s", $ed) . "' \n";
$sql .= "AND osh.orders_status_id = '" . $this->date_status . "' \n";
}
else {
if ($this->manufacturer) {
$sql .= "INNER JOIN " . TABLE_ORDERS_PRODUCTS . " op on o.orders_id = op.orders_id \n";
$sql .= "INNER JOIN " . TABLE_PRODUCTS . " p on p.products_id = op.products_id and p.manufacturers_id = " . $this->manufacturer . " \n";
}
$sql .= "WHERE o.date_purchased >= '" . date("Y-m-d H:i:s", $sd) . "' AND o.date_purchased < '" . date("Y-m-d H:i:s", $ed) . "' \n";
}
sorry but where is the link to sales report 2.2 ?
i see the downloads section is version 2.0.
thanks
Hi all,
I realised that
1) Sales Report are showing even those deleted orders, can i actually do something to not let them showing up?
2) I realised that Sales Report did not show orders if I shop for them (eg. I use Master Password to log in to their account and shop for them)
Is there anyway to fix both problems?
Thanks alot!:smile:
They only way to prevent orders from appearing in the Sales Report is to delete them. Not sure how you are "deleting" your orders, but if they are still stored in the DB, they will be processed.Quote:
Originally Posted by whitekisses
Not sure what you mean here. Any orders in the system are eligible to display in the report; whether or not they display is determined by your report criteria. The fact that you are logging into your users' accounts using the master password is not relevant.Quote:
2) I realised that Sales Report did not show orders if I shop for them (eg. I use Master Password to log in to their account and shop for them)
Ya i figured that out, i'm just dumb hahaa
But i had another problem, as I use my cart with the Edit Order module, i realised i can't edit those with discounts.
For instance on the Edit Order module,
Total Price: $27
Discount: -$3.00
Total: $24
But it will show up on Sales Report module as;
Goods Value: $27
Discount: -$3.00
Total: $30
I tried without the minus sign, and this is what i get,
Edit Order Module;
Total Price: $27
Discount: $3.00
Total: $30
Sales Report module;
Goods Value: $27
Discount: $3.00
Total: $24
Any idea how to fix it? Thank you so much for your help! :smile:
The Edit Orders module is not storing the discount value properly. If you can look at your database using a tool like phpMyAdmin, browse the orders_total table. You'll note there's a field called "class." This field is internal to this table (i.e. it's not used anywhere else), and defines exactly the "type" of order total for a given record. Core Zen cart functionality allows discounts to be defined using a class string of either "ot_gv" or "ot_group_pricing". Anything else is considered an expense, and increases the cost.
Based on your examples, it would appear that Edit Orders does not follow this convention, and simply appends a minus sign to the number stored in "value". The Sales Report picks this up as an expense (correctly) and counts accordingly.
I warn people all the time about the Edit Order modules out there. They are based on some way old code, and can cause some serious issues. This is (fortunately) a more minor one.
Firstly let me say this is an excellent contrib and always one of the first that I install.
I wanted to add something to the wishlist of Sales Report if there is one. I would like to generate reports where the output is more about customers then sales. It seems like it would be easy to add into, or mod from, Sale Reports (he says knowing nothing og PHP or sql).
For example I would like to generate lists of customers that purchase product x, during period y. Or a list of customers that made x number of purchases during period y. Or a list of customers that purchased product A and B either together or seperately. Or a list of customers that have spend more/less then X dollars. Filters also for State, postcode
I have a need for this in trying to select choice customer to get feedback from. For example I could generate a report of everyone that purchased X and then purchased y later. This report would be centred around customer details, showing name, address, phone, order date, order value/products. etc. because this customer made 2 seperate purchases I presume they would have something positive to say about the product or service that they received.
I hope that makes sense. I think it is (logically not code) as simple as generating a customer list with filters for date range, state, post code, order value, product1, product2, number of transactions...
I am currently trying to find a cheap coder to write this for me so am certainly willing to contribute to it being done.
Thanks for listening.
Hi. This is a great reporting mod. But is it possible to change the date format? We need it in dd/mm/yy. I have looked in the files and seems there are loads of references to date("m"), date("d") which I tried swapping but didn't work. Couldn't find a solution on this thread. The Zencart date format does not affect the format of this mod.
Thanks
I also notice another probem... using the Custom date selection results in UK date format (perhaps its based on the Zencart date format we have?) so when we run the query we get an error message saying date format is wrong. i.e. if we choose 30th June 2008 (using Custom box its 30/06/08) we get an error probably because the system thinks 30 is the month.
So please can you let us know how to switch between US/European date formats (mm/dd/yyyy and dd/mm/yyyy). Thanks.
Try searching this thread for "conor" and you should find some posts and solutions.
Craig
Thanks again for this, Frank. It's come a long way and is quite exciting with my new 1.3.8a install....
I am concerned about the edit orders mod based on your comment.
Have not made this new store live yet...any tips on an alternative? Our goal is to be able to "edit orders" ;)
We are seeing this problem also. I have my old 1.3.0.2 zencart and new 1.3.8a opened to two windows comparing reports and the latter sales_report_rev104 is randomly a few cents off...but this adds up over time to make a difference of thousands. These reports are being run off the same data.Quote:
Originally Posted by psr racing
Well...further research showed that the old 1.3.0.2 cart was off a cent here and there. It was adding shipping to the sales with an error of .01 ...odd...but not happening so far with this recent install. Will try and give the issue more time later.
Although this 2.0 version is a beautiful thing, One thing I do miss is the quick ability to compare previous years to present and to filter results.
Hello,Quote:
Originally Posted by BlindSide
This is exactly what I need. The accountants are asking for reports on each size sold for items (they often come from different manufacturers) and I'd really like to be able to do this within Zen Cart. Does anyone have a solution?
Thanks,
Darren
I have put all the files in all the right places and can't get it to work, when I click on sales report in the admin panel it comes up with the error 404 page or forbidden :(
What am I doing wrong?
Is this portbale to version 1.3.8? caz I am having trouble making it work there. do i need to change something?
Thanks in advance.
vhjdb
I am working with Sales Report on Zen Cart 1.38a and it works fine. The only thing I would like to do is to have an option to omit canceled orders from the totals. Can anyone advise me where I would need to make that change? Thank you!
-Shawn
I found the solution for my problem at http://www.zen-cart.com/forum/showth...=44669&page=18
Opal, If your log is showing " PHP Parse error: syntax error, unexpected $end.... " Please follow this and it will solve your problem as well.
Nightwolff, thanks for confirmation! This made me believe that it works with latest version and I tried diggin in instead of throwing this nice module thinking it is not competible.
Regards,
Vhjdb
I've looked all over the place and although I find people with this same issue (see below) I have yet to find answer on HOW to correct it.
When I use the "Batch Status Update" option to update orders, everything updates EXCEPT the "last modified date" (in the "orders" table) is NOT updated.
The only way that updates is if I use the standard "Orders" option to edit and update.
How can this be corrected and what is causing it? At one point it time I believe it must have worked.
I figured it out.
The problem was that there was a missing parameter in the super_orders_funtctions.php file.
Around lines 409 - 412 you'll find:
Change that to:PHP Code:$db->Execute("UPDATE " . TABLE_ORDERS . " SET
orders_status = '" . $new_status . "'
WHERE orders_id = '" . (int)$oID . "'");
}
And you are all set. This must have been altered in an update release somewhere because it was working in previous versions I had.PHP Code:$db->Execute("UPDATE " . TABLE_ORDERS . " SET
orders_status = '" . $new_status . "', last_modified = now()
WHERE orders_id = '" . (int)$oID . "'");
}
Hi Eric
Shouldn't this be in the super orders thread, not the sales report?
Craig
Yes!Quote:
Originally Posted by CES
Wow. That is the second time I did that last night! It must have been late.
I meant to post it to the Super Orders thread.
Doing so now.
Disregard the past post. Sorry for any confusion.
Hi all,
Does any one knows why discount is not showing up in the report ...
or is it becaus ei use store wide discount ???
Hello,
Using "Search date of..." with "assigned status" may list a product or order several times if the selected status is used more than once in status history. In this case, totals are wrong.
Therefore, I wrote a hack to consider only the first occurrence of the status. I think this should be the default behavior, but just in case, I added a check box to activate this new feature.
It would be nice if Frank Koehl (PM: BlindSide) could include it in the next release. Contact me if you want the patch.
says this is for 1.3.6 will this work on 1.3.7 and 1.3.8 etc??
it sure will. I installed it first on 1.3.7 and have since upgraded to 1.3.8a without any troubles.
thanks :D
im trying to get the manufacturers drop down search column to display like this :
http://i35.tinypic.com/2uf8xvt.jpg
i have changed this part of the code :
PRODUCT MANUFACTURERS COLUMN
// Setting this define to true will display the
// manufacturer on each product line item, and will default
// to the value of TEXT_NONE if there is no manufacturer.
// False will remove the manufacturer column from the report.
//
define('DISPLAY_MANUFACTURER', true);
but the manufacturers drop down list still wont show, anyone any idea what im doing wrong?:unsure:
Hi,
I don't know if I'm asking this in the correct topic. If not, I apologize and please direct me to the right topic. :oops:
I had asked the same question in another topic regarding a similar report module, but thought I'd try here also. :blush:
I want to keep track of the product cost( the price I pay for) and the price I sell it for, so that I can keep track of Revenue. So, in addition to the sales reports, I was wondering if this module have revenue reports.
I had thought this is what the NET and GROSS prices are for while adding the products, but after some research it turns out they are for taxing products.
I'm thinking maybe the Product Cost has to be added while I'm adding the products... so this might be the wrong topic. But, maybe this module could include a feature where I could put in a product's cost(price I paid for).
Sorry if I'm asking, and this is already available in ZC. I'm new to ZC's system :blush:
Thanks much in advance!
ITF :bigups:
Does this happen for anybody else? Any way to fix it or modify it so it just adds the order totals together?Quote:
Originally Posted by psr racing
After a bit more testing it seems 'sale report' is randomly adding incorrect figures? I did a report over just one day (6 orders) and 'sales report' added roughly $36 to one order for no apparant reason, another one was out by a few dollars and the remaining 4 were spot on. Why would it change figures like that?
My tax return from last year will have to be redone as the total I used could well be 10's of thousands of dollars out from the true figure.
Is there some other way or addon that will simply give me the total of all orders between 2 dates as that is all I need from this mod.
For reference:
I had the same issue as the first quote below.
I found that it was simply the result of the Admin Profiles addon restricting the admin user, that I was logged in as, access to the Sales Report addon.
It seems anything you install after integrating the Admin Profiles will need to be check-marked in the permissions area of the Admin Settings > "admin-username". In other words, for every admin user you have, you need to go into the permissions area and check-mark the Sales Report module, or any other module you have installed after you installed Admin Profiles.
Hope this helps someone and saves them time trying to troubleshoot!
Quote:
Originally Posted by gwkg
Quote:
Originally Posted by BlindSide
I have some questions/requests...
We have this add-on installed, and it has worked great so far, but we have recently added products from another manufacturer, and we will need to produce Sales Reports for him.
the problem is this: We want to be able to include several different order statuses in a report, while excluding others.
We have 7 different Order Statuses in total:
Pending [1]
Paid [2]
Shipped [3]
Updated [4]
Printed [5]
Canceled [6]
Testing Only [7]
I want to be able to include ALL statuses except for 6 & 7. Is there any way to do this? Or is there a change that I can make to the code to allow me to do this?
Any help would be appreciated!!
Works fine in my 1.3.8a store but the flat fee shipping doesn't show up. Anybody worked this out.
for all of those who are looking for a sales report that includes product attributes try the mod "Export Shipping & Order Information", it solved that dilemma for me, I needed to track products by specific attributes
Sales Report is a great mod too!
Nope. My own error. Shipping shows up. It has to be enabled in Order Totals under admin first. Duh.Quote:
Originally Posted by brushwoodnursery
I've installed Sales report add-on and once I try to access it via Zencart, all I get is a blank page.
Can someone point me in the right direction to get this working?
Thanks.
Apply the code changes I came up with in a few posts on this page:Quote:
Originally Posted by jdannan
http://www.zen-cart.com/forum/showth...=44669&page=18
Hope that works for you.
Works great. Really appreciate your help. :cool:
Sorry if I'm cross-posting (I'm trying not to - my problem has changed its shape as I've learned more about the issue). I'm reposting here because I believe this is a better thread for my question. (prior post)
After some debugging, I finally found what Steve has already pointed out - <?php////// doesn't always work.
Is there a reason why this works on some servers but not others? I ask because I'd like to have my home computer set up with the same server config as my host. I have this problem on my home computer. I can change the code easily enough, but I'm wondering if this will cause other incompatibilities down the road. It'd be easier to change my Apache or PHP installation options than to debug another problem (I have enough of those). Then again, if it's a linux v.s. winxp issue, I'll just move on.
Thanks,
Carl
I've been using sales report for a while. We switched servers recently and all of a sudden I'm getting a 500 error when I try and pull up sales report. Tried the <php?//// change and it made no difference. Could this be something with php5?
Is there a way for the sales report to reflect refunds and discount coupons used???
I run the Sales Report on a PHP 5 server, and it works fine for me.Quote:
Originally Posted by MotoDelta
I run it on multiple servers with PHP5 with no problems. These 500 errors are internal server errors. One possible cause is directory and file permissions. If your new server has tighter restrictions, it could be that the permissions need to be reduced. Try 755 for directories and 644 for files. If that doesn't work, talk to your web host about the problem.Quote:
Originally Posted by MotoDelta
Another possibility is a problem with something in the .htaccess file -- I've gotten 500 errors from that before.
Installed Zen Cart this past December. The latest version. Changed the admin directory name for security reasons. Installed an invoice mod and customized the looks. Then after getting some orders i tried to get a sales report and it didn't work. It sent me back to login. Tried installing the new sales report from the link on this thread and now there are 2 sales reports (identical) on the reports drop down menu in admin. They both do the same thing, they send you back to the login page. If you login again it just takes you back to the home page. No report.
Can someone help?
I can't figure it out.
No expert here - but are you using Admin Profiles add-on, if so then maybe you need to enable this mod from Tools/Admin Settings/Permissions for your user?!?Quote:
Originally Posted by pepe0309
Doesn't sound like Admin Profiles. That would send you to a page denied screen, rather than log you out.Quote:
Originally Posted by stride-r
I just installed Sales Report 2.0 on ZenCart 1.3.8.a and I am having the same HTTP 500 issue... Mine is on a windows box with PHP 5 that I administer. Everything else in ZenCart seems to be working..
I checked permissions and al;l seems to be fine... any ideas??
Thanks!
Mark
Was this something that could be incorporated into the Sales Report? or just a column that says, Cost PriceQuote:
Originally Posted by sky1
Thanks
Sam
I just installed this app., nice job. What led me here it that I thought a year ago paypal would do yearly reports showing all your total actual postage paid, paypal fees, sales and refunds. Very helpful for tax purposes.
But it appears they now only allow 3 months data, poor print outs and a frustrating set up even for downloads to database.
Does this mod have the ability to show what paypal nicks us for?
And is the shipping totals including our handling fees in the total as I assume?
As it is this mod could be very helpful once I learn more.:cool:
WD
I am not in the right area, can some one explain why my sales ad with price ranges, only some will show up and others will not.. Thanks in advance.. PM me if you wish...
Wellbourne
www.familyoutdoorstore.com
Hi, so I work for a company that hosts a lot of sites and we have AwStats configured for the all of our sites. AwStats was configured before I started working here and looks the same for all of our sites. We have a new site with a shop using ZenCart 1.7 with the latest version of Sales Report on it.
The issue we are having is that when we or the customer go to view any of the Sales Report information or other stats under reports it just automatically redirects to a page that looks like the AwStats we have configured for all of our other sites. This is a problem since the customer wants it to look like it the Zen Cart skin and well none of the shop data is there either.
Can anyway help or any have insites as to why it is doing this?
Thanks.
Any response on this? I already have a cost field in my db from 'cash on hand' calculator. Would love to have a column added to sales report with the cost field! It doesn't seem like it would be hard to do.Quote:
Originally Posted by sam_m
Can someone tell me how I can get my Paypal fees to show up in the report in place of another field that I don't use? I'm thinking I could get rid of the gift certificates field. I know the fee information is stored in the database, I just don't know where and how to incorporate it.
I would like to know the same thing. I don't use Coupons & I too need to have this function so that my vendors can see what fees they pay. Here's what I found:Quote:
Originally Posted by dinki
admin/includes/languages/english/paypal.php 'ENTRY_PAYMENT_FEE', 'Payment Fee'
Module location: includes/languages/english/modules/payment/paypal.php
MODULE_PAYMENT_PAYPAL_ENTRY_PAYMENT_FEE
Now that I've located it... what would need to be changed in "sales report" in order to pull this information? If I can figure it out, I will gladly share. :bigups:
Hi,
Great Mod,
Can anybody tell me how to remove some fields,
For example I do not want the "Num Products" field, how and where can I comment out this field.
Any help appreciated .
Hi suffrinmick & everyone,
This is a fantastic module. One small (hopefully) thing - I too need an option to generate a report by category ... is there any way to achieve this ? I am a PHP newbie ... if someone points me to the right part of the code, could I try it myself ?Quote:
Originally Posted by suffrinmick
Thanks. :smile:
Thank you for a great mod. I have a downloadable product with over 20 manufacturers in store but if one manufacturer has a discount on their product and makes a sale, that discount shows and subtracts whatever the amount of discount is from each sale the other 19 manufacturers have made on their monthly sales report. How can I stop this?
Hi Everyone,
I am having a problem getting the report to run. I have Zen Cart 1.3.8a, and have installed the module according to the instnructions.
On the report screen, the "custom" and "show me the money!" buttons do nothing when clicked - so I can not run the report.
I have already made the changes in post #173 - 14 replacements each.
If anyone else has any suggestions, I would be very grateful.
Thank you.
Hello :-)
I am in need of help with my sales report, it is giving me an error and i cant figure out how to fix it. Here is what it says:
Parse error: syntax error, unexpected $end in C:\wamp\www\Test Zen\admin\stats_sales_report.php on line 1229
Now line 1229 is the following
?>
Thats it, so i have no idea. It is the basic sales report with added custom script made from Diego and he sent to me without testing, so far i was able to fix it myself but i just cant get past this part.
I originally got the unexpected $end in C:\wamp\www\Test Zen\admin\stats_sales_report.php on line 1187
And i fixed that with the helpful info in posts thus far :-)
Any help is appreciated
Hello,
I have just installed sales report 2.0. I have tried to change the settings in my profiles admin to select the admin profiles and save the changes. The changes never seem to save so it is always unselected. I get the error message that I don't have permission to use sales reports.
Any help would be greatly appreciated.
Erin
www.momandbabyboutique.com
Pardon my dumbness, but I don't understand.
You're in zencart admin, how do you change profiles admin? what are admin profiles?
I just may need more step by step to understand. You try to generate a report saying "Reports -> Sales Report", and it says you don't have permission?
Are you using the 'Reports Defaults' button? How?
Please please please? Tax season will be upon us before we know it! This would make life so much easier on those of us who use Paypal AND file taxes.Quote:
Originally Posted by dinki
I've done some work to capture paypal transactions into SO as they occur. Another approach is to find the transactions after the fact during report generation. These were both posted in the SO support thread.
Thanks for the information, but please excuse my ignorance when I ask what 'SO' is?
Quote:
Originally Posted by carlvt88
I have installed the "Admin Profiles" mod so that my staff can update the site without access to all of the admin. Frankly - zencart admin can be very confusing so I try to keep it simple and only give them the basics.
I go to "Reports -> Sales Report and I receive the error message "Sorry, your security clearance does not allow you to access this resource.Quote:
Originally Posted by carlvt88
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience."
I'm not sure what you are asking.Quote:
Originally Posted by carlvt88
Thanks for responding.
Erin
www.momandbabyboutique.com
Thanks Erin - makes more sense to me now. I'm unfamiliar with the admin profiles module so I can't help much here, and it sounds like that may be the source of the problem. Of course if it's the interaction between the two modules, might need someone who uses both to weigh in here.
I might load up admin profiles, but probably not until November as I'm in busy season now.
Dinki, send me a PM. I may have generated the paypal report you're looking for, you're welcome to see if it works.
Anyone? I'm still can't get this to work. I haven't been separating my store sales from my on-line sales and I need to know that info now.
Thanks,
Erin
www.momandbabyboutique.com
Quote:
Originally Posted by erinl
I would try uninstalling the admin profiles, OR before I do that I might try assigning myself a new profile with all permissions and try logging in from there to run the reports.
Again, disclaimers that I'm really unfamiliar with this module, bla bla bla,
I tried loading this module, so your description makes a little more sense. First problem - you say you go to Tools->Admin settings, click on the Preferences logo to edit preferences for a user, select some items, click save, then when you go back to look at that user's preferences again, the changes aren't there? If so, it sounds like you're not writing to the database.
I was able to reproduce your problem. The error message said your security clearance does not allow you to access this resource
In the profile screen (the one with lots of boxes), do you see "stats sales reports" under the Third Party Mods section? At first I didn't, but running though the code would aparently add this module to the internal table of pages, so that the next time through this checkbox appeared. Then, checking the box would enable that capability.
If you can't get that box to appear by letting the module add it by itself, you could manually add it through the SQL patches, but probably better to let the module manage it.
Had the same problem on a Windows machine.Quote:
Originally Posted by sweetikins
Its because of the php parser. To fix this problem, you have to replace 2 occurences of <? in
In Line 693 and 1029
Replace
withCode:<?
Code:<?php
I figured out a way to get my total Paypal charges for the year by doing:Quote:
Originally Posted by dinki
This is done as a query directly on the database. This suits my needs just fine. Thought I'd share for those who may stumble across this.Code:SELECT SUM(mc_fee) FROM `paypal` WHERE date_added <= 20100101 AND date_added >= 20090101;
I have installed Sales Report as directed, but "Sales Report" does not appear under "Reports" any clues, ThanksQuote:
Originally Posted by BlindSide
I have uploaded Sales Report, but there is no indication it is there or working, There is NO "Sales Report" under "Reports" in Admin. Does anyone have any clue as to what my problem is?
I am having the same problem. "Sales report" does not appear under "Reports".
Hi,Quote:
Originally Posted by dinki
I needed this functionality too, so i have a new version that will show paypal stuff in the report. paypal columns will only be in order view, not in product view as they wont make sense in there.
There is no check yet to see if the paypal table is present so if you don't use paypal, it makes no sense to use the paypal report.
In this zip, i have included conner's latest version with date fixes for the original blindside version and also the paypal report which elaborates on conner's version. Both versions will run next to each other so you will have 2 report options added under reports, Sales Report & Sales Report PayPal.
Please, if anyone can run this in their shop and tell me the results, good or bad, i will be happy to hear.
p.s. also added an option to exclude a "current status" so if you don't want orders to show up that are currently assigned to "cancelled" or something similar. that should be possible.
p.s.s added dutch language files as i am dutch :P
:oops:file limits don't allow me to post the zip here so please get it from here.
Cheers,
Jeroen
have been using this mod as the only one to really let me know how sales are happening on my site. greatone ! Thanks.
i would like to remove the time limit for grouping as is now for daily, monthly yearly to "all time"
As my site is more than a year old I want to see which products i am selling an how much without the yearly grouping just all time.
Any help would be highly appreciated
Thanks
AVF