---
title: Multibuy Module Dataset
slug: multibuy-module-dataset
createdAt: 2026-03-18T16:36:31.892Z
---

The required dataset applies only to the **Multibuy Pricing Module**. It must include the list of products that offer multibuy pricing. Multibuy prices are proposed in a way that maintains an optimal proportion between tiers.

:::hint{type="info"}
Each table indicates the column name in the file, the data type, and a description. Primary keys (unique values) are highlighted in **bold**.
:::



## Bulk Offers

A complete list of all bulk offers must be provided. This dataset should include all essential information required to define product bulks, specific tiers, prices, and the validity period of each offer.

**For bulk offers data, we distinguish between two types:**

- **Historical data** – One-time export of the entire three-year history into a single file named ***bulk\_offers-history.csv***.
- **Daily incremental data** – Prices from the previous day must be exported in the file ***bulk\_offers.csv.***

| **Column**            | **Data type** | **Description**                                                                                                      |
| --------------------- | ------------- | -------------------------------------------------------------------------------------------------------------------- |
| **bulk\_offer\_id**   | string        | Bulk offer Identifier                                                                                                |
| **product\_id**       | string        | Product identifier                                                                                                   |
| **zone\_id**          | string        | Zone identifier.<br />Can be set to -1 or all in the case of global bulk offers.                                     |
| **date\_from**        | date          | Start date of bulk price offer                                                                                       |
| **date\_to**          | date          | End date of the bulk price offer.<br />This field may be left empty to indicate that the bulk offer has no end date. |
| **bulk\_tier\_limit** | decimal(2)    | Quantity tier limit for the discounted price.                                                                        |
| price                 | decimal(2)    | Bulk price of one unit of the product for specific bulk\_tier\_limit                                                 |
| discount\_type        | integer       | 0/1/2: 0 - percentual (i.e. 5% down). 1 - absolute (i.e. 5€ down). 2 - fixed (i.e. 5€).                              |

::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/GXXQsC7etcvsZPQR0ZRM--20260323-145937.csv" label="bulk_offers.csv"}

:::hint{type="warning"}
**Data Checks**

The higher tier limit must always have a lower price than the base price or any lower tiers.

The base price for every bulk offer × product is defined as the price for bulk\_tier\_limit = 1.

The maximum number of tiers is 6 (the base tier plus up to 5 additional tiers).
:::



## Sales

The standard sales file will be extended with one additional column to indicate the tier in which the product was sold, if the transaction was part of a multibuy offer.

:::hint{type="info"}
**Can all multibuy offers be identified in the sales data?** Their price\_type should always be set to 6.

**Does the sales file include shelf price information?**

**Does the sales file include bulk\_tier\_limit information?** If yes, do multibuy limits change over time?
:::

| **Column**        | **Data type** | **Description**                                                     |
| ----------------- | ------------- | ------------------------------------------------------------------- |
| bulk\_tier\_limit | decimal(2)    | Quantity tier limit that defines when the discounted price applies. |