Skip to main content
Best answer

How do I separate Shopify order line items into individual SmartSuite records?

  • August 7, 2023
  • 3 replies
  • 94 views

Wolfgram

I want to pull the individual line items from a Shopify order into SmartSuite.

 

Currently, if there are multiple items in the order they are consolidated into a single field. For example, the Quantity Ordered field in SmartSuite will show the quantities from multiple line items of the Shopify order…

Shopify Order:

QTY.     SKU.     PRICE.     DESCRIPTION

1 -         BBk     $19.95.     Blue Book

3 -         RBk     $14.95.     Red Book

 

RESULTING DATA in SmartSuite:

Quantity: 13

SKU: BBk,RBk

Price: 14951995

Desc: Blue Book,Red Book

 

How do I get each line item from the Shopify order to create a new individual record in SmartSuite?

Best answer by Troy Tessalone

Hi @Wolfgram 

Good question.

Try using the Looping app: https://zapier.com/apps/looping/help

 

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

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • August 7, 2023

Hi @Wolfgram 

Good question.

Try using the Looping app: https://zapier.com/apps/looping/help

 


Wolfgram
  • Author
  • Beginner
  • August 9, 2023

This worked! Thank you!!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • August 14, 2023

Glad to hear it @Wolfgram! 😁🎉

Thank you so much for confirming that Troy’s suggestion of using Looping by Zapier solved things for you here. The Community greatly appreciates it! 🤗