Elbuz calculates a bundle's price, cost price, stock and availability from its products: a component gets pricier, the set is recalculated too, with no manual bundle price.
When you need this:
- The bundle should cost less than its products separately — each component's discount goes into the set price automatically.
- You sell a “2 pcs” pack — the price doubles, the stock is halved.
- You buy the parts from suppliers — the set's price and availability update with the price lists.
- One component runs out — the set goes out of stock by itself.
Where to start: select the components in the product grid and click “Add to set”.
What product sets can do
A set is a regular catalog product that has a composition: a list of other products it is made of.
- Build a bundle from catalog products — with a few checkboxes in the product grid.
- Build a bundle from price list rows — for a product you don't have as a ready-made item.
- Set a quantity and discount for each component — the bundle saving is calculated automatically.
- Calculate price, RRP, cost price, stock and availability from the composition.
- Keep your own price with the “Fixed Price” flag while availability is calculated automatically.
- Recalculate all sets with one button or during a catalog update.
What to build from: catalog products or price list rows
The source of the composition determines when and by which rules the set price is recalculated.
| Composition from the catalog | Composition from price lists | |
|---|---|---|
| What it contains | products from your catalog | rows from supplier price lists |
| When it is recalculated | when the composition is added, with the “Update main products” button, and during a base catalog update from price lists | automatically during a batch update of price lists |
| Price is made up of | prices of catalog products | prices of price list rows that are in stock |
| Main product stock | how many bundles can be assembled | how many bundles can be assembled |
| Why use it | a bundle from what is already in your catalog | a bundle you don't have as a product — assembled from supplier price lists |
How to build a set from catalog products
You set the composition manually: a set is not built automatically by a rule or filter.
- In the product grid, select the components with checkboxes — everything that should go into the set. A bar with actions for the selection appears at the bottom.
- Place the cursor on the product that will be the main one (the set itself). The cursor and checkboxes are different things: checkboxes define the composition, the cursor points to the set.
- Click “Add to set” on the bar.
- In the confirmation window, check that the main product is at the top and the composition below it. Confirm.
Selections are stored on the server, not in the browser window. Everything selected goes into the set, even products on other grid pages. The confirmation window shows the first thirty items and the line “Total going into the set: …” — check against this number.
There is no limit on the number of items in a composition. If a product is already in this set's composition, clicking “Add to set” again won't add it a second time.
Right after adding, the main product's price becomes the total of the composition — for what exactly is written, see calculating a set from the catalog.
How to build a set from price list rows
This kind of set is a product you don't have as a ready-made item: you sell the bundle but buy it in parts from suppliers. The price and availability are pulled in with every batch update of price lists.
- In the price list products window, select the supplier rows you need.
- In the catalog product grid, place the cursor on the product that will be the set. If none is selected, you'll see the red message “First select the main product of the set in the catalog — nothing was added.”, and the row selections stay.
- Click “To set” on the selection bar and confirm the composition.
The confirmation window shows the composition from the server — all selected rows from all pages: the first thirty, then “...and N more items” and the total “Total going into the set”.
How to set component quantity and discount
The “Product sets” window opens for the selected product and shows its composition: component name, category, manufacturer, SKUs, price, stock status and two fields you fill in yourself.
| Field | What it does |
|---|---|
| Quantity | how many units of the component go into the set. An empty value counts as one unit |
| Discount, % | a discount on this component within the set: the component price is reduced by this percentage before it is added to the total |
Two actions on the window toolbar:
- “Delete set” — removes the whole composition of the selected product right after you confirm with “Delete”. The product itself stays and simply stops being a set; the component products stay in the catalog too.
- “Update main products” — recalculates the price and availability of all set products in the account built from the catalog, not just the open one. More: recalculating with the button.
Give each component a discount and the bundle will cost less than the same products bought separately — with no manual price that someone later forgets to update.
How the set's price and availability are calculated
Set from the catalog
- Price = total across the composition: (component price − discount %) × quantity.
- RRP and cost price — totals of the matching component fields, multiplied by quantity.
- Stock of the main product — how many bundles can be assembled: for each item, “stock ÷ quantity in the set” is calculated and rounded down, and the smallest number is used.
- Availability is set only when all components are in stock. If even one is missing, the set stays out of stock.
The “Add to set” button immediately writes only the set price using this formula. It doesn't change the price of a set with “Fixed Price” or “Do not update”. The set gets its RRP, cost price, stock and availability after “Update main products” or a base catalog update.
Set from price lists
- Price = total across price list rows: (price − discount %) × quantity, same as for a composition from the catalog.
- RRP and cost price — totals of the matching fields multiplied by quantity, without the discount.
- Stock — how many bundles can be assembled, by the same rule.
- Availability is set only when all items in the composition are in stock. If even one is missing, the set stays out of stock instead of selling at the price of an incomplete bundle.
A set with one item is still a set. A “2 pcs” pack is one composition row with a quantity of 2. Price and stock are calculated the same way as for a composition of several items.
A composition row where the set refers to itself is left out of the calculation — otherwise, with a quantity or discount, the price would change on every recalculation.
What blocks recalculation
| Product flag | Result |
|---|---|
| “Fixed Price” | the set price is not recalculated. Availability is updated from the composition for both kinds of sets, and for a set from price lists, stock is updated too |
| “Do not update” | nothing is updated |
| A composition item is not in stock in any active price list (set from price lists) | the set is not recalculated: availability is removed, price and stock keep their previous values |
The price list rule “deactivate products that are not in price lists” does not affect sets: a set has no row of its own in any price list, so without this exception it would be taken off sale on every update.
Two settings related to set calculation
Where: general system settings.
| Setting | What it changes |
|---|---|
| “Group bundles by supplier” | the set cost is calculated separately for each supplier instead of mixing rows from different price lists into one total. Use it when the bundle has to be bought from a single supplier |
| “Cost from composition” | doesn't affect sets: it works with the product specification (the “Product composition (specification, set)” section of the product card). When the card is saved, it calculates the product's cost price as the total of the specification items' cost prices. Set cost prices are calculated by the set recalculations themselves |
How to recalculate all sets with a button
The “Update main products” button in the “Product sets” window sends a single request to the server and doesn't queue a job. While the request runs, the button is disabled and a spinner turns next to it.
- The request finished — you'll see “Updated”.
- The request failed — the button becomes active again, and a red pop-up message shows the error text.
1
Update main products2
Delete set3
Quantity and Discount, %- Update main products — recalculates prices and availability of the main products.
- Delete set — removes the selected set.
- Quantity and Discount, % — columns holding each component's quantity and discount.
Three recalculation steps
Each step is one database query covering all sets built from the catalog at once. There is no limit on the number of sets.
- All such sets, except those marked “Do not update”, get the status whose classification in the stock status directory is “Out of stock”. This step overwrites availability set on a set by hand — including sets with “Fixed Price”.
- Sets whose components are all in stock get their availability back: the set takes the stock status of one of its components.
- Sets without “Do not update” and without “Fixed Price” get their price, RRP, cost price and stock written.
- Start or end
- Action or result
- Decision: the path depends on the answer
If the recalculation was interrupted
- Interrupted after the first step: all sets from the catalog, except “Do not update”, have the “out of stock” status, and prices are old.
- Interrupted after the second: availability is already new, price and stock are old.
- Prices for all sets are written by one query, so the button never leaves a state where “some sets have the new price and some the old one”.
- Clicking again is safe: each run recalculates everything from scratch from the composition and current component data. To finish an interrupted recalculation, click the button again.
The button doesn't save the previous set prices and availability anywhere, so they can't be restored.
How sets are recalculated during a catalog update
A base catalog update from price lists recalculates both kinds of sets at the price and product field update stage, before new products are added. The order is:
- Sets from price lists: availability is removed from all of them.
- One query writes the price, RRP, cost price, stock and availability for sets whose composition items are all in stock.
- Sets from the catalog — with the same three steps as the “Update main products” button.
Item availability is taken from all active price lists, not just the one being updated. A set built from different suppliers' items doesn't lose availability when one price list is updated.
- Start or end
- Action or result
- Decision: the path depends on the answer
What happens to the catalog if the update is stopped or interrupted, and what a restart does — base catalog update: interruption and restart.
Scenarios
A bundle cheaper than the same products bought separately
Task: sell several catalog products together for less than the sum of their prices.
What to do: select the components with checkboxes, place the cursor on the bundle product and click “Add to set”. In “Product sets”, fill in “Discount, %” for the components (and “Quantity” if needed) and click “Update main products”.
Result: the bundle price is the total of (component price − discount %) × quantity, stock is how many bundles can be assembled, and the bundle is available only when all components are in stock.
The bundle RRP ignores the discount — it's the total of the components' RRPs multiplied by quantity.
A “2 pcs” pack of one product
Task: sell a product as a pair, as a separate catalog item.
What to do: create a separate pack product. Select the single product with a checkbox, place the cursor on the pack, click “Add to set”, set “Quantity” to 2 in “Product sets” and click “Update main products”.
Result: the pack price is double the product price (minus “Discount, %” if set), and the pack stock is the single product's stock divided by two and rounded down.
A bundle from supplier items
Task: sell a bundle whose parts you don't keep in your catalog but buy from suppliers.
What to do: in the price list products window, select the part rows, place the cursor on the bundle product in the product grid and click “To set”. If the bundle has to come from a single supplier, turn on “Group bundles by supplier”.
Result: the bundle's price, RRP, cost price, stock and availability are recalculated during the base catalog update, and it's available only when every item in the composition is in stock. The “Update main products” button doesn't recalculate such a bundle.
Your own bundle price, automatic availability
Task: keep your own price on a bundle but have it go out of stock when a component runs out.
What to do: build the set with “Add to set”, then set the price in the bundle product's card and turn on the “Fixed Price” flag.
Result: recalculations don't touch the bundle's price, RRP or cost price, but calculate availability from the composition. Clicking “Add to set” again adds components without changing the price you set.
What to do when a set is calculated incorrectly
| What you see | Why | What to do |
|---|---|---|
| “Select products to add them to the set!” | no components are selected | select the checkboxes — without them, the bar with the “Add to set” button doesn't even appear |
| I can't find where to build a set | the button is not in a menu but on the selection bar, which appears after you select checkboxes | select products with checkboxes |
| “First select the main product of the set in the catalog — nothing was added.” | the catalog product that should become the set is not selected | place the cursor on the set product in the catalog product grid and repeat “Add to set” or “To set” — the selections stay |
| “To create a set of products, select a product from the price list!” | no price list rows are selected | select rows in the price list products window |
| More products went into the set than the confirmation window showed | selections are stored on the server, and the dialog shows the first thirty (for price lists, only the loaded page) | check the “Total going into the set” number and review the composition in the “Product sets” window |
| The set is “out of stock” | at least one item in the composition is out of stock — there's nothing to assemble the bundle from | check the availability of each item in the “Product sets” window |
| The set price doesn't change | the main product has “Fixed Price” or “Do not update” | clear the flag in the product card |
| The price of a set from price lists didn't change after a catalog update | at least one composition item isn't in stock in any active price list — such a set isn't recalculated, it only loses availability | wait until the item is back in stock or replace it in the composition |
| The set stock is lower than expected | it equals the number of bundles that can be assembled: the smallest “item stock ÷ quantity in the set” | find which item is the limit; that's the one you're short of |
| The bundle is assembled from different suppliers | “Group bundles by supplier” is turned off | turn the setting on |
| The price was recalculated for other sets too | “Update main products” recalculates all sets in the account | that's how the button works |
| A product was taken off sale after a price list update | not because of the set: sets are excluded from deactivation | look for the cause in the price list rules |
FAQ
How do I delete a whole set at once instead of one product at a time?
Open “Product sets” for the set product, click “Delete set” and confirm with “Delete”. The product and its components stay in the catalog. To delete the products themselves, select them in the grid.
Are components written off from stock when a bundle is sold?
Yes, if the set is built from catalog products. A posted sales invoice or sales receipt for the set writes off the components from stock according to their quantity in the set; the set itself has no stock. A set built from price list rows isn't broken down into components (sets in warehouse documents).
Can I build sets automatically by a filter?
No, the composition is set manually — with checkboxes in the product grid or in price list products (how to build one).
Can I make the colors and sizes of one product a set?
No, a set is a bundle of different products. Variations of one product are option products.
I set a set's availability manually — why did it change?
Set recalculation overwrites availability based on the composition, even for sets with “Fixed Price”. The only way to keep manual availability is the “Do not update” flag (recalculation steps).
Where to find it and who has access
- Menu
- Base product catalog → Products
- Build from the catalog
- select the components with checkboxes — the “Add to set” button is on the bar at the bottom
- Build from price lists
- the price list products window → selected rows → “To set”
- View the composition
- the grid's additional operations menu → “Product sets” for the selected product
- Access right
- the “Products” window; for a composition from price lists, also “List of price lists”
1
Add to set2
Product sets3
Select column- Add to set — builds a set from the products ticked in the grid.
- Product sets — opens the window with the set composition.
- Select column — the checkboxes used to mark products for a set.
Related topics
- To give a set “Fixed Price” or “Do not update” — product card.
- If the components come from supplier price lists — price list products.
- To understand when sets from price lists are updated — base catalog update.
- If you need color or size variations rather than a bundle — option products.
