All Collections
Frequently Asked Questions
Product and Stock Information
How can you add Minimum Order Quantity and Units of Measurement?
How can you add Minimum Order Quantity and Units of Measurement?
MOQ & UOM for purchase orders
Jansen avatar
Written by Jansen
Updated over a week ago

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 the 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 are 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 on the right side of the screen to enable it.

  • 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).

  • 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.

-

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 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.

  • Select Import at the bottom, then Vendor Attributes


  • Select the CSV file to upload, or drag the file to the upload section.
    We also offer the option to download a CSV template for this upload.

  • Proceed using the option to Map Columns, then use the dropdowns to match with column headers in your spreadsheet. Most of the columns are optional, if they are not selected, their value does not change

  • Use the dropdown options for each field to make sure the correct information is matched. Finally, click Import.

You will then see the results of your import, including information that was successfully imported and an error log if there were any issues encountered.

Please reach out to us, if you have any concerns with this process.

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.

Did this answer your question?