# Products set up

**URL:** <https://www.dolibarr.org/forum/t/products-set-up/13536>\
**Category:** Using my Dolibarr\
**Created:** [March 29, 2016, 11:47am UTC](https://www.dolibarr.org/forum/t/products-set-up/13536 "2016-03-29T11:47:31Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![maxdod](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/f1d935/32.png) [@maxdod](https://www.dolibarr.org/forum/u/maxdod)\
**Post date:** [March 29, 2016, 11:47am UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/1 "2016-03-29T11:47:31Z")

</div>

Hi, I am just few days working on Dolibarr. I am going to see if this product fits with the requirements of a friend of mine that sells forms of cheese.  
he has a hierarchy of products, for example:  
Parmesan (main product) --  
LOT : SFXXX (identifies a container of cheese forms)  
CASES: the single form of cheese into the LOT, each form has a different weight:  
Example:  
Product: Parmesan Reaggiano  
LOT: XX01 : Weight: 246 kg  
CASES: 1 - Weight: 120 kg  
CASES: 2 - Weight: 123 kg

Using Dolibarr product module I am able to insert the main product (Parmesan), associating the LOT , but I am not able to insert the cases list for each LOT.  
More, the selling is for number of forms and the invoice is based on the total weight\*pricexkg .  
My question: is possible to setup Dolibarr to manage this kind of problem or have I to develop a custom module to implement the “cases” table ?  
Thanks in advance  
Massimo

---

<div class="post-metadata">

**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\
**Post date:** [March 31, 2016, 7:55pm UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/2 "2016-03-31T19:55:44Z")

</div>

My guess would be this…

Make the CASES as one product and then make them part of the product package for LOT.

Apologies if I am wrong.

---

<div class="post-metadata">

**Author:** ![maxdod](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/f1d935/32.png) [@maxdod](https://www.dolibarr.org/forum/u/maxdod)\
**Post date:** [April 1, 2016, 5:01am UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/3 "2016-04-01T05:01:18Z")

</div>

Thanks for your answer. It could work but the problem is that the number of cases is huge compared to the number of product (see attachment)

 ![Schermata2016-04-01alle06.57.25.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/5/586f866359fc8fc4db496d9a737407e11cb1fbd7.png)

 ![Schermata2016-04-01alle06.58.35.png](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/a/affc90bfd35a75c1f20b547cb7dc60360c334b43.png)

. So , the list of products is not easy to manage.  
For now, I decided to develop a specific module to handle this. It works (I added two tabs to products (one with cases and one with lots), using a new table for cases and a view to join cases and lots).  
Now I am going to modify (add) the method to calculate the price of orders (the total price in dolibarr is based on number of items while , in my case, I have to multiply the weight of N items (cases) x the unit price (price/kg).  
Probably I have to create a new order detail table where put the informations about cases and fire a business trigger to overload the method to calculate the final price.  
Is the right way or there is a better solution ?  
Thanks  
Massimo

---

<div class="post-metadata">

**Author:** ![altatof](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/altatof/32/2426_2.png) [@altatof](https://www.dolibarr.org/forum/u/altatof)\
**Post date:** [April 1, 2016, 6:39am UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/4 "2016-04-01T06:39:14Z")

</div>

Hello, i’ve found already 2 modules that might manage your case :

> **[Votre spécialiste Dolibarr - ATM Consulting](https://www.atm-consulting.fr)**
>
> Votre spécialiste Dolibarr, ATM Consulting vous accompagne dans l'intégration de solutions open source ERP/CRM, GPAO et gestion RH.

  
[http://www.patas-monkey.com/index.php/fr/actualites/146-gestion-des-declinaisons-dans-dolibarr](http://www.patas-monkey.com/index.php/fr/actualites/146-gestion-des-declinaisons-dans-dolibarr)

---

<div class="post-metadata">

**Author:** ![maxdod](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/f1d935/32.png) [@maxdod](https://www.dolibarr.org/forum/u/maxdod)\
**Post date:** [April 1, 2016, 6:49am UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/5 "2016-04-01T06:49:34Z")

</div>

Thanks I will check the module, but really I have one product and not N products.  
I sell cheese cases; each of them has a different weight. In warehouse I select n cases from a lot# ,  
in the invoice I have to specify the REAL weight of the cases selected (because the price is function of weight not of number - i know that dolibarr on this is lack of functionality).  
So probably I will extend the shipment module with my logic (I am studying an elegant way to extend with modify the original code)  
Massimo

---

<div class="post-metadata">

**Author:** ![msnoeck](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/e495f1/32.png) [@msnoeck](https://www.dolibarr.org/forum/u/msnoeck)\
**Post date:** [January 30, 2017, 8:05pm UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/6 "2017-01-30T20:05:43Z")

</div>

Dear Maxdod,

Would you want to share this modification with me.  
Because I have more or less the same issue, instead of cheese I have choclate

Thanks and best regards Marcel Snoeck

---

<div class="post-metadata">

**Author:** ![maxdod](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/f1d935/32.png) [@maxdod](https://www.dolibarr.org/forum/u/maxdod)\
**Post date:** [January 31, 2017, 6:20am UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/7 "2017-01-31T06:20:31Z")

</div>

Hi Marcel , i would like to share with you the solution  
But the code is much customized. I had to modify manu classes and general functions (for example the computation of order prices).  
I have three kind of products:  
Price x quantity  
Price X weight  
Price X fixed weight  
To manage it I added an extrafield to product that specifies the nature of product.  
Then I have a more problem. Because every case of cheese has a different weight and i have not automated id of cases (just a paper on the pallet with the number of cases ) i have to process the order in two steps:

1. prepare order with the number of cases of a given product
2. send the bill of lading to warehouse for delivering usino the average weight of cases.
3. the warehouse send back the list of cases (number) for a given lot#.
4. the invoice is prepared setting the right weights and prices

I do not know if you have a problem like the mine  
I added also a list price management, accounting functionalities more advanced than the default, reservatio of a product cases for specified customers.  
I can send you more details (tables structure, etc)  
Massimo

---

<div class="post-metadata">

**Author:** ![msnoeck](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/e495f1/32.png) [@msnoeck](https://www.dolibarr.org/forum/u/msnoeck)\
**Post date:** [January 31, 2017, 12:24pm UTC](https://www.dolibarr.org/forum/t/products-set-up/13536/8 "2017-01-31T12:24:47Z")

</div>

That would be Nice,

I have more of less the same problem, only then with the chocolate.  
We deliver only per box, but the customer order by KG.  
And the amount weight of each box can be different.  
Example:  
Customer order 3 KG of Praline  
I have a box with 1,5 KG and 1 box 1,4.  
This means that the customer should pay 2.9 instead of 3 KG.  
The vendor who deliver the chocolate, will deliver the products with the folowing information:

- Product Code
- Lot Number
- Production Date
- Expire date
- Weigth of the box

So I whould be nice If you can send me by wetransfer the modifications/customizations  
Thanks for you support and cooperation

Best regards Marcel Snoeck  
my Email is : marcel.snoeck@home.nl
