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?