# Generate Reports weekly

**URL:** <https://community.shiphero.com/t/generate-reports-weekly/162>\
**Category:** GraphQL API\
**Created:** [October 3, 2019, 1:39pm UTC](https://community.shiphero.com/t/generate-reports-weekly/162 "2019-10-03T13:39:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JFurr](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@JFurr](https://community.shiphero.com/u/JFurr)\
**Post date:** [October 3, 2019, 1:39pm UTC](https://community.shiphero.com/t/generate-reports-weekly/162/1 "2019-10-03T13:39:19Z")

</div>

I would like to run an automated reporting script for various reports within shiphero. Is it possible to get the ‘Sales By Sku’ or ‘Inventory Change Log’ etc via api?

---

<div class="post-metadata">

**Author:** ![seba](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@seba](https://community.shiphero.com/u/seba)\
**Post date:** [October 3, 2019, 2:28pm UTC](https://community.shiphero.com/t/generate-reports-weekly/162/2 "2019-10-03T14:28:22Z")

</div>

@JFurr you can usse the inventory\_changes query

```
query {
  inventory_changes {
    request_id
    complexity
    data(first: 20) {
      edges {
        node {
          reason
          location {
            id
            name
            zone
          }
          warehouse_id
          previous_on_hand
          change_in_on_hand
          previous_on_hand
	   cycle_counted
 	   created_at
          sku
        }
      }
    }
  }
}

```

If don’t have a DS (dynamic slotting account) avoid the location field.

---

<div class="post-metadata">

**Author:** ![emily.wilson](https://avatars.discourse-cdn.com/v4/letter/e/c77e96/32.png) [@emily.wilson](https://community.shiphero.com/u/emily.wilson)\
**Post date:** [October 3, 2019, 6:39pm UTC](https://community.shiphero.com/t/generate-reports-weekly/162/3 "2019-10-03T18:39:05Z")

</div>

@seba can you give a query for the “Sales By Sku” report as well?

---

<div class="post-metadata">

**Author:** ![seba](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@seba](https://community.shiphero.com/u/seba)\
**Post date:** [October 3, 2019, 6:46pm UTC](https://community.shiphero.com/t/generate-reports-weekly/162/4 "2019-10-03T18:46:47Z")

</div>

I’m afraid we dont have that yet