Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
114 Lượt xem

How to integrate products with customer individual length and width into ordering, procurement, production, stock management?

I need to integrate the following:

  • Customers order customized products at individual prices per product and per customer.
  • Customers order the products in a particular length and with.
    • Product A: 
      • 5 units
      • unit dimensions: 4000mm by 360mm = 1,44 m2
      • price/m2 = 0,23€
    • Product B: 
      • 2 units
      • unit dimensions: 2000mm x 420mm=0,84m2
      • price/m2 = 0,28€
    • Product C: 
      • 1 unit
      • unit dimensions: 3500mm x 380mm =1,33m2
      • price/m2 = 0,32€ 
  • I need a suitable solution for
    • orders and invoicing
    • stock
    • procurement
    • production

In order to decide for moving forward with odoo I need to make sure that this is possible in general and understand at an 'high-level',how this could technically work.


Thank you very much in advance. Any feedback is highly welcome. Cheers - Christian

Ảnh đại diện
Huỷ bỏ

Hi Christian - I think this should be possible using "dynamic" variants. Have you looked at how they work in Odoo?
https://odootricks.tips/about/odoo-applications/using-variants-colour-size-fit/

Hello there, Christian, unfortunately Odoo does not support this out of the box. We hired an Odoo partner to write an app for us that does this. Before you do the same, make sure you have figured out where exactly you need this: In the sales app? In the eCommerce app as well? Do you need the calculation for the weight for shipping? Do you need custom measures and price calculation in the purchase app, too? And so on. Also be aware of min and max measures. We had to change that from product templates to product variants, to differentiate how big each can be configured by the customer. Of all the customisations we have had, this wasn't the most complex, fortunately, and it works perfectly for years now. So I hope you'll find what you need.

Câu trả lời hay nhất

Hi,


In Odoo, managing customized products with individual dimensions and prices per customer is entirely possible through configuration and a few customizations. You can create a product template (e.g., Product A, B, C) and use product variants or custom fields to record customer-specific dimensions such as length and width. The system can automatically calculate the surface area (e.g., in m²) and compute pricing dynamically using a formula or custom fields linked to the unit price per square meter.


For orders and invoicing, the Sales module can generate quotations and invoices based on these calculated values, ensuring that each line reflects the correct price per m² and the total based on custom dimensions.


For procurement and stock management, the products can be configured as make-to-order (MTO) items so that each sale triggers a corresponding purchase or manufacturing order. Stock quantities can be managed either per piece or by total area, depending on your operational preference.


For production, Odoo’s Manufacturing module can use the dimensions to create custom bills of materials or routings, allowing each production order to reflect the customer-specific size and material usage.


In summary, Odoo can fully support this workflow through a combination of product variants, computed fields, and automated MTO procurement/production rules, ensuring seamless integration from order entry to manufacturing and stock control.


Reference:-

* https://www.cybrosys.com/blog/how-to-manage-product-variants-in-odoo-18

* https://www.youtube.com/watch?v=iRpaofKOGng

* https://www.cybrosys.com/odoo/odoo-books/v17-ce/inventory/product-variants-attributes/

* https://www.cybrosys.com/odoo/odoo-books/v18-ce/sales/product-variants-and-attributes/#:~:text=In%20Odoo%2018%2C%20the%20Product,from%20the%20module's%20Settings%20menu.


Hope it helps

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 5 25
4168
0
thg 11 24
1305
1
thg 8 24
2076
1
thg 8 24
3883
2
thg 5 23
2498