Check Shopify order CSVs with multiple line items

Do not treat every order row as a duplicate

Shopify's order export can repeat the order identifier for each line item. First distinguish line-item rows from true duplicate orders; otherwise a deduplication step can delete products from a legitimate order.

• One order ID appears on several rows because it has several products
• Addresses or notes contain commas and line breaks
• A UTF-8 export looks damaged after opening it in a legacy spreadsheet

• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Check the CSV character encoding →Choose the source encoding from the preview instead of guessing from the country.

Define the unit you are counting

Decide whether the task counts orders, line items, or customers. LocaCSV can inspect and filter rows, but it will not infer which repeated order ID represents a legitimate item.

• Use the line-item identifier when reconciling product quantities
• Keep quoted commas and newlines inside address fields
• Preserve Shopify's header row for any supported re-import workflow

• Keep only rows that belong in the import →Exclude test, inactive, or incomplete records with a visible count.
• Remove duplicate CSV records by a selected key →Define the business key before removing a duplicate.

Inspect Shopify order rows in LocaCSV

LocaCSV does not calculate Shopify refunds, taxes, or fulfillment state. It keeps the original row boundaries visible so the analysis can be reproduced.

1. 1Open a copy of the Shopify export and run CSV diagnosis
2. 2Check the order ID, line-item, quantity, and financial columns
3. 3Filter only confirmed test or empty rows and record the count
4. 4Aggregate or export after confirming whether the unit is an order or line item

Reconcile orders and line items separately

• The number of unique orders and total line-item rows are both recorded
• Quoted addresses, notes, and product titles remain one field
• No duplicate-removal step deleted a valid line item
• The file remains UTF-8 when passed to the next tool

• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Keep only rows that belong in the import →Exclude test, inactive, or incomplete records with a visible count.
• Check the CSV character encoding →Choose the source encoding from the preview instead of guessing from the country.

If the goal is a Shopify import instead of analysis

Switch to the destination template and check size, headers, encoding, and product duplicates. An order export is not automatically a product import file.

• Split a Shopify product CSV under 15 MB →
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.

Diagnose the Shopify orders CSV