Last updated 22/01/2021
Some products have different units of measure; perhaps you buy one pack of ten, but sell each item individually. Or maybe you buy tiles in packs, but sell by the square foot.
Cin7 can handle these situations easily by setting up a product with an alternative unit of measure; this allows you to calculate how much product to dispatch on the fly.
Before you can add in alternative units of measure, make sure that you have set the products module up correctly. To do this:
This will add a few extra fields to the product details page.
Each product has a base unit of measure. When the inventory in Cin7 says you have 10 items in stock, this means you have 10 of your base unit of measure.
Each alternative unit of measure is going to be a multiple of the base unit of measure. This multiple could be a whole number or a decimal.
When you enter an order in your alternative unit of measure, the system will know to convert this using the multiple into the base unit of measure.
Take, for example, a rugby ball. Rugby balls are sold separately, but are bought from the supplier in boxes of ten. You need to be able to order one box but, when the goods are received, you need your inventory to show 10 units. The base unit of measure will be single units, and the alternative unit of measure will be the box of ten. In a purchase order, you will add the rugby ball product, choose the alternative unit of "Box" and enter a qty of "1". On receipt of this order, 10 balls will be added to the inventory.
Choosing your base unit of measure
It might not always be obvious what to choose as your base unit of measure. Ask yourself how you count your stock. If you look at the shelf and count the boxes, then boxes is your base unit. If you count the individual components, then use items as your base unit.
To create a Product with alternative units of measure:
Using the example of the rugby ball above, the product would look like this:
Note that the second/blue line is the alternative unit of measure. Each line has its own unique code.
Each unit of measure has its own price and cost fields. If left blank, the base unit of measure price and costs are used.
To add a promotion to a product with UOM size less than 1, calculate the UOM QTY Price by using the following formula:
For example, a product with a UOM quantity of 0.1 and a unit price of $2.50 per unit would result in the values shown below.
Volume discounts can be applied to sales orders using Alternative Units of Measure, with a new unit being used for each tier.
To create a volume discount:
We really appreciate your feedback.