Skip to main content
Question

Importing specific data from Shopify to Google Sheets

  • December 10, 2022
  • 2 replies
  • 45 views

Forum|alt.badge.img

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. 

Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31364 replies
  • December 11, 2022

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.

 

 


Paolo
Forum|alt.badge.img+5
  • Zapier Staff
  • 98 replies
  • December 13, 2022

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