Shopify Release Notes

May 2023

Shopify has deprecated and changed a few fields in their API. The Panoply connector has aligned with these changes:

• Orders - Order:
  • Removed last_order_id, last_order_name, orders_count and total_spent from the customer nested data
  • Removed origin_location, destination_location, gateway, payment_details, processing_method and total_price_usd from the main table
  • Added the current_total_additional_fees_set and original_total_additional_fees_set nested data
  • Added merchant_of_record_app_id to the main table
• Store Properties - Shop:
  • Added marketing_sms_consent_enabled_at_checkout to the main table
• Metafields - Metafield Definitions:
  • Added collection_reference to the list nested data
  • Added collection_reference to the main table
• Orders - Transaction:
  • Added credit_card_name, credit_card_wallet, credit_card_expiration_month and credit_card_expiration_year to the payment_details nested data
  • Added the total_unsettled_set nested data
  • Added payment_id to the main table

February 2023

Panoply now support the collection of Shopify Metafield Definitions and metafields' values for the following Shopify objects:

• Customers
• Orders
• Products

What You Need To Know

• The Metafield Definitions resource is collected incrementally. This means that the collected data includes new or updated data since the last time the data source succeeded.
• In order to get the metafields' values for Customers/Orders/Products records that were not updated since the last successful collection of the data source, you will need to change the incremental value to a certain point of time in the past you wish to collect data since.

December 2022

Due to Shopify API updates, we've removed the Customer - Customers Saved Search resource and added the Customer - Segments resource instead. This new resource will populate two tables:

1. shopify_customer_segments - This table lists all the different cusotmer segments that exists in your shop
2. shopify_customer_segment_members - This table lists all the customers in each segment

November 2022

Panoply has changed the way you authenticate your Shopify account. Users will need to first create a custom app in their Shopify store and use the given Admin API access token in order to collect data using Panoply. Learn more in the Shopify Setup Guide.

October 2021

The following resources were removed: Shipping and Fulfillment - Fulfillment and Orders - Refund. The data returning from these resources is available directly through the Orders - Order resource. If one of these resources has been selected in the past, the data source will continue to extract their data until they will be deselected from the data source.

April 2021

The Shopify API version was updated from 2020-01 to 2020-07.

March 2021

The Shopify data source has been updated and released. With this update, Panoply has added additional resources and user control over the date range used to extract data.

To migrate to the new data source, users will need to add new data sources and recollect their data.