Hi everyone,

I’m working with a client who imports products from abroad, and I’m looking a guide on how to automate the product cost calculation process in Odoo 18 Enterprise.

Here’s the scenario:

1. The client orders products that are shipped in containers. Each product package occupies a specific amount of space in the container.
2. The client needs to calculate the cost of each product by adding:
   • The price they paid to their vendor.
   • The cost per square foot of the container space that the product occupies.

Example 1: Products in Cartons

• Product Y is packed in cartons, with 10 products per carton.
• The client needs to calculate the cost of the carton by adding:
  • The vendor price for the carton.
  • The container space cost that the carton occupies.
• To get the cost per unit, they divide the total carton cost by 10.
• Finally, they add their profit margin to set the sales price.

Example 2: Products Sold in Sheets

• Product Z is purchased in sheets (e.g., 50m x 50m), which also occupy space in the container.
• The client calculates the total cost of the 50m x 50m sheet by adding:
  • The vendor price.
  • The container space cost for the entire sheet.
• The product is then sold in smaller units, such as 10m x 10m sheets. 

If the price of the product + the price of square foot for container is entered in Odoo. The client wants Odoo to divide the total cost (price for container + price paid for the product with the vendor) to get the price per 10m x 10m sheet, and then they will apply the margin to set the sales price.

What the Client Wants:

• The client wants to automate this process in Odoo and they will input the following:
  • they will input the price paid for the product to the vendor.
  • they will input how the product was bought (per carton, sheet, roll, or unit).
  • they will input the space the product occupies in the container and the cost per square foot of the container.
  • they will input the dimensions how they sell each product: e.g: per unit, per sheet of 10m x 10m, per roll, per meter, per centimeter, per box.
    

They want Odoo to calculate the total cost per product (price paid from vendor + container cost), divide as necessary (e.g., by units, by sheet or dimensions) This will represent their Cost Price, and the client to add their profit margin for the final sales price.

Question:

Is there a way to automate this process in Odoo 18 Enterprise, where the system can handle these calculations and help set total cost price based on container costs and vendor prices? 

Does anyone know how to implement this requirement?

Thank you.