Inventory Sync

Does Connex support lot and bin numbers?

Connex can map values to the bin or lot fields, based off your QuickBooks item name. You must add rules or use a default bin. Then, contact us to upgrade your QuickBooks XML version to 12, which is a setting on your account.


Login to Connex and click configure. Under inventory site and bin mapping, choose an inventory site and a bin. You cannot assign a bin, unless you choose the parent inventory site. Here is an example:

What if my bin is a warehouse within a site?

In the map to on the rules, enter INVENTORY SITE:BIN. An example would be Amazon FBA:Amazon Bin 1:

How do I add a rule to map inventory sites?

In this example, we will map Boston as the site for all orders shipping to the United States. Here are the steps:

  1. Login to Connex.
  2. Click rules > my rules.
  3. Click add.
  4. Choose start from scratch.
  5. In the action field, select map inventory site.
  6. In the rules field, enter these details: 
  7. In the map to field, enter Boston.
  8. Finish the wizard.

Can Connex automatically add lot numbers?

Connex can add the last lot number from your last inventory adjustment. Here are the steps:

  1. On the Connex configure page, expand inventory.
  2. Expand the advanced inventory section.
  3. Check apply lot numbers to QuickBooks.
  4. In QuickBooks, create an inventory adjustment for the item on the order. Add a lot number.
  5. Sync the order to QuickBooks.

Lot numbers and bin locations must exist under your inventory site in QuickBooks.

Connex applies he most recent lot for the most recent inventory adjustment that it can find. The adjustment must happen in 30 days, or it will not work.

I have over a hundred bins. How do I map the bin dynamically?

We recommend an inventory control solution, if your mapping is this complex. Ideally, your sale should contain the site and bin. Contact our support and ask if we can map the fields. Attach a copy of the sale. Highlight the bin and site fields.

Adding rules individually is time-consuming. In this example, we will upload a spreadsheet. The rule says if the SKU is ABC:123, then map MA:Boston as the bin:

  1. Login to Connex.
  2. On the left, click rules.
  3. Click my rules.
  4. Click upload.
  5. Upload the attached sheet.