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
. 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
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
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:
prepare order with the number of cases of a given product
send the bill of lading to warehouse for delivering usino the average weight of cases.
the warehouse send back the list of cases (number) for a given lot#.
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
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
