The Minimum Order Quantity (MOQ) requirement specifies the lowest quantity of a certain product that a supplier is willing to sell.
The Units of Measurement (UOM) requirement specifies case size or multiple used for ordering. For example, if a variant needs to be ordered in multiples of 50, then UOM will display the quantity to order on a purchase order as 50, 100, 150, etc based on the replenishment recommendation. Note that UOM will be a number entered, not text such as 'case' or 'pallet'.
When MOQ and/or UOM is specified it does not change replenishment numbers for variants that are shown on the Replenishment section of Inventory Planner. However when the variant is added to a purchase order and the quantity is below the MOQ or outside of the UOM, it's automatically rounded up to the MOQ or UOM number as appropriate.
How to set Minimum Order Quantity (MOQ)
This can be set under Catalog > Vendors with different options.
Change settings in the MOQ Type column. If you don't see this column, click on the gear icon at the right side of the screen to enable it.
- For Purchase Orders: This applies the MOQ to the total Purchase Order for the selected vendor. If the total quantity ordered is less than the value entered in the MOQ field, a warning will appear in red on the Purchase Order. To update to meet the MOQ, click Scale to Quantity on the error detail.
- For Variants or Products: this applies MOQ to the Variant (child) or Product (parent) level. This value can be entered on the Catalog > Vendor Attributes, or it can be uploaded in a spreadsheet on the Replenishment screen as part of a vendor catalog (Import > Vendor Attributes).
When a MOQ is specified it does not change replenishment numbers for products. However if the product is added to a purchase order and the quantity is below the MOQ - it is automatically rounded up to the MOQ number.
How to add Units of Measurement (UOM)
The Units of Measurement (UOM) requirement specifies the granularity of variants and is used when variants are purchased in boxes or other multiples.
This can also be set manually on the Catalog > Vendor Attributes or uploaded as the part of a vendor catalog.
When a variant with UOM is added to a purchase order quantities are automatically rounded up to the next UOM number. For example, when the UOM is set to 10 and the replenishment number is 45 it will be converted to 50 (5 packs of 10 items each).
Import MOQ/UOM to Vendor Attributes
You can import the MOQ and UOM values, using Replenishment > Import.
You can download a CSV template for the import, please also see the required/optional columns on the right hand side of the Import section.
Once uploaded, you can map the necessary details, using the column selections:
Once set, use "Import" option to complete the import.
An overview will be shown to advise on changes and if any errors were detected.
Viewing Replenishment with MOQ or UOM Considered
To see an adjusted Replenishment metric that considers vendor rules, you can add the "To Order" metric as a column using the gear icon in the top right of the Replenishment Report. Several others can also be added to see "To Order" at Cost, Gross Revenue, or Profit.
MOQ and UOM are available columns that can be added to the Replenishment table. In the example below - the first Variant was rounded to the nearest case of 50 based on the UOM rule. The second Variant was rounded to 1,500 based on the MOQ rule.