Skip to main content
Answer

Shopify x Google Sheets: How to Track SKU Quantities Sold?

  • November 22, 2024
  • 3 replies
  • 64 views

LudivineAvell
Forum|alt.badge.img+1

Hi,

I want to create a dashboard in Google Sheets using Shopify as the data source.

I'd like to show the sales evolution of SKU groups in terms of quantities sold, not number of orders. Which metric should I select? I used "item" but I'm not getting the same data as in Shopify.

Thank you in advance for your help

Best answer by jessiebrock

Wanted to let you know we’re now releasing the change that adds the Ordered quantity metric to Shopify. You noted you were using Google Sheets, so it should be already available in that destination!

Thank you,
Jessica

3 replies

jessiebrock
Forum|alt.badge.img+1
  • Community Moderator
  • November 26, 2024

Hi!

Sadly, this is not yet possible as we haven’t implemented the ordered quantity metric that would enable this. It’s on our feature to-do list and hopefully we can release it sometime early next year.

The Items field we already have is close, its the Net quantity in the Shopify UI.

 

Thanks,

Jessica
Product Manager - Connectors


jessiebrock
Forum|alt.badge.img+1
  • Community Moderator
  • Answer
  • December 12, 2024

Wanted to let you know we’re now releasing the change that adds the Ordered quantity metric to Shopify. You noted you were using Google Sheets, so it should be already available in that destination!

Thank you,
Jessica


LudivineAvell
Forum|alt.badge.img+1
  • Author
  • Newbie
  • December 12, 2024

Amazing ! Thank you !