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

Custom Report in Magento
 
php007
Jr. Member
 
Total Posts:  3
Joined:  2012-02-27
 

I need to create a new daily report that displays total numbers for each order.  I have researched online, but haven’t found any convincing solutions. I’d like to replicate the same report options as Reports > Sales, and place it under Reports > Advanced, and have the following columns displayed:

- Date
- Order ID
- Customer Name
- State
- Quanitity
- Sale Amount (not including tax or shipping)
- Tax
- Shipping
- Total Invoiced

This is a sample output i’m looking for:

Date           Order ID        Name         State   Quantity  Sale Amount  Tax     Shipping   Invoiced
March 1
2013    #11       Katherine King    MD        1        $39.99     $3.23     $0.00      $43.22
March 12013    #12       Jane Johnson      NY        3        $57.32     $1.23    $10.00      $68.55
March 22013    #13       Tim Thomson       MO        1        $19.99     $0.00     $0.00      $19.99
March 42013    #14       Pragnesh Patel    KS        4        $78.95     $0.00     $0.00      $78.95
March 42013    #15       Susan Smith       CA        2        $24.65     $0.00     $0.00      $24.65
March 52013    #16       Bill Boone        MI        1        $15.99     $0.00     $0.00      $15.99

Total        # of orders                               #        $#.##      $#.##     $#.##       $#.##

Any help is greatly appreciated!

 
Magento Community Magento Community
Magento Community
Magento Community
 
php007
Jr. Member
 
Total Posts:  3
Joined:  2012-02-27
 

I reviewed your Demo, but it does not provide the report I’m looking for.

Any other solutions?

 
Magento Community Magento Community
Magento Community
Magento Community
 
php007
Jr. Member
 
Total Posts:  3
Joined:  2012-02-27
 

*bump* Any help would be appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michaelbonocore
Jr. Member
 
Total Posts:  4
Joined:  2012-11-14
 

ONLY $49 - with Magento Advanced reports pro extensions - View Detail Now : http://www.mage-shop.com/magento-reports-extension.html

Advanced Report Pro extension allows you to select the report by one or multiple stores or all stores and it’s available for all types of report

It allows you to select “custom date range” options available in dropdown-box such as: Today, Yesterday, Last 7 days, Last week (Sunday - Saturday), Last business week (From Monday to Friday), This month, Last month, ... This dropdown-box is available for all type of report and it’s an advanced feature for you to take advantage of

Report pro extension allows you to select report from date to date you want and it also allows you to filter the report by order status ( advanced report extension ). Two features are available on all type of report. Presently it’s providing 8 report options for you to select as follows:

Report on sales by Country
Report on sales by Product
Report on sales by Customer Group
Report on sales by Coupon code
Report on sales Report
Report on sales by Hours
Report on sales by Day of Week
Report on New customers and Returning customers

Basic Advanced Reports offers other specialized options:

“Bestsellers” report. This report displays information about the products your customers most frequently purchased over a period of time. As an added benefit, the number of products can be limited

“Sales by Hour” report. This type of report helps you analyze the hours purchases were made in your traditional or online store. Each hour is set to be reported separately; however, this default setting can be customized

“Sales by Day of Week” report. Want to know how many sales you made on Tuesday versus Thursday? Advanced Reports can create a Week Day report for any week day

“Sales by Product” report. It’s easy to check the sales of any product for any period of time! Compare the sales of several products, all with the touch of a few buttons! Now with SKU instant search and detailed data selection by optional and masked SKU

“Sales by Country” report. It helps you maintain sales reports by country, which is especially critical if you’re operating on a global level. With the extension software, it’s easy to view the items purchased during any period of time; the amount and total price of the products purchased; and an easy-to-read world map showing where purchases were made

“Sales Report”. With this Advanced Reports unit, it’s simple to display the purchase date and time of products sold during a specified period. Filtering option allows you to sort the data according to any value you’d like - SKU, product name, manufacturer, etc.

“Sales” report. This report type is enhanced Magento Sales Report which allows you to display sales data on the chart and set up the pre-defined reporting period range.

“Users Activity” report. This report allows you to observe customers’ activities (e.g., new accounts and orders) for any period of time. The Users Activity chart is set up to reflect the reporting information visually.

“Sales by Customer Group” report
. This great feature gives you the opportunity to see sales by groupings of customer types

“Products by Customer” report.
This report allows you to learn how many products have been bought at a time by the majority/minority of your customers

The enlarged number of fields in each report type allows you to make a thorough analysis of your business situation.

Image Attachments
Advanced reports-4.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
Michaelbonocore
Jr. Member
 
Total Posts:  4
Joined:  2012-11-14
 
Michaelbonocore - 17 May 2013 06:18 PM

ONLY $49 - with Magento Advanced reports pro extensions - View Detail Now : http://www.magentocommerce.com/magento-connect/catalog/product/view/id/17462/

Advanced Report Pro extension allows you to select the report by one or multiple stores or all stores and it’s available for all types of report

It allows you to select “custom date range” options available in dropdown-box such as: Today, Yesterday, Last 7 days, Last week (Sunday - Saturday), Last business week (From Monday to Friday), This month, Last month, ... This dropdown-box is available for all type of report and it’s an advanced feature for you to take advantage of

Report pro extension allows you to select report from date to date you want and it also allows you to filter the report by order status ( advanced report extension ). Two features are available on all type of report. Presently it’s providing 8 report options for you to select as follows:

Report on sales by Country
Report on sales by Product
Report on sales by Customer Group
Report on sales by Coupon code
Report on sales Report
Report on sales by Hours
Report on sales by Day of Week
Report on New customers and Returning customers

Basic Advanced Reports offers other specialized options:

“Bestsellers” report. This report displays information about the products your customers most frequently purchased over a period of time. As an added benefit, the number of products can be limited

“Sales by Hour” report. This type of report helps you analyze the hours purchases were made in your traditional or online store. Each hour is set to be reported separately; however, this default setting can be customized

“Sales by Day of Week” report. Want to know how many sales you made on Tuesday versus Thursday? Advanced Reports can create a Week Day report for any week day

“Sales by Product” report. It’s easy to check the sales of any product for any period of time! Compare the sales of several products, all with the touch of a few buttons! Now with SKU instant search and detailed data selection by optional and masked SKU

“Sales by Country” report. It helps you maintain sales reports by country, which is especially critical if you’re operating on a global level. With the extension software, it’s easy to view the items purchased during any period of time; the amount and total price of the products purchased; and an easy-to-read world map showing where purchases were made

“Sales Report”. With this Advanced Reports unit, it’s simple to display the purchase date and time of products sold during a specified period. Filtering option allows you to sort the data according to any value you’d like - SKU, product name, manufacturer, etc.

“Sales” report. This report type is enhanced Magento Sales Report which allows you to display sales data on the chart and set up the pre-defined reporting period range.

“Users Activity” report. This report allows you to observe customers’ activities (e.g., new accounts and orders) for any period of time. The Users Activity chart is set up to reflect the reporting information visually.

“Sales by Customer Group” report
. This great feature gives you the opportunity to see sales by groupings of customer types

“Products by Customer” report.
This report allows you to learn how many products have been bought at a time by the majority/minority of your customers

The enlarged number of fields in each report type allows you to make a thorough analysis of your business situation.

 
Magento Community Magento Community
Magento Community
Magento Community
 
putler
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2014-03-11
 

Hello,

You may want to try out Putler and Putler Connector.

Putler also supports payment gateways like Paypal, 2Checkout and many more.

Hope that helps. grin

 
Magento Community Magento Community
Magento Community
Magento Community
 
JeniferKim
Jr. Member
 
Total Posts:  13
Joined:  2014-03-12
 

I used to think to create Magento report for my Magento website by my self but in fact it take me a lot of time and the result is not good as I expected
Finally, I decided to buy a Magento Extensions, and now I think it is a wise choice
thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mage Solution
Sr. Member
 
Avatar
Total Posts:  179
Joined:  2013-11-12
 

Magento Advanced reports brings 8 report options for you .With this extension you can check reports of products, customers, orders… in the back-end of your Magento site. It’s designed and developed to help you have the perfect solutions for your reporting with visual charts and tables.
ONLY $ 69
Presently it’s providing 8 report options for you to select as follows:
Report on sales by Country
Report on sales by Product
Report on sales by Customer Group
Report on sales by Coupon code
Report on sales Report
Report on sales by Hours
Report on sales by Day of Week
Report on New customers and Returning customers

Click HERE for more details

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top