Integration Specifications

This page will help you learn about how Daasity replicates data from Shopify, the limitations of the data we can extract, and where the data is stored in the Shopify schema.

Integration Overview

Shopify is a leading e-commerce platform that empowers businesses to easily create and manage online stores, offering built-in analytics and seamless integration with third-party tools for data-driven insights.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

The Daasity Shopify extractor is based on the Shopify REST API and Shopify GraphQL documentation.

Daasity is currently using the 2022-04 version of the REST and GraphQL APIs.

The following endpoints are used by Daasity to replicate data from Shopify:

The Orders endpoint runs each hour and all other endpoints are updated daily unless requested otherwise.

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Shopify integration illustrating the different tables and keys to join across tables.

Shopify & Shopify Plus Schema

The Daasity Shopify extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.

Collects

  • Endpoint: Collect

  • Update Method: UPSERT

  • Table Name: [shopify.collects]

Custom Collections

  • Update Method: UPSERT

  • Table Name: [shopify.custom_collections]

Customer Addresses

  • Endpoint: Customer

  • Update Method: UPSERT

  • Table Name: [shopify.customer_addresses]

Customers

  • Endpoint: Customer

  • Update Method: UPSERT

  • Table Name: [shopify.customers]

Discount Codes

  • Endpoint: Discount Codes

  • Update Method: UPSERT

  • Table Name: [shopify.discount_codes]

Disputes

  • Endpoint: Dispute

  • Update Method: UPSERT

  • Table Name: [shopify.disputes]

Fulfillment Order Items

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.fulfillment_order_items]

Gift Cards

  • Endpoint: Gift Card

  • Update Method: UPSERT

  • Table Name: [shopify.gift_cards]

NOTE: This table is only available for merchants on Shopify Plus.

Please contact support@daasity.com to enable this table, if you are a Shopify Plus merchant.

Gift Card Adjustments

  • Endpoint: Gift Card

  • Update Method: UPSERT

  • Table Name: [shopify.gift_card_adjustments]

NOTE: This table is only available for merchants on Shopify Plus.

Please contact support@daasity.com to enable this table, if you are a Shopify Plus merchant.

Inventory Items

  • Endpoint: Inventory Items

  • Update Method: UPSERT

  • Table Name: [shopify.inventory_items]

Inventory Items Country Harmonized System Codes

  • Endpoint: Inventory Items

  • Update Method: UPSERT

  • Table Name: [shopify.inventory_items_country_harmonized_system_codes]

Inventory Levels

  • Update Method: UPSERT

  • Table Name: [shopify.inventory_levels]

Locations

  • Endpoint: Locations

  • Update Method: UPSERT

  • Table Name: [shopify.locations]

Orders

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.orders]

Order Discount Applications

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_discount_applications]

Order Discount Codes

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_discount_codes]

Order Fulfillments

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_fulfillments]

Order Line Items

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_line_items]

Order Line Duties

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_line_duties]

Order Line Duty Tax Lines

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_line_duty_tax_lines]

Order Line Item Discount Allocations

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_line_item_discount_allocations]

Order Line Item Properties

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_line_item_properties]

Order Metafields

  • Endpoint: Metafield (filtered for ownerType is ORDER)

  • Update Method: UPSERT

  • Table Name: [shopify.order_metafields]

If you set up your Shopify integration before July 2024, you need to contact support@daasity.com to enable extraction to this table.

Order Note Attributes

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_note_attributes]

Order Payment Gateway Names

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_payment_gateway_names]

Order Refund Transactions

  • Endpoint: Refund

  • Update Method: UPSERT

  • Table Name: [shopify.order_refund_transactions]

Order Sales Agreements

  • Endpoint: Order (GraphQL)

  • Update Method: UPSERT

  • Table Name: [shopify.order_sales_agreements]

Order Shipping Lines

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_shipping_lines]

Order Shipping Line Tax Lines

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_shipping_line_tax_lines]

Order Tax Lines

  • Endpoint: Order

  • Update Method: UPSERT

  • Table Name: [shopify.order_tax_lines]

Payment Transactions

  • Endpoint: Transaction

  • Update Method: UPSERT

  • Table Name: [shopify.payment_transactions]

Payouts

  • Endpoint: Payouts

  • Update Method: UPSERT

  • Table Name: [shopify.payouts]

Price Rules

  • Endpoint: Price Rules

  • Update Method: UPSERT

  • Table Name: [shopify.price_rules]

Products

  • Endpoint: Product

  • Update Method: UPSERT

  • Table Name: [shopify.products]

Product Images

  • Endpoint: Product

  • Update Method: UPSERT

  • Table Name: [shopify.product_images]

Product Metafields

  • Endpoint: Metafield (filtered for ownerType is PRODUCT)

  • Update Method: UPSERT

  • Table Name: [shopify.product_metafields]

If you set up your Shopify integration before July 2024, you need to contact support@daasity.com to enable extraction to this table.

Product Variant Metafields

  • Endpoint: Metafield (filtered for ownerType is PRODUCTVARIANT)

  • Update Method: UPSERT

  • Table Name: [shopify.product_variant_metafields]

If you set up your Shopify integration before July 2024, you need to contact support@daasity.com to enable extraction to this table.

Product Variants

  • Endpoint: Product

  • Update Method: UPSERT

  • Table Name: [shopify.product_variants]

Refunds

  • Endpoint: Refund

  • Update Method: UPSERT

  • Table Name: [shopify.refunds]

Refund Line Items

  • Endpoint: Refund

  • Update Method: UPSERT

  • Table Name: [shopify.refund_line_items]

Refund Order Adjustments

  • Endpoint: Refund

  • Update Method: UPSERT

  • Table Name: [shopify.refund_order_adjustments]

Shops

  • Endpoint: Shop

  • Update Method: UPSERT

  • Table Name: [shopify.shops]

Tender Transactions

  • Update Method: UPSERT

  • Table Name: [shopify.tender_transactions]

NOTE: Please contact support@daasity.com to enable this table.

Transaction Fee

  • Endpoint: Transactions

  • Update Method: UPSERT

  • Table Name: [shopify.transaction_fee]

NOTE: Please contact support@daasity.com to enable this table.

Transactions

  • Endpoint: Transactions

  • Update Method: UPSERT

  • Table Name: [shopify.transactions]

Transactions Receipt

  • Endpoint: Transactions

  • Update Method: UPSERT

  • Table Name: [shopify.transactions_receipt]

NOTE: Please contact support@daasity.com to enable this table.

Users

  • Endpoint: User

  • Update Method: UPSERT

  • Table Name: [shopify.users]

NOTE: This table is only available for merchants on Shopify Plus.

Please contact support@daasity.com to enable this table, if you are a Shopify Plus merchant.

User Permissions

  • Endpoint: User

  • Update Method: UPSERT

  • Table Name: [shopify.users]

NOTE: This table is only available for merchants on Shopify Plus.

Please contact support@daasity.com to enable this table, if you are a Shopify Plus merchant.

Last updated