Funnelish Order Information Export

1

Hi guys, I’m trying to export my order lists - need that for a bunch of reasons, but the exported file is an HTML blank page with a loading circle, like it’s loading. I’ve waited for a while with hopes it’s actually loading or smth, but nothing happened.
Does anyone have a fix for this?

2

Hi @leonrybinski4 unfortunately you’re running into a bug which the team is aware of and currently looking into to resolve it ASAP. As soon as it’s resolved we’ll make sure to keep you posted.

In the meantime, you can set up an automation to sync the order details to Google Sheets (but it will only apply for new incoming orders).

  1. Create an Excel file and configure it with the columns of data you want to collect from orders.

  2. Integrate with Google Sheets:

https://docs.funnelish.com/integrations/google_sheets

  1. Go back to Funnelish and create an automation so that once a product has been purchased, it adds it to the Excel list.

This article has more details:

1 Like
3

Thanks, Belen!
Is there any ETA on the bug fix? This feature would be really important for me for TAX reporting reasons ://

4

Can’t confirm at this point a specific resolution date but we’re prioritizing this bug. We’ll notify you in this post once the fix has been released/

Thank you so much for your understanding!

2 Likes
5

Hi all!

Just wanted to let you know that the orders export bug has been fixed! :tada:

You should now be able to export your orders as CSV.

In some cases, when exporting a large number of orders or customers, you might still notice a hiccup but if that happens, try exporting by timeframe as a quick workaround until fully stabilized.

Our team is continuing to improve this to ensure it works seamlessly for all cases.

Thanks so much for your patience while we worked on this! :blue_heart:

Belén @Funnelish

1 Like
6

Hi Belen,

I am trying to use the export orders to csv file but it’s not working anymore.
Here is the error message:

{
    "error": {
        "name": "internal server error",
        "desc": "Failed to export orders.",
        "details": "spanner: code = \"InvalidArgument\", desc = \"The ORDER BY clause only allows aggregation if GROUP BY or SELECT list aggregation is present [at 1:634]\\\\n...BETWEEN @p2 AND @p3) AND `o`.`deleted_at` IS NULL ORDER BY MAX(o.created_a...\\\\n                                                     ^\", requestID = \"1.1b717cd479bd00c8.1.4.161182.1\""
    },
    "status_code": 500
}
7

Hi @Le_Anh_Vu thank you for keeping us posted, sorry that you ran into this again. Would you be able to do a short loom of the exporting process until you run into this error and then send it privately to my inbox so we can look into this further?

Thanks in advance,
Belén@Funnelish

8

Hi Belen,

Thanks for getting back. Here is the loom video: https ://www.loom.com/share/33cc15d6c04a401c83f436d108ad603f

9

Hi @Le_Anh_Vu thanks so much for the video! We’re getting it rechecked by the team. :folded_hands:

We’ll keep you posted on the updates!

10

Hi @Le_Anh_Vu this has now been fixed and you should now be able to export your orders.

Please let me know if you’re still struggling.

Best,
Belén@Funnelish