Hi. We deliver all our own goods to the local community. Currently we are printing off each order individually and then inputting the delivery addresses manually into a spreadsheet to then run a route planner. This is very time consuming. Is there an app that can pull this information out of shopify? I cant find a report on shopify that can do this.
@tmfreshpro Ah, crap, I'm two days too late!
I wrote a tutorial today that could automate at least half of this process....
Basically, it gets all the open orders from Shopify each morning, does some data-wrangling and pushes them into a route planner. It then sends you an e-mail with a link to the route planner, that will auto-calculate the fastest route. This is all done automatically, and then you have a choice - either take the route planner's output (a map and a list of directions) or click two-three more times to push it into Google Maps (for voice navigation and a proper navigation experience).
Is that something that could be of interest to you? If so take a look here. I'd be really happy to hear if you used it in production, and please note it's customizable to fit your use case.
@bfox2718 If you also care to take a look, I think it might solve some of your problem. The "marking orders as fulfilled while on the road" can probably be created by using something like the following process (also using Integromat, like in the tutorial):
0. Add - in my tutorial - the order number in addition to the address.
1. Create a very small form - just a single field and a "Fulfilled" button - where drivers can enter an order number
2. A filling of that form triggers a call to the Shopify Module in Integromat, that updates the order as fulfilled
I can probably create a separate tutorial on how to that, actually, if that's of interest.
BTW, here's what the roundtrip output looks like in Google Maps:
|an hour ago|
|3 hours ago|
|3 hours ago|
|4 hours ago|
|5 hours ago|