Picky Assist Help Desk
Main WebsiteBlogFacebook Community
Picky Assist Help Desk
Picky Assist Help Desk
  • Welcome To Picky Assist 🙏
  • Setting Up Guide
    • Sending First Message
    • Connecting Channels
      • WhatsApp Web Automation to Official API Migration Guide 2024
      • Connecting WhatsApp Web Automation
      • Connecting Facebook Messenger
        • Introduction
        • Getting Start
        • Guidelines & Compliances
        • Messenger Link
      • Connecting WhatsApp Official
        • Introduction
        • Dashboard
        • Profile
        • Templates
      • Connecting WhatsApp Cloud API
      • WhatsApp Official Managed Service
      • Connecting Instagram
      • Phone Bridge (Call Blaze)
      • Connecting SMTP
      • Connecting Amazon SES
      • Connecting Sendgrid
      • Connecting Additional WhatsApp Numbers
      • Porting WhatsApp Number to Picky Assist
      • WhatsApp Official Message Delivery Issues & Solutions
    • Working With Prebuilt CRM Modules
      • Introduction
      • Onboarding
      • Modules
        • Leads
        • Deals
        • Meetings
        • Company
        • Support Cases
        • System Modules
          • Contacts
          • Notes
          • Task
          • Call Logs
          • Tags
          • Activity Logs
      • Automations
        • Workflows
        • Chatbots
        • Funnels
        • Connectors
        • Scheduler
        • Other Prebuilt Features
      • Reports and Dashboard
      • Mandatory Preconditions for Using Prebuilt
      • Testing Prebuilt
    • Managing Organization
    • Setting Up Teambox
      • Introduction
      • Routing Rules
      • Teambox
      • Inbox View
      • Organization Hierarchy
      • Analytics
    • Setting Up Smart Replies
      • Introduction
      • Train Module
        • Training Bot Introduction
        • Topics / Categories
        • Intent & Context
        • Question Variations
        • Uploading Bulk Questions
        • Reply with Media Files
        • Personalising Replies
        • Smart Actions
        • Direct URL
        • Fall Back Response
        • Small Talks
        • Testing the Bot
        • Publishing Bot
      • ChatGPT Integration
      • Learn Module
      • Stats Module
      • Deep Linking
      • Settings
    • Smart Reply V2
      • Introduction
      • ChatGPT Integration
      • Train Module
        • Training Bot Introduction
        • Topics / Categories
        • Intent & Context
        • Question Variation
        • Uploading Bulk Questions
        • Reply with Media Files
        • Personalizing Replies
        • Smart Actions
        • Direct URL
        • Fall Back Response
        • Small Talks
        • Publishing Bot
      • Learn Module
      • Stats Module
      • Deep Linking
      • Settings
    • Setting Up Broadcaster
      • Introduction
      • Creating a Campagin
      • Sending Message to WhatsApp Groups
      • Reports
      • Broadcaster V2
        • Introduction
        • Creating Campaign
        • Reports
    • Setting Up Sequence
      • Introduction
      • Creating New Sequence
      • Sequence Stats
      • Subscribe & Unsubscribe
      • Disabling Sequence Message
    • Setting Up Reminder
    • Setting Up Mobile App
    • Setting Up Connector
      • Introduction
      • Getting Started
      • Steps
        • Introduction
        • Filters
        • Delay
        • Iterator
        • Stats
      • Actions
      • Formatter
        • Date & Time
        • Counter
        • Math Calculation
        • Data Parser
        • Convert File
        • Line Items
      • Building Mini App
      • Email Parser
      • Data Storage
      • Simulate Test
      • Connector Logs
    • Email Builder
    • Setting Up Flow Builder
      • Fundamentals (Must Read)
      • Basic Terminology (Must Read)
      • Guide to Building an Effective Chatbot (Must Read)
      • Create, Manage, Test & Publish Flows
      • Triggering a Chatbot Flow
      • Steps
        • Introduction (Must Read)
        • Send Message
        • Ask A Question
        • Filter
        • Save Data
        • Actions
        • Check WhatsApp Session
        • Delay
        • Smart Delay
        • Formatter
        • Splitter
        • Data Lookup
        • Trigger HTTP API
        • Webhook
        • Apps
        • Match Keywords
        • Route to Chatbot
        • End
      • Saving Data into CRM
      • Analytics
      • Integrations
      • Flow Builder logs and conversational logs
      • Chatbot Best Practices, Ideas & FAQ
    • Setting up Modular CRM
      • Fundamentals (Must Read)
      • Guide to Building and Implementing a Modular CRM (Must Read)
      • Create & Manage Data Modules
      • CRM Macro Buttons
      • Adding Records into CRM
      • Data View & Manage Records
      • Task
      • Workflows
      • Funnels
      • Data Import
      • Integrations
    • Setting Up Scheduler
    • Media Gallery
    • Quick Replies
    • Opt-out Settings
    • Blacklist
    • Global Variables
    • Setting Up Ad-On's
      • Setting Up WhatsMail
      • Setting Up Zendesk
      • Setting Up Zapier
      • Setting Up Zoho CRM
        • Getting Started
        • Working with Extension
        • Integrating with Zoho Workflow
        • Lead Assignment Rules
        • Integrating into Custom Modules
        • Connecting Multiple WhatsApp Numbers into Zoho CRM
        • Integrating WhatsApp with Zoho CRM Mobile App
        • Keyboard Shortcuts
      • Setting Up Facebook Lead Adform
      • Facebook Lead Ad form V2
      • Setting Up WhatsApp Web
      • Setting Up Pabbly Connect
      • Setting Up ChatGPT App
    • Google Chrome Extensions
      • Extension for Sending WhatsApp Messages from any Webpage
      • Chrome Extension V2
      • Extension for Zoho CRM & Teambox
    • Managing Profile
      • Two Factor Aunthentication
      • Login History
      • Delete Account
    • Quick Rollout Guide
      • WhatsApp Official Account
    • Developers & Partners Guide for Deep Integration of Picky Assist
  • API Documentation V2
    • Introduction
    • Quick Start Guide 🏃
    • Global Webhook
      • How Webhook Works
      • Webhook Variables
      • Configuring Webhook URL
      • Webhook Request & Response
      • Getting the Conversation Context
      • Testing Your Webhook
    • Event Webhook
      • How Event Webhook Works
      • Event Webhook Variables
      • Configuring Event Webhook URL
      • Event Webhook Sample Request & Response
    • Push API
      • Introduction
      • API Variables
      • Sending Single Message - Push
      • Sending Dynamic Messages – Push
      • Sending Media Attachments – Push
      • Sending Interactive List & Buttons
      • Sending Stickers
      • Sending Bulk Messages - Push
      • Sending Contacts
      • Sending Location
      • Sending WhatsApp Template Messages
        • Introduction
        • Sending WhatsApp Template Text Messages
        • Sending WhatsApp Template Image
        • Sending WhatsApp Template Document
        • Sending WhatsApp Interactive Buttons
        • Sending WhatsApp Limited Time Offer Templates
      • Sending Message to Groups
      • Sending SMS Using SIM Card
      • Sending Message to Facebook Messenger
      • Normal Post Method
      • Delivery Reports
      • Push API Must Read Instructions
      • Testing API Requests
    • WhatsApp Template API
      • Introduction
      • API Variables
      • Template Request API
      • Template Status API
      • Languages
      • Guidelines
    • WhatsApp Group API
      • Introduction
      • API Variables
      • Create Group
      • Set Group Permission
      • Add Group Admin
      • Add Group Members
      • Fetch Group Details
      • Update Group Info
      • Remove Group Members / Admin
      • Generate New Invite Link
      • Group Delete Actions
    • WhatsApp Settings API's
      • WhatsApp Profile API
      • 2 Step Verification
      • WhatsApp Status Update
      • WhatsApp Contact & Group Fetching
    • Device Manage API’s
      • Fetching Device Status API
      • Device Commands API’s
      • WhatsApp Automation Server Status API
    • Account API
      • Fetch Balance
    • Project Management API
      • Introduction
      • Create Project
      • Get Project Details
      • Set / Update Webhook
      • Create API Token
      • Manage API Token
      • Change Billing Plan
      • Fetch Account Balance
      • Country Code & Timezones
    • References
      • Status & Error Codes
      • Most Frequent Issues & Solutions
      • Formating & Sending Emojis 😊
      • Postman Collection for Picky Assist API's
      • High Volume Messaging Bots - WhatsApp
    • Sample Codes
      • PHP
      • Python
      • Node JS
      • Ruby
      • Java
      • ASP.NET Using C#
      • Javascript
      • Go
      • Swift
      • C
      • C#
      • Objective C
  • General Guidelines
    • Billing
    • Adding Money Into Account
    • Rate Limits
    • Character Limits WhatsApp
    • Best Practices for Media Handling
    • Roadmap
    • Features In the Early Beta Version
  • Changelog
    • 2021
      • February 2021
      • March 2021
      • April 2021
      • May 2021
      • June 2021
    • 2020
      • February 2020
      • March 2020
      • April 2020
      • May 2020
      • June 2020
      • September 2020
      • October 2020
    • 2019
      • November 2019
      • October 2019
      • August 2019
      • September 2019
Powered by GitBook
On this page
  • What is a Line Item?
  • How it Works?
  • Setting Up Line Items
  • Select Field
  • Sample Value
  • Delimiter
  • Customise the Format
  • Limit Line Items
  • Store Converted Result To

Was this helpful?

  1. Setting Up Guide
  2. Setting Up Connector
  3. Formatter

Line Items

PreviousConvert FileNextBuilding Mini App

Last updated 3 years ago

Was this helpful?

Line Items helps to extract data values from an invoice or an ecommerce order then helps you to format the items lists in an order which can be used to send WhatsApp or SMS in a better way.

What is a Line Item?

Line items are generally multiple items combined into one item, the best example when you buy multiple 10 items from a supermarket they will provide you only one invoice instead of 10 separate invoices but each item in the single invoice have different price value, quantity and expiry date so an items in an invoice can be treated as a line item. For better understanding see the below image.

How it Works?

When an invoice or an ecommerce order contains multiple items in which the number of items for each transactions is not sure i.e first customer may have only 5 items where the next customer may have 10 items. Once the customer placed the order you want to send the item in details like Item Name, Quantity, Price, Offer, Tax etc as a WhatsApp Messages.

Line item formatter helps you to extract the values of each items in the order and send as a WhatsApp message, see the below example for a better understanding how it works,

This in an invoice line item contains 4 columns and 3 rows, this is ok to be sent via Email but not for WhatsApp or SMS

SL

Item Name

Quantity

Price

1

Onion

2

20

2

Carrot

3

10

3

Milk

5

30

Below is the formatted line item which can sent via WhatsApp or SMS

1, Onion x 2 = $20 2, Carrot x 3 = $10 3, Milk x 5 = $30 Total Items : 3

You have the option to customise the above format the way you needed, you will learn more how to customise the format in the below sections.

Setting Up Line Items

To setup line item go to Formatter -> Line Items as show below;

Select Field

You will see an option to "Select Field" as shown below on clicking this will open a popup which will only list the supported line items (array or objects)

Please note if you are not seeing any values here this means no line items is found the request received from the 3rd party app.

Once a line item is selected you will see options as shown in the below image;

Sample Value

Sample value shows the heading of the line items in the left side and sample values in the line items in the right side, which helps you to review it,

Kindly note only 3 values are fetched and shows as sample.

Delimiter

Delimiter helps you to separate each row to make it more visually appealing like it can separate one row with another with 5 spaces, 2 new lines or combining both like text & new line, once you setup the delimiter you will have an option to use it in the below section;

Customise the Format

This helps you to customise the outgoing message format the way you needed, you can type the message in the text area and use the attribute section to insert the line items into it.

Please note in the attribute only line item details will be show, no other attribute values can't be inserted from here.

You can see 3 Additional Attributes which is common for all the sections as shown below;

Auto Number Auto number means what is position of the item in the list like 1st, 2nd etc

Total Items This gives you the total row count i.e total items, suppose if an order contains 100 items then it shows as 100, useful when you limit the line items to certain number and want to inform your customer that Total Item is 100 i.e it will show the first 5 items in the message then you can put Total Items.

Delimiter When a delimiter attribute is added into the formatting section, the system will add the delimiter as configured by you. For an example if the delimiter configured by you is 2 new line space then the system will automatically add 2 new line space after end of every row data till it reaches the last row in the item

If you put any static value before the delimiter position then it will repeatedly show this, so if you want to put any static data like Total Items then always put this after inserting the delimiter attribute.

Sample Formatting

You can customise the message formatting the way you needed, few samples are shown below for better understanding This is an example of an order contains 3 line items

SL

Item Name

Quantity

Price

1

Onion

2

20

2

Carrot

3

10

3

Milk

5

30

Sample Formatting 1 SL : 1 Item Name : Onion Quantity : 2 Price : 20

SL : 2 Item Name : Carrot Quantity : 3 Price : 10

SL : 3 Item Name : Milk Quantity : 5 Price : 30

Total Items : 3

Sample Formatting 2

1, Onion x 2 = $20 2, Carrot x 3 = $10 3, Milk x 5 = $30 Total Items : 3

Sample Formatting 3

Item 1 Onion | Qty : 2 | Price : $20 Item 2 Carrot | Qty : 3 | Price : $10

Item 2 Milk | Qty : 5 | Price : $30 Total Items : 3

Limit Line Items

This helps you to limit the number of line items to be included in the message, you may have 100 of line items and including all of them in the message may not be a good idea, so you can use the option to limit the number of items to be included, if you put 5 then only first five items and its details will be included while sending the message

Store Converted Result To

This helps to store the formatted final item into a value and you can make use this in the Broadcaster or Send Message Action in any Steps