Description

Shopify is a cloud-based, multi-channel commerce platform designed for small and medium-sized businesses.

Connector Details

Name	Value
Platform	Shopify
Auth Type	API Keys
Direction	Bidirectional
Unified Schema	Supported in Ecommerce Unified Schema

Triggers

See the table below for the list of real-time triggers supported by the Shopify connector.

Name	Description
Created order	Triggered when a new sale order is created
Deleted order	Triggered when a sale order is deleted
Created product	Triggered when a new product is created
Deleted product	Triggered when a product is deleted

Supported Data

See the table below for the list of data you can read with the Shopify connector.

Table Name	Fields
abandoned_checkouts	note_attributes, location_id, buyer_accepts_marketing, currency, completed_at, token, billing_address, email, discount_codes, customer_locale, created_at, updated_at, gateway, referring_site, source_identifier, total_weight, tax_lines, total_line_items_price, closed_at, device_id, phone, source_name, id, name, total_tax, subtotal_price, line_items, source_url, total_discounts, note, presentment_currency, shipping_lines, user_id, source, shipping_address, abandoned_checkout_url, landing_site, customer, total_price, cart_token, taxes_included, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
metafields	owner_id, admin_graphql_api_id, owner_resource, value_type, key, created_at, id, namespace, description, value, updated_at, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
shop	id, name, email, domain, province, country, address1, zip, city, phone, latitude, longitude, money_in_emails_format, money_with_currency_in_emails_format, eligible_for_payments, requires_extra_payments_agreement, password_enabled, has_storefront, eligible_for_card_reader_giveaway, finances, primary_location_id, cookie_consent_level, visitor_tracking_consent_preference, checkout_api_supported, multi_location_enabled, setup_required, pre_launch_enabled, enabled_presentment_currencies, currency, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
locations	country_code, name, address1, city, id, address2, province_code, zip, localized_province_name, localized_country_name, updated_at, province, phone, legacy, created_at, country, active, admin_graphql_api_id, country_name, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
customers	last_order_name, currency, email, multipass_identifier, default_address, orders_count, state, verified_email, total_spent, last_order_id, first_name, updated_at, note, phone, admin_graphql_api_id, addresses, last_name, tags, tax_exempt, id, accepts_marketing, accepts_marketing_updated_at, created_at, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
transactions	error_code, device_id, user_id, parent_id, test, kind, order_id, amount, authorization, currency, source_name, message, id, created_at, status, payment_details, gateway, admin_graphql_api_id, receipt, location_id, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
orders	presentment_currency, subtotal_price_set, total_discounts_set, total_line_items_price_set, total_price_set, total_shipping_price_set, total_tax_set, total_price, line_items, processing_method, order_number, confirmed, total_discounts, total_line_items_price, order_adjustments, shipping_lines, admin_graphql_api_id, device_id, cancel_reason, currency, payment_gateway_names, source_identifier, id, processed_at, referring_site, contact_email, location_id, fulfillments, customer, test, total_tax, payment_details, number, email, source_name, landing_site_ref, shipping_address, total_price_usd, closed_at, discount_applications, name, note, user_id, source_url, subtotal_price, billing_address, landing_site, taxes_included, token, app_id, total_tip_received, browser_ip, discount_codes, tax_lines, phone, note_attributes, fulfillment_status, order_status_url, client_details, buyer_accepts_marketing, checkout_token, tags, financial_status, customer_locale, checkout_id, total_weight, gateway, cart_token, cancelled_at, refunds, created_at, updated_at, reference, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
order_refunds	order_id, restock, order_adjustments, processed_at, user_id, note, id, created_at, admin_graphql_api_id, refund_line_items, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
inventory_items	id, sku, created_at, updated_at, requires_shipping, cost, country_code_of_origin, province_code_of_origin, harmonized_system_code, tracked, country_harmonized_system_codes, admin_graphql_api_id, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
products	status, published_at, created_at, published_scope, vendor, updated_at, body_html, product_type, tags, options, image, handle, images, template_suffix, title, variants, admin_graphql_api_id, id, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
custom_collections	handle, sort_order, body_html, title, id, published_scope, admin_graphql_api_id, updated_at, image, published_at, template_suffix, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
collects	id, collection_id, created_at, position, product_id, sort_value, updated_at, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain
inventory_levels	available, inventory_item_id, updated_at, location_id, incoming, admin_graphql_api_id, _sdc_shop_id, _sdc_shop_name, _sdc_shop_myshopify_domain

Credentials Setup

Follow the steps below to get the credentials you need to use the Shopify connector.

There are two ways to use Shopify: either via a Shopify Public App (OAuth) or using a Private App (API keys). We have guides for both of these options below:

Private App

📘
These steps will be performed by each of your customers when they connect their Shopify account.

The first thing you need to do is log in to Shopify. If you're just testing you can create a free partner account.

Once logged in on the left side of the screen, you should select the Apps option in the navigation bar.

You should now be on the Apps page of your store. Near the bottom, you should click the link that says Manage private apps.

If you have not enabled private apps yet, your page will look like this. Click the Enable private app development button to get started.

It will ask you a few things. You should check all these off and hit the Enable private app development button.

This will now take you back to the Apps page, but now will give you the option to create a private app. You should select the Create Private App button.

Next, you need to fill in the private app name and your email.

Now you want to click the Show inactive Admin API permissions drop down in order to configure what data you would like to be able to pull from Shopify.

This will drop down a bunch of permissions that you can change. Configure the permissions as needed, and then click the Save button in the top right corner.

📘
If you plan to use both the Shopify source and target make sure to enable Read and write access. Otherwise, Read access is sufficient.

Once you have clicked Save, this popup will appear. Click the Create app button.

From here you can get the API Password field which is required for the Shopify source to work properly.

📘
If you plan to use triggers with the Shopify source, make sure to keep your API key as well.

Now you can insert the API Password into your hotglue Shopify source settings along with the name of your Shop.