Creating a New Bundle Product
A bundle product is a product made up of other products (raw materials or components), so its components’ quantities are deducted from the inventory according to the quantities set for it. For example, a set of 10 books whose books are deducted when the set is sold, or a perfume whose components of oils and alcohol are deducted in set proportions. The feature is useful in production businesses and in offers such as “buy one product and get another”. It can also be used to convert raw materials into a finished product without a manufacturing order. This guide explains enabling the feature, the two bundle types, creating a bundle product, what happens on sale and assembly, a bundle product inside another bundle product, and all restrictions and messages.
Table of Contents
- Enabling Bundle Products
- The Two Bundle Types: Compound and Pack
- Creating a Bundle Product
- Allowed Components
- Bundle Product Cost
- Selling a Compound Bundle Product
- Assembling and Selling a Pack Bundle Product
- A Bundle Product Inside a Bundle Product
- Returns and Invoice Edits
- Editing and Deleting a Bundle Product
- Error Messages and Solutions
- FAQs
Enabling Bundle Products
- Open Inventory & Products Settings.
- In the Products Configuration section, allow Bundles and Composite Items System.
- Choose the Default Bundle Type: Compound or Pack. This type is suggested when creating each new bundle product, and you can change it for each product.
- Save the settings.
🛈
Note: In the Product Tracking settings, there is the Allow Negative Inventory for Bundle Component option, which allows a negative balance only for products used as components in a bundle product. This option is disabled automatically if the default bundle type is Compound.
The Two Bundle Types: Compound and Pack
| Compound | Pack | |
|---|---|---|
| Idea | The product is sold from its components directly without assembling it in advance. | The product is first assembled from its components so it has a balance, then it is sold from its balance. |
| When components are deducted | On sale: the component quantities matching the sold quantity are deducted automatically. | On assembly (adding to stock while deducting the components). |
| On sale | The components are deducted, and the bundle product balance stays zero. | Only the bundle product balance is deducted, and the components are not touched. |
| Bundle product balance | It doesn’t need a balance. | It has a real balance, and it can’t be sold without a balance (unless negative inventory is allowed). |
| Suitable for | Restaurants, offers, and products prepared on order. | Products manufactured or packed in advance and stored. |
Creating a Bundle Product
🛈
Note: Add the components as products first before creating the bundle product. See the Adding a new Product guide.
- From the main menu, click Inventory, then Products & Services.
- Click the arrow next to Add and choose New Bundle.
- Enter the basic product data, such as the name, SKU, Selling Price, and Purchase Price (leave it empty for the system to calculate it; see Bundle Product Cost).
- In the Bundle Items:
- Raw Warehouse: the warehouse the components are deducted from. If it is left on Default Warehouse, they are deducted from the warehouse of the sale or assembly transaction.
- Bundle Type: Compound or Pack.
- Product: choose the component.
- Quantity: the component quantity needed to make one unit of the bundle product, with the unit if multiple units are enabled.
- Click Add Product to add another component.
- Make sure Track Stock is selected in the Inventory Management section so the components are deducted.
- Click Save.
🛈
Note: If you save without components, this appears: No raw materials have been added. Click Save again to save the bundle without raw materials. If you add the same component more than once, its quantities are added together. The opening quantity you enter when creating the bundle product is added to its balance without deducting the components.
Allowed Components
| Component | Allowed? |
|---|---|
| A product with the tracking type Quantity Only | Yes. |
| A product tracked by serial number, lot number, or expiry date | No: You cannot choose product with type serial number , Lot number or expiry date in the bundle. |
| Service | Yes, and its cost is calculated at the purchase price and it is not deducted from any stock. Except a service linked to a package: You cannot select the service with type package in the bundle. |
| Another bundle product | Yes, but it is deducted as a product and its components are not deducted. See A Bundle Product Inside a Bundle Product. |
| The bundle product itself, or a product that contains it | No, because it causes a circular reference. |
| An inactive or suspended product | It doesn’t appear in the selection list. If an existing component becomes inactive or suspended, selling the bundle product is prevented. |
Bundle Product Cost
- If you leave the Purchase Price empty when creating it, the system calculates it = the sum of (average cost of each component × its quantity), and services at their purchase price.
- You can enter the Purchase Price manually to set the cost yourself.
- On sale or assembly, the actual cost is calculated from the average cost of the components at the time of the transaction.
- If one of the components is a bundle product, its cost is calculated at its own average cost, not the sum of its components.
- Selling Price is entered manually and is not calculated from the components.
Selling a Compound Bundle Product
When you sell a Compound bundle product in a sales invoice, POS, sales order, or an outbound requisition for an invoice:
- The bundle product is deducted from the inventory.
- Each component is deducted from the Raw Warehouse with a quantity = the sold quantity × the component quantity, through a stock transaction whose source is Bundle.
- The bundle product is added to the inventory with the same quantity at the components’ cost, so its balance returns to zero.
- A journal entry is recorded for the deducted raw materials: credit the raw warehouse, debit Other Credit, matched by the journal entry for adding the bundle product.
⚠
Warning: If the Compound product has its own balance (for example, from an opening quantity or an inbound requisition), it is sold from this balance first, and the components are deducted only when its balance becomes negative. So don’t add a balance to a Compound bundle product.
If the quantity of one of the components is not enough and negative inventory is disabled, the sale is rejected with the message: Amount not sufficient for (component) of the (bundle product). You can view the transaction details from the Bundle Transaction Details button in the stock transactions.
Assembling and Selling a Pack Bundle Product
A Pack product needs a balance before it can be sold. To assemble a quantity of it:
| Method | Steps |
|---|---|
| Manual Stock Adjustment | From the bundle product page, choose Add, select the Deduct The Components From Stock option, and enter the quantity. Without selecting the option, the quantity is added without deducting the components. |
| Manual Inbound | Add the bundle product to an inbound requisition; the components are always deducted. |
- The components are deducted from the raw warehouse, and the bundle product is added at the actual cost of the components, so its average cost follows the average cost of the components.
- To store the bundle product in another warehouse, such as the finished goods warehouse, choose this warehouse when adding the quantity (the warehouse selection appears when the account has more than one warehouse), and the components are still deducted from the raw warehouse set in the product.
- A journal entry is recorded: credit the raw warehouse, debit Other Credit.
- If the components are not enough, this appears: Components amounts are not sufficient.
- On sale, only the bundle product is deducted.
- There is no unbundling transaction; issuing a Pack bundle product from the inventory doesn’t return its components. To return them, add them with an inbound requisition.
A Bundle Product Inside a Bundle Product
You can add a bundle product as a component inside another bundle product, but the deduction happens on one level only:
- When the main product is sold, the sub bundle product itself is deducted from the inventory, and its components are not deducted (the raw materials), whether the sub product is Compound or Pack.
- So if the sub product is Compound and its balance is zero, its balance becomes negative, and its raw materials stay as they are.
- The same applies when assembling a Pack product that contains a bundle product.
- You can’t add the bundle product inside itself, or add a product that contains it directly or indirectly.
⚠
Warning: If you want all raw materials deducted on sale, don’t put a Compound bundle product inside another; add the sub product’s components directly as components of the main product. Or make the sub product Pack and assemble a quantity of it in advance so it has a balance.
Example
Returns and Invoice Edits
- When a bundle product is returned with a refund receipt or a credit note, the bundle product itself goes back to the inventory, and its components don’t. The Compound product then has a balance that is sold first in the next sale.
- When a sales invoice is edited or deleted, the component transactions linked to it are deleted and recreated according to the product’s current components.
Editing and Deleting a Bundle Product
- You can edit the components and their quantities at any time. The edit applies to new transactions, and previous transactions keep their old components unless their document is edited.
- You can’t change the Bundle Type after the product has stock transactions.
- You can’t delete a bundle product that has stock transactions; make it inactive.
- Before deleting a product or making it inactive, make sure it isn’t a component in a bundle product; an inactive component prevents selling the bundle product.
Error Messages and Solutions
| Message | Cause | Solution |
|---|---|---|
| Bundles and Composite Items System are not allowed | The feature is not enabled. | Enable it from the inventory settings. |
| Bundle type is required | The bundle type is not set. | Choose Compound or Pack. |
| You cannot choose product with type serial number , Lot number or expiry date in the bundle | The component has a tracking type other than Quantity Only. | Choose a product with the Quantity Only tracking type. |
| You cannot select the service with type package in the bundle | The component is a service linked to a package. | Remove this component. |
| You cannot select a bundled product from within the same bundle. | You added the bundle product as a component of itself. | Remove this component. |
| This item creates a circular bundle reference because it (directly or indirectly) contains this bundle… | The component contains the bundle product, causing a circular reference. | Remove this component. |
| Amount not sufficient for (component) of the (bundle product) | A component’s balance is not enough on sale, and negative inventory is disabled. | Add a balance to the component, or enable Allow Negative Inventory for Bundle Component. |
| Components amounts are not sufficient. | The components are not enough to assemble the required quantity. | Reduce the quantity or add a balance to the components. |
| The Bundle cannot be sold because it contains inactive or suspended Bundle Items… | One of the components is inactive or suspended. | Activate the component or remove it from the bundle product. |
FAQs
How do I convert raw materials into a finished product without a manufacturing order?
Use a bundle product of the Pack type: create the finished product as a bundle product, and set the Raw Warehouse and the raw materials with the quantity of each for one unit. Then add a quantity of the bundle product to the finished goods warehouse with Deduct The Components From Stock selected; the raw materials are deducted from the raw materials warehouse by the produced quantity. Details in Assembling and Selling a Pack Bundle Product.
If I add a Compound bundle product inside a Compound bundle product, are its raw materials deducted?
No. When the main product is sold, the sub bundle product itself is deducted, and its raw materials are not, so its balance becomes negative. To deduct the raw materials, add them directly as components of the main product.
Do I need a balance for a Compound bundle product?
No; it is sold from its components directly. If you add a balance to it, it will be sold from it first without deducting the components.
Can a product with a serial number or lot be used as a component?
No; components must have the tracking type Quantity Only.
Why didn’t the components return to the inventory when the bundle product was returned?
Because the return brings back the bundle product itself. To return the components, add them with an inbound requisition, and issue the bundle product with an outbound requisition.
Can the bundle type be changed from Pack to Compound?
Only before the product has any stock transactions. After that, create a new bundle product with the required type.