Home > Docs > StoreRobo - Shopify Product Import Export App > Add New Line Items to Existing Shopify Orders In Bulk

Add New Line Items to Existing Shopify Orders In Bulk

Last updated on October 3, 2024

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:

  1. Export the orders with Order ID and Name.
  2. Download and filter the unnecessary columns.
  3. Add line item-related columns (Line: Type, Line: Product ID, Line: Quantity)
  4. Import the CSV file back into the store.

Step 1: Export Shopify orders to update

To export required products,

  1. Head to StoreRobo Import/Export Suite.
  2. Click on Proceed under Export.
Export Shopify orders
Export Shopify orders
  1. Under Select data, choose Orders.
  2. Expand the data type.
  3. Under Basic columns, select ID and Name.
  4. 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
  5. Keep other options unchanged and click on Export.
Exporting orders to update
Exporting orders to update
  1. Once the export is done, Download the CSV file.
Download exported orders
Download exported orders

Step 2: Preparing the CSV file for order update

Once you have the downloaded CSV file:

  1. Open the CSV file.
  2. Remove unnecessary columns, retaining ID and Name columns.
Exported orders data in a CSV editor
Exported orders data in a CSV editor

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.

template to update orders to add new line items
Template to update orders to add new line items

Step 3: Add data to the CSV file

As we are updating orders with new line items(products):

  1. Set the Line: Type as Line Item.
  2. In the Line: Product ID column, please input the product ID of the specific line item you wish to add to the order.
  3. Under Line: Quantity, Enter the quantity of each line item you wish to add to the order.
  4. You can repeat the row with the same ID and Name to add multiple line items to a single order.
Updated CSV file for adding new line items to existing order
Updated CSV file for adding new line items to existing order

Step 4: Import the CSV file back into the store

Once you have successfully modified and saved the CSV file,

  1. Head back to StoreRobo Import/Export Suite.
  2. Under Import, select the updated file from the saved location.
  3. 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.
  4. You can use the preview option to verify the data.
  5. Under Select data type, select Orders.
  6. Click on Proceed.
Importing updated order csv.png\
Importing updated order csv
  1. Under options select, Update if orders already exist in the store.
  2. Finally, click on Import.
updating existing orders
updating existing orders

On successful import, the status will change to completed, and you will be notified by mail.

Import confirmation window
Import confirmation window

Once the import is done, selected orders will be updated with the new line items.

 Updated order
Updated order 1011
Order 1012
Order 1012
 Updated order 1013
Updated order 1013