> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Replace a Single Row with Multiple Rows


## ${color}[#1a63ba](Replace a Single Row with Multiple Rows)
**(e. g. for creating an Order Picking list)**

This tutorial explains how to break down a set product (= a product created as a single item in Shopify without using a bundle app) into its individual components. For example, if you sell a PC-Set that includes a pc, a keyboard, and a monitor, you may want to separate these items for reporting or order picking. This guide shows you how to do exactly that. 
If you are using a bundle app to create your bundles, please refer to our separate article here: [How to Export Bundle Orders from Shopify with Datachamp](https://help.datachamp.io/en/article/how-to-export-bundle-orders-from-shopify-with-datachamp-15hstkw/)

${youtube}[](PJqe5HGeGow)

#### ${color}[#1a63ba](Steps to Split a Set Product into Individual Components:)

1. Filter the set product (optional)
If you only want to export the PC-Set, apply the following filter:
* "Line item: Name" includes “PC-Set” 
If you click Preview, you will see that the set product (PC-Set) is exported as a single row.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/scr-20260119-kspm_xw5moy.png)
2. Add the set components
Since we know which components the set contains, we will now add them manually. Therefore we go to the Rows-Tab:
* Add the first component row: click "Add" 
* Set Position to "After each Order"
* Click "Set condition" and choose: Add row if “Line items: Name” includes “PC-Set”

3. Enter product details
In the new row, enter the component details, for example:
* Name: PC
* SKU: SET1-PC-001

4. Set the correct quantity
For the quantity, use curly brackets to reference the actual ordered quantity.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/add-row_1gb9an6.png)

5. Repeat for other components
Repeat the same steps to add rows for the remaining components (e.g. keyboard, monitor).

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/other-two_ykuonq.png)
6. Preview the result
Click Preview again and you will see that the set product is split into its individual components.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/preview-1_1fub3g7.png)
7. Hide the original set row (Optional)
If you don’t want the original PC-Set row to appear in the export:
* Add another row
* Set Position to "Delete row of Order"
* Enable "Set Condition"
* Add the condition: "Line items: Name" includes “PC-Set”
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/hide_olzagq.png)
8. Save and run your report