# Pulling data from Shopify

**URL:** https://community.parabola.io/t/pulling-data-from-shopify/962
**Category:** Ask a question
**Created:** [August 20, 2020, 12:01am UTC](https://community.parabola.io/t/pulling-data-from-shopify/962 "2020-08-20T00:01:58Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Bonnie\_Mooney](https://avatars.discourse-cdn.com/v4/letter/b/fbc32d/32.png) [@Bonnie\_Mooney](https://community.parabola.io/u/Bonnie_Mooney)
#### Post date: [August 20, 2020, 12:01am UTC](https://community.parabola.io/t/pulling-data-from-shopify/962/1 "2020-08-20T00:01:58Z")

</div>

I’m pulling data from Shopify, How do I "publish’ the results? I want to see how many of each product variant we have sold. I can see the results but not sure what to do next! See screenshot attached. Thank you 🙂

 ![Screen Shot 2020-08-20 at 10.01.14 am](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/33a07ce80db3866b4276ad1730b5f41e614249e7.png)

---

<div class="post-metadata">

### Author: ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)
#### Post date: [August 20, 2020, 1:06am UTC](https://community.parabola.io/t/pulling-data-from-shopify/962/2 "2020-08-20T01:06:25Z")

</div>

Hi @Bonnie_Mooney!

To count how many of each product variant you’ve sold, search for the `Count by Group` step from the sidebar and connect your `Pull from Shopify` step to it.

 ![Screen Shot 2020-08-19 at 5.58.30 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/d636d92da38492a578e703785eb4a87c283798eb.png)

Then, double-click on the `Sum by group` step and configure it like so:

 ![Screen Shot 2020-08-19 at 5.59.52 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/cd12148a480251a02b500df75cb7e7efe9cb8c0b.png)

If you only need the product variant title and not the variant id, you can just choose `Line Items: Variant Title`.

The new column that will be created, `Line Items: Quantity (sum)` will show you, per product variant, how many total quantities of each product variant were sold.

If you want a _net_ count, taking into account the quantity of refunded items, search for the `Insert math column` step from the sidebar and connect your `Sum by group` step to it.

 ![Screen Shot 2020-08-19 at 6.03.44 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/51cc3272faa17fad964886eea6ac59b779e27bb8.jpeg)

Double-click on the `Insert math column` step and configure it like so:

 ![Screen Shot 2020-08-19 at 6.05.04 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/d8c8bf4557ad150b79f6be1ff4584b435da9e290.png)

You’ll see that I’m taking the quantity sold and subtracting the quantity refunded.

Once you have the data that you need, you can use the `Remove Column` step to keep just the columns that you need.

Where do you ultimately want the data to go? Should it be emailed to you as a CSV? Should it be exported to a Google Sheet?