How do I map inventory assembly items to QB?

Introduction

Connex can map bundles or kits to QB, if the product SKU and the QB name of an inventory assembly item match.

Can Connex create inventory assembly items in QB?

Not at this time. We can match the product SKU to the QB item name of an assembly item. We are working on adding assembly items automatically for a future release of Connex.

Can Connex bring over COGS?

Our software adds a single line item to the order, which matches the assembly item. QuickBooks will debit the COGS account and credit the asset account for the bill of materials. Since we almost never receive COGS, we recommend a mass import of assembly items into QB.

Can Connex build assemblies?

Under the advanced tab of Connex, scroll down and check build assemblies. Connex will build assemblies under these circumstances:

  1. The SKU in Bigcommerce matches an existing assembly.
  2. The inventory assembly's quantity on hand minus the total from the order is zero or less.
  3. You have enough raw materials.

Prerequisites

QuickBooks must have enough components to build the assembly. Make sure that the product SKU matches to an existing inventory assembly item.

Inventory Assembly Items

In this example, we created an inventory assembly item called fruit basket. It contains apples and oranges. As we sell more fruit baskets, QB debits the COGS account and credits the inventory asset account. QB decrements the quantity on hand of the fruit basket, the apples and oranges.

Have more questions? Submit a request
Powered by Zendesk