How to replace comma separator in Shopify "Line Item Properties Value" to something else (e.g. "|" )

Shopify Discussion
1

I have a product customisation form in Shopify that customers input their messages in the respective fields in the form:

Name: John

Sex: Male

Message: Hello

I then use zapier to extract the shopify inputs from “Line Item Properties Value”. The inputs in the respective fields in the form are separated by commas:

John,Male,Hello.

This is OK but if the customer inputs commas into the fields like the example below, I then run into problems:

Name: John

Sex: Male

Message: Hello, world

The Line Item Properties Value then shows: “John,Male,Hello,world” as if I had 4 fields. In reality I have 3 fields. But because of the comma in the message “Hello, world”, it recognized “world” as the 4th input.

I think the way to resolve this is to change the separator in Shopify to “|” instead of comma.

How do I do this? Thanks a million!

2

Hi @zhhan1 ,

Sorry, I am trying to understand. Is this name, sex, and message is on their own input text? If you separate them, you should not run into problems since it is being pass as a value on each.

Not familiar with Zapier, but it looks like the problem is the backend. Therefore, you need to change the backend code.

3

Yes, the input fields are separate. Just that in Zapier, it seems that the data from Shopify that can be seen is captured under “Line Item Properties Value”.

And this is in the form of John,Male,Hello.

On the backend code, I suppose you mean to change in Shopify for the separator? Any idea how that can be done?

4

@zhhan1

If you are sending this line item properties to Zapier then they might process the code. You need to change on how they process. I would suggest contacting Zapier