Skip to Content
This question has been flagged
7 Replies
7253 Views
Avatar
Anton Chuikin

Hi everyone, please try to suggest me the best set up for my rather complicated product and it's units of measures.

Basically, it is plywood, that each sheet has 3 dimensions: W x L x Thickness. But we sell it majority by packs. Each pack will have individual number of sheets depends on manufacturer (limited to 2-3 combinations). Obviously, each pack has volume in cbm. But, prices we quote, depending on a market, could be by sheet, by square meter or feet, or by cubic meter. 

i other system i use, key was thickness and the next step was to pick up packaging (how many sheets per pack) and the rest system calculated itself by multiplying dimensions on this parameters. What would be the best way with Odoo? Thanks in advance!

Avatar
Discard
Husam M. Obaid

hi , i just reached your query

my question did you find a solution for your case please , as i am facing something like it now

Regards,

Husam

Skype : husam-esco

Avatar
vishalratani
Best Answer

Key limitations in odoo: unit of measure category: odoo doesn't understand how to convert between related unit of measure categories like m, sq. m  and cu.m. So you would have to get to a workaround/ custom solution.

For your practical purpose, you can create different products by thickness(one Product.template per thickness size). And within that product you set the width or (widthxlength combination) to be variant defining attribute with unit of measure to be sq. m for the products.

Thanks
Vishal Ratani,
skype: vishal.ratani

Avatar
Discard
Ermin Trevisan

IMHO meters, square meters and cubic meters are not related categories, and the conversion has to be done by using BoMs of type "Set".

Anton Chuikin
Author

Dear Vishal,

I'm trying your second suggestion now, but i don't really like it for few reasons. But the main one, I need an option to buy or manufacture in one UoM and sell in 3-4 different UoMs and need oDoo to do everything for me. So, i think i'll check how complicated custom solution would be.

Dear Ermin,

I'm afraid using BoM will not let me do the job on fly? I'll have to convert manually my products when selling?

Avatar
Ermin Trevisan
Best Answer

Basically such a question is to broad and vast for this help forum, you may want to revert to the mailing list.

However, the general problem seems to be rather complicated. From a functional point of view you should study Odoo's product templates and product variants, bill of materials (BoM) for the conversion of UoMs from one category to another, and maybe also Pledra's product configurator (https://github.com/pledra/odoo-product-configurator), but most probably you would have to create a custom module for a well adapted solution. From a business point of view, you may want to consider a simplification of the price building.

Avatar
Discard
Avatar
Anton Chuikin
Author Best Answer

Thank you, Ermin,

  So, best strategy for person who just encountered odoo and liked everything except product  (me) is to find vendor who would "cook" me the solution?

Avatar
Discard
Ermin Trevisan

Based on the information you have posted, you should first follow the leads I have posted in order to get the knowledge to better analyse your case and then it s maybe a good advise to get a knowledgable functional Odoo consultant first. Your requirements seem to be difficult to be handled by any default ERP system.

Anton Chuikin
Author

So did I and, to be honest, looks like I can handle it using variants. Only frustration i have now is that you can't bulk change volume, m3 and weight for every variant and I can only do it one-by-one. What am I missing? Is their quicker way to do it? And also giving each variant personal internal reference (SKU) is the same headache. Should I import the list?

And another issue i faced - volume per item is limited by 2 decimals, when I need at least 4. Is it possible to adjust somewhere? I know when i create my own UoM i can adjust rounding precision, but this is smth else, isn't it?

Ermin Trevisan

Please do post new questions and not append to existing ones. For bulk editing check the OCA mass editing module and for the decimals check the decimal accuracy setttings in "Technical/Settings" somewhere.

Anton Chuikin
Author

Thanks a lot. Sorry, i will post new if I got them. Great help, Ermin.

Ermin Trevisan

Please upvote an answer, if it was helpful and tick the OK box when you consider the answer as valid.