Creating products with variations in Wave to match Woocommerce

[ArshilAhmad]

It doesn't look like the product names in old orders are being updated—they still seem to contain commas. Anyway, could you please share a list of product names that contain commas, so we can try removing the commas from the product names of already existing orders within the workflow itself?

 

[basslion]

It doesn't look like the product names in old orders are being updated—they still seem to contain commas. Anyway, could you please share a list of product names that contain commas, so we can try removing the commas from the product names of already existing orders within the workflow itself?
View attachment 58574

I checked all products and the only product that contains comma's is the one in the screenshot above. The comma's appear only in the variations and the product only has 3 variations. I have corrected all variations in the Woocommerce backend by removing said comma's

 

[ArshilAhmad]

We have added a Text Formatter to your workflow that should remove the commas from the product names of already existing orders. Please test your workflow now.

 

[basslion]

We have added a Text Formatter to your workflow that should remove the commas from the product names of already existing orders. Please test your workflow now.

Hello ok we ran the workflow again and received errors again. The errors are the same as before mentioning comma's

I checked one of the Text formatters above the failed Wave step and see this:

But in the backend of the site i dont see any comma's

Any idea's how to remove that comma? Or do you think that is causing the issue?

 

[ArshilAhmad]

That comma is used to separate line items, so we don’t need to remove those—they are necessary. The ones that needed to be removed were the commas within product names like (Mango, Strawberry, Grape).

We’ve made a slight change to your workflow and moved the 'Replace Text' Text Formatter to Step 9, so we can also map the result in Step 10. Please test the workflow now—it should run correctly.

 

[basslion]

That comma is used to separate line items, so we don’t need to remove those—they are necessary. The ones that needed to be removed were the commas within product names like (Mango, Strawberry, Grape).

We’ve made a slight change to your workflow and moved the 'Replace Text' Text Formatter to Step 9, so we can also map the result in Step 10. Please test the workflow now—it should run correctly.

Ok so we ran the workflow again and it returned errors, however this time the errors are limited to only 2 lines in the Wave step

Variable "$input" got invalid value "" at "input.items[2].quantity"; Expected type "Decimal". Value is not a valid Decimal:
Variable "$input" got invalid value "" at "input.items[2].unitPrice"; Expected type "Decimal". Value is not a valid Decimal:

When i look at the Data In section of the Wave step, i dont see any comma's and the product name shows proper.and the input items (2) Quantity and input items (2) Unit Price are blank.