🥳 Celebrate Our Launch With a $200 LIFETIME Discount OFF The Premium Plan Use: BIRTHDAY2024
This offer expires 9/30/2024, at 11:59 PM EST
Fetch Product Details Using Pluck and Join in Workflows
Dynamically extract and format order line item details using Pluck and Join so your automations can log, message, and sync clean product lists anywhere.
Making Workflow Data Easier To Use Instead of Sorting Through Complex Order Records
Orders often contain multiple products, quantities, prices, and line-item details stored inside structured datasets. While this information is valuable, it is not always easy to use directly inside notifications, spreadsheets, reports, or external integrations.
BizStackPro's Pluck and Join workflow helpers allow businesses to extract specific values from collections of data and combine them into clean, readable outputs that can be used throughout automation workflows.
Without data formatting helpers, businesses may struggle to display product information clearly, create readable reports, map order details to external systems, or automate workflows that depend on structured product data.
This guide explains how Pluck and Join work together, how product details can be extracted and formatted, and how to create cleaner workflow outputs inside BizStackPro.
Before formatting product details in workflows, it helps to understand how order data, workflow variables, line items, integrations, reporting systems, and automation helpers work together inside BizStackPro.
Overview
When a workflow trigger includes an array of order line items, you can extract specific fields (like product title, SKU, quantity, or price) and format them into a single value. This is especially useful for external logs (Google Sheets), internal notifications, or pushing structured data to other systems.
Why this matters: You get a clean, readable “Products Purchased” output without manual formatting.
What Pluck and Join do
Pluck
Pulls one field from every item in an array (example: every product title in order.line_items).
Join
Combines extracted values into a single string using a separator you choose (comma, pipe, line breaks, etc.).
Step-by-step: Fetch and format product details
Step 1: Use a trigger that includes order data
Choose a trigger that provides the line items array. Common options include:
- Order / Checkout Submitted (order events)
- Inbound Webhook (order data coming from an external system)
Step 2: Pluck the field you want
Example: extract product titles from line items.
{{ pluck order.line_items "title" }}Tip: You can pluck other fields too (SKU, quantity, price)—as long as they exist in the dataset.
Step 3: Join the values into a clean string
Example: turn the array of titles into a comma-separated list.
{{ join (pluck order.line_items "title") ", " }}
Custom separators: Swap ", " for
" | " or "; " based on where you’re sending the data.
Step 4: Use the formatted output in an action
Map the joined output into an integration field (Google Sheets, CRM, database, etc.).
Example mapping (Google Sheets)
- Name:
{{ contact.first_name }} - Email:
{{ contact.email }} - Products:
{{ join (pluck order.line_items "title") ", " }}
Step 5: Test and validate
- Submit a test order (or send a sample webhook).
- Confirm the trigger contains
order.line_items. - Verify the joined output is not blank and is formatted correctly.
- Check the destination tool (example: the Google Sheets row) for correct values.
Quick troubleshooting
- Blank output: the trigger may not include order data or the array path is different.
- Wrong values: confirm the field name you’re plucking (example:
"title"). - Formatting issues: change the Join separator to match your destination tool.
Turn raw order data into clean automation outputs
Once you format product data, you can log it, message it, or send it anywhere your workflows connect.
Opens in a new tab.
Frequently Asked Questions
Can I use custom separators with the Join helper?
Yes. Replace the default comma separator with any character or string, such as ; or | , to format the output as needed.
What happens if no product titles are found?
If no matching items exist in the dataset, the Join helper returns an empty string. Ensure the trigger provides the expected order data.
Can I use Pluck and Join with fields other than product titles?
Yes. You can extract and format any available field from your dataset, such as SKU, price, quantity, or custom attributes.
Which platforms can receive the formatted output?
Any platform that accepts structured data—such as Google Sheets, CRMs, databases, or analytics tools—can receive the formatted output.
How do I debug formatting issues in workflows?
Use test submissions to inspect the output at each step and confirm the dataset structure matches your Pluck and Join expressions.
Build workflow outputs you can reuse everywhere
Pluck + Join helps you standardize order data once—then use it across spreadsheets, notifications, CRMs, and integrations.
Cleaner data. Better automations.
Disclaimer: This site is NOT endorsed by Google, Facebook or YouTube in ANY WAY. All trademarks & Logo / branding are the property of their respective owners. Please Note: This site was created in BizStackPro by Ken George II (An Affiliate of BizStackPro) and may contain affiliate links.
Copyrights 2024 | AllAboutBizStackPro.Com | Pricing | About | Features | All Rights Reserved.