Solved

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

Ram_A
Explorer
60 3 19

 

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,

Accepted Solutions (2)
Jonathan-HA
Shopify Partner
320 25 100

This is an 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:

JonathanHA_0-1674342459598.png

 

Under lineitemscustomAttributes:

 

JonathanHA_2-1674342660896.png

 

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

 

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill

View solution in original post

Jonathan-HA
Shopify Partner
320 25 100

This is an 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 %}

JonathanHA_0-1674343813748.png

 

 

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill

View solution in original post

Replies 5 (5)

Jonathan-HA
Shopify Partner
320 25 100

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.propertieshttps://shopify.dev/api/admin-rest/2023-01/resources/order

 

JonathanHA_0-1674337992970.png

 

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).

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill
Ram_A
Explorer
60 3 19

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
Shopify Partner
320 25 100

This is an 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:

JonathanHA_0-1674342459598.png

 

Under lineitemscustomAttributes:

 

JonathanHA_2-1674342660896.png

 

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

 

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill
Jonathan-HA
Shopify Partner
320 25 100

This is an 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 %}

JonathanHA_0-1674343813748.png

 

 

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill
Ram_A
Explorer
60 3 19

 

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.