Calculate the cost of goods

I want to be able to calculate the qty of each item by the cost and add up all the totals fo each day.

How can I do this?

Hey @Patton_Yoon,

Assuming you’re using our Pull from Shopify step, there are a few ways to set up your flow.

Import your Shopify Orders with the associated Line Items details. You can select all orders processed within the previous 1 day. This should return a bunch of data linked to each order. Let’s look at these columns:

To identify the quantity of each item

  • Line Items: Sku
  • Line Items: Quantity

To calculate the total price paid including sales tax and discounts

  • Line Items: Price
  • Line Items: Total Tax Lines
  • Line Items: Total Discount Allocations

Using the Insert math column step, we can calculate the total price by calculating the individual cost of each item and multiplying that by the quantity purchased. In this example, I’m making a new column called Line Items: Total Price.

We can use a Sum by group to count the total price of unique Skus across all of your orders. If you want to total your daily sales, you can simply sum the Line Items: Total Price column.

Hope that helps!

1 Like