importing orders from Shopify

[cindy hobbs]

Hi there, can someone tell me how you go about importing all existing orders to trello from Shopify ?, I can only find ways to import orders going forward not pre existing ones 

[Laiba]

I think Trello integration mostly works for new orders only. It syncs future orders automatically, but not old ones.

For existing Shopify orders, you may need to export them first from Shopify admin (CSV file). Then you can manually add them to Trello cards or use tools like Zapier or Make.

If you are using shopify development services, they can also help set up a proper automation flow between Shopify and Trello so future orders sync easily.

I also faced same issue before. Historical orders usually don’t import automatically.

Best option is export + automation setup.

[milynnus]

@cindy hobbs 

This might be useful.

https://towardsdatascience.com/how-to-get-all-orders-from-shopify-69db163c7a2d

You can use py-trello you can create cards from each of the orders retrieved. I do not have a shopify account with orders to try but it would be interesting work on this.

[milynnus]

@cindy hobbs 

I tested the above and it works as described in the document. The return json put into a df (aka dataframe - think of it like a spreadsheet) has 78 columns. Hence it is a matter of deciding what you need in Trello.