There are instances where you may need to add line items to an order after placing it. While Shopify does offer this functionality, manually adding new line items to existing Shopify orders can be tedious and time-consuming. This task can become never-ending, especially when dealing with multiple orders simultaneously.
With StoreRobo Import Export Suite, new line items can be added to your existing orders quickly.
To add new line items to existing orders:
- Export the orders with Order ID and Name.
- Download and filter the unnecessary columns.
- Add line item-related columns (Line: Type, Line: Product ID, Line: Quantity)
- Import the CSV file back into the store.
Step 1: Export Shopify orders to update
To export required products,
- Head to StoreRobo Import/Export Suite.
- Click on Proceed under Export.

- Under Select data, choose Orders.
- Expand the data type.
- Under Basic columns, select ID and Name.
- Use the filter option to select only selected orders. For example, I’m only selecting the orders with the Name:
#1011
,#1012
, and#1013
. To know more about filtering orders, refer to the article, StoreRobo Export Filters for Shopify Order Data - Keep other options unchanged and click on Export.
- Once the export is done, Download the CSV file.
Step 2: Preparing the CSV file for order update
Once you have the downloaded CSV file:
- Open the CSV file.
- Remove unnecessary columns, retaining ID and Name columns.
Add additional columns
In addition to the ID and Name columns, you need to add a few additional columns manually in order to add line items.
- Line: Product ID or Line: Product Handle to identify the line item product. If you are selecting a specific product variant then you can use Line: Variant ID or Line: SKU.
- Line: Type to specify the type of line item in the order.
- Line: Quantity to specify the number of line items to add.
For this example, we will be using Line: Product ID to identify line items to add.
Step 3: Add data to the CSV file
As we are updating orders with new line items(products):
- Set the Line: Type as Line Item.
- In the Line: Product ID column, please input the product ID of the specific line item you wish to add to the order.
- Under Line: Quantity, Enter the quantity of each line item you wish to add to the order.
- You can repeat the row with the same ID and Name to add multiple line items to a single order.
Step 4: Import the CSV file back into the store
Once you have successfully modified and saved the CSV file,
- Head back to StoreRobo Import/Export Suite.
- Under Import, select the updated file from the saved location.
- Choose a delimiter as the one you set while saving the file. (comma is the default one). To learn more about delimiters, refer to Uncovering Delimiters: Crucial Data Organization Techniques.
- You can use the preview option to verify the data.
- Under Select data type, select Orders.
- Click on Proceed.
- Under options select, Update if orders already exist in the store.
- Finally, click on Import.
On successful import, the status will change to completed, and you will be notified by mail.
Once the import is done, selected orders will be updated with the new line items.