How can I include delivery date in the exported CSV orders report without an app?

[Ram_A]

Hi,

Please check the attached file.d

I have a custom "product-grid-item__info  that shows the delivery date for each "Products"  on the cart page, as you can see in the attached pic.

Without using any APP, what I want is to have this info on the exported CSV orders report when I use the order export feature from the admin dashboard.

Currently, I can see it on the Cart page, on order admin page and I even I can see it on the confirmation email, or any other 3rd party app like Zapier or report apps.

I would appreciate any help, I am thinking of any workaround, like if it's possible to change the date data type from "product grid item" to something that can show up on the order report, like variants. 

The customer can select the delivery date from a custom Calendar Bar.

Thanks,

[Jonathan-HA · Accepted solution]

Ah, I see, totally understand the concern there.

I was just looking at Shopify Flow and one thing you could potentially do is add that information in the Order Note field, which is included in the default CSV order export.

Shopify Flow allows adding variables in the note field so you could potentially do something like this for the Action:

Update order note:

Under lineitems > customAttributes:

You can then probably use Liquid to only pull the specific attributes you need from that variable.

[Jonathan-HA]

Hey there Ram,

Unfortunately, this information is not available via the Shopify default order CSV export in the Shopify Admin.

If you're a developer or you already have a developer on your team, this information is available in the API under the field called line_items.properties: https://shopify.dev/api/admin-rest/2023-01/resources/order

If this is a one-off export, it might be worth considering just using an app with a free trial like our EZ Exporter app where you can create your own custom CSV export and place the custom options/properties in separate columns (just uninstall the app before the free trial period ends so your account doesn't get charged for it).

[Ram_A]

Thanks, Jonathan for your response, the thing with the app is a privacy concern, I don’t want to give access to the customer's data.

I thought there is a workaround, or maybe by using Shopify Flow! 

again, I appreciate your response 

[Jonathan-HA · Accepted solution]

Ah, I see, totally understand the concern there.

I was just looking at Shopify Flow and one thing you could potentially do is add that information in the Order Note field, which is included in the default CSV order export.

Shopify Flow allows adding variables in the note field so you could potentially do something like this for the Action:

Update order note:

Under lineitems > customAttributes:

You can then probably use Liquid to only pull the specific attributes you need from that variable.

[Jonathan-HA · Accepted solution]

Just did a quick test on our test store and this Liquid code works for updating the Order Note field to include Lineitem Properties in Shopify Flow:

{% for lineItems_item in order.lineItems %}{% for customAttributes_item in lineItems_item.customAttributes %}{{customAttributes_item.key}}: {{customAttributes_item.value}}
{% endfor %}{% endfor %}

[Ram_A]

I had not considered using the Order Note field for this purpose, so thank you for bringing it to my attention.
However, upon trying the Shopify flow, I noticed that nothing appeared on the Order Note. I suspect this may be due to the fact that my theme has been heavily customized.

May I request you to check your private message for further details? Thank you.