Question

Shopify Google sheets Stopping order total from duplicating across lines

  • 13 February 2021
  • 2 replies
  • 23 views

I have a Google Sheet that I am creating a new line when I get a new paid Shopify order. 

 

When an order comes through with multiple line items it duplicates the total paid which makes it hard to sum monthly sales. I would like the total for each order to only appear once. Is this possible with Zapier or will I have to create a formula where I somehow disregard multiple totals on the same order.

Above with the order 3249 if I sum the total the customer paid it duplicates it across however many items were purchased

 

Note: adding Line items does not seem to work as they do not take into account discounts applied globally to the order.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @Libertine

One option would be to have 2 steps in the Zap.

1 Step to send the Order # and Order Total to a GSheet tab.

1 Step to send the Order Line items to a GSheet tab, as you are doing currently.

 

As an alternative, you could use another GSheet tab to do the analysis calculation for the unique monthly sales via a formula.

Userlevel 7
Badge +10

@Libertine 
Just checking in to see if you still need help with this?