Add row to spreadsheet - Comma issue

Shopify Plus
1

I have an issue where I want to add the title of a product to google sheet. However, some product names have commas in the title, which are separated in different rows in the spreadsheet.

Row content section looks like this now:

{{product.distributor.value}},{{productVariant.product.title}},{{productVariant.title}},{{productVariant.sku}},{{productVariant.barcode}},{{productVariant.inventoryQuantity}},{{product.minimumLagerbeholding.value}},{{product.onlineStoreUrl}},

It works nicely when products doesn’t have commas in the name, but when it does, the whole spreadsheet gets messed up.

How can I sort this? Thank you!

1 Like
2

Encase the names in double quotes to keep it from breaking your csv.

2 Likes
3

I couldn’t get it to work with double quotes, but I found another thread here and the solution was this:

{{productVariant.product.title | replace: ‘,’, ‘,’ }}