Sales by Category in Magento?

Posted by Tegan Snyder on Stack Overflow See other posts from Stack Overflow or by Tegan Snyder
Published on 2010-03-22T01:35:50Z Indexed on 2010/03/22 1:41 UTC
Read the original article Hit count: 349

Filed under:

magento

|

reports

|

zend-framework

We have a category called "Clearance" on our Magento website. Ideally it would be nice to be able to get a report of all orders sold in that category.

Is there anyway I can join the orders collection with the products collection and filter by category id?

Here is a similar thread: http://www.magentocommerce.com/boards/viewthread/44296/

Any ideas, or am I crazy? It doesn't need to be pretty.

© Stack Overflow or respective owner

Related posts about magento

Can't view order in magento

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've been setting up a fresh magento 1.4.0.1 install, working great so far. I did some test orders just to see. Everything works fine, but when I click on "view order" under "my orders", I get a bunch of error messages: There has been an error processing your request Notice: iconv_substr() … >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Developers: Is Magento really -that- good?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are looking at Magento as a possible commerce solution, but we are reading more bad than good on the free product. However Magento sells itself as the best thing ever, so I am confused on its actual value. Thought I'd ask the pros here. Can any seasoned developer here explain the difficulties… >>> More
Loading Magento child html outside of Magento

as seen on Stack Overflow - Search for 'Stack Overflow'
I am loading Magento blocks outside of Magento for certain parts of my site. I can do this successfully with something similar the following. require_once $docRoot.'/app/Mage.php'; umask(0); Mage::app('default'); ... $layout = Mage::getSingleton('core/layout'); $block = $layout->createBlock('Mage_Page_Block_Html_Header'); $block->setTemplate('page/html/header… >>> More

Related posts about reports

Grep Crystal Reports (with Sub-reports)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need a way to quickly search a large number of Crystal reports (with sub-reports) for the names of several stored procedures. (Trying to find dependencies.) I'm running Windows XP and downloaded this grep program - http://www.wingrep.com/download.htm. So far, I'm not convinced that it's working… >>> More
Scheduling parameterized reports in Crystal Reports Server

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to set up a report to run monthly in Crystal Reports Server 2008 that will give me the next month's Affordable Care Plan termination dates. However, as far as I can tell, I can only give it a particular date string, not "7 days after the report is scheduled". How do I do this? (Same question… >>> More
SQL Server Reports IDE for creating reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to modify SQL Server reports. It is not easy to modify directly XML report file (*.rdl). Is there any IDE for editing SQL Server Reports? >>> More
Alternate line colors in reports using Crystal Reports

as seen on C# Corner - Search for 'C# Corner'
Sometimes when we have a big reports displaying heavy textual information, one technique to visualize data in a consistent way is to shade line in alternate colors. In this article, I will show how Crystal Reports enables this technique very easily. >>> More
How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More