Setting up bundles in Inventory Planner ensures that sales demand of the bundle are accounted for in the components of that bundle. Bundles need to be configured so that you are ordering enough to meet demand of both individual sales and sales of bundles where the item is a component.
Managing Bundle Stock on Your Connected Platform
If you use an inventory management system that supports bundles/kitting natively you don't have to configure anything in Inventory Planner. We will automatically detect bundles and re-assign all sales to their variants. You will only see sellable items in the replenishment report and the forecast will be based on the combined sales (all bundles + product sales).
For e-commerce platforms such as Shopify, BigCommerce, and others that don't support bundles by default there are two separate stages:
- Use an application from their marketplace to create bundles and manage stock for them. Inventory Planner does manage stock so you need to ensure that bundle sales reduce components correctly.
- Mark bundled products within your Inventory Planner account. This allows Inventory Planner to maintain accurate sales (customer demand) for components when a bundle is sold.
Bundle Set-Up in Inventory Planner
To mark a product as bundle in Inventory Planner go to Replenishment > Variants. Find the bundle SKU, click on Details.
Then view the Bundles tab within Details. Here you will mark the SKU as a "bundle".
Assign Component Quantities
Next add all components with corresponding quantities.
If you need to create a variant as a component that is not a variant on your platform (listed for sale individually), then you can create an IP Variant. Instructions for adding an IP Variant are at the end of this article.
If your bundles are assembled prior to fulfillment (that is, stock of your bundles is separate from stock for each of its components) then check the box for 'Produced Bundles'. If your bundles are assembled at the time of fulfillment, then do not check this box.
For example, say you have Product A which you sell individually and in the pack of 6. If you have 60 units of A and this means you also have 10 units of Ax6, then do not enable 'Produced Bundle'. If you have 60 units of A and another 30 units of Ax6 (different assembled stock) so 60 + 30*6 units of A in total, then this option should be enabled.
You can also set this store-wide in Account > Settings
> Forecast > Produced bundles by default.
How to View Bundles
Once a bundle is configured you will be asked to recompute sales for your store.
After the recompute, bundles will show in Replenishment > Bundles.
Bundle components will appear in the Variants view and the forecast for those components will include both demand for the bundle and the product sold individually outside of the bundle.
Unbundle or Undo Settings for a Bundle
To unbundle an item, find a bundle first in the replenishment report by using the Bundle view. Then click Details > Bundles and uncheck the bundle option.
IP Variant - Add New Variant (Variant Not Available For Sale Individually)
If there is a component of your bundle that is not sold individually, you can create an IP variant by clicking on Add New Variant. An IP Variant only exists in Inventory Planner.
Note that this is not for creating a new product that will be added to your platform to be sold on its own. A new product for sale should be created on your platform then synced to Inventory Planner.
Create a title, SKU, and assign a vendor for this new variant. You can optionally enter the cost price, retail price (useful for calculating retail stock value metrics) and a barcode.
You can also set the starting stock level in each warehouse for the component, along with lead time and days of stock for each location. Click Create Variant.
Note: you can also set the cost price of the bundle to be the sum of the component (variant) cost prices. To do this, first configure bundles including associating components/variants. In Replenishment, view by Bundles (using drop-down at the top of the page), then select bundles with the checkbox on the left side of the page.
Then select Bulk Actions at the bottom of the page > 'Set bundle cost price from components'.
Manage Components Stock Based On Bundle Sales
To control stock of IP variants, there are two options. One is to tie stock of the component to sales of the bundle. When you click the checkbox to 'Manage components stock based on bundles sales', each sale of the bundle will reduce stock of the component by the corresponding amount. For example, if three units of an IP variant go into each bundle, a bundle sale will reduce stock of the variant by three units.
The second option to deplete stock of an IP variant is to include it on a warehouse transfer. For example, if you purchase Product Z in individual units from your supplier and sell it on Amazon in packs of two, you may need to bundle the individual units. In this case, you will create a warehouse transfer to the Amazon warehouse with the bundles by creating an assembly.
Create a spreadsheet with the following information in 3-10 total columns and including a column title for each:
- Bundle SKU or other identifier such as Title, ID (used by your sales platform), Inventory Planner ID, Vendor Reference, or Barcode.
- Component/Variant SKU or other identifier such as Title, ID (used by your sales platform), Inventory Planner ID, Vendor Reference, or Barcode.
- The Quantity of Components included in the respective bundle.
- Component Retail Price (Optional)
- Designating a Produced Bundle, enter "1" if so (Optional)
- Manage Components Stock Based On Bundle Sales, enter "1" if so (Optional)
Here is a template you can use for creating this spreadsheet. The import spreadsheet does not need to follow this format (columns may be in any order), though all columns do require a title.
Template for bundle import
Additionally you can Create IP Variants via CSV import. By checking the box for "Create IP Variants for non-existing components", additional (optional) fields will appear to add more information on IP Variants including:
- IP Variant Title.
- IP Variant Barcode.
- IP Variant Vendor.
- IP Variant Cost Price.
Go to Replenishment > Import > Bundles.
Click Select File and then select the spreadsheet you've created with bundle data.
In the import dialog, be sure to select the correct identifier. SKU will be the identifier used by default.
Match dropdown fields to the correct column in your imported CSV. When all fields are matched to the corresponding field in Inventory Planner, select Upload.