Join us for an upcoming Shopify Partner webinar on February 27, 2024. Discover the latest Checkout Extensibility features, and deep dive on improvements to Shopify Functions and Web Pixels. Register now for either the 10am EST or 2pm EST sessions.
Solved

Export Customer Personalization

svcimino
Visitor
1 0 0

Hello,

 

We allow the customer to enter personalized messages that we then engrave onto our products. I am looking for the best way to export that information into either a CSV or some other format so that I can that upload that information into CorelDraw. 

 

We are currently using a copy and paste system that is not working all too well for us. 

 

I want to see if it is at all possible to gather this system using the API before I start spending too much time making it work.

 

Thanks.

Accepted Solution (1)

Jonathan-HA
Shopify Partner
314 24 98

This is an accepted solution.

Hey there @svcimino ,

 

This would normally be stored in the line_items. properties field in the Order API.

 

A quick way to check if it's there is to simply add .json to the URL in the Order Detail page in the Shopify Admin (after the Order ID).  This will give you the raw JSON data similar to what the API will output (more info here).

 

If you're open to using a third-party app, our EZ Exporter app can also generate a custom CSV export for you where you can include individual line item properties in separate columns (more info here).

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)

CloudlabSam
Shopify Partner
515 41 81

You could gather this data via the API if you want and then add to a CSV that you could use. you would just use the Admin Api and the Order endpoints. the data you are seeking is probably stored in the Note Attributes or Line Item Properties.

 

As an alternative, we could help you do this in a few minutes using our Report Toaster app. please feel free to take a look and contact support at support@cloudlab.com with your specific requirements and we can help get it setup.

PaulNewton
Shopify Partner
6274 572 1311

This highly depends on where that data actually lives.

Is that data inside of an app?

If it's in an app you need to consult with that app.

 

Is it in the shopify admin data such as in orders, in customer metafields, etc

In which case if you know programming check for the data via the graphql api in a tool like postman,insomnia, or shopifys graphiql-app.

If your not familar with programming and purely need this data in CSV look at export apps like matrixify, ez-exporter.

If the data needs some sort of logic to work on it as part of the export then look at scriptable automation tools such as usemechanic so you don't have to build a full app( https://tasks.mechanic.dev/?q=CSV , https://tasks.mechanic.dev/?q=customer%20meta  )   

If you need a script made you can contact me,info in sig please provide context(post url, issue,etc).

 

Good hunting.

 

 

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


Jonathan-HA
Shopify Partner
314 24 98

This is an accepted solution.

Hey there @svcimino ,

 

This would normally be stored in the line_items. properties field in the Order API.

 

A quick way to check if it's there is to simply add .json to the URL in the Order Detail page in the Shopify Admin (after the Order ID).  This will give you the raw JSON data similar to what the API will output (more info here).

 

If you're open to using a third-party app, our EZ Exporter app can also generate a custom CSV export for you where you can include individual line item properties in separate columns (more info here).

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

Report-Pundit
Trailblazer
300 11 20

Hello @svcimino ,

As Sam mentioned, this can be done via API using Order endpoints. Alternatively, Report Pundit can retrieve line item properties such as personalized messages and other factors in CSV, Excel, and PDF formats.

If the total number of orders in the store is less than 1000, our Free plan will support it.

You can reach us at support@reportpundit.com

Thanks!

Report Pundit - Instant reports and custom dashboards

EasifyApps-Zoe
Shopify Partner
582 14 38

Hi @svcimino,

One effective solution for your needs would be to utilize the Easify Product Options app, free plan available. With this app, you can easily create custom Engraving options tailored to your specific requirements 🤗.

 

EasifyAppsZoe_0-1696567147547.png

 

Once you've set up these options, you can seamlessly export them as individual line items using an order export app like Exportier

 

EASIFY - MAKING SHOPIFY SIMPLE & SWEET!
Easify Product Options: Create custom product options 10X faster & easier!
Easify Product Attachments: Effortlessly add downloadable PDF files (or any other format) to Shopify pages!
Try for Free | 24/7 Live Chat Support