Skip to Content
Menu
This question has been flagged
3 Replies
1954 Views

Odoo 15 CE - Selling in Different Quantities (Individual, Case, Etc..)

I want to be able to sell a product in different quantities on the website, in POS, or via sales order. I'm afraid I need a module for this functionality...

Example:

I buy a case of 1000 cups for $75. Each case of 1,000 cups has 25 sleeves, each sleeve has 40 cups.

I want to allow the customer to purchase either a case of 1000 or a sleeve of 40 cups.

Ideally it would allow selection of either on the product webpage.

Current Setup (that doesn't work.)
I setup UoM category as "Unit"
Unit is base unit
Sleeve of 40 is bigger than reference, ratio of 40.0
Case of 1000 is bigger than reference, ratio of 1000.0

Product Packagings
Created Packaging "Sleeve of 40" with contained quantity "0.025 Case of 1000"

There are a few problems with this setup.
1) The 0.025 gets rounded up to 0.03 during a purchase, even when increasing decimal accuracy.
2) Packaging isn't available on the website.

I actually installed a module from the software developer Webkul that was supposed to enable this, but after a week of back and forth with them, they just showed me photos from their sales page that shows it's supposed to work. (Despite me giving them screenshots of it not working for me.)


It seems clunky to me to define a sleeve as 0.025 of a case, however I have to relate to our base Unit of Measure as on the Inventory Product Page and I can't change that because our pricing is setup as cost + 50%. (I achieve this by configuring a pricelist to add a negative discount to the base quantity.)

I'm hoping someone will suggest some simple solution I've overlooked. Any conversation is much appreciated!

 


Avatar
Discard
Author Best Answer

It appears I cannot comment on replies due to low karma, so I guess I will comment in a new answer.

@lars Aam
I do not see a way to define package pricing. In Inventory -> Configuration -> Product Packaging, creating a package allows you to name the package, assign a product, define contained quantity, its barcode, and via checkmark boxes, select whether the packaging is available in Sales or Purchase. 

I also do not see packaging as an option that can be chosen on the web store.

@Diiconnect Innovations
Interesting suggestion on kits. I looked at it. In this scenario, I would create a product named "Case of Cups" or "Sleeve of Cups". The main problem of this, it appears, is that you have to define the pricing of the kit.

Prices fluctuate very wildly and frequently in our industry. Our markup is setup as cost + 50%, and so we have to define our base unit as the unit in which we purchase. (Otherwise we would have to divide our $74.18 purchase cost of a case of cups by 1,000 routinely to update pricing.) And again in this scenario, we would have to update pricing in the base product and the kit unit.

I do understand we may need to change our processes to adapt to the capabilities of the software.

Avatar
Discard
Best Answer

You get problems whem you use unit of measure like that.  I know odoo many times recommended such a way to use unit of measure.  This is a typical example where it make lot of problems.  Set it up the easy way, as it is.

Base unit = 1 cup.

Package 1 sleeve = 40 cups.

Pacake 1 case = 25 sleeves. 

This is standard functionality, and you need no development.  Can be selected on the web shop, sales order.  You define prices pr package.

Avatar
Discard
Best Answer

Try using kits.

  • Install MRP (Manufacturing) app
  • Select Bill of Materials from Products menu
  • Select Kit under BoM Type
  • Create your kit product (make sure to set as consumable)
  • Add your item as a component to the kit in the appropriate quantity


Avatar
Discard
Related Posts Replies Views Activity
1
May 24
3093
4
Nov 23
4626
1
Dec 23
4494
3
Aug 23
5310
4
Feb 25
7511