How to export my new options variants from order list export feature?

hi,

i will simplify my need:

i sell cups. I ask people (customers) to enter a name to print on it, to choose a material (wood,rock,plastic) and choose a priority (month,year,whatever) to produce & reveive.

To do that,i installed an application to add extra fields (option variants) into each product that the customer will add to his cart.

I tested two app :
EXPO ‑ Extra Product Options
Globo Product Options

Both applications offer the feature to add extra field options into the product item (item line of order).

I need to export my order list with the new extra fields (priority,material, name)

When i use the export feature of order shopify, the new extra field are not exported.

Whereas the new extra field are well stored into order detail lines (i can see the fields in order detail )

So, how can i export the new extra options field that the customer filled ?

is there a free application that can handle such export ? or a payable/subscribalbe application ?

I really need to have my new fields (name,priority,material) into each order lines that shopify export in CSV-excel.

I hope my need is clear, thank you to read me and also help&reply me.

Best regards

It’s not free, but it specifically states they do exactly what you need.

Matrixify can export line item properties with order export – https://matrixify.app/documentation/orders/#line-items-line-properties

Not free, but very useful.

I think Matrixify or EZ Exporter ‑ Data Exports can help you out with that but they all require paid plan to do so

hi,

i tried Matrixify but it exports only a merged string filed. there is no one column by each option.

All new options are like “field1: value1 fields2: valeue2 fields3: value3”

Well, it’s hard to predict how many properties there gonna be…

One option is to setup scheduled export from Matrixify to Google Sheet and then have some formulas to extract those values into separate columns.

Then instead of doing export, you just pull data from the Sheet.

Hey there Michael,

We don’t have a free plan, but our EZ Exporter app can export the line item properties in separate columns (more info here).

Each line item will be exported as a separate row and you can customize the columns to only include the fields you need (including the specific line item properties/personalization you want exported).

Hi @michael80000 :raising_hands:

If your requirement is to collect additional information from customers (such as name, material, priority, etc.) when they place an order and then export this information together with the order into a CSV file, this can definitely be done using Easify Product Options.

Here’s an example I’ve created so you can see how it works:

  • This is the result:

  • This is the app setting:

First, you can create additional fields for the product such as Name to print, Material (wood, rock, plastic), or Priority using the option field types available in the app, such as text fields, dropdowns, or radio buttons.

When customers place an order and fill in these details on the product page, all the information will be saved together with the order as option values.

After the order is created, you can go to the Orders section in the app and use the Export orders with options feature to export the order data. The exported file will be in CSV format and will include the information entered by customers, such as the name to print, selected material, or production priority. This makes it easy to process the order data in Excel or use it for your production workflow.

Additionally, when exporting, you can choose how the option data is displayed in the file. For example, you can display each option value on a separate row or group the values into different columns. This helps keep the data file clearer and more convenient when filtering or processing order information.

Overall, the setup is quite simple since the app interface is designed to be intuitive and user-friendly. You can quickly create option fields and export order data without needing any complex technical configuration. If you need further assistance during the setup, the support team is also available to help configure everything according to your needs.:blush:

can we have a screenshop of how it appears in EXCEL (or OpenOffice) or the content of the CSV file please ?