Send Shopify line items information to Demio (streaming tool)

[sachi]

That sounds right. First, you’ll make a mapping table like this, where you map your Shopify Variant ID to your Demio Event ID. I recommend using Google Sheets or Excel to create this table.

Your flow should look something like this:

1. Import your Order Line Items
2. Use the Remove columns step to filter for the following columns:

Line Items: Variant Id
Order: Customer: First Name
Order: Customer: Last Name
Order: Customer: Email

3. Use a Pull from Google Sheets step or Use Excel file step to import your mapping table.
4. Use the Combine tables step to match by the Variant ID column, like so:
   
   
5. Finally, use the Send to an API step to send the data to Demio. I believe your Send to an API step should be configured like this:
   
   
   
   As you can see in the Body, I’ve mapped the fields that Demio expects to the corresponding column names in Parabola.

As you test and until you make sure this flow accomplishes what you’re trying to do, I recommend adding a Remove rows step before the Send to an API step to filter down the records you export to Demio to less than 5 records. This is a good way to avoid incorrect batch updates that would be harder to undo

Hope this helps!