Wednesday, April 24, 2013

How To Create and Install Custom Reports And General Reports In Magento

How To Create and Install A Report in Magento

Installation
Step 1: unzip AHT_Reportpro_1.0.zip From : Magento Advanced Reports
Step 2: In source folder, rename interface folder and theme folder in a way that is suitable for your website. Currently it is default.
Rename
app\design\frontend\default\default to app\design\frontend\your_interface\your_template
skin\frontend\default\default to skin\frontend\your_interface\your_template
Step 3: copy folder app and paste them on your root folder
Step 4: on admin panel, refresh cache, logout and login again. It is ready for your exploration



Report
After you install this extension, in admin of magento we have a menu “Report Pro”






We have eight advanced report here.
Sales by Country: Statistic order by country, with this report you can know what is country is good to sale your product
Sales by Customer Group: Statistic order by Customer Group. If your site have many customer group, you can use this report to know what is the best group have bought your products.
Sales by Coupon Code: This report use to statistic the order buy coupon code, it is useful to know, what coupon code is good in your sales campaign.
Sales Report: This is extra of sales statistic, many columns and many fields. With the filter, you can show specify for sales on your site
Sales by Product: Use this report you can know detail about sale of a product. It will list all order of this product by time.
Sales by Hour: This report will show the orders by hour in the day. You can compare the time to know what the time in the day is good for sale product.
Sales by Day of Week: This report show order by day in the week. Use this report you will know what the day is better for sale (Monday, Tuesday….)
New and Retuning customer: This report will show the number and the rate of new customer and returning customer. You can know the rate between new customer order and the old customer order (the old customer return your site and order product)

Sales by Country
Go to Report Pro/Sales by Country

Choose date range and status order then click “Show Report” button to show report.
The result as image below

Sales by Customer Group
Go to Report Pro/Sales by Customer Group
You can do same as Sales by Country


Sales by Coupon Code
Go to Report Pro/Sales by Coupon Code
Do same as Sales by country

Sales Report

Go to Report Pro/Sales Report
Choose date range then click “Refresh” to show the report

If you want filter the order, you can enter the value in the box (see above image) then click “Refresh” to show result

Sales by Product
Go to Report Pro/Sales by Product
Enter product SKU to report, this field support autocomplete, so you can enter some character, it will auto search the products are matching.

Choose Date Range, Status Order, Show By… then click Show Report to report.

Sales by Hour
Go to Report Pro/Sales by Hour
Do the same with Sales by Country, the order will be listed as image below

Sales by Day of Week
Go to Report Pro/Sales by Day of Week and do same as Sales by Country

New and Returning customer
Go to Report Pro/New and Returning customer
Choose Show By, Date Range then click Show Report

For more information on Report Pro Extensions, - ONLY $49 -  including a video overview of how it works, please visit the.




Enjoy the application! ;)

No comments:

Post a Comment