Orders6 min read
Shopify Order Export Blank Rows: Stop Filling Cells Down by Hand
Why Shopify's order CSV leaves most fields blank on the extra rows of multi-product orders, how to fill them safely for fulfilment, and when to skip the step.
In this guide
- Why are most fields blank on the extra rows of my Shopify order export?
- Which columns should I fill down, and which should I leave alone?
- How do I fill the blank cells in Excel?
- How do I fill the blank cells in Google Sheets?
- Is there a way to skip the fill-down step?
- What should a fulfilment-ready order file contain?
- Where Columna: Order Export & Sheets fits
- FAQ
When an order has several products, Shopify’s order export puts each extra product on its own row and leaves most order fields on those rows blank: no email, no shipping address, no order date. That is by design, so the rows still read as one order. For fulfilment it means someone fills those cells down by hand before the file can be sorted, split or handed to the packing table. Below is why it happens, how to fill the gaps without breaking totals, and how to get a file that is ready to use straight away.
Why are most fields blank on the extra rows of my Shopify order export?
Shopify’s help page on exporting orders says that when an order has several line items, each additional item is shown on a separate line and many fields are left blank to show that the items were bought on the same order. The first row of the order carries the order details; the rows after it carry mainly the Lineitem columns.
A three-product order, simplified:
| Name | Shipping Name | Shipping City | Lineitem name | Lineitem quantity | |
|---|---|---|---|---|---|
| #1051 | maria@example.com | Maria Lopez | Porto | Linen apron | 1 |
| #1051 | Tea towel set | 2 | |||
| #1051 | Gift card holder | 1 |
Read top to bottom, that is fine. Sort the sheet by product, filter it to one SKU, or split it between two packers, and the second and third rows no longer say who they ship to. Merchants describe the same thing in the Shopify Community thread Need to export orders with no blank cells.
Which columns should I fill down, and which should I leave alone?
Fill down the fields that describe the order or the customer. Leave the money fields as they are, because they belong to the whole order and copying them onto every product row multiplies them when you add them up.
| Column type | Examples | Fill down? |
|---|---|---|
| Order identity | Name, Created at, Financial Status, Fulfillment Status |
Yes |
| Customer and address | Email, Shipping Name, Shipping Address1, Shipping City, Shipping Zip, Shipping Country, Shipping Phone |
Yes |
| Delivery choice | Shipping Method, Notes, Tags |
Yes, if packers need them |
| Order money | Subtotal, Shipping, Taxes, Total, Discount Amount, Refunded Amount |
No, keep on the first row only |
| Line item | Lineitem name, Lineitem SKU, Lineitem quantity, Lineitem price |
Already on every row |
If a three-product order has a total of 64.00 and you copy it onto all three rows, a SUM of Total reports 192.00 for that order. For anything per product, use Lineitem price times Lineitem quantity.
How do I fill the blank cells in Excel?
- Open the CSV and save it as an
.xlsxworkbook, so the formulas survive. - Select only the columns you want filled, for example
Emailand theShippingaddress columns. Do not include the money columns. - Press F5 (or Ctrl+G), click Special, choose Blanks and click OK. Excel selects only the empty cells.
- Type
=, press the up arrow once, then press Ctrl+Enter. Every blank cell now copies the cell above it. - Select the same columns, copy, and paste them back as values, so sorting does not break the formulas.
- Sort or filter only after step 5.
This works because the extra rows of an order always sit directly under its first row in Shopify’s file. If you sorted the file before filling, re-export it first, or the cells fill from the wrong order.
Power Query has a Fill Down command under Transform that does the same job and can be refreshed on the next export.
How do I fill the blank cells in Google Sheets?
Add a helper column next to each column you want filled. If Email is in column C and the helper is column D, with data starting in row 2:
- In D2 type
=IF(C2="", D1, C2)and copy it down to the last row. - Copy column D and paste it over column C with Paste special → Values only.
- Delete the helper column and repeat for the next column.
Is there a way to skip the fill-down step?
You have three routes. Which one fits depends on how often you export and what the file is for.
| Route | Good for | What you still do by hand |
|---|---|---|
| Fill down in Excel or Sheets | An occasional export | The steps above on every file |
| Shopify order CSV to Excel converter | Turning Shopify’s own CSV into a sortable sheet, in the browser | Run the export, then the converter |
| An export app | A recurring fulfilment or production file, or columns Shopify’s CSV does not have | Pick the columns once |
The converter fills the order details down within each order, so every line-item row carries them. It works on Shopify’s own export, so it cannot add columns that file does not contain, such as each line-item property in its own column.
What should a fulfilment-ready order file contain?
Whatever route you take, check the file against this list before it goes to the packing table:
- Every row says which order it belongs to. The order number is on every line-item row.
- Every row says where it ships. Ship-to name and address are on every row, not only the first.
- Every row says what to pack. Product, variant, SKU and quantity.
- Personalisation is readable. Engraving text, gift messages and upload links in their own columns, not one long text cell. Our guide to exporting Shopify orders with line item properties covers why Shopify’s CSV has no column for them.
- Money is counted once. Order totals on one row per order, or left out of the packing file altogether.
- Leading zeros survive. SKUs and ZIP codes such as
00123are imported as text, not numbers.
For the packing and production side of the same file, see packing lists and production sheets from Shopify orders. For a deeper look at the row layout itself, see Shopify order export: one row per line item.
Where Columna: Order Export & Sheets fits
Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties such as engraving, gift messages and upload links, each in its own column. It is built for shops that hand orders to production, fulfilment or accounting. You pick the columns once and save them as a template, such as order number, created date, customer email, line item, SKU and quantity, then filter by date, payment and fulfillment status and download the file. The file is processed in your browser.
Try Columna: Order Export & Sheets on the Shopify App Store.
FAQ
Why does my Shopify order CSV have rows with only product information?
Those rows are the second, third and later products of a multi-product order. Shopify leaves most order fields blank on them to show that they belong to the order above. The Name column, the order number, ties them together.
Can I fill the blanks with the same values as the first row?
Yes, for order and address fields such as email, ship-to name and city. Do not copy order totals, shipping, taxes or discounts onto the extra rows, or your sums count those orders several times.
Why did my fill-down put the wrong address on a row?
The file was sorted or filtered before you filled it, so the rows of one order were no longer together. Re-export, fill down first, then sort.
Does Shopify’s order export include engraving text or gift messages as columns?
No. Shopify’s order CSV has no column for line-item properties. To get each property in its own column you need an export app or a custom export.