· DataEase · Tutorials  · 3 min read

Bulk Add Line Items to Orders

Adding new line items to many existing orders manually can be extremely time-consuming. DataEase makes it easy: export orders, prepare line rows with itemCommand=CREATE, and import them back to Shopify—all with validation.

🎯 Goal

Add new line items to many existing Shopify orders at once using CSV/Excel and DataEase.

📋 Step-by-Step Instructions

1. Export Orders (Optional, for IDs)

In DataEase, go to New Export → Orders. Include at least:

  • id (order ID)
  • If helpful: name (order number), customer fields, and current line items for reference

Apply filters (date range, financial/fulfillment status) to target only editable orders.

2. Prepare the File to Add Items

Open the exported file in Excel or Google Sheets. For each order you’re editing, create one or more line rows:

  • Set topRow = TRUE on the order’s main line (you can leave order-level fields unchanged or set command=UPDATE)
  • Add lines with topRow = FALSE and itemCommand = CREATE to add new items
  • Provide one of: variantId (preferred) or variantSKU
  • Set itemQuantity (integer)
  • (Optional) itemPrice to override the price on the order line; otherwise Shopify uses the variant price
  • (Optional) itemProperties (e.g., key=value; color=red)
  • Keep column names exactly as in your export template

When done, save the file as .xlsx or .csv.

3. Import & Validate

  1. In DataEase, start New Import → Orders
  2. Upload your edited file
  3. Map columns (Order ID, line-item fields)
  4. Run Validation

Open the validation report and fix any issues (missing variantId/SKU, invalid quantities, non-editable orders).

4. Run the Import and Download the Results

After validation passes, click Run Import to add the line items to Shopify.

Once complete, download the results file and spot-check the edited orders in Shopify Admin: the new line items should appear, totals/subtotals updated accordingly.

📝 Important Notes

  • Editable orders only: Canceled/fully refunded/locked orders can’t be edited. Unarchive or revert status before editing if needed
  • Stock & fulfillment: Adding items increases items to fulfill; ensure inventory exists and adjust fulfillments afterward
  • Pricing & taxes: If you set itemPrice, taxes/discounts recalc from that value. If not set, Shopify uses the variant’s current price
  • Identifiers: Use variantId for reliable matching; use variantSKU only if unique across your catalog

💡 Minimal CSV Examples

Add one item to an order (by Variant ID):

id,topRow,command,itemCommand,variantId,itemQuantity,itemPrice
gid://shopify/Order/123,TRUE,UPDATE,,,, 
gid://shopify/Order/123,FALSE,,CREATE,gid://shopify/ProductVariant/111,2,24.99

Add two different items to the same order (use separate line rows):

id,topRow,command,itemCommand,variantId,itemQuantity
gid://shopify/Order/456,TRUE,UPDATE,,, 
gid://shopify/Order/456,FALSE,,CREATE,gid://shopify/ProductVariant/222,1
gid://shopify/Order/456,FALSE,,CREATE,gid://shopify/ProductVariant/333,3

Add an item by SKU (price from variant):

id,topRow,command,itemCommand,variantSKU,itemQuantity
gid://shopify/Order/789,TRUE,UPDATE,,, 
gid://shopify/Order/789,FALSE,,CREATE,SKU-RED-M,2

🎉 That’s it!

Your line items are now added to orders in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: