Skip to Content
This question has been flagged
3 Replies
789 Views
Avatar
Barry Healy

v15.

We buy steel bars in full lengths, I.e 3 metre bars. The customer can request that we cut any custom length, with the remaining piece return to stock.


An example would be:

5 pieces of 50mm diameter steel cut at 200mm

I want the customer to be able to tell the website (or sales person tell the sales/quote module) that they need:


Custom length: 200mm

Quantity: 5


The price will be calculated on the fly.


This will reduce the stock of the 50mm bar by 1mtr, I should then see my bar of 50mm show a remaining piece at 2mtr


I am struggling to find a way to implement this in Odoo.



Avatar
Discard
Avatar
ZY
Best Answer

I think you can create product with OD size (e.g. product name as Bar_OD50), and 'mm' as UoM. as Jaideep mentioned.

To receive the information for 5 pieces * 200mm, a convenient way is to create a product variant with custom attribute value, then customer could input the pieces and length manually. The only drawback is that they need also input the qty as 1000 correctly (i.e. it is 1000mm).




Avatar
Discard
Avatar
Barry Healy
Author Best Answer

Hi Jaideep,

I can't seem to get this to work, I need the customer to be able to add the custom length into the website then add the required quantity to their basket. 

The shop then offers a price in MM which is fine, but if my customer needed 5x 200mm then they would need to add qty 200 5 times, and it then shows as 1000 items in the basket. we would have no way to distinguish the customers requirements. Do you know of any addons that might help me accomplish this?

I would say the closest business to ours is that of a timber yard if that helps?

Avatar
Discard
Jaideep

I see what you are saying.. as far as i know this can’t be achieved in standard Odoo and might need customization/ 3rd party app.

You need 3 variables on the sale order, length, qty and unit price, while standard has only unit price and qty.

The work around in standard Odoo would be for customers/ sales teams to be able to capture qty and length which would update description in sales order and delivery orders.

You can achieve this by using product variants and have the attribute value as custom value and variant creation mode as never.

On the website 2 fields qty and length to be filled out by customer, while they would need to provide total as qty. (might be a bit misleading)

In your example customer will have to provide qty as 5, length as 200mm and qty counter as 1000.

Hope this helps, it isn’t a comprehensive solution and practicality depends on the number of such products and orders you receive.

Avatar
Jaideep
Best Answer

Create product as '50mm steel bar' storable with Unit of Measure 'mm' Purchase UoM 'm' specify Sales price per 'mm'.

practically you might need to track each bar separately (with a serial number), as you might be cutting and storing multiple bars at a time and would want to know which bar to cut from for an order

Avatar
Discard