Hello,
how can I export the order number from Shopify with the segment lists? I don't just want to have the emails. The order numbers are also important
So it should be exported as Excel as follows
Order number | e-mail
Best answer by Kylie W
View original
+4
Hey
Welcome to the community.
So when exporting your orders in Shopify you will need to go to the Orders section and click on the Export button in the top right corner. Then choose the All Orders option and Select the Plain CSV file format. Then click Export, the exported CSV file will have columns such as Order number, Email, and other relevant order details. You can open this CSV file in Excel or any other spreadsheet software.
Try it out and let us know if you still having trouble. The community I always here to help where we can! Remember to customize the export parameters according to your specific requirements.
Thanks
I have a segment and would like to have an Excel list from it.
But when I export it I only get the emails from the list.
Can I somehow get a list where the order numbers and the emails are? Something like this
ORDER1314 | XXXXX@gmail.com
+28
Hi
Are you feeding the Shopify Order ID back in Klaviyo some-how?
Klaviyo has a lot of data, especially about actions, ie; view X Product, purchase Z product, but if you are not feeding the Shopify Order ID back into Klaviyo as some custom field, I am unsure this is possible.
The other option is to do an export of the segment from Klaviyo, export from Shopify and do a merge into one file.
Hope this provides some help
Kylie
+4
Hey
Thank you for clarifying that.
When you select Export List to CSV/Export Segment to CSV from the Manage List dropdown, you will be given an option to choose whether to export all properties associated with your contacts’ profiles, or just specific ones. So, you can then select the specific ones you need. If the order number is not showing as an option, then it's most likely not being fed into Klaviyo from Shopify and you will need to relook at the integration feeding the order number into Klaviyo.
I hope this resolves your question. Let us know if this worked for you?
Thanks
So I have an email flow that adds customers to a property X.
If I make an export from segment Y (where it is set that property X contains people), I do not get an order ID
How exactly do I set that the order ID is taken from Shopify?
I am really a beginner and would need precise instructions.
+4
Hey
If you are trying to pull a customer's email and all past and present order numbers, then you will be able to do this on Shopify as I mentioned in my first comment above.
If you are looking to pull just the recent order number of the customer/profile, then this type of integration is not natively done by the Klaviyo-Shopify integration. It would require a developer to do it using Shopify’s APIs or a third-party app to achieve this like Zapier.
I recommend reaching out to Klaviyo’s support for more specific guidance on this if you are on a paid plan. Sorry I couldn't be of much help here, but I hope someone can add to this and hopefully give you more info.
I can't contact Klaviyo support because I no longer have a paid plan.
I just want a quick and uncomplicated solution for this
+24
That will help us guide you better on the best solution!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
