Look up sales by customer location

[jmckartwork]

I am trying to look up how many online sales I had from a particular country in a given year. Is there a way to do this? I can't seem to find the option to look up sales by customer location. 

[LukeNieuw]

Interesting! 

So you've been collecting their address & country at time of purchase? Or is this from online sales? 

The only way I can think of is by exporting your customer list to spreadsheet and sort for by "State" if you have those details.

For a specific year you would need to run transactions report and isolate those customer names. It will be tedious but can be done. 

Not a great solution but is possible. Maybe someone else has done this before and has a better way?

[jmckartwork]

This is for online sales. Seems silly there isn't a way to do this more easily. 

[RobynR · Accepted solution]

Hey @jmckartwork,

Thanks for reaching out to the Community!

At this time, there isn’t a way to filter sales by the customer's location. For a temporary solution, we recommend trying out @LukeNieuw's workaround from above. If this feature would be helpful for your business, we recommend submitting your idea to our Ideate Board here, where the Product Team reviews suggestions for future improvements. 

If you need further assistance, feel free to reach out!