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:
Customers
Discounts
Plus (Available only with the Daasity Shopify Plus extractor)
User (Please contact support@daasity.com to enable this endpoint.)
Products
Shopify Payments
Transactions (Please contact support@daasity.com to enable this endpoint.)
Store Properties
Tender Transaction
Tender Transaction (Please contact support@daasity.com to enable this endpoint.)
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
Endpoint: Custom Collection
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
Endpoint: 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 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 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
Endpoint: Tender Transaction
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