So as for right now I have 3 modules.
And what this scenario is doing right now is - every time i get a new order with order status being ‘‘processed’’ it will add a new row to my google sheets with data I need from woocommerce order page. If an order has more than one unique product ID it will add as many new rows as unique product IDs are in the order. Right now its just duplicating the data from first unique product ID in every new row (if order has more than one unique product ID) .
The problem is , that I need every new row to be filled with data that is relevant to every unique product ID, not just one of them and then it gets copied to other new rows.
How it is right now if I get new order with more than one Unique Product ID:
10491, John Wick, gmail@gmail.com, Fat Burner ,8EUR, 3EUR, 11EUR
John Wick, gmail@gmail.com, Fat Burner ,8EUR, 3EUR, 11EUR
What I Want:
10491, John Wick, gmail@gmail.com, Fat Burner , 8EUR, 3EUR, 11EUR
John Wick, gmail@gmail.com, Protein Powder, 16EUR, 3EUR, 19EUR.
Like i would like every added row to contain an information regarding the each unique product ID.