WooCommerce Meta Data Separation For Each Product

[shashikant]

Hello There,

We have recently stated using pabbly connect. We have tried our best to understand this until now but were forced to raise this to the forum.

We have created a flow where a new order is created a template based WhatsApp message is sent through API and everything works perfectly fine.

But we are having 2 concerns as of now

1. We are having product fields / addon fields for our products which are cakes. Like delivery date, message on the cake, pick up data, pick up location etc. We have tried our best to add the json extractor / data transformer from the woocommerce meta. But the meta fields are showing like ["Pickup"],["Pickup"] for 2 products in the order. It is showing similarly in the whatsapp message also. Can we show it like how the product names are shown or just the plain format without brackets and quotes?
2. We have some optional fields in the product fields, how can we manage it in the whatsapp template? Like users sometime need that - so it will be included in the whatsapp message, if not entered (empty) the message need not show that.

Thanks in advance
Shashikant

 

[Luv]

Hey @shashikant

Kindly let us know your workflow name or URL that you want to use so that we can look into it and assist you accordingly.

 

[shashikant]

Hello @Preeti Paryani,

We have already tried the meta data extractor action but they don't come as a array. Seems like they are separated. I tried with both simple response on and off. Below is the response

Usually how does this woocommerce whatsapp notification work when we have multiple products in the order?

It seems that this would not be possible as the template fields are required to the API.

That's unfortunate. I think we will have to create 2 different messages templates and operate it through routing action if it's empty or not empty? Will that work?

 

[shashikant]

Hey @shashikant

Kindly let us know your workflow name or URL that you want to use so that we can look into it and assist you accordingly.

Hello,

My workflow name is "WhatsApp Notification - New Order"

This is the URL from my login not sure how it works for you.

URL For Workflow

 

[ArshilAhmad]

Please try adding a Line Itemizer to your workflow to extract the JSON as comma-separated line items.

Then, to remove the double quotes and square brackets, use the 'Text Formatter: Replace Text' action step.

That's unfortunate. I think we will have to create 2 different messages templates and operate it through routing action if it's empty or not empty? Will that work?

Yes, you can add a Router to your workflow and set a Filter condition to check whether a field is empty or not. Then, add different templates to each of the two routes.

 

[shashikant]

Please try adding a Line Itemizer to your workflow to extract the JSON as comma-separated line items.

Then, to remove the double quotes and square brackets, use the 'Text Formatter: Replace Text' action step.

Yes, you can add a Router to your workflow and set a Filter condition to check whether a field is empty or not. Then, add different templates to each of the two routes.

Hi @ArshilAhmad,

Thanks for your response. I will try the router option with different templates. It should work I am guessing.

Coming to the text formatter my find text is ["Pickup"],["Pickup"], and when I am trying to replace [ with space ( {{space}} ), it works well. But how about replacing multiple items - like this this above key phrase I would like the quotes and square brackets to be removed. How can we add multiple items in that find option? Should we add it by space or comma or something else?

Thanks

 

[ArshilAhmad]

You will need to add three Text Formatters to your workflow. Formatter 1 can replace the open square bracket [, Formatter 2 can replace the close square bracket ], and Formatter 3 can replace double quotation marks.

P.S. You don't need to replace them with a space; just leave the 'Replace' field blank.