Csv order export with customer information

[Orlff]

Hi !

I would like to export orders in csv, with a column that contains a number that is in each customer's "notes" field (not the full notes fields, just a number inside it).

Is there any app that can achieve this ?

Thank you for your help.

[LukaszWiktor · Accepted solution]

Hi @Orlff,

You can achieve this with Exporteo. Our app gives you the flexibility to specify a CSV template in Liquid code. You can use the following expression to extract a number from the customer notes field:

{{ order.customer.note | extract_number }}

A simple CSV template that exports order numbers along with the number extracted from customer notes looks like this:

OrderNumber,CustomerNoteNumber
{%- for order in orders %}
{{ order.order_number -}},{{ order.customer.note | extract_number }}
{%- endfor %}

Please make sure to use the Bulk processing mode if you want to export multiple orders to one file.

[CloudlabSam]

Hi there! You can do this and much more with our Report Toaster app. Please feel free to take a look and reach out so we can setup the report for you.

[Jonathan-HA]

Hey there,

Just to give you one more option, our app EZ Exporter can also export just the numbers from the customer.note field as part of the order CSV export. 🙂

We have a feature called Calculated Fields where you can use a formula like this to only return the numbers inside the customer.note field:

strip_non_numeric_chars({{ customer.note }})

[BetterReports-C]

Hi @Orlff 

Claudia here from Better Reports.

Have you been able to find a solution? If not, I would recommend our app Better Reports for this.

We can easily create a custom field pulling the number from the customer note. With this field, we can create a report that you can export in CSV, Excel or PDF format.

In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use-cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?