# Bulk Update Product Bundles

{% hint style="info" %}
The bulk operation feature for editing virtual bundles is particularly useful when there are a large number of bundles that need to be updated, such as in the case of upcoming campaigns. This feature allows for efficient and streamlined management of virtual bundles, saving valuable time and effort.
{% endhint %}

## Steps

<figure><img src="https://lh4.googleusercontent.com/SHBq7J9o9DunpiJbPyHVU_K4TztqRa6kv5cLvBQc4vFwzQ2AQ-mivHy876d8rLLS9_tnW3ACchjo22T9ukKPLEiefBtRFXS2e8JNjvckb9_2KfM7dp5U-8YLbeu5Se7PwUsGd0SFGoGp8_pQrn2xB7OXO4xm2Gwv27V2NvC32Bev0k3P677UC9lKlmlYNg" alt=""><figcaption></figcaption></figure>

1. Click on "Products" in the navigation menu.
2. Navigate to "Bulk Operations".
3. Click on the "Export" button displayed as an icon under "Update Product Bundles" and wait for the template to be generated.
4. Click on the "Template File" under the operation history once it has been generated to download the file. Then, edit the template file based on the [specification](#template-specification).

{% hint style="info" %}
To update product bundles, only upload the rows to be updated.
{% endhint %}

<figure><img src="https://3200660590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FY00avLzsxCKjiygAWqkf%2Fuploads%2FsBepXROF0ESsI1JDktiJ%2Fbundles%203.png?alt=media&#x26;token=9980f3e6-07b8-4f39-b282-5180f9891c5b" alt=""><figcaption></figcaption></figure>

5. Upload the edited template in the upload section under "Update Product Bundles".
6. Uploaded file will be marked as "Processed" under operation history if no issues were encountered.

{% hint style="danger" %}
If any issues arise with the uploaded file, the 'Operation History' section will display the 'Uploaded File' and 'Issues Report.' Download the Issues Report file and edit the fields that require corrections.
{% endhint %}

{% hint style="warning" %}
If any inventory items in the kitting process contain errors, you must update and add all inventories that are attached together before uploading them into the system.
{% endhint %}

## Template Specification

| Variant SKU                                                                                                                                                                           | Inventory SKU                                                                                                                                                                                                   | Quantity                                                 | Organisation ID                                                                                     |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------- | --------------------------------------------------------------------------------------------------- |
| <mark style="color:red;">**Mandatory**</mark>                                                                                                                                         | <mark style="color:red;">**Mandatory**</mark>                                                                                                                                                                   | <mark style="color:red;">**Mandatory**</mark>            | <mark style="color:red;">**Mandatory**</mark>                                                       |
| Variant SKU is a unique identifier for each product variation. (SellerSKU)                                                                                                            | <p>Inventory SKU is a unique identifier for each physical product.<br>Inventory should be already exist in Sellercraft<br>\*\*Users can do bundling by adding a row with the same variation</p>                 | Quantity of the item (Inventory) attach with the variant | Organisation ID that connected to the shop                                                          |
| <p><strong>Fill up the SellerSKU.</strong> <br><strong>\*Same SellerSKUs in the rows will be grouping together as bundle (Attach more than 1 inventories to 1 SellerSKU)</strong></p> | <p><strong>Please choose from the drop-down box, or copy and paste SKU for inventory from “Inventory Reference” sheet.</strong><br><strong>Inventory SKU that needs to be attached to the variant.</strong></p> | **Fill up the quantity for item (Inventory)**            | **Please choose from the drop-down box, or copy and paste ID from “Organisation Reference” sheet.** |
| sskublacktotebag                                                                                                                                                                      | invskublacktotebag                                                                                                                                                                                              | 1                                                        | fe50b9dd-bbe5-42be-b101-a710b10d83d0                                                                |

***Multi Items Variant Example***

<figure><img src="https://3200660590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FY00avLzsxCKjiygAWqkf%2Fuploads%2F1mzqKZIZXKsieFfgteRU%2Fimage.png?alt=media&#x26;token=41b45fa3-0a2d-4c92-9273-8237a1ce53b4" alt=""><figcaption></figcaption></figure>

***Single Item Variant Example***

<figure><img src="https://3200660590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FY00avLzsxCKjiygAWqkf%2Fuploads%2Fv0POH6JjRNM2JFhN73Kr%2Fimage.png?alt=media&#x26;token=f4183ddd-e776-4077-a2bf-6dac4c677104" alt=""><figcaption></figcaption></figure>