Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Custom Reports
 
inkfast_1
Jr. Member
 
Total Posts:  4
Joined:  2008-05-23
 

Hi Everyone,

I’ve just installed Magento 1.0.19870 with the sample data. The store I want to create will basically all be prepaid orders for stock, and we will send off one big order to each supplier for a whole heap of stock to fill the orders.

I can’t figure out how to make a new report. I want to be able to print a report which shows the quantity of each product required, grouped by supplier. Obviously only for orders with a status of ‘Paid’ or however it’s organised.

Can anyone help me? I’ve read through the forums, knowledge base and user guide, and I can’t work it out.

Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
inkfast_1
Jr. Member
 
Total Posts:  4
Joined:  2008-05-23
 

*Bump*

anyone? I’d really appreciate any help on this.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
scree
Sr. Member
 
Avatar
Total Posts:  137
Joined:  2008-07-14
Linz
 

Could you solve your problem?

 
Magento Community Magento Community
Magento Community
Magento Community
 
marcus178
Jr. Member
 
Total Posts:  19
Joined:  2008-02-06
 

It would be really nice to see some documentation on how to build a custom report. I would like to create one so that I can see the number of orders for each product.

 
Magento Community Magento Community
Magento Community
Magento Community
 
scree
Sr. Member
 
Avatar
Total Posts:  137
Joined:  2008-07-14
Linz
 

thats exactly what we needed. so we let it code now for $300. i would share it for a minimum of $$$ smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
jpluttme
Member
 
Total Posts:  34
Joined:  2008-04-28
 
marcus178 - 11 November 2008 01:40 AM

It would be really nice to see some documentation on how to build a custom report. I would like to create one so that I can see the number of orders for each product.

That’s exactly what I need as well…

 
Magento Community Magento Community
Magento Community
Magento Community
 
scree
Sr. Member
 
Avatar
Total Posts:  137
Joined:  2008-07-14
Linz
 

I will post results here, if I get my advanced reporting extension.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ShaneB
Jr. Member
 
Total Posts:  6
Joined:  2008-10-13
Madison, Wisconsin
 

Greetings…

Any progress on the advanced reporting extension?

Are there other options for us to create custom reports?

Shane.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ChrisShed
Jr. Member
 
Total Posts:  2
Joined:  2009-01-19
 

yes any help adding to and/or creating new reports would be most helpful.

 
Magento Community Magento Community
Magento Community
Magento Community
 
MageParts
Guru
 
Avatar
Total Posts:  415
Joined:  2007-11-18
 

A while back another community member, IrishC, was asking the same question. I tried to give some pointers which might be helpful to anyone developing a custom report / report extension module. Hope it can be useful to someone smilehttp://www.magentocommerce.com/boards/viewthread/27928/.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ilovemagento
Member
 
Total Posts:  40
Joined:  2009-02-04
 

you may find a good solution to create a ‘Custom report in Maganto’ :

http://www.magentocommerce.com/boards/viewthread/29535/

 
Magento Community Magento Community
Magento Community
Magento Community
 
ilovemagento
Member
 
Total Posts:  40
Joined:  2009-02-04
 

you may find a good solution to create a new report in Maganto here:

http://www.magentocommerce.com/boards/viewthread/29535/

you may also get the idea for report customization of Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
balero
Sr. Member
 
Avatar
Total Posts:  170
Joined:  2009-01-29
埼玉県所沢市
 

We going to take a stab at an improved reporting extension for our own use, and depending on how much extra trouble it is we might release it to the public.

If anyone has any “requests,” let me know. In particular, what sort of columns would you want? Can you describe useful reports in detail?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tingu
Jr. Member
 
Total Posts:  14
Joined:  2009-06-01
 

Hi! All,

I’m Tingu very new to magento.
Thanks lot for your contributions to us.
I have a issue regarding reports, I’m sure you are the right person to ask.
Please help me. The issue is…

Login into magento admin > System > Configuration > To the left side, under Sales > Shipping Methods > UPS > Gave values like this Calculate Handling Fee = Fixed, Handling Applied = Per Order & Handling fee = 5;

I am getting “Shipping Amount” = “Handling fee” + “Amount given by the UPS”.
Its working fine, having no issue with it at all.

Now Reports > Sales > Shipping, I can see the report with fields “Period”, “Carrier/Method”, “Number of Orders” & “Total Shipping”,
now also no issue.

But now I want to add a column to the existing columns with the name “Shipping Profit”, Under this for each row, value should be “Total Shipping” − “Amount given by the UPS”. So that I will get value to “Shipping Profit”. At last total row I should have sum of Shipping Profit.

And one more thing is if I change Calculate Handling Fee = Percent, Handling Applied = Per Package & Handling fee =10; Then also it should work.

Please help me. I will be very thankful to you.
I’m doing a small project using Magento for my academics. If I do it well in time I will get a good grade. Please help me in this issue.

I haven’t created custom reports.

With lots of hope. Please help me……….

Thanks lot for you time.

Truly,
Tingu.

 
Magento Community Magento Community
Magento Community
Magento Community
 
summa_solutions
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2011-03-03
Argentina
 

Hello,
Here I give you a tutorial on how to create a custom report on Magento

http://www.summasolutions.net/blogposts/custom-reports-magento

I hope you’ll find this helpful.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dg_0175
Jr. Member
 
Total Posts:  5
Joined:  2011-05-09
 

<?php
/*
Creating custom sale report in magento.

1. Create new module by module creator.
2. Now create collection inside grid for report output.
Go to >
\app\code\local\Dg\Statesale\Block\Adminhtml\Statesale\Grid.php

In my case I need this report. You can modify your report as per your need.
################################################################################
*/
protected function _prepareCollection()
{


$collection = Mage::getModel(’sales/order’)->getCollection();
$collection->getSelect()->join( array(’address_table’=>’sales_flat_order_address’),
‘main_table.billing_address_id=address_table.entity_id or main_table.shipping_address_id=address_table.entity_id’,
array( ‘address_table.*’)
$this->setCollection($collection);
//print_r($collection);
return parent::_prepareCollection();

}

/*################################################################################
3. Now you have created collection the next step prepare columns in same file.
In my case I need these columns
################################################################################
*/
protected function _prepareColumns()
{
$this->addColumn(’real_order_id’, array(
‘header’=> Mage::helper(’statesale’)->__(’Order #’),
‘width’ => ‘80px’,
‘type’ => ‘text’,
‘index’ => ‘increment_id’,
));

if (!Mage::app()->isSingleStoreMode()) {
$this->addColumn(’store_id’, array(
‘header’ => Mage::helper(’statesale’)->__(’Purchased from (store)’),
‘index’ => ‘store_id’,
‘type’ => ‘store’,
‘store_view’=> true,
‘display_deleted’ => true,
‘filter_index’ => ‘main_table.store_id’
));
}

$this->addColumn(’created_at’, array(
‘header’ => Mage::helper(’statesale’)->__(’Purchased On’),
‘index’ => ‘created_at’,
‘type’ => ‘datetime’,
‘width’ => ‘100px’,
‘filter_index’ => ‘main_table.created_at’
));

$this->addColumn(’firstname’, array(
‘header’ => Mage::helper(’statesale’)->__(’Firstname’),
‘index’ => ‘firstname’,
‘type’ => ‘text’,
));

$this->addColumn(’lastname’, array(
‘header’ => Mage::helper(’statesale’)->__(’Lastname’),
‘index’ => ‘lastname’,
‘type’ => ‘text’,
));

$this->addColumn(’region’, array(
‘header’ => Mage::helper(’sales’)->__(’State Name’),
‘index’ => ‘region’,

‘width’ => ‘70px’,

));

$this->addColumn(’country_id’, array(
‘header’ => Mage::helper(’sales’)->__(’Country Name’),
‘index’ => ‘country_id’,
‘type’ => ‘text’,
‘width’ => ‘70px’,

));

$this->addColumn(’address_type’, array(
‘header’ => Mage::helper(’sales’)->__(’Address Type’),
‘index’ => ‘address_type’,
//’type’ => ‘options’,
‘type’ => ‘text’,
‘width’ => ‘70px’,
//’options’ => Mage::getSingleton(’sales/order_config’)->getStatuses(),
));


$this->addColumn(’total_qty_ordered’, array(
‘header’ => Mage::helper(’statesale’)->__(’Items Ordered’),
‘index’ => ‘total_qty_ordered’,
‘type’ => ‘number’,
‘total’ => ‘sum’
));



$this->addColumn(’grand_total’, array(
‘header’ => Mage::helper(’statesale’)->__(’G.T. (Purchased)’),
‘index’ => ‘grand_total’,
‘type’ => ‘currency’,
‘currency’ => ‘order_currency_code’,
));

$this->addColumn(’status’, array(
‘header’ => Mage::helper(’statesale’)->__(’Status’),
‘index’ => ‘status’,
‘type’ => ‘options’,
‘width’ => ‘70px’,
‘options’ => Mage::getSingleton(’sales/order_config’)->getStatuses(),
));


$this->addExportType(’*/*/exportCsv’, Mage::helper(’statesale’)->__(’CSV’));
$this->addExportType(’*/*/exportXml’, Mage::helper(’statesale’)->__(’XML’));

return parent::_prepareColumns();
}

/*################################################################################
That’s it now the cake is ready.

*/

[/code][code]
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2