[Feature] Shopify v2022-07 -> v2023-04 API Update Schema Change Considerations

[fivetran-joemarkiewicz]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Shopify is upgrading from their v2022-07 to v2023-04 API. This is resulting in a number of deprecations and new field additions. For this package (and likely the downstream dbt_shopify package), the following changes will need to be made to reflect the connector changes:

• OrderLine Resource (ORDER_LINE Table)
  • origin_location (deprecated)
  • destination_location (deprecated)
  • fulfillment_service (deprecated)
• Order Resource
  • total_price_usd (deprecated)
  • processing_method (2023-04) (unsupported)
• ProductVariant Resource (PRODUCT_VARIANT Table)
  • title (deprecated)

Describe alternatives you've considered

This will still likely work following the API upgrade, but it would be best to upgrade to ensure our package is using the latest fields provided by the API and connector.

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

No response

[fivetran-joemarkiewicz]

Notes from the duplicate Issue from the source package are included below

In June 2023, the connector was migrated to a new Shopify API version, in which the following relevant columns were deprecated

order_line.fulfillment_service
order_line.destination_location_* fields
order_line.origin_location_* fields
order.total_price_usd
order. processing_method
customer.lifetime_duration
we should mark them as deprecated in the src yml file and remove them from staging models

[fivetran-joemarkiewicz]

The latest release incorporates these changes.