Orders6 min read
Spot Engraving Orders With Missing Details Before Production
A pre-production checklist for Shopify engraving and made-to-order shops: export one column per property and find orders whose custom details are missing.
In this guide
To spot engraving orders with missing details, check every batch before it reaches the workshop, not after. Export the orders you are about to make with one column per line item property (engraving text, font, initials, upload link), sort by product, and look for empty cells on products that always need text. A blank cell next to an engraved ring is an order to hold and ask the customer about, today rather than at the bench.
Sellers of engraved, monogrammed and made-to-order products know the problem: the order arrives, payment is fine, but the custom detail is missing or sits somewhere unexpected. Nobody notices until someone picks up the blank and has nothing to engrave. This guide gives you a short check you can run on each batch, and explains where details usually go missing.
Why do engraving details go missing from Shopify orders?
The custom text a customer types on the product page is saved on the order as a line item property: a name and value attached to one item, such as Engraving: Anna & Tom. It only gets there if the field is part of the product form that adds the item to the cart. A few common situations can break that path:
- Express or dynamic checkout buttons. A buy-now button on the product page can send the customer to checkout without the cart. Whether your custom fields travel with it depends on your theme and options app, so test it on your own store.
- Bundles. When a personalised product is sold inside a bundle, the property can end up on the bundle line, on one component, or nowhere, depending on how the bundle is built.
- Theme updates or theme switches. Custom fields added by hand to an old theme are not copied into a new theme version. The product page keeps selling, but the field is gone.
- Renamed fields. If
EngravingbecomesEngraving text, new orders carry the new name. A sheet built around the old name shows those orders as empty. - Optional fields. If the field is not required, a customer can simply leave it blank.
Some of these give you no error at all. That is why a check on the orders themselves is more reliable than trusting the product page.
Why is a missing detail hard to see in a normal export?
Shopify’s standard order CSV export has columns for the line item name, quantity and SKU, but no column for line item properties. You can see properties on each order page, under the product title, but that means opening orders one by one.
Some export tools put all properties into a single cell, such as Engraving: Lena; Size: 52. A missing engraving then looks like a slightly shorter cell, which is easy to miss in a long list.
| How the details appear | What a missing engraving looks like |
|---|---|
| On each order page | Nothing under the product title, but only if you open that order |
| One combined Properties cell | Size: 52 instead of Engraving: Lena; Size: 52 |
| One column per property | An empty cell in the Property: Engraving column |
With one column per property, the gaps line up in one column, so you can sort or filter on it in Excel or Google Sheets.
How do I check a batch before production?
These steps use Columna: Order Export & Sheets for the export; the checks work in any spreadsheet.
- Choose the batch. Filter the orders you are about to make, for example paid and unfulfilled orders from the last few days, or orders with a tag such as
engraving. - Use one row per line item. Each personalised item then has its own row with its own text. Orders with several items repeat the order number on each row.
- Add a column for each property you need. The app scans your last 250 orders for property keys and offers a column for each, named
Property: <key>, such asProperty: EngravingorProperty: Initials. Add SKU or product and variant next to them. - Download CSV or XLSX. The file is built in your browser. Save the columns as a template so the next batch uses the same layout.
- Sort by SKU or product. Products that need personalisation now sit together.
- Filter the property column for blanks. In Excel or Google Sheets, filter
Property: Engravingto show empty cells. Every row left that belongs to a product that needs engraving is an order to hold. - Look for unexpected columns.
Property: Engravingnext toProperty: Engraving textmeans the field was renamed. Check both columns before you call an order empty. - Open the upload links. For print or photo products, a link that does not open the customer’s file is as much a gap as an empty cell.
- Hold and contact. Tag or note the incomplete orders, email the customers, and leave those rows out of the sheet you send to production.
What should I do with an incomplete order?
Hold it rather than guess. Contact the customer with the order number and the exact field you need, and keep their reply with the order, for example in the order notes, so the detail is on record if the item is questioned later. Once you have the text, the order goes into the next batch.
If the same gap shows up on several orders in a row, the problem is probably on the product page, not with the customers. Place a test order through each way of buying: the add-to-cart button, any express checkout button, and the bundle if you sell one. Open the test order and see whether the property is there.
How often should I run the check?
Run it every time you start a production batch. For a small shop that may be once a day; for a busy period, before each run. Also run it after any theme update, new options app or bundle change, on the first orders that come in afterwards.
FAQ
Can Shopify warn me when an order is missing its engraving?
Not by itself in the order list. You can make the field required on the product form, so a customer cannot add the item without it, but that does not cover every way of reaching checkout, so check the orders as well.
Why does the engraving show on some orders but not others?
Common reasons are a field that is optional, a buy button that skips the product form, a bundle that does not pass the property on, or a field that was renamed. Compare a complete and an incomplete order of the same product to see which way the customer bought.
My gift message is in the export but the engraving is empty. Why?
The gift message may be saved as the order note or a note attribute for the whole order, while the engraving is saved on the item as a line item property. Our guide to cart notes vs cart attributes explains the difference.
What if one item has quantity 3 and three different names?
Items with different text are usually separate line items, each with its own row. If customers type several names into one field, see our guide to a Shopify export with one row per quantity.
Try Columna: Order Export & Sheets
Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties such as engraving text, gift messages and upload links, each in its own column, processed in your browser. It is made for shops that hand orders to production, fulfilment or accounting. For the full setup, read exporting Shopify orders with line item properties or see the Columna: Order Export & Sheets page.
Want the blank cells to show up before production does? Try Columna: Order Export & Sheets on the Shopify App Store and check your next batch.