How does Connex map unit of measure?

Each item has a default unit of measure and conversion ratios.


Each item has a default unit of measure and conversion ratios. Here is an example:

  • One box is ten pencils.
  • One carton is ten boxes.

If the default unit of measure was box and you send ten each, QuickBooks would divide the quantity ten by the conversion ration ten. You would see one box. QuickBooks would multiply the price by ten. If your unit price was $1 each, then the price would be $10.

The order will still balance, but the quantity and price from your order and QuickBooks would be different. You can instruct Connex to multiply the quantity and divide the price, which cancels QuickBooks calculations.

How do I set-up unit of measure in QuickBooks?

Here are the steps:

  1. In QuickBooks, go to edit and click preferences.
  2. Click items and inventory.
  3. Click the second tab.
  4. Select multiple U/M per item. This will enable mapping carton and each in this example.
  5. In QuickBooks, go to lists and click item list.
  6. Double click a product.
  7. Next to unit of measure, select a preexisting unit of measure or make a new one.
  8. If you make a new one, choose each.
  9. Assign the ratio: 

Under default units, make sure you specify each. If you specified box, then QuickBooks will divide the quantity by ten.

How do I map the unit of measure?

In this example, there is an order for ten pencils at $1 each. In QuickBooks, the pencils have a default unit of measure called each. On the order, the product description contains the phrase each. We will say if the product description contains each, then map each as the unit of measure.

  1. Login to Connex.
  2. Click rules engine on the left.
  3. Click add.
  4. As the template, choose map unit of measure.
  5. Enter a title and skip to step three.
  6. On the third step, click edit and enter each:
  7. On the fourth step, enter the QuickBooks unit of measure. In this case, enter each.

Here is the end result:

What if I sent cartons?

For this item, the default unit of measure is each. In this example, a carton is one hundred pencils. In the example above this paragraph, replace each with carton. In the background, QuickBooks will remove one hundred pencils from inventory.

How do I test if my rule was successful?

Here are the steps:

  1. Login to Connex.
  2. Click orders > order previewer.
  3. Choose your site.
  4. Enter an order number or choose a date range.
  5. When the grid appears, enter UOM in order details fields.
  6. On the right, you will see a UOM.