How to count values in Code step?

Question

Hello,

I am trying to count the quantity of several products in a line item order (WooCommerce). I.e. the line items in the order look like:

Product 1 × 3, Product 2 × 1, Product 3 × 2

So:
Product 1 was ordered 3 times
Product 2 was ordered once
Product 3 was ordered 2 times

And the result/output should be:
6

I am trying to count all quantities together. I already tried to solve this with the Formatter, but didn’t have success. Is it possible to do this with JavaScript or Phyton? Or is there another way?

Thanks a lot for your support,
M.

Troy Tessalone · Accepted Answer

@michael291This can be done in a Code step: https://zapier.com/apps/code/helpTry this JavaScript…CONFIGCODElet Count = 0;let Items = inputData.Items.split(",");for (let i = 0; i < Items.length ; i++) {  Items = Items.split(";")[1].trim();  Count += parseInt(Items);}output = [{Count, Items}];RESULTS

Troy Tessalone · Answer

Hi @michael291Can you post screenshots with how the actual data comes thru on the Zap step that you are trying to use?

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded