Question

Importing specific data from Shopify to Google Sheets

  • 10 December 2022
  • 2 replies
  • 39 views

Userlevel 1
Badge

Hey everyone. Bit of a confusing problem. 

 

I own a running store, and want to import only shoe sales from Shopify - Google sheets. I need to make some sort of filter, telling it to only import when it’s footwear, however, I cant seem to find a unique identifier for footwear. In Shopify there is product category, but that’s not an option within Zapiers Shopify integration. 

Secondly, let’s say I did get a unique identifier and it triggers the zap, Id need to find a way to exclude the other non shoe items in that order. 

Hoping someone can make a suggestion on a unique identifier I could use for shoe orders, and a way to exclude non shoe items from those orders as well. 

Maybe this is too specific to be done. Thanks in advance for the help - this community has been extremely helpful. 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @Eric Caldwell 

Good question.

Try using the SKU as the unique ID to filter on.

 

The Looping app can be used to handle line items of a Shopify Order.

 

 

Userlevel 3
Badge +5

Hey @Eric Caldwell, checking back in to see if you were able to get this workflow up and running. Let us know!