Shopify

Shopify logo

Shopify

Configuration

Shopify source connector integrates with the Shopify Admin API.

Uses OAuth 2.0 client credentials grant to exchange client_id/client_secret for an access token, then syncs comprehensive data from your Shopify store:

  • Products and their variants with pricing and inventory
  • Customer profiles and purchase history
  • Orders with line items and fulfillment status
  • Custom and Smart Collections
  • Store locations and inventory levels
  • Fulfillments and shipment tracking
  • Gift cards and discounts/price rules
  • Metaobjects for custom data structures
  • Files/media via GraphQL
  • Themes and templates

Authentication

This connector uses a custom authentication configuration.

Authentication Configuration

Shopify authentication credentials schema using client credentials grant.

Uses client_id and client_secret to obtain an access token via OAuth 2.0 client credentials flow. The token is exchanged for Admin API access.

client_id
strRequired

Client ID from your Shopify app in the Dev Dashboard

client_secret
strRequired

Client Secret from your Shopify app in the Dev Dashboard

Configuration Options

The following configuration options are available for this connector:

Configuration Parameters

Shopify configuration schema.

shop_domain
strRequired

Your Shopify store domain (e.g., ‘my-store.myshopify.com’)

Data Models

The following data models are available for this connector:

Schema for Shopify Product resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/product

FieldTypeDescription
product_idstrShopify product ID.
product_titlestrTitle of the product.
created_timedatetimeWhen the product was created.
updated_timedatetimeWhen the product was last updated.
web_url_valueOptional[str]URL to view this product in Shopify admin.
body_htmlOptional[str]Product description in HTML format
vendorOptional[str]Name of the product vendor
product_typeOptional[str]Product type/category
handleOptional[str]URL-friendly product handle
statusOptional[str]Product status (active, archived, draft)
tagsOptional[str]Comma-separated list of product tags
variantsList[Dict[str, Any]]Product variants with pricing, inventory, etc.
optionsList[Dict[str, Any]]Product options (size, color, etc.)
imagesList[Dict[str, Any]]Product images

Schema for Shopify Product Variant resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/product-variant

FieldTypeDescription
variant_idstrShopify variant ID.
variant_titlestrTitle of the variant.
created_timedatetimeWhen the variant was created.
updated_timedatetimeWhen the variant was last updated.
web_url_valueOptional[str]URL to view this variant in Shopify admin.
product_idOptional[str]ID of the parent product
skuOptional[str]Stock keeping unit (SKU)
priceOptional[str]Price of the variant
compare_at_priceOptional[str]Compare-at price for sale pricing
inventory_quantityOptional[int]Available inventory quantity
weightOptional[float]Weight of the variant
weight_unitOptional[str]Weight unit (g, kg, oz, lb)
barcodeOptional[str]Barcode (ISBN, UPC, GTIN, etc.)
option1Optional[str]First option value
option2Optional[str]Second option value
option3Optional[str]Third option value

Schema for Shopify Customer resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/customer

FieldTypeDescription
customer_idstrShopify customer ID.
customer_namestrDisplay name of the customer.
created_timedatetimeWhen the customer was created.
updated_timedatetimeWhen the customer was last updated.
web_url_valueOptional[str]URL to view this customer in Shopify admin.
emailOptional[str]Customer’s email address
phoneOptional[str]Customer’s phone number
first_nameOptional[str]Customer’s first name
last_nameOptional[str]Customer’s last name
verified_emailboolWhether the email has been verified
accepts_marketingboolWhether customer accepts marketing emails
orders_countintNumber of orders placed by customer
total_spentOptional[str]Total amount spent by customer
stateOptional[str]Customer account state (disabled, invited, enabled, declined)
currencyOptional[str]Customer’s preferred currency
tagsOptional[str]Comma-separated list of customer tags
noteOptional[str]Notes about the customer
default_addressOptional[Dict[str, Any]]Customer’s default address

Schema for Shopify Order resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/order

FieldTypeDescription
order_idstrShopify order ID.
order_namestrOrder number/name (e.g., #1001).
created_timedatetimeWhen the order was created.
updated_timedatetimeWhen the order was last updated.
web_url_valueOptional[str]URL to view this order in Shopify admin.
order_numberOptional[int]Sequential order number
emailOptional[str]Customer’s email address
phoneOptional[str]Customer’s phone number
total_priceOptional[str]Total price of the order including taxes and shipping
subtotal_priceOptional[str]Subtotal price before taxes and shipping
total_taxOptional[str]Total tax amount
total_discountsOptional[str]Total discount amount applied
currencyOptional[str]Currency code (e.g., USD, EUR)
financial_statusOptional[str]Payment status (pending, authorized, paid, refunded, etc.)
fulfillment_statusOptional[str]Fulfillment status (fulfilled, partial, null)
customer_idOptional[str]ID of the customer who placed the order
line_itemsList[Dict[str, Any]]Line items in the order
shipping_addressOptional[Dict[str, Any]]Shipping address
billing_addressOptional[Dict[str, Any]]Billing address
tagsOptional[str]Comma-separated list of order tags
noteOptional[str]Notes about the order
cancelled_atOptional[datetime]When the order was cancelled (if applicable)
cancel_reasonOptional[str]Reason for cancellation

Schema for Shopify Draft Order resource.

Draft orders are orders created by merchants that haven’t been completed/paid yet. https://shopify.dev/docs/api/admin-rest/2024-01/resources/draftorder

FieldTypeDescription
draft_order_idstrShopify draft order ID.
draft_order_namestrDraft order name (e.g., #D1).
created_timedatetimeWhen the draft order was created.
updated_timedatetimeWhen the draft order was last updated.
web_url_valueOptional[str]URL to view this draft order in Shopify admin.
emailOptional[str]Customer’s email address
statusOptional[str]Draft order status (open, invoice_sent, completed)
total_priceOptional[str]Total price of the draft order
subtotal_priceOptional[str]Subtotal price before taxes and shipping
total_taxOptional[str]Total tax amount
currencyOptional[str]Currency code (e.g., USD, EUR)
customer_idOptional[str]ID of the customer
line_itemsList[Dict[str, Any]]Line items in the draft order
shipping_addressOptional[Dict[str, Any]]Shipping address
billing_addressOptional[Dict[str, Any]]Billing address
tagsOptional[str]Comma-separated list of tags
noteOptional[str]Notes about the draft order
invoice_sent_atOptional[datetime]When the invoice was sent
completed_atOptional[datetime]When the draft order was completed

Schema for Shopify Collection resources (Custom and Smart Collections).

https://shopify.dev/docs/api/admin-rest/2024-01/resources/customcollection https://shopify.dev/docs/api/admin-rest/2024-01/resources/smartcollection

FieldTypeDescription
collection_idstrShopify collection ID.
collection_titlestrTitle of the collection.
created_timedatetimeWhen the collection was created.
updated_timedatetimeWhen the collection was last updated.
web_url_valueOptional[str]URL to view this collection in Shopify admin.
handleOptional[str]URL-friendly collection handle
body_htmlOptional[str]Collection description in HTML format
published_atOptional[datetime]When the collection was published
published_scopeOptional[str]Publication scope (web, global)
sort_orderOptional[str]Sort order for products in collection
collection_typestrType of collection (custom or smart)
disjunctiveOptional[bool]For smart collections: whether rules are OR (true) or AND (false)
rulesList[Dict[str, Any]]For smart collections: rules that define product membership
products_countOptional[int]Number of products in the collection

Schema for Shopify Inventory Item resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/inventoryitem

FieldTypeDescription
inventory_item_idstrShopify inventory item ID.
inventory_item_namestrDisplay name for the inventory item.
created_timedatetimeWhen the inventory item was created.
updated_timedatetimeWhen the inventory item was last updated.
web_url_valueOptional[str]URL to view this inventory item in Shopify admin.
skuOptional[str]Stock keeping unit (SKU)
costOptional[str]Unit cost of the inventory item
trackedboolWhether inventory tracking is enabled
requires_shippingboolWhether the item requires shipping
country_code_of_originOptional[str]Country code of origin
province_code_of_originOptional[str]Province/state code of origin
harmonized_system_codeOptional[str]Harmonized System (HS) tariff code

Schema for Shopify Location resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/location

FieldTypeDescription
location_idstrShopify location ID.
location_namestrName of the location.
created_timedatetimeWhen the location was created.
updated_timedatetimeWhen the location was last updated.
web_url_valueOptional[str]URL to view this location in Shopify admin.
address1Optional[str]Primary street address
address2Optional[str]Secondary address line
cityOptional[str]City
provinceOptional[str]Province/state name
province_codeOptional[str]Province/state code
countryOptional[str]Country name
country_codeOptional[str]Country code (ISO 3166-1 alpha-2)
zipOptional[str]Postal/ZIP code
phoneOptional[str]Phone number
activeboolWhether the location is active
legacyboolWhether this is a legacy location
localized_country_nameOptional[str]Localized country name
localized_province_nameOptional[str]Localized province/state name

Schema for Shopify Inventory Level resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/inventorylevel

FieldTypeDescription
inventory_level_idstrComposite ID (inventory_item_id-location_id).
inventory_level_namestrDisplay name for the inventory level.
created_timedatetimeWhen the inventory level was created.
updated_timedatetimeWhen the inventory level was last updated.
web_url_valueOptional[str]URL to view this inventory in Shopify admin.
inventory_item_idstrID of the inventory item
location_idstrID of the location
availableOptional[int]Available quantity at this location

Schema for Shopify Fulfillment resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/fulfillment

FieldTypeDescription
fulfillment_idstrShopify fulfillment ID.
fulfillment_namestrDisplay name for the fulfillment.
created_timedatetimeWhen the fulfillment was created.
updated_timedatetimeWhen the fulfillment was last updated.
web_url_valueOptional[str]URL to view this fulfillment in Shopify admin.
order_idstrID of the parent order
statusOptional[str]Status of the fulfillment (pending, open, success, cancelled, error, failure)
tracking_companyOptional[str]Name of the tracking company
tracking_numberOptional[str]Tracking number
tracking_numbersList[str]List of tracking numbers
tracking_urlOptional[str]URL for tracking the shipment
tracking_urlsList[str]List of tracking URLs
location_idOptional[str]ID of the fulfillment location
line_itemsList[Dict[str, Any]]Line items in this fulfillment
shipment_statusOptional[str]Shipment status

Schema for Shopify Gift Card resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/gift-card

FieldTypeDescription
gift_card_idstrShopify gift card ID.
gift_card_namestrDisplay name for the gift card.
created_timedatetimeWhen the gift card was created.
updated_timedatetimeWhen the gift card was last updated.
web_url_valueOptional[str]URL to view this gift card in Shopify admin.
initial_valueOptional[str]Initial value of the gift card
balanceOptional[str]Current balance
currencyOptional[str]Currency code
codeOptional[str]Gift card code (masked)
last_charactersOptional[str]Last 4 characters of the code
disabled_atOptional[datetime]When the gift card was disabled
expires_onOptional[str]Expiration date
noteOptional[str]Notes about the gift card
customer_idOptional[str]ID of the customer who owns this gift card
order_idOptional[str]ID of the order that created this gift card

Schema for Shopify Price Rule / Discount resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/pricerule

FieldTypeDescription
discount_idstrShopify price rule ID.
discount_titlestrTitle of the discount/price rule.
created_timedatetimeWhen the discount was created.
updated_timedatetimeWhen the discount was last updated.
web_url_valueOptional[str]URL to view this discount in Shopify admin.
value_typeOptional[str]Type of discount value (fixed_amount, percentage)
valueOptional[str]Discount value (negative for discounts)
target_typeOptional[str]Target type (line_item, shipping_line)
target_selectionOptional[str]Target selection (all, entitled)
allocation_methodOptional[str]Allocation method (across, each)
once_per_customerboolWhether the discount can only be used once per customer
usage_limitOptional[int]Maximum number of times the discount can be used
starts_atOptional[datetime]When the discount becomes active
ends_atOptional[datetime]When the discount expires
prerequisite_subtotal_rangeOptional[Dict[str, Any]]Minimum subtotal required
prerequisite_quantity_rangeOptional[Dict[str, Any]]Minimum quantity required

Schema for Shopify Metaobject resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/metaobject

FieldTypeDescription
metaobject_idstrShopify metaobject ID.
metaobject_namestrDisplay name/handle for the metaobject.
created_timedatetimeWhen the metaobject was created.
updated_timedatetimeWhen the metaobject was last updated.
web_url_valueOptional[str]URL to view this metaobject in Shopify admin.
typestrMetaobject definition type
handleOptional[str]Unique handle for the metaobject
fieldsList[Dict[str, Any]]Field values for the metaobject
capabilitiesOptional[Dict[str, Any]]Capabilities of the metaobject

Schema for Shopify File resource.

Inherits from FileEntity for consistency with other file entities in the codebase.

https://shopify.dev/docs/api/admin-graphql/2024-01/objects/file

FieldTypeDescription
file_idstrShopify file ID.
file_namestrName of the file.
created_timedatetimeWhen the file was created.
updated_timedatetimeWhen the file was last updated.
web_url_valueOptional[str]URL to view this file in Shopify admin.
altOptional[str]Alt text for accessibility
file_statusOptional[str]Status of the file (UPLOADED, PROCESSING, READY, FAILED)
preview_image_urlOptional[str]URL of the preview image

Schema for Shopify Theme resource.

https://shopify.dev/docs/api/admin-rest/2024-01/resources/theme

FieldTypeDescription
theme_idstrShopify theme ID.
theme_namestrName of the theme.
created_timedatetimeWhen the theme was created.
updated_timedatetimeWhen the theme was last updated.
web_url_valueOptional[str]URL to view this theme in Shopify admin.
roleOptional[str]Role of the theme (main, unpublished, demo)
theme_store_idOptional[int]ID from the Shopify Theme Store
previewableboolWhether the theme can be previewed
processingboolWhether the theme is currently being processed