Develop a new report (or Order View with export functionality) that contains the following order fields from the Magento database and one record per item ordered:
Purchased On (Date)
Bill to Name
Ship to Name
Gross Total (G.T.)
Item SKU (From Items Ordered)
Item Name (From Items Ordered)
Qty (From Items Ordered)
Price (From Items Ordered)
Subtotal (From Items Ordered)
Tax Amount (From Items Ordered)
Subtotal (From Order Totals)
Shipping & Handling (From Order Totals)
Discount (From Order Totals)
Processed Amount (From Payment Information)
Credit Card Type (From Payment Information)
NOTE: We need one row PER ITEM ORDERED. So an order with 3 items purchased will have three rows in the report with the common date (such as order number, date, etc.) repeated.
We will use this report on a number of Magento sites, so we need a simple plugin or code files to install in each Magento installation so we can have the same report in all of our Magento sites.
In your response, please describe how you will create the solution (a report in the reports section, a new order view in the sales section, a new plugin for Magento, etc.) and describe your total price and time required to complete this.
We have other Magento needs and wish to develop a relationship with a good Magento/PHP programmer.
See the attached file for a list of the fields we need with sample a sample report.
We also have purchased a plugin that allows us to extend the order grid and add additional fields to the order grid found in SALES>ORDERS. However, this plugin dies not allow us to add certain fields such as the Credit Card Type. We can provide this code to the programmer if they wish to expand on this plugin instead of developing one from scratch. The plugin is called EXTEND ORDER GRID BY AMASTY (https://www.magentocommerce.com/magento-connect/extended-order-grid-by-amasty.html).