Recently a client of mine decided to do away with the useless “best sellers” page in admin (found at admin > reports > products purchased) and instead make it do something more useful.
Introducing the “Purchase Order” report…
1. We added a dropdown to select the last 30 / 60 / 90 days. When this is clicked the report updates to show a list of all the products sold within the selected timeframe
You’ll notice there are some extra columns; Manufacturers Name, Model, Stock on Hand. You’ll also notice a very special column where you can insert the quantity you want to re-order.
2. We added a “create purchase order” button linked to a script that creates a CSV file ready to save onto your hard drive and open up in your favourite spreadsheet.
Are you asking yourself how can that be useful ? If so, then you don’t need this script 🙂 If you can see the value of having a re-ordering script like this, then get in touch with me by email ( firstname.lastname@example.org ) as it can be yours at very low cost, fully installed, and fully supported and with any extra changes needed.
Possible extensions that I can think of; show gross amount of sales, show net sales, show sales made in August 2013. Show sales that have an order status of completed. I’m sure you can think of more. Use this script to supercharge your backend reporting and purchase ordering…
And here’s a video of it in action