Shopify Flow is an ecommerce automation platform that enables you to automate tasks and processes within your store and across your apps.
Hi All,
Hope you're doing fine. I really think Flow are powerful if we can automate some reporting with it. For instance, logging every order with product details, refund date, etc etc
You can always run various reports from the reporting tab, but in my opinion, the most complete info is when you export orders directly from the order tab, and built automated reporting out of it.
So:
I'm working on a flow to export all orders with product details (one row per line item, etc etc) in a spreadsheet. This would really help us automate most reportings we do by exporting various reports every now and then.
Ask:
Has anyone created a Flow that export to spreadsheet, with one line per line item, all its orders ?
I was working on it and for loop examples show it can be done, however I don't have technical background, so for all orders with >= 2 products, it's not working 🙂
My current flow export this variables in a GS:
{{order.createdAt}}, {{order.name}}, {{order.email}}, {{order.publication.name}}, {% for a in order.lineItems %}{{a.name}} {% endfor %},{% for a in order.lineItems %}{{a.quantity}}{% endfor %}, {{order.shippingAddress.country}}, {{order.totalPriceSet.shopMoney.amount}}
This basically export name, email, channel sale, product items, country, etc, etc
Some variables are very easy to add, regarding product line items, I'm stuck 🙂
Hope it's clear !Thanks !
Hey @lepetitlunetier!
Parabola is a new app that just launched in the Shopify app store. Custom reporting has been one of our customers' favorite use cases for using our Shopify Import step. Looks like you're trying to export order line items, regardless of quantity per order. Check it out in Parabola:
Hopefully, this would solve your problem. Also, are you looking to automate these exports?
thanks, i'll check it out
just to be clear: it"s just custom reporting, but not using shopify flow ?
Hey @lepetitlunetier,
That's correct! Parabola is a Shopify app, different from Shopify Flow, that allows you to create custom reports with data from across your business; specifically in this case: Order Line Items from Shopify. If you're looking for any additional help, definitely check out our community (community.parabola.io) or let me know here!
Are you ready to take your business to the next level? Look no further than the latest ...
By SarahF_Shopify Apr 15, 2024We’re keeping the ball rolling to make sure you’re always ahead of the game. So buckle ...
By JasonH Apr 8, 2024Portrait of Stephen positioned next to an image of planet Earth, with the Stephen's World ...
By JasonH Mar 18, 2024