Blog | Do you know your order profitability?
25th March 2015
Ever needed to know whether that last order was more profitable than the one yesterday? After all you had to source the stock from a different supplier.
We recently developed a bespoke module for key clients which plugs in to our ecommerce system (Shopit) that answers that very question every day.
Calculating your order profitability
The module is an orders spreadsheet which allows clients to add cost prices, mark true postage and packaging costs and other important information to any order. Any changes are calculated on the fly thus providing up to date profit data.
Why did they want this?
Prior to the module being deployed, our clients were managing this data through a single Excel spreadsheet which was shared over the network. As you can imagine this spreadsheet would have become very large in filesize, slow to update and inconsistent over time with a higher risk of file corruption. It also meant that they had to manually copy and paste the order information into the spreadsheet everytime which was extremely time consuming.
With clients already heavily utilising the Shopit! Admin in nearly all of their daily processes, it made complete sense that the spreadsheet was integrated into the admin as well – the data was already there, so the whole process would be so much quicker than manually copy and pasting.
What did we do?
Our first step was to take a copy of the Excel spreadsheet, see what data we needed to display and capture and then figure out the calculations. Once we’d got this settled, a few modifications and additions to the database and we were all set to start coding. During the entire development phase, we ensured that the spreadsheet’s code remained flexible should any future additions be required.
- Search filters
- Live editing
- Live calculations (no need to refresh the browser)
- CVS export
- Intergrates fully with our ecommerce platform (Shopit!)
WHAT WE USED
- PHP & MySQL
Our clients have been using the spreadsheet for a few months now and feedback has been really positive and it has speeded up their internal workflow considerably.
All we need now is a decent name for it! Any ideas?