How to separate bundled sub items into separate line items in Connex
Business Problem
A company wants to predict how much raw materials to order to build kits. Connex can predict how many products to order, based on previous order history. You must instruct Connex to sync the sub items of the bundle to Connex.
Example
We will create an item called TennisKit in Connex, create an order in Shopify, and instruct Connex to insert the sub items into the orders table. This ensures proper reporting and inventory planning.
The order must sync from your selling channel to Connex. We do not support syncing sales from QuickBooks to Connex and inserting sub items at this time.
Add bundled product
In Connex, go to products and click bundled items. Add a bundled product:
Here is the end result:
In Shopify, create an order with a kit:
Adjust Settings
- On the top of Connex, click connections.
- Select your channel.
- Under order settings, select Bundled Items Added as Line Items.
How does the sale appear in Connex?
When Connex inserts the Shopify sale into our database, our software pulls the sub items and adds the SKU, quantity, and unit price in Connex products table:
Shopify does not send a quantity and unit price for bundled sub items. Connex makes the order appear that the items were sold separately.
Here is how it will appear:
Order Number | Name | SKU | Quantity | Sales Price |
JMA1185 | WM-4000 | 6020 | 5 | 200 |
JMA1185 | Water Bottle | 4922 | 10 | 10 |
Without the setting, the sub items are never taken out of inventory:
Order Number | SKU | Price |
JMA1185 | TennisKit | 300 |