SQL2Report

SQL2Report

With Sql2report for magento plugin, you can simply generate report from a SQL, create filters y used as params in sql statements.

Magento brings a number of report, but in many cases not enough, you need specific information or change it, in this case you have two options, find a plugin in Magento Connect and get lucky that is the the specific report you want or develop it on you own, search Google: “How to develop a custom report in magento” and find that you have to create a plugin, with a folder structure, own class extending Magento class, PHP programming, generate the sentence, find how to insert a new filter, reuse magneto grid itself,… and in the end if you haven’t a much experience the learning curve is very large and create various report have several plugin makes a huge cost in hours.

To solve this, I created sql2report plugin, with this plugin you can:

• Create a report from a sql sentence.
• Create filters and use them as parameters in the report statement, such filters can be of type date, text field, a list of values or retreive the list of value from another SQL statement.
• Sort and group reports in groups.
• Export report data as csv or excel file and configure how to export.

• Quotes – Quotes list : Orders that are in carts and have not made ??the payment reached.
• Sales – by Day of Week : Sales Information (number of requests, number of products, subtotal, taxes, transportation costs, discounts and total) grouped by day of the week.
• Sales – by Hour :Sales Information (number of requests, number of products, subtotal, taxes, transportation costs, discounts and total) grouped by hour of the day.
• Sales – by Coupon code :Sales Information (number of requests, number of products, subtotal, taxes, transportation costs, discounts and total) grouped by coupon code.
• Sales – by Country : Sales Information (number of requests, number of products, subtotal, taxes, transportation costs, discounts and total) grouped by country.
• Sales – Sales general : Sales Information (number of requests, number of products, subtotal, taxes, transportation costs, discounts and total) grouped by day.
• Sales – by Zip Code : Sales Information (number of requests, number of products, subtotal, taxes, transportation costs, discounts and total) grouped by zip code.
• Products – Bestsellers : Sales Information (Product Name, Total sales, number of sales) grouped by product name
• Customers – Customers & guest list : Information of all clients and guests.
• Alerts – Rate equals 0 : Alert conversion rates between currencies equal to 0.