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.
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.
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.
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.
Ok thanks.
How do I configure a Scheduled time trigger + Get order data? Is that done within Shopify itself or within the Flow App?
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