Order Report Customization

[B4NAFTR]

I'd like to produce a report of all orders and list the Coupon Code as an additional column. Is there a way to do that?

[jjones]

There is no way to build custom reporting into the administrative software, but you certainly could do it with some standard PHP skills. All of the order information exists in the database under the ec_order table. This table holds the order totals, coupons used, and the customers shipping, billing and contact information. So the report would be either a simple excel dump of that table, or you could build a nicer looking web based report somewhere.

If you needed order details, then you would need to link the table to the ec_orderdetail table that holds individual product information, but most order summary information would be in the one table. I know crystal reports is another great tool for people wanting to build customized reports...