How to add new column from and exiting column using a parser funtion?

Answered

Follow

Mehroz Shahid

• September 06, 2022 15:56

Hi

In my product feed, there is a column group_id with 12 digit codes.
Using the parser function, I want to create a new column which can only take the last 4 digits of the group_id.

Hope someone could help.

1

• 

  Saul Ackerman

  • July 30, 2024 21:06
  • Edited

  You can have a function running within the parser that extracts the last 4 digits, and point a new column to that function. For example, take a standard CSV upload with the 8 required column

   

  function parse(data){
      return data.map(function(prod) {
        return {
          sku: prod.sku,
          name: prod.name,
          categories: prod.categories,
          group_id: prod.group_id,
          price: prod.price,
          in_stock: prod.in_stock,
          url: prod.url,
          image_url: prod.image_url,
          keywords:prod.keywords,
          last_four: getLAstFourDigits(prod.group_id)
        }
      })
  }
  
  function getLAstFourDigits(group_id){
    return groupId.slice(-4);
  }

  1

  Comment actions Permalink
• 

  Mehroz Shahid

  • August 08, 2024 09:07

  Thanks Saul.
  
  We were able to achieve it with this funtion

    // [DY] Set "colorID" column
          products[item.sku]['ColorID'] = item.group_id.slice(item.group_id.length - 4);

  0

  Comment actions Permalink

Please sign in to leave a comment.