> ## Documentation Index
> Fetch the complete documentation index at: https://nce-docs.bglobale.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Product Bundle Mapping

You can create product bundles to group products so that they can be sold together. The Product Bundle Mapping screen enables you to import and process products in bundles and handle the mapping to a parent SKU on the Bundle Product Management page.

The product bundle mapping file can be uploaded in one of the following ways:

* Upload a CSV file via sFTP.
* Upload manually from the Merchant Portal. See [Product Bundle Mapping](/product-management#product-bundle-mapping-332678).

<Note>
  1. The CSV file format is the same for both upload options. No special formatting is required for a specific file upload.
  2. The time interval between load requests is 60 minutes.
  3. Contact your CSM to enable the sFTP file upload.
</Note>

## Importing Products in Bundles

**To import products in bundles:**

1. Navigate to Merchants > Product Management > Product Bundle Mapping from the top menu.
2. Select a merchant from the Merchant menu.
3. Download the Bundle template file by clicking File Format Example.
4. Populate the Bundle template file with the following values:

   * **BundleSKU** - The parent SKU as it exists on the products table.
   * **ChildSKU** - The child SKU as it should be passed by the merchant in the GSD request.
   * **Quantity** - The quantity of the child SKU items for this bundle,
   * **BundleFulfillmentGroup**(optional) - A merchant-defined label that groups the child-SKU rows making up one way to fulfil the bundle. Rows that share the same BundleSKU + BundleFulfillmentGroup form one fulfilment option. Free text (for example,`SINGLES`or`PREPACK`); it can be left empty when a Bundle SKU has only one fulfilment option (an empty value means the default/single option) and populated only when a bundle is fulfilled in more than one way - one label per option, shared across that option's rows. Global-e does not auto-group rows - the merchant assigns the label. The legacy 3-column file can still be used for the single-option case.
   * Fill out a row for each parent bundle SKU and child bundle SKU.

   **File Columns**

   The mapping file uses the following columns:

   | Column                   | Required?               | Description                                                                                                                                                                                                                           |
   | ------------------------ | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
   | `BundleSKU`              | Required                | The parent SKU as it exists on the products table.                                                                                                                                                                                    |
   | `ChildSKU`               | Required                | The child SKU as it should be passed by the merchant in the GSD request.                                                                                                                                                              |
   | `Quantity`               | Required                | The quantity of the child SKU items for this bundle.                                                                                                                                                                                  |
   | `BundleFulfillmentGroup` | Optional (may be empty) | Merchant-defined label grouping the child rows of one fulfilment option (e.g. `SINGLES`, `PREPACK`). Optional and may be left empty for a single-option bundle; populate it only when the bundle has more than one fulfilment option. |

## File Format: 3-Column and 4-Column

* The mapping file supports two formats: the legacy **3-column** format (`BundleSKU, ChildSKU, Quantity`) and the **4-column** format that adds `BundleFulfillmentGroup` as the 4th column.
* The format is detected from the **header row only**. Column order is fixed - `BundleSKU, ChildSKU, Quantity[, BundleFulfillmentGroup]` - and header names are matched case-insensitively. A single file cannot mix the two formats.
* Legacy 3-column files keep working with no change.
* A single `BundleSKU` can have several fulfilment groups (multiple rows with different `BundleFulfillmentGroup` values), so the same bundle can be fulfilled in more than one valid way.
* On import, Global-e **replaces per BundleSKU**: all existing rows for a bundle listed in the file are removed and replaced by the rows in the file. To keep multiple groups for a bundle, include every group for that bundle in the same file.

## Product Bundle CSV Example

The following figure shows the content included in a product bundle CSV file:

<Frame>
  <img src="https://mintcdn.com/globale-nce/uDvROrO5ThNQJhEA/images/uuid-238f0570-a92a-6399-0fad-1e8ac8511f95.png?fit=max&auto=format&n=uDvROrO5ThNQJhEA&q=85&s=6867568ba76f94a129550ec3fc12b5d5" width="525" height="236" data-path="images/uuid-238f0570-a92a-6399-0fad-1e8ac8511f95.png" />
</Frame>

Worked Examples

## Example - bundle PACK-3 can be offered two ways: three individual shirts (SINGLES) or one pre-packed kit (PREPACK).

| BundleSKU | ChildSKU  | Quantity | BundleFulfillmentGroup |
| --------- | --------- | -------- | ---------------------- |
| PACK-3    | SHIRT-S   | 1        | SINGLES                |
| PACK-3    | SHIRT-M   | 1        | SINGLES                |
| PACK-3    | SHIRT-L   | 1        | SINGLES                |
| PACK-3    | KIT-3PACK | 1        | PREPACK                |

* **Singles** option = 3 rows sharing group `SINGLES` (bundle fulfilled as individual child items).
* **Pre-pack** option = 1 row with group `PREPACK` (bundle fulfilled as a single pre-packed kit SKU).

The same bundle in the legacy 3-column format (still valid) - note that a 3-column file supports only one fulfilment group per Bundle SKU; multiple fulfilment groups require the 4-column format with `BundleFulfillmentGroup`:

| BundleSKU | ChildSKU | Quantity |
| --------- | -------- | -------- |
| PACK-3    | SHIRT-S  | 1        |
| PACK-3    | SHIRT-M  | 1        |
| PACK-3    | SHIRT-L  | 1        |