Product bundles

Manual: Add or Update Product Bundles via Bulk Action (OMS/WMS)

With this bulk action, you can create or modify multiple product bundles at once within afosto.app (OMS/WMS).
A product bundle is a SKU consisting of multiple underlying items (components).
When the bundle is sold, the stock of the components is automatically deducted.

Documentation link:
https://afosto.com/nl/docs/product/createdproductbundle/#wat-is-een-bundel

Use this when you:

  • Sell gift sets.
  • Offer sets (e.g. 4 chairs + 1 table).
  • Create bundles for promotions or seasons.
  • Sell multiple fixed combinations.

Step 1 Go to the bulk action

Log in to afosto.app.
Open Processes > Bulk actions.
Choose Product bundles.
You will now see a spreadsheet input screen.

Step 2 Select warehouse and business

  • Give your bulk action a unique reference.
  • Select the warehouse where you want to perform this action.
  • Select the business where you want to perform this action.
  • Click next if you agree with the selected options.

Step 3 Paste your data into the spreadsheet

You can copy and paste your data directly from Excel or Google Sheets.
The following columns can be used (* = required):

ColumnRequiredMeaning in Afosto
SKU*YesThe SKU of the bundle (the main product that is sold).
Track stockNoDetermines whether the bundle itself has stock, or only the components are leading.
Priced per componentNoDetermines whether the price is calculated per component or at bundle level.
PartsNoThe underlying SKUs that make up the bundle.

What is required?

SKU (required)*


This is the SKU of the bundle product itself.
It must already exist in the system.
When this SKU is sold, the components are automatically deducted.

Explanation of the other fields

Track stock
This determines how bundle stock is handled.

There are two situations:

Off (most common)

  • The bundle has no own stock.
  • Availability is calculated based on the components.
  • If one component is out of stock, the bundle is unavailable.

On

  • The bundle has its own stock level.
  • You manage the bundle as a separate item.

In most OMS/WMS setups, component stock is kept leading.

Priced per component
Determines how the price is calculated.

Off

  • The bundle has one fixed selling price.

On

  • The price is built from the components.

Use this only when you want to apply pricing logic per component.

Parts
Here you specify which SKUs the bundle consists of.
In Afosto this means:

  • Which items are deducted when sold.
  • In which quantities.

Conceptual example:

COMPONENT-A (1)

COMPONENT-B (2)


When 1 bundle is sold:

  • 1× A is deducted.
  • 2× B is deducted.

Without correct Parts, the bundle will not function.

Step 4 Check your input

Always verify:

  • Does the bundle SKU already exist?
  • Do all components (Parts) exist as SKUs?
  • Are the quantities per component correct?
  • Should Track stock be on or off?

Note: SKU is always leading — not the product name.

Step 5 Execute the bulk action

Click Process / Execute.

  • The system validates the rows.
  • Any errors are shown per row.
  • If successful, the bundles are immediately active.

Practical example

SKUTrack stockPriced per componentParts
GIFT-SET-01NoNoCANDLE-01 x1; TRAY-02 x1

In this example:

  • The bundle has no own stock.
  • The price is fixed.
  • When sold, 1 candle and 1 tray are deducted.

Important notes

  • Components must always have sufficient stock.
  • Bundles directly affect your available stock.
  • Changes take effect in real time in OMS/WMS.

Use Track stock carefully — it changes your stock logic.