Changes to order not reflected in flow to google sheets

Changes to order not reflected in flow to google sheets

nimbinvalley
Visitor
3 0 0

Hi.  I have connected a google sheet to receive new orders from Shopify.  If however a customer changes their order or adds to it at a later time because of an upsell these new additonal line items are not tansferred across to the speadsheet.  Is there a solution to this problem?

 

Thanks.

Replies 5 (5)

paul_n
Shopify Staff
1196 144 279

Updating a spreadsheet can be pretty problematic and difficult, as it's not really a structured database that allows queries. 

 

You could potentially either delay updating the Sheet until after edits are made, or possible just write the row twice and then delete one via a script in Sheets.

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
nimbinvalley
Visitor
3 0 0
Thanks.

We are using the Flow App so the orders are continuously and automatically sent to the Google Sheet specified as the order is completed. We can't delay any updates.

My question is really whether any edits made by a customer to their order are then transferred through by the Flow App AFTER the initial order is placed. It's seems to me they aren't but maybe I am missing a setting somewhere to allow this.

Paul.
paul_n
Shopify Staff
1196 144 279

The Google Sheets action does not support updating existing rows. So the trigger part doesn't matter. You can find orders with updates by using a Scheduled time trigger + Get order data. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
nimbinvalley
Visitor
3 0 0
Ok thanks.

How do I configure a Scheduled time trigger + Get order data? Is that done within Shopify itself or within the Flow App?
paul_n
Shopify Staff
1196 144 279

This is in the Flow app. The trigger is scheduled time and the next action is "get order data", where you choose a filter on the orders to get. You can get all the orders updated in the last 10 minutes for example

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.