Supermetrics brings all your Shopify data into Google Sheets, Looker Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Shopify Updates

Updates on the Shopify data source, including new metrics, dimensions, and other features.

December 2024

2024-12-10

The following fields have been added:

  • Customer notes
  • Ordered quantity
  • Returned quantity
  • Net quantity
  • Units per transaction

September 2024

New fields added:

  • Duties
  • Fulfillment date
  • Line item Fulfillment date

January 2022

2022-01-24

New dimension added:

  • Cost per item

December 2021

2021-12-22

Upgraded the data source to API version v2021-07.

2021-12-14

The following dimensions have been added:

  • Billing country
  • Billing province
  • Billing city
  • Billing postal code
  • Billing address 1
  • Billing address 2
  • Billing phone

September 2021

2021-09-07 The following fields have been renamed:

  • Product created at => Product created datetime
  • Order created date => Order created datetime
  • Order close date => Order closed datetime
  • Order cancelled date => Order cancelled datetime
  • Last order created date => Last order created datetime
  • Account created => Account created datetime

New dimensions added for all products:

  • Product created date
  • Order created date
  • Order closed date
  • Order cancelled date
  • Last order created date
  • Account created date

New dimensions added for data warehouse and cloud storage products only:

  • Product created time (ISO)
  • Order created time (ISO)
  • Order closed time (ISO)
  • Order cancelled time (ISO)
  • Last order created date (ISO)
  • Account created time (ISO)

June 2021

2021-06-15 -

Added new metric:

  • Cost per item [This was reverted temporarily on June 30th, 2021]

This uses InventoryItem properties, which requires an additional scope to work. Users will need to re-authenticate to get access to this.

Jan. 2021

2021-01-28-

Upgraded the connector to API version v2021-01.

Oct. 2020

2020-10-21 -

New dimensions added:

  • Product tags
  • Order tags

2020-10-26 -

New dimensions added:

  • Shipping address 1
  • Shipping address 2
  • Shipping phone
  • Shipping post code
  • Shipping city
  • Shipping province
  • Shipping country

April 2020

2020-04-23 -

New fields added:

  • SKU
  • Order fulfillment status

New behavior added for selecting stores, they can be selected like an account from all the stores the user currently has logged in as.