You sell flowers in various quantities: 25 – 150 – 200 stems.
On Shopify, you have to set quantities for each stem option/variant, but this doesn’t show your real inventory accurately. For example, if you have 10,000 flowers available, it can be divided into:
400 bouquets of 25 Stems (10,000 in total)
66 bouquets of 150 Stems (10,000 in total)
50 bouquets of 200 Stems (10,000 in total)
Setting quantities individually for each pack size can result in a total inventory that’s much higher than what you actually have (e.g., 516 bouquets and 30,000 stems in total instead of 10,000).
Since all stem options/variants use the same inventory, choosing one variant should reduce the available quantity of the others. However, Shopify treats each variant’s quantity separately.
These problems show the need for a solution that accurately manages inventory across all stem variants.
To address this issue, consider implementing the following solution:
A. Create a Base Product
This product serves to set the initial total inventory available.
The initial inventory of this base product will determine the quantities available for selling for each visible Flowers product option displayed on the storefront. For example, the inventory of the Base product is 10,000 so there are 400 bouquets of 25 Stems variant available for selling.
It will reflect the actual remaining inventory. When a product variant is purchased (e.g., 25 Stems), the inventory of the Base product will be adjusted accordingly (deducted by 25).
Updating the inventory of the Base product will automatically adjust the inventory of other Flowers product variants (150 Stems, 250 Stems).
Notes:
Since the Base product is created for the purpose of tracking actual inventory only and will not be sold on the storefront, you can create it as Draft product.
You must create your Base product before creating the Bundle groups.
B. Create Bundle Groups in Easify Inventory Sync app
Establish connections between the Base product and the visible Flowers product variants (25 Stems, 150 Stems, 200 Stems) using Bundle Groups. This ensures that changes in inventory are synchronized accurately across all pack sizes.
How to Set Up the Bundle Groups
You’ll need to create separate bundle groups for each stem variant.
For example, if your Flowers product has 3 variants(25 Stems, 150 Stems, 200 Stems), you’ll need to create 3 bundle groups.
After creating the first bundle group (e.g., Flowers – 25 Stems), you can Duplicate that group to create groups for the remaining variants (150 Stems, 250 Stems).
Each group will contain the Base product and a Product variant.
If you have many products, consider using the app’s Import function to create all bundle groups in a CSV file and import them into the app.
Below is the setup guide for creating the bundle group for the 25 Stems variant:
1. Navigate to the app’s menu and select Bundle Groups.
2. Click on the Add new group button to create a new bundle group.
3. Set a Title for the bundle group, which should include the stem variant name to distinguish among bundle groups. For example: “Flowers – 25 Stems”.
4. Add 2 products to the group:
Product variant: Select the product variant of 50g (Flowers – 25 Stems) to add to the group.
Base product: Flowers (Tracking inventory).
5. Define the Master and Component products:
Master product: Flowers – 25 Stems
Component product: Flowers (Tracking inventory)
6. Specify the Quantity per bundle for the Component product:
Flowers (Tracking inventory): Since when 1 bouquet of the25 Stems product variant is bought, the quantity of the Base product – Flowers (Tracking inventory) will be deducted by 25. So, the Quantity per bundle of the Flowers (Tracking inventory) product will be 25.
Once your bundle groups are set up, inventory synchronizations will begin.
When a Flowers product variant is purchased, e.g.: 25 Stems, (reducing its quantity by 1), the quantities of the Component product (Base product for inventory tracking) will automatically adjust based on the predefined Quantity per bundle (25).
Notes:
Automatic Master Quantity Adjustment:
To automatically adjust the available quantities of each stem variant of the Flowers product (25 Stems, 150 Stems, 200 Stems) based on the actual quantity of the Base product, follow these steps:
Enable the “Update Master based on changes in Component inventory” feature on the Settings page.
The adjustment will occur immediately after you create the bundle group or enable this setting.
Manual Quantity Update Process:
If you update the Component product quantity on Shopify’s Product editing pages, consider the following:
The Master product inventory will not update automatically, even if the “Update Master based on changes in Component inventory” feature is enabled.
To update the Master quantity after changing Component inventory on Shopify’s Product editing pages: Navigate to the Bundle Groups listing page, select the group containing those products, and click on the “Update Master quantity” button.
If you run into any challenges while setting up your Bundle Groups, feel free to reach out to us for assistance through our convenient in-app live chat, by submitting your request via our contact form, or by sending an email to support@tigren.com. We’re here to help!
