Connex can map bundles or kits to QuickBooks if the product SKU and the QuickBooks name of an inventory assembly item match.
Can Connex create inventory assembly items in QuickBooks?
Not at this time. We can match the product SKU to the QuickBooks 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 QuickBooks.
Can Connex build assemblies?
Under the advanced tab of Connex, scroll down and check build assemblies. Connex will build assemblies under these circumstances:
- The SKU in Bigcommerce matches an existing assembly.
- The inventory assembly's quantity on hand minus the total from the order is zero or less.
- You have enough raw materials.
What date does Connex use to build assemblies?
Connex maps the order creation date minus a day to the build assembly date. This ensures QuickBooks has enough stock prior to the sale date. If you map the shipped date to the QuickBooks date, then Connex would use the ship date minus a day. If Connex failed to subtract a day and you lacked stock, then you would get this error:
The transaction could not be saved because the quantity on hand of item Survival Kit would go negative to -1 on 2017-11-15. Please ensure that the products you are selling have inventory.
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, QuickBooks debits the COGS account and credits the inventory asset account. QuickBooks decrements the quantity on hand of the fruit basket, the apples and oranges.