Below is an image of the screen at this URL in our Magento Community edition.
It is the grid view of all sales orders.
I have been tasked with building a printable worksheet report that will list all the orders in our Magento so in a nutshell I need to get the data that you see on this image below along with a couple other items about an order, such as the image for the products and dimensions. As well as be able to sort the data based of different order statuses.
I am not sure the best way that I can get all this data though.
Is it possible to query the database for all this data? What I build does not even have to be a Magento extensions, if it;s possible to simple query the database and build these reports that would be fine too.
Another idea, is perhaps the API is the best route to get all this data?
As I am new to Magento and haven't touched it in the past month even, I am just not sure where to start here.
Would appreciate any tips on how you would achieve this task.
All orders in our System have a Status and my boss would like these printable reports to list each Status as a heading section and then list all orders under each status section, so that is how I need to sort the data