Case study
OD Center: automated margin calculation for used boats and machines
OD Center (Ocean Dealers Ab Oy) in Bosund sells boats, engines and ATVs and has around 710 used products in stock. Optely built an automation that calculates what each used product has cost and the margin it leaves.
“Optely built an automation that connects our Tehden POS to a spreadsheet and automatically calculates the added value of our used products. It saves us manual work.”
The challenge
When a used boat or machine is serviced or gets new parts before sale, its value increases. But that value wasn't collected anywhere. Working out what each product had really cost – purchase price, labour and parts – was manual work.
The solution
We built an n8n automation that connects the Tehden POS system to a Google Sheets spreadsheet. The automation:
- fetches the used products and their purchase prices
- finds labour and parts for each product via the order number and calculates the added value – labour is counted at an internal hourly rate
- shows everything in the spreadsheet in two views that update automatically
- calculates the margin per product: sales price minus purchase price, labour and parts
The result
OD Center now sees straight away what each used product has cost and the margin it leaves – without calculating by hand.