Hi, I have a tick box for my customers to agree to donate Gift Aid on their orders, but this field isn’t coming through when I export the CSV file. 
I have read that it should show in Line item properties, but there’s nothing there?
Do I need to use an app for this?
Thanks!
Shopify’s native order CSV does not always include line item properties cleanly, especially if you need custom options from the product/order line.
You can do this with Altera by exporting Orders and including the Line: Properties column. That pulls the custom line item properties into the spreadsheet as key/value pairs, so it should work for personalization fields such your donation field.
Lastly it’s free for up to 100 rows, so that should probably work for your purposes!
Hey @Helene9
If the checkbox isn’t showing up in line item properties on the order or in the CSV export, that means it’s not actually being attached to the cart as a line item property when the customer ticks it. It’s just rendering as a visual checkbox without the underlying form input wired up correctly. Pretty common issue with custom additions to product or cart pages.
The fix depends on where the checkbox lives. If it’s on the cart page, the input needs name="attributes[Gift Aid]" to come through as a cart attribute (shows up under Additional Details on the order, exportable as Note Attributes in the CSV, not line item properties). If it’s on the product page and you want it tied to each item, the input name needs to be properties[Gift Aid], then it’ll show in line item properties on the order. Easiest way to check is right click the checkbox, Inspect, and look at the name attribute on the input. If it’s neither of those formats, that’s why it’s not flowing through.
No app needed for this, just a small theme code fix. If you can share a screenshot of the checkbox HTML or the theme file where it’s set up, I can point to the exact line to change.
Best,
Moeed
I agree with Moeed: there are several ways to pass a checkbox to order – cart note, cart attribute, line item properties.
First you need to make sure what method you use and that it actually passes data to order.
Make sure you can see this checkbox data in Admin.
As to the export – there is also another possibility: with Flow you can add lines to the Google Docs Sheet and you can control what data you want to have in your sheet.
Hi @Helene9, I’m Sajini from Identixweb, a Shopify development company.
It sounds like the “Gift Aid” checkbox field isn’t being captured properly in your export. Usually, line item properties are used to store custom fields like checkboxes, but if you’re not seeing it in the exported CSV, there could be a couple of reasons for that.
Here are a few things to check:
Ensure the Checkbox is Set Up Correctly: If you’re using a custom form or checkbox for Gift Aid, ensure that it’s properly added to the order as a line item property. The checkbox should appear under Order Details > Line Item Properties in Shopify. If you’re not seeing it there, the setup might need a small tweak in your theme code or checkout flow.
Export Settings: Double-check the export settings to ensure you’re including line item properties. Sometimes, Shopify exports exclude custom fields or line item properties by default.
Custom Code or App: If you’re still not seeing it, you might need a custom solution (small code tweak) or consider using an app like Order Printer Templates or Data Export that can allow you to create custom export templates to include line item properties.
Test with a Test Order: Place a test order with the checkbox ticked to see if it captures the data correctly and if it shows up under the line item properties in the export.
Hope this helps! Let me know if you need more assistance with this.
Can you share your store URL too? That will help me have a better look.
Best,
Moeed
Just checked the cart.json and good news, the form is working perfectly. The Gift Aid property is flowing through correctly:
"properties": { "name-for-certificate": "Test Name", "Gift Aid": "Yes" }
So the code is fine, this is purely a CSV export issue. Line item properties do export, they just go into a column called Lineitem properties which sits way to the right in the CSV (around column AA-AD), and most people miss it because they only check the first few columns. The format inside is Gift Aid: Yes; name-for-certificate: Test Name (semicolon separated).
Make sure you’re exporting via Orders > select orders > Export > Plain CSV file (not the Excel/Numbers version, that one strips some columns). Place a real test order with the box ticked, then export and scroll right until you see the Lineitem properties column. It should be there.
Best,
Moeed
Hello @Helene9
Yes, that is a familiar constraint of the default Shopify order export. Line item properties will only show up if the checkbox was included as line item property in the cart or product on the checkout. And if it was collected through other means, it might be absent from the standard CSV export.
Many merchants use apps such as Matrixify or Data Export IO to extract custom fields, cart attributes, or metafields more dependably. Or, place a test order to simulate and view what the Gift Aid amount appears on the order timeline/line item detail.
I’d check one more thing before assuming the export is impossible.
Since the property is showing in cart.json, the checkbox is probably being saved correctly. The question is whether Shopify is storing it as a line item property or as another order-level/custom field by the time the order is created.
For one real test order, I’d open the order in admin and check the actual line item area first:
Gift Aid: Yes appears directly under that product, not only in notes/additional details.If it appears under the product line item, then I’d expect it to export somewhere in the plain CSV, even if the column is far to the right or named slightly differently.
If it only appears in additional details / note attributes, then it won’t be in Lineitem properties; it would need to be exported as note attributes instead.
That distinction is what I’d verify first, because the CSV column depends on where Shopify stored the value, not just whether the checkbox worked in the cart.
Shopify’s basic built-in CSV export often drops or buries custom cart attributes and line-item properties, which is why your Gift Aid checkbox data is missing from your download.
To fix this completely and get that data into your spreadsheet, you can use Misk Order Export Pro. It is designed specifically to extract hidden order data that Shopify’s default exporter leaves behind.
Extracts Line-Item Properties: The app deep-scans your orders and uncovers the exact field where your Gift Aid selection is stored.
Custom CSV Columns: Instead of digging through a messy, packed row of text, you can map the Gift Aid checkbox data to its own clean, dedicated column in your CSV template.
Automated Reports: If you need these records for tax or auditing purposes, you can schedule the app to automatically export and email you the updated Gift Aid spreadsheet daily, weekly, or monthly.
@Helene9, Shopify’s native export already covers a lot of ground, but this is still a really common pain point with Shopify’s default CSV export. The built in exporter can treat line item properties, note attributes, and order metafields inconsistently. So even when the data is captured correctly, as it clearly is in your case since it shows up in cart.json, it may not always appear cleanly in the export.
Incase if you are willing to try an app, Report Pundit can pull the full order data model, including:
No coding in checkout or Liquid theme changes is needed. Once the app is installed, those fields become available as columns in your reports.
You can also automate the export and schedule it to run daily or weekly, then deliver the CSV to your inbox or Google Sheets.
It also avoids the confusion of whether the checkbox was stored as a line item property or a note attribute, because the report can surface it either way.
Adding another option here since this comes up a lot: the confusion between line item properties, note attributes, and order metafields is real. Shopify’s native export doesn’t cleanly separate them, and none of the three come through in the standard CSV.
I’m the developer of Export OrderPro, and this is exactly the gap Custom Columns are built to close. You can wire a column to a line item property key, a note attribute key, or an order/customer/product/variant metafield key individually, so you’re not guessing which bucket your data landed in. You just point the column at the specific key and it exports every time. There’s also a live Excel formula category if you need calculated columns, and a Local Row Status option for manual fulfillment tracking that stays in-browser.
Wrote up exactly how it’s configured, including the character limits and a few gotchas (like which column types slow down large exports), here: How Custom Columns Work in Export OrderPro | EXPORT OrderPro
Happy to answer specifics if anyone’s stuck on a particular field.