Tech note - Shopify Query versioning

Overview

The Shopify Query component has been versioned as of Matillion ETL version 1.64. A new version of the Shopify Query component is now available.

Please consult the Shopify data model for a comprehensive view of the available tables, views, and connection options for this version of the component.

New tables

• ApplicationCredit
• ScriptTags
• AbandonedCheckoutsItems
• DraftOrderItemProperties
• Redirects
• Blogs
• Themes
• Pages
• DraftOrderItemTaxLines
• DraftOrderItems
• Articles
• ApplicationCharges
• ShippingItemDiscountAllocations
• UsageCharges
• Assets
• RecurringApplicationCharges
• Comments
• RefundTransactions
• Reports
• ProductImages
• OrderItemDiscountAllocations
• Metafields

---

New columns

• Table: Orders

  • PaymentTermsAmount
  • PaymentTermsCurrency
  • PaymentTermsPaymentTermsName
  • PaymentTermsPaymentTermsType
  • PaymentTermsDueInDays
  • PaymentTermsPaymentSchedules
  • TotalShippingPriceSetShopMoneyAmount
  • TotalShippingPriceSetShopMoneyCurrencyCode

• Table: RefundsItems

  • OrderID

• Table: Products

  • Status

• Table: FulfillmentOrders

  • FullfillAt
  • FulfillmentHolds
  • InternationalDuties

• Table: OrderTransactions

  • PaymentsRefundsAttributesStatus
  • PaymentsRefundsAttributesAcquirerReferenceNumber

• Table: TaxItems

  • ChannelLiable

• Table: OrderItemProperties

  • OrderUpdatedAt

---

Removed columns

• Table: Shop
  • ForceSSL