Add individual variations to a new row in Sheets

How To
1

Hey legends,

We sell multiple products with multiple variations and often people purchase a few at a time. Just wondering how to have it so that every variation has its own line created in sheets? EG someone buys a blue large shirt and a green medium shirt, how can I get those sales on individual rows?

Any assistance would be great, thanks!

1 Like
2

Hi @TommyP
Can you explain the requirement by showing an example. Do you want all the product the person buys in a single cell.
Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

1 Like
3

Hi Tommy,
Not sure what e-commerce platform you are using…but the general idea should be similar to the below idea.
You can use an Iterator module between your e-commerce platform and Google Sheets. The iterator will collect all the “line_items” from the order, which represent each individual product variation purchased.
The simply output each line onto your Google Sheet

1 Like
4

Thanks for the responses! To clarify we’re using WooCommerce and variable products.

So below someone has ordered multiple teams and it’s exported those teams all on the same line, I’m hoping to get each team (variable) on its own individual line. I’m really new to how this works but IT fluent so should be able to figure it out but any help would be awesome!

Screenshot 2024-09-26 150957
Screenshot 2024-09-26 1509571793Ă—21 19.4 KB

1 Like
5

Hi @TommyP

image
image1745Ă—145 82.6 KB

Is this entire part coming as single text? If so you can split and iterate to get them in different lines.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

6

Thanks again for the response. I’m just not familiar enough with the platform to be able to do this. Is this a service I could speak to you about implementing?

7

Hi @TommyP
Can you share the screen shot of how to map these values into sheet. So that we can further assist you.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

8

image
image1699Ă—37 2.33 KB

So the fields I have here are:

(A) Billing: First Name Billing: Last Name
(B) Line Items Quantity
(C) Line Items Parent Name
(D) Line Items Name
(E) Shipping Lines Meta Data Value

So the products purchased were two variations of the one product (NFL - Topps Composite TEST) and they were (Tennessee Titans & Washington Commanders). Ideally what I’d like to do is have each variation be on a separate line so in this case it would look like:

Thomas Parle - 1 - NFL Topps Composite TEST - Tennessee Titans
Thomas Parle - 1 - NFL Topps Composite TEST - Washington Commanders

That way if someone purchased multiple variations of multiple products, those would each have a separate line displaying the product & variation idividually.