Hi there :) I was wondering, if there is a known and proven way to work with products that make use of a formula. That could be something like "$width * $length * price / square meter", so to put this product on an invoice for example, you'd have to put in the "width" and the "length" first, so the price of the product can be calculated. That would be the price per square meter of cause.
More complicated formulas should be possible as well, like adding the circumference multiplicated with a second price, e.g. "($width * $lenght * price / m²) + (2 * ($length + $width) * price / running meter)" like a cut metal sheet with worked on borders or a blanket that needs sewing around.
And so on... does anyone know? As far as I know, there is no direct function for this in Odoo. Is there a module perhaps or an example on how some one has done something similar?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
Hi Parker,
I think your question isn't easy to answer as under that simple demand (changing the way prices are computed), it may also let think that you have MRP processes attached to it?
I confirm there's no direct function for this in standard and you would need to develop it. In order to know how many hours/days would be needed for that, I can put you in touch with one of our advisors that would first spend time to understand your global need ;)
Regards,
Thank you Antoine! I think you are right. I've given it a little more thought and I do not think that it would even be neccessary, since length * width only result in the essential square meter. Therefore a simple JavaScript Calculator in the front end would be enough. I'll be in touch with a partner of yours, soon.
Would be nice though to have simple price formulas that'd ask for some parameters when adding a product to an invoice. Maybe that'll be added on day :)
Hi Parker !
I got the exact same issue and I'm wondering if you figured out something ?
Thank
Salut :)
Yeah, we had to go to an official Odoo partner who developed this for us. It indeed has to tackle a lot of things, as Antoine mentioned before.
This "square calculator" in our case, is implemented in the sales app, the purchase app and the e-commerce app to be able to select the product's dimensions. Then there had to be additions to the warehouse so delivery orders can have the appropriate information. Last but not least we needed the option to say how a unit on a manufacturing order has to be calculated (the material per m², the border per running meter).
We skipped the extra cost calculations on the cost of the material and the border and just made it a price per square meter, as this would have been way to difficult.
It is not an easy thing, to say the least.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
If nobody knows an existing way to do that, does anyone know how hard and complicated it would be to implement that? I have some coding experience, but neither do I know the inner workings of odoo, nor Python, yet, so how hard might that be for a pro?