Skip to main content
Skip table of contents

Shopify Connector Public API

The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the internal_ prefix in their names. Public API procedures do not have such prefix in their names.

AbandonedCheckouts

Abandoned checkouts
Parameter
<created_at_max> (optional): Show checkouts created before the specified date
<created_at_min> (optional): Show checkouts created after the specified date
<since_id> (optional): Restrict results to after the specified ID
<status> (optional): Show only checkouts with a given status
<updated_at_max> (optional): Show checkouts last updated before the specified date
<updated_at_min> (optional): Show checkouts last updated after the specified date
<token> (optional): Token
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the checkout

name

string

Where the checkout originated. Valid values: web , pos , iphone , android

abandoned_checkout_url

string

The recovery URL that's sent to a customer so they can recover their checkout

billing_address_address1

string

The street address of the billing address

billing_address_address2

string

An optional additional field for the street address of the billing address

billing_address_city

string

The customer's city, town, or village

billing_address_company

string

The customer's company

billing_address_country

string

The name of the country of the billing address

billing_address_country_code

string

The two-letter country code corresponding to the customer's country

billing_address_first_name

string

The first name of the person associated with the payment method

billing_address_last_name

string

The last name of the person associated with the payment method

billing_address_latitude

bigdecimal

The latitude of the billing address

billing_address_longitude

bigdecimal

The longitude of the billing address

billing_address_name

string

The full name of the person associated with the payment method

billing_address_phone

string

The phone number at the billing address

billing_address_province

string

The name of the state or province of the billing address

billing_address_province_code

string

The alphanumeric abbreviation of the state or province of the billing address

billing_address_zip

string

The zip or postal code of the billing address

buyer_accepts_marketing

boolean

Whether the customer would like to receive email updates from the shop. This is set by the I want to receive occasional emails about new products, promotions and other news checkbox during checkout

buyer_accepts_sms_marketing

boolean

Whether the customer would like to receive SMS updates from the shop. This is set by the Text me with news and offers checkbox during checkout

cart_token

string

The ID for the cart that's attached to the checkout

closed_at

timestamp

The date and time ( ISO 8601 format ) when the checkout was closed. If the checkout was not closed, then this value is null

completed_at

timestamp

The date and time ( ISO 8601 format ) when the checkout was completed. For abandoned checkouts, this value is null until a customer completes the checkout using the recovery URL

currency

string

The three-letter code ( ISO 4217 format) of the shop's default currency at the time of checkout. For the currency that the customer used at checkout, see presentment_currency

customer_created_at

timestamp

The date and time ( ISO 8601 format) when the customer was created

customer_currency

string

The three-letter code ( ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders

customer_default_address_address1

string

The first line of the customer's mailing address

customer_default_address_address2

string

An additional field for the customer's mailing address

customer_default_address_city

string

The customer's city, town, or village

customer_default_address_company

string

The customer's company

customer_default_address_country

string

The customer's country

customer_default_address_country_code

string

The two-letter country code corresponding to the customer's country

customer_default_address_country_name

string

The customer's normalized country name

customer_default_address_customer_id

long

Customer default address customer id

customer_default_address_default

boolean

Returns true for each default address

customer_default_address_first_name

string

The customer's first name

customer_default_address_id

long

A unique identifier for the address

customer_default_address_last_name

string

The customer's last name

customer_default_address_name

string

The order name, generated by combining the order_number property with the order prefix and suffix that are set in the merchant's general settings . This is different from the id property, which is the ID of the order used by the API. This field can also be set by the API to be any string value

customer_default_address_phone

string

The customer's phone number at this address

customer_default_address_province

string

The customer's region name. Typically a province, a state, or a prefecture

customer_default_address_province_code

string

The alphanumeric code for the customer's region

customer_default_address_zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

customer_email

string

The unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error

customer_email_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is used

customer_email_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by email

customer_email_marketing_consent_state

string

The current email marketing state for the customer

customer_first_name

string

The customer's first name

customer_id

long

A unique identifier for the customer

customer_last_name

string

The customer's last name

customer_last_order_id

long

The ID of the customer's last order

customer_last_order_name

string

The name of the customer's last order. This is directly related to the name field on the Order resource

customer_locale

string

The two or three-letter language code, optionally followed by a region modifier. Example values: en , en-CA

customer_multipass_identifier

string

A unique identifier for the customer that's used with Multipass login

customer_note

string

A note about the customer

customer_orders_count

integer

The number of orders associated with this customer. Test and archived orders aren't counted

customer_phone

string

The unique phone number (<a href="https://en.wikipedia.org/wiki/E.164">E.164 format ) for this customer. Attempting to assign the same phone number to multiple customers returns an error. The property can be set using different formats, but each format must represent a number that can be dialed from anywhere in the world. The following formats are all valid: 6135551212 +16135551212 (613)555-1212 +1 613-555-1212

customer_sms_marketing_consent_consent_collected_from

string

The source for whether the customer has consented to receive marketing material by SMS

customer_sms_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by SMS. If no date is provided, then the date and time when the consent information was sent is used

customer_sms_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by SMS

customer_sms_marketing_consent_state

string

The current SMS marketing state for the customer

customer_state

string

The state of the customer's account with a shop. Default value: disabled . Valid values: disabled : The customer doesn't have an active account. Customer accounts can be disabled from the Shopify admin at any time. invited : The customer has received an email invite to create an account. enabled : The customer has created an account. declined : The customer declined the email invite to create an account

customer_tags

string

Tags that the shop owner has attached to the customer, formatted as a string of comma-separated values. A customer can have up to 250 tags. Each tag can have up to 255 characters

customer_tax_exempt

boolean

Whether the customer is exempt from paying taxes on their order. If true , then taxes won't be applied to an order at checkout. If false , then taxes will be applied at checkout

customer_total_spent

bigdecimal

The total amount of money that the customer has spent across their order history

customer_updated_at

timestamp

The date and time ( ISO 8601 format) when the customer information was last updated

customer_verified_email

boolean

Whether the customer has verified their email address

device_id

long

The ID of the Shopify POS device that created the checkout

discount_codes

string

Discount codes applied to the checkout. Returns an empty array when no codes are applied. Each discount code has the following fields: amount : The amount of the discount in presentment currency. code : The discount code. type : The type of discount. Valid values: percentage , shipping , fixed_amount . (default: fixed_amount )

email

string

The customer's email address

gateway

string

The payment gateway used by the checkout. For abandoned checkouts, this value is always null

landing_site

string

The URL for the page where the customer entered the shop

location_id

long

The ID of the physical location where the checkout was processed

note

string

The text of an optional note that a shop owner can attach to the order

note_attributes

string

Extra information that is added to the order. Appears in the Additional details section of an order details page. Each array entry must contain a hash with name and value keys

phone

string

The customer's phone number for receiving SMS notifications

presentment_currency

string

The three-letter code ( ISO 4217 format) of the currency that the customer used at checkout. For the shop's default currency, see currency

referring_site

string

The website that referred the customer to the shop

reservation_token

string

Reservation token

shipping_address_address1

string

The street address of the shipping address

shipping_address_address2

string

An optional additional field for the street address of the shipping address

shipping_address_city

string

The city of the shipping address

shipping_address_company

string

The company of the person associated with the shipping address

shipping_address_country

string

The name of the country of the shipping address

shipping_address_country_code

string

The two-letter code ( format) for the country of the shipping address

shipping_address_first_name

string

The first name of the person associated with the shipping address

shipping_address_last_name

string

The last name of the person associated with the shipping address

shipping_address_latitude

bigdecimal

The latitude of the shipping address

shipping_address_longitude

bigdecimal

The longitude of the shipping address

shipping_address_name

string

The full name of the person associated with the shipping address

shipping_address_phone

string

The phone number at the shipping address

shipping_address_province

string

The name of the state or province of the shipping address

shipping_address_province_code

string

The alphanumeric abbreviation of the state or province of the shipping address

shipping_address_zip

string

The zip or postal code of the shipping address

sms_marketing_phone

string

The phone number used to opt in to SMS marketing during checkout

source

string

The channel where the checkout originated. Example value: shopify

source_identifier

string

Source identifier

source_name

string

Where the checkout originated. Valid values: web , pos , iphone , android

source_url

string

Source url

subtotal_price

bigdecimal

The price of the checkout in presentment currency before shipping and taxes

taxes_included

boolean

Whether taxes are included in the price

token

string

A unique ID for a checkout

total_discounts

bigdecimal

The total amount of discounts to be applied in presentment currency

total_duties

bigdecimal

The total duties of the checkout in presentment currency

total_line_items_price

bigdecimal

The sum of the prices of all line items in the checkout in presentment currency

total_price

bigdecimal

The sum of line item prices, all discounts, shipping costs, and taxes for the checkout in presentment currency

total_tax

bigdecimal

The sum of all the taxes applied to the checkout in presentment currency

total_weight

bigdecimal

The sum of all the weights in grams of the line items in the checkout

user_id

long

The ID of the user who created the checkout

created_at

timestamp

The date and time ( ISO 8601 format ) when the checkout was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the checkout was last modified

SQL
CREATE VIEW shopify_examples.example_AbandonedCheckouts AS
SELECT *
FROM (
CALL shopify.AbandonedCheckouts (
updated_at_min => NULL,
updated_at_max => NULL,
status => NULL,
since_id => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

AccessScopes

List of access scopes
Parameter
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

handle

string

Handle

SQL
CREATE VIEW shopify_examples.example_AccessScopes AS
SELECT *
FROM (
CALL shopify.AccessScopes ()
) AS x;;

ApplicationCharges

Application charges
Parameter
<since_id> (optional): Restrict results to after the specified ID
<application_charge_id> (optional): Application charge id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the application charge

name

string

The application charge name

api_client_id

long

Api client id

charge_type

string

Charge type

currency

string

The currency of the price of the application charge

decorated_return_url

string

Decorated return url

external_id

string

External id

price

bigdecimal

The price of the application charge. The minimum price is 0.50, and maximum price is 10,000

return_url

string

The URL where the merchant is redirected after accepting a charge

status

string

The status of the application charge. Valid values: pending : The application charge is pending approval by the merchant. accepted : Removed in version 2021-01 . The application charge has been accepted by the merchant and is ready to be activated by the app. At this point it will appear on the merchant's invoice. As of API version 2021-01, when a merchant accepts a charge, the charge immediately transitions from pending to active . active : The application charge has been activated by the app and will be paid out to the Partner. declined : The application charge was declined by the merchant. expired : The application charge was not accepted within 2 days of being created

test

boolean

Whether the application charge is a test transaction. Valid values: true , null

created_at

timestamp

The date and time ( ISO 8601 format) when the application charge was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the charge was last updated

SQL
CREATE VIEW shopify_examples.example_ApplicationCharges AS
SELECT *
FROM (
CALL shopify.ApplicationCharges (
since_id => NULL
)
) AS x;;

ApplicationCredits

Application credits
Parameter
<application_credit_id> (optional): Application credit id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the application credit

amount

bigdecimal

The amount refunded by the application credit

currency

string

The currency of the application credit amount

description

string

The description of the application credit

test

boolean

Whether the application credit is a test transaction. Valid values: true , null

SQL
CREATE VIEW shopify_examples.example_ApplicationCredits AS
SELECT *
FROM (
CALL shopify.ApplicationCredits ()
) AS x;;

ArticleAuthors

Article authors
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

author

string

The name of the author of the article

SQL
CREATE VIEW shopify_examples.example_ArticleAuthors AS
SELECT *
FROM (
CALL shopify.ArticleAuthors ()
) AS x;;

ArticleTags

Article tags
Parameter
<popular> (optional): A flag for ordering retrieved tags. If present in the request, then the results will be ordered by popularity, starting with the most popular tag
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

tag

string

Tag

SQL
CREATE VIEW shopify_examples.example_ArticleTags AS
SELECT *
FROM (
CALL shopify.ArticleTags (
popular => NULL
)
) AS x;;

Assets

Assets for a theme
Parameter
<theme_id> (optional): Theme id
<theme_table> (optional): Table with theme containing column id (containing theme_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

checksum

string

The MD5 representation of the content, consisting of a string of 32 hexadecimal digits. May be null if an asset has not been updated recently

content_type

string

The MIME representation of the content, consisting of the type and subtype of the asset

key

string

The path to the asset within a theme. It consists of the file's directory and filename. For example, the asset assets/bg-body-green.gif is in the assets directory, so its key is assets/bg-body-green.gif

public_url

string

The public-facing URL of the asset

size

long

The asset size in bytes

theme_id

long

The ID for the theme that an asset belongs to

value

string

The text content of the asset, such as the HTML and Liquid markup of a template file

created_at

timestamp

The date and time ( ISO 8601 format) when the asset was created

updated_at

timestamp

The date and time ( ISO 8601 format) when an asset was last updated

SQL
CREATE VIEW shopify_examples.example_Assets AS
SELECT *
FROM (
CALL shopify.Assets (
theme_id => 73257517171
)
) AS x;;

AssignedFulfillmentOrders

Fulfillment orders assigned to the shop locations that are owned by the app
Parameter
<assignment_status> (optional): The assignment status of the fulfillment orders that should be returned. If assignment_status parameter isn't provided, then the query will return all assigned fulfillment orders, except those with the CLOSED status
<location_ids> (optional): The IDs of the assigned locations of the fulfillment orders that should be returned. If the location_ids parameter isn't provided, then all fulfillment orders assigned to the shop locations that are managed by the app will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the fulfillment order

assigned_location_address1

string

The customer's mailing address

assigned_location_address2

string

An additional field for the customer's mailing address

assigned_location_city

string

The customer's city, town, or village

assigned_location_country_code

string

The two-letter country code corresponding to the customer's country

assigned_location_id

long

The unique identifier for the address

assigned_location_location_id

long

Assigned location id

assigned_location_name

string

The customer's first and last names

assigned_location_phone

string

The customer's phone number at this address

assigned_location_province

string

The customer's region name. Typically a province, a state, or a prefecture

assigned_location_zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

destination_address1

string

The first line of the address of the destination

destination_address2

string

The second line of the address of the destination

destination_city

string

The city of the destination

destination_company

string

The company of the destination

destination_country

string

The country of the destination

destination_email

string

The email of the customer at the destination

destination_first_name

string

The first name of the customer at the destination

destination_id

long

The ID of the fulfillment order destination

destination_last_name

string

The last name of the customer at the destination

destination_phone

string

The phone number of the customer at the destination

destination_province

string

The province of the destination

destination_zip

string

The ZIP code of the destination

fulfillment_service_handle

string

Fulfillment service handle

international_duties_incoterm

string

The international duties relevant to the fulfillment order

order_id

long

The ID of the order that's associated with the fulfillment order

request_status

string

The request status of the fulfillment order. Valid values: unsubmitted : The initial request status for the newly-created fulfillment orders. This is the only valid request status for fulfillment orders that aren't assigned to a fulfillment service. submitted : The merchant requested fulfillment for this fulfillment order. accepted : The fulfillment service accepted the merchant's fulfillment request. rejected : The fulfillment service rejected the merchant's fulfillment request. cancellation_requested : The merchant requested a cancellation of the fulfillment request for this fulfillment order. cancellation_accepted : The fulfillment service accepted the merchant's fulfillment cancellation request. cancellation_rejected : The fulfillment service rejected the merchant's fulfillment cancellation request. closed : The fulfillment service closed the fulfillment order without completing it

shop_id

long

The ID of the shop that's associated with the fulfillment order

status

string

The status of the fulfillment order. Valid values: open : Default state for newly created fulfillment orders. in_progress : The fulfillment order is being processed. cancelled : The fulfillment order has been cancelled by the merchant. incomplete : The fulfillment order cannot be completed as requested. closed : The fulfillment order has been completed and closed

supported_actions

string

Supported actions

SQL
CREATE VIEW shopify_examples.example_AssignedFulfillmentOrders AS
SELECT *
FROM (
CALL shopify.AssignedFulfillmentOrders (
location_ids => NULL,
assignment_status => NULL
)
) AS x;;

BalanceTransactions

Balance transactions
Parameter
<last_id> (optional): Filter response to transactions exclusively before the specified ID
<payout_id> (optional): Filter response to transactions paid out in the specified payout
<payout_status> (optional): Filter response to transactions with the specified payout status
<since_id> (optional): Filter response to transactions exclusively after the specified ID
<test> (optional): Filter response to transactions placed in test mode
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique identifier of the transaction

adjustment_reason

string

The reason for the adjustment that is associated with the transaction. If the source_type is not an adjustment, the value will be null

amount

bigdecimal

The gross amount of the transaction, in a decimal formatted string

currency

string

The ISO 4217 currency code of the transaction

fee

bigdecimal

The total amount of fees deducted from the transaction amount

net

bigdecimal

The net amount of the transaction

payout_id

long

The id of the payout the transaction was paid out in

payout_status

string

The status of the payout the transaction was paid out in, or 'pending' if the transaction has not yet been included in a payout

source_id

long

The id of the resource leading to the transaction

source_order_id

long

The id of the Order that this transaction ultimately originated from

source_order_transaction_id

string

The id of the Order Transaction that resulted in this balance transaction. If the source_type is an adjustment, the value will be null

source_type

string

The type of the resource leading to the transaction. charge refund dispute reserve adjustment payout

test

boolean

If the transaction was created for a test mode Order or payment

type

string

The type of the balance transaction. The value will be one of the following: charge refund dispute reserve adjustment credit debit payout payout_failure payout_cancellation

processed_at

timestamp

The time the transaction was processed

SQL
CREATE VIEW shopify_examples.example_BalanceTransactions AS
SELECT *
FROM (
CALL shopify.BalanceTransactions (
test => NULL,
since_id => NULL,
payout_status => NULL,
payout_id => NULL,
last_id => NULL
)
) AS x;;

BlogArticles

Articles from a blog
Parameter
<author> (optional): Filter articles by article author
<blog_id> (optional): Blog id
<created_at_max> (optional): Show articles created before date (format: 2014-04-25T16:15:47-04:00)
<created_at_min> (optional): Show articles created after date (format: 2014-04-25T16:15:47-04:00)
<handle> (optional): Retrieve an article with a specific handle
<published_at_max> (optional): Show articles published before date (format: 2014-04-25T16:15:47-04:00)
<published_at_min> (optional): Show articles published after date (format: 2014-04-25T16:15:47-04:00)
<published_status> (optional): Retrieve results based on their published status
<since_id> (optional): Restrict results to after the specified ID
<tag> (optional): Filter articles with a specific tag
<updated_at_max> (optional): Show articles last updated before date (format: 2014-04-25T16:15:47-04:00)
<updated_at_min> (optional): Show articles last updated after date (format: 2014-04-25T16:15:47-04:00)
<article_id> (optional): Article id
<blog_table> (optional): Table with blog containing column id(containing blog_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the article

title

string

The title of the article

author

string

The name of the author of the article

blog_id

long

The ID of the blog containing the article

body_html

string

The text of the body of the article, complete with HTML markup

handle

string

A human-friendly unique string for the article that's automatically generated from the article's title. The handle is used in the article's URL

image_alt

string

Image alt attribute

image_created_at

timestamp

The date and time when the product image was created. The API returns this value in ISO 8601 format

image_height

bigdecimal

Height dimension of the image which is determined on upload

image_src

string

Specifies the location of the product image. This parameter supports Liquid filters that you can use to retrieve modified copies of the image

image_width

bigdecimal

Width dimension of the image which is determined on upload

published_at

timestamp

The date and time ( ISO 8601 format) when the article was published

summary_html

string

A summary of the article, which can include HTML markup. The summary is used by the online store theme to display the article on other pages, such as the home page or the main blog page

tags

string

A comma-separated list of tags. Tags are additional short descriptors formatted as a string of comma-separated values

template_suffix

string

The name of the template an article is using if it's using an alternate template. If an article is using the default article.liquid template, then the value returned is null

user_id

long

A unique numeric identifier for the author of the article

created_at

timestamp

The date and time ( ISO 8601 format) when the article was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the article was last updated

SQL
CREATE VIEW shopify_examples.example_BlogArticles AS
SELECT *
FROM (
CALL shopify.BlogArticles (
since_id => NULL,
published_status => NULL,
published_at_min => NULL,
published_at_max => NULL,
handle => NULL,
created_at_min => NULL,
created_at_max => NULL,
blog_id => 8992030835,
author => NULL,
updated_at_min => NULL,
updated_at_max => NULL,
tag => NULL
)
) AS x;;

Blogs

Blogs
Parameter
<handle> (optional): Filter by blog handle
<since_id> (optional): Restrict results to after the specified ID
<blog_id> (optional): Blog id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

A unique numeric identifier for the blog

title

string

The title of the blog

commentable

string

Indicates whether readers can post comments to the blog and if comments are moderated or not. Possible values are: no (default) : Readers cannot post comments to blog articles. moderate : Readers can post comments to blog articles, but comments must be moderated before they appear. yes : Readers can post comments to blog articles without moderation

feedburner

string

FeedBurner is a web feed management provider and can be enabled to provide custom RSS feeds for Shopify bloggers. Google has stopped supporting FeedBurner, and new or existing blogs that are not already integrated with FeedBurner can't use the service. This property will default to blank unless FeedBurner is enabled

feedburner_location

string

The URL that points to the FeedBurner location for blogs that have FeedBurner enabled. Google has stopped supporting FeedBurner, and new or existing blogs that are not already integrated with FeedBurner can't use the service. This property will default to blank unless FeedBurner is enabled

handle

string

A human-friendly unique string that is automatically generated from the title if no handle is sent during the creation of a blog. Duplicate handles are appended with an incremental number, for example, 'blog-2'. The handle is customizable and is used by the Liquid templating language to refer to the blog. If you change the handle of a blog, then it can negatively affect the SEO of the shop. We recommend that you create a URL redirect to avoid any SEO issues

tags

string

A list of tags associated with the 200 most recent blog articles. Tags are additional short descriptors formatted as a string of comma-separated values. For example, if an article has three tags: tag1, tag2, tag3. Tags are limited to 255 characters

template_suffix

string

States the name of the template a blog is using if it is using an alternate template. If a blog is using the default blog.liquid template, the value returned is "null"

created_at

timestamp

The date and time when the blog was created. The API returns this value in ISO 8601 format

updated_at

timestamp

The date and time when changes were last made to the blog's properties. Note that this is not updated when creating, modifying or deleting articles in the blog. The API returns this value in ISO 8601 format

SQL
CREATE VIEW shopify_examples.example_Blogs AS
SELECT *
FROM (
CALL shopify.Blogs (
since_id => NULL,
handle => NULL
)
) AS x;;

CarrierServices

CarrierServices
Parameter
<carrier_service_id> (optional): Carrier service id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the carrier service

name

string

The name of the shipping service as seen by merchants and their customers

active

boolean

Whether this carrier service is active. If true , then the service will be available to serve rates in checkout

callback_url

string

The URL endpoint that Shopify needs to retrieve shipping rates. This must be a public URL

carrier_service_type

string

Distinguishes between API or legacy carrier services

format

string

The format of the data retu...

SQL
CREATE VIEW shopify_examples.example_CarrierServices AS
SELECT *
FROM (
CALL shopify.CarrierServices ()
) AS x;;

CollectionById

Single collection
Parameter
<collection_id> (optional): Collection id
<collections_table> (optional): Table with collections containing column id (containing collection_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the collection

title

string

The name of the collection

body_html

string

A description of the collection, complete with HTML markup. Many templates display this on their collection pages

collection_type

string

Collection type

handle

string

A unique, human-readable string for the collection automatically generated from its title. This is used in themes by the Liquid templating language to refer to the collection. (limit: 255 characters)

image_alt

string

The alternative text that describes the collection image

image_created_at

timestamp

The time and date ( format) when the image was added to the collection

image_height

bigdecimal

The height of the image in pixels

image_src

string

The source URL that specifies the location of the image

image_width

bigdecimal

The width of the image in pixels

products_count

integer

Products count

published_at

timestamp

The time and date ( ISO 8601 format) when the collection was made visible. Returns null for a hidden collection

published_scope

string

Whether the collection is published to the Point of Sale channel. Valid values: web : The collection is published to the Online Store channel but not published to the Point of Sale channel. global : The collection is published to both the Online Store channel and the Point of Sale channel

sort_order

string

The order in which products in the collection appear. Valid values: alpha-asc : Alphabetically, in ascending order (A - Z). alpha-desc : Alphabetically, in descending order (Z - A). best-selling : By best-selling products. created : By date created, in ascending order (oldest - newest). created-desc : By date created, in descending order (newest - oldest). manual : In the order set manually by the shop owner. price-asc : By price, in ascending order (lowest - highest). price-desc : By price, in descending order (highest - lowest)

template_suffix

string

The suffix of the liquid template being used. For example, if the value is custom , then the collection is using the collection.custom.liquid template. If the value is null , then the collection is using the default collection.liquid

updated_at

timestamp

The date and time ( ISO 8601 format) when the collection was last modified

SQL
CREATE VIEW shopify_examples.example_CollectionById AS
SELECT *
FROM (
CALL shopify.CollectionById (
collection_id => NULL
)
) AS x;;

Collects

Collects
Parameter
<since_id> (optional): Restrict results to after the specified ID
<collect_id> (optional): Collect id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

A unique numeric identifier for the collect

collection_id

long

The ID of the custom collection containing the product

position

integer

The position of this product in a manually sorted custom collection. The first position is 1. This value is applied only when the custom collection is sorted manually

product_id

long

The unique numeric identifier for the product in the custom collection

sort_value

long

This is the same value as position but padded with leading zeroes to make it alphanumeric-sortable. This value is applied only when the custom collection is sorted manually

created_at

timestamp

The date and time ( ISO 8601 format) when the collect was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the collect was last updated

SQL
CREATE VIEW shopify_examples.example_Collects AS
SELECT *
FROM (
CALL shopify.Collects (
since_id => NULL
)
) AS x;;

Comments

Comments
Parameter
<created_at_max> (optional): Show comments created before date (format: 2014-04-25T16:15:47-04:00)
<created_at_min> (optional): Show comments created after date (format: 2014-04-25T16:15:47-04:00)
<published_at_max> (optional): Show comments published before date (format: 2014-04-25T16:15:47-04:00)
<published_at_min> (optional): Show comments published after date (format: 2014-04-25T16:15:47-04:00)
<published_status> (optional): Filter results by their published status
<since_id> (optional): Restrict results to after the specified ID
<status> (optional): Filter results by their status
<updated_at_max> (optional): Show comments last updated before date (format: 2014-04-25T16:15:47-04:00)
<updated_at_min> (optional): Show comments last updated after date (format: 2014-04-25T16:15:47-04:00)
<comment_id> (optional): Comment id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

A unique numeric identifier for the comment

article_id

long

A unique numeric identifier for the article that the comment belongs to

author

string

The name of the author of the comment

blog_id

long

A unique numeric identifier for the blog containing the article that the comment belongs to

body

string

The basic Textile markup of a comment

body_html

string

The text of the comment, complete with HTML markup

email

string

The email address of the author of the comment

ip

string

The IP address from which the comment was posted

published_at

timestamp

The date and time ( ISO 8601 format) when the comment was published

status

string

The status of the comment. Valid values: pending : The comment has been created but is awaiting spam detection. Depending on the result of the spam detection and the shop owner's comment preferences, this property will be transitioned to either spam , unapproved , or approved . unapproved (default) : The comment is awaiting approval by the shop owner. It's not visible to the readers of the blog. published : The comment has been approved (if the blog requires comments to be approved) and is visible to readers of the blog. spam : The comment has been marked as spam and removed from the Shopify admin. It's not visible to readers of the blog. removed : The comment has been removed by the shop owner. It's not visible to readers of the blog

user_agent

string

The user agent string provided by the software used to create the comment (usually a browser)

created_at

timestamp

The date and time ( ISO 8601 format) when the comment was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the comment was last modified. When the comment is created, this matches the value of created_at . If the blog requires comments to be approved, then this value is updated to the date and time when the comment is approved

SQL
CREATE VIEW shopify_examples.example_Comments AS
SELECT *
FROM (
CALL shopify.Comments (
updated_at_min => NULL,
updated_at_max => NULL,
status => NULL,
since_id => NULL,
published_status => NULL,
published_at_min => NULL,
published_at_max => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

Countries

List of all Countries

Parameter
<since_id> (optional): Restrict results to after the specified ID
<country_id> (optional): Country id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the country. The ID for a country is unique across all Shopify stores. The ID for a country in one shop will be different from the same country in another shop

code

string

The two-letter country code (ISO 3166-1 alpha-2 format)

name

string

The full name of the country in English

tax

bigdecimal

The national sales tax rate applied to orders made by customers from that country

tax_name

string


SQL
CREATE VIEW shopify_examples.example_Countries AS
SELECT *
FROM (
CALL shopify.Countries (
since_id => NULL
)
) AS x;;

Currencies

List of currencies enabled on a shop

Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

currency

string

The three-letter code (ISO 4217 format) for the currency associated with this setting

enabled

boolean


rate_updated_at

timestamp

The date and time (ISO 8601 format) when the conversion rate associated with this currency was last updated. Conversion rates are checked every 15 minutes, but typically only updated a few times a day

SQL
CREATE VIEW shopify_examples.example_Currencies AS
SELECT *
FROM (
CALL shopify.Currencies ()
) AS x;;

CustomCollections

List of all CustomCollections

Parameter
<handle> (optional): Filter by custom collection handle
<ids> (optional): Show only collections specified by a comma-separated list of IDs
<product_id> (optional): Show custom collections that include a given product
<published_at_max> (optional): Show custom collections published before date
<published_at_min> (optional): Show custom collections published after date
<published_status> (optional): Show custom collectsion with a given published status (default: any): - published: Show only published custom collections; - unpublished - Show only unpublished custom collections; - any - Show custom collections of any published status
<since_id> (optional): Restrict results to after the specified ID
<title> (optional): Show custom collections with a given title
<updated_at_max> (optional): Show custom collections last updated before date
<updated_at_min> (optional): Show custom collections last updated after date
<custom_collection_id> (optional): Custom collection id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the custom collection

body_html

string

The description of the custom collection, complete with HTML markup. Many templates display this on their custom collection pages

handle

string

A human-friendly unique string for the custom collection automatically generated from its title. This is used in shop themes by the Liquid templating language to refer to the custom collection. (limit: 255 characters)

image_alt

string


image_created_at

timestamp

The date and time when the product image was created. The API returns this value in ISO 8601 format

image_height

integer

Height dimension of the image which is determined on upload

image_src

string

Specifies the location of the product image. This parameter supports URL filters that you can use to retrieve modified copies of the image. For example, add _small, to the filename to retrieve a scaled copy of the image at 100 x 100 px (for example, ipod-nano_small.png), or add _2048x2048 to retrieve a copy of the image constrained at 2048 x 2048 px resolution (for example, ipod-nano_2048x2048.png)

image_width

integer

Width dimension of the image which is determined on upload

published_at

timestamp

The time and date (ISO 8601 format) when the collection was made visible. Returns null for a hidden custom collection

published_scope

string

Whether the collection is published to the Point of Sale channel

sort_order

string

The order in which products in the custom collection appear

template_suffix

string

The suffix of the liquid template being used. For example, if the value is custom, then the collection is using the collection.custom.liquid template. If the value is null, then the collection is using the default collection.liquid

title

string

The name of the custom collection. (limit: 255 characters)

updated_at

timestamp

The date and time (ISO 8601 format) when the custom collection was last modified

SQL
CREATE VIEW shopify_examples.example_CustomCollections AS
SELECT *
FROM (
CALL shopify.CustomCollections (
updated_at_min => NULL,
updated_at_max => NULL,
title => NULL,
since_id => NULL,
published_status => NULL,
published_at_min => NULL,
published_at_max => NULL,
product_id => NULL,
ids => NULL,
handle => NULL
)
) AS x;;

CustomerAddresses

Addresses for a customer
Parameter
<customer_id> (optional): Customer id
<address_id> (optional): Address id
<customer_table> (optional): Table with customer containing column id(containing customer_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique identifier for the address

name

string

The customer's first and last names

address1

string

The customer's mailing address

address2

string

An additional field for the customer's mailing address

city

string

The customer's city, town, or village

company

string

The customer's company

country

string

The customer's country

country_code

string

The two-letter country code corresponding to the customer's country

country_name

string

The customer's normalized country name

customer_id

long

The unique identifier for the customer

default

boolean

Default

first_name

string

The customer's first name

last_name

string

The customer's last name

phone

string

The customer's phone number at this address

province

string

The customer's region name. Typically a province, a state, or a prefecture

province_code

string

The alphanumeric code for the customer's region

zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

SQL
CREATE VIEW shopify_examples.example_CustomerAddresses AS
SELECT *
FROM (
CALL shopify.CustomerAddresses (
customer_id => 7553192001792
)
) AS x;;

Customers

Customers
Parameter
<created_at_max> (optional): Show customers created before a specified date
<created_at_min> (optional): Show customers created after a specified date
<ids> (optional): Restrict results to customers specified by a comma-separated list of IDs
<since_id> (optional): Restrict results to those after the specified ID
<updated_at_max> (optional): Show customers last updated before a specified date
<updated_at_min> (optional): Show customers last updated after a specified date
<customer_id> (optional): Customer id
<query> (optional): Text to search for in the shop's customer data. Note: Supported queries: accepts_marketing , activation_date , address1 , address2 , city , company , country , customer_date , customer_first_name , customer_id , customer_last_name , customer_tag , email , email_marketing_state , first_name , first_order_date , id , last_abandoned_order_date , last_name , multipass_identifier , orders_count , order_date , phone , province , shop_id , state , tag , total_spent , updated_at , verified_email , product_subscriber_status . All other queries returns all customers
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

A unique identifier for the customer

currency

string

The three-letter code ( ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders

default_address_address1

string

The first line of the customer's mailing address

default_address_address2

string

An additional field for the customer's mailing address

default_address_city

string

The customer's city, town, or village

default_address_company

string

The customer's company

default_address_country

string

The customer's country

default_address_country_code

string

The two-letter country code corresponding to the customer's country

default_address_country_name

string

The customer's normalized country name

default_address_default

boolean

Returns true for each default address

default_address_first_name

string

The customer's first name

default_address_id

long

A unique identifier for the address

default_address_last_name

string

The customer's last name

default_address_name

string

Default address name

default_address_phone

string

The customer's phone number at this address

default_address_province

string

The customer's region name. Typically a province, a state, or a prefecture

default_address_province_code

string

The alphanumeric code for the customer's region

default_address_zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

email

string

The unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error

email_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is used

email_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by email

email_marketing_consent_state

string

The current email marketing state for the customer

first_name

string

The customer's first name

last_name

string

The customer's last name

last_order_id

long

The ID of the customer's last order

last_order_name

string

The name of the customer's last order. This is directly related to the name field on the Order resource

multipass_identifier

string

A unique identifier for the customer that's used with Multipass login

note

string

A note about the customer

orders_count

integer

The number of orders associated with this customer. Test and archived orders aren't counted

phone

string

The unique phone number (<a href="https://en.wikipedia.org/wiki/E.164">E.164 format ) for this customer. Attempting to assign the same phone number to multiple customers returns an error. The property can be set using different formats, but each format must represent a number that can be dialed from anywhere in the world. The following formats are all valid: 6135551212 +16135551212 (613)555-1212 +1 613-555-1212

sms_marketing_consent_consent_collected_from

string

The source for whether the customer has consented to receive marketing material by SMS

sms_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by SMS. If no date is provided, then the date and time when the consent information was sent is used

sms_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by SMS

sms_marketing_consent_state

string

The current SMS marketing state for the customer

state

string

The state of the customer's account with a shop. Default value: disabled . Valid values: disabled : The customer doesn't have an active account. Customer accounts can be disabled from the Shopify admin at any time. invited : The customer has received an email invite to create an account. enabled : The customer has created an account. declined : The customer declined the email invite to create an account

tags

string

Tags that the shop owner has attached to the customer, formatted as a string of comma-separated values. A customer can have up to 250 tags. Each tag can have up to 255 characters

tax_exempt

boolean

Whether the customer is exempt from paying taxes on their order. If true , then taxes won't be applied to an order at checkout. If false , then taxes will be applied at checkout

total_spent

bigdecimal

The total amount of money that the customer has spent across their order history

verified_email

boolean

Whether the customer has verified their email address

created_at

timestamp

The date and time ( ISO 8601 format) when the customer was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the customer information was last updated

SQL
CREATE VIEW shopify_examples.example_Customers AS
SELECT *
FROM (
CALL shopify.Customers (
updated_at_min => NULL,
updated_at_max => NULL,
since_id => NULL,
ids => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

DeprecatedAPIcalls

Deprecated API calls
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

api_type

string

API type

description

string

Description

documentation_url

string

Documentation URL

endpoint

string

Endpoint

graphql_schema_name

string

GraphQL schema name

last_call_at

timestamp

Last call at

migration_deadline

timestamp

Migration deadline

version

string

Version

SQL
CREATE VIEW shopify_examples.example_DeprecatedAPIcalls AS
SELECT *
FROM (
CALL shopify.DeprecatedAPIcalls ()
) AS x;;

DiscountCodes

Discount codes
Parameter
<price_rule_id> (optional): Price rule id
<discount_code_id> (optional): Discount code id
<price_rule_table> (optional): Table with price_rule containing column id(containing price_rule_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the discount code

code

string

The case-insensitive discount code that customers use at checkout. (maximum: 255 characters) Use the same value for code as the title property of the associated price rule

price_rule_id

long

The ID for the price rule that this discount code belongs to

usage_count

integer

The number of times that the discount code has been redeemed

created_at

timestamp

The date and time ( ISO 8601 format) when the discount code was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the discount code was updated

SQL
CREATE VIEW shopify_examples.example_DiscountCodes AS
SELECT *
FROM (
CALL shopify.DiscountCodes (
price_rule_id => 1471906382080
)
) AS x;

Disputes

List of all disputes

Parameter
<initiated_at> (optional): Return only disputes with the specified initiated_at date
<last_id> (optional): Return only disputes before the specified ID
<since_id> (optional): Return only disputes after the specified ID
<status> (optional): Return only disputes with the specified status
<dispute_id> (optional): Dispute id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the dispute

amount

bigdecimal

The total amount disputed by the cardholder

currency

string

The ISO 4217 currency code of the dispute amount

evidence_due_by

timestamp

The deadline for evidence submission

evidence_sent_on

timestamp

"The date and time (ISO 8601 format) when evidence was sent. Returns null if evidence has not yet been sent

finalized_on

timestamp

The date and time (ISO 8601 format) when this dispute was resolved. Returns null if the dispute is not yet resolved

initiated_at

timestamp


network_reason_code

long

The reason for the dispute provided by the cardholder's bank

order_id

long

The ID of the order that the dispute belongs to

reason

string

The reason of the dispute provided by the cardholder's bank

status

string

The current state of the dispute

type

string

Whether the dispute is still in the inquiry phase or has turned into a chargeback

SQL
CREATE VIEW shopify_examples.example_Disputes AS
SELECT *
FROM (
CALL shopify.Disputes (
status => NULL,
since_id => NULL,
last_id => NULL,
initiated_at => NULL
)
) AS x;;

DraftOrders

Draft orders
Parameter
<ids> (optional): Filter by list of IDs
<since_id> (optional): Restrict results to after the specified ID
<status> (optional): Filter draft orders by their status
<updated_at_max> (optional): Show orders last updated before date (format: 2014-04-25T16:15:47-04:00)
<updated_at_min> (optional): Show orders last updated after date (format: 2014-04-25T16:15:47-04:00)
<draft_order_id> (optional): Draft order id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the draft order

name

string

Name of the draft order

applied_discount_amount

bigdecimal

The applied amount of the discount, based on the setting of value_type. For more information, see

applied_discount_description

string

Reason for the discount

applied_discount_title

string

Title of the discount

applied_discount_value

bigdecimal

The value of the discount. If the type of discount is fixed_amount, then it corresponds to a fixed dollar amount. If the type is percentage, then it corresponds to percentage

applied_discount_value_type

string

The type of discount. Valid values: percentage, fixed_amount

billing_address_address1

string

The street address of the billing address

billing_address_address2

string

An optional additional field for the street address of the billing address

billing_address_city

string

The customer's city, town, or village

billing_address_company

string

The customer's company

billing_address_country

string

The name of the country of the billing address

billing_address_country_code

string

The two-letter country code corresponding to the customer's country

billing_address_first_name

string

The first name of the person associated with the payment method

billing_address_last_name

string

The last name of the person associated with the payment method

billing_address_latitude

bigdecimal

The latitude of the billing address

billing_address_longitude

bigdecimal

The longitude of the billing address

billing_address_name

string

The full name of the person associated with the payment method

billing_address_phone

string

The phone number at the billing address

billing_address_province

string

The name of the billing address region, such as province, state, or prefecture

billing_address_province_code

string

The alphanumeric abbreviation of the region for the billing address

billing_address_zip

string

The postal code of the billing address, such as zip, postcode, or Eircode

completed_at

timestamp

The date and time ( ISO 8601 format) when the order is created and the draft order is completed

currency

string

The three letter code ( ISO 4217 format) for the currency used for the payment

customer_created_at

timestamp

The date and time ( ISO 8601 format) when the customer was created

customer_currency

string

The three-letter code ( ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders

customer_default_address_address1

string

The first line of the customer's mailing address

customer_default_address_address2

string

An additional field for the customer's mailing address

customer_default_address_city

string

The customer's city, town, or village

customer_default_address_company

string

The customer's company

customer_default_address_country

string

The customer's country

customer_default_address_country_code

string

The two-letter country code corresponding to the customer's country

customer_default_address_country_name

string

The customer's normalized country name

customer_default_address_customer_id

long

Customer default address customer id

customer_default_address_default

boolean

Returns true for each default address

customer_default_address_first_name

string

The customer's first name

customer_default_address_id

long

A unique identifier for the address

customer_default_address_last_name

string

The customer's last name

customer_default_address_name

string

Customer default address name

customer_default_address_phone

string

The customer's phone number at this address

customer_default_address_province

string

The customer's region name. Typically a province, a state, or a prefecture

customer_default_address_province_code

string

The alphanumeric code for the customer's region

customer_default_address_zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

customer_email

string

The unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error

customer_email_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is used

customer_email_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by email

customer_email_marketing_consent_state

string

The current email marketing state for the customer

customer_first_name

string

The customer's first name

customer_id

long

Customer id

customer_last_name

string

The customer's last name

customer_last_order_id

long

The ID of the customer's last order

customer_last_order_name

string

The name of the customer's last order. This is directly related to the name field on the Order resource

customer_multipass_identifier

string

A unique identifier for the customer that's used with Multipass login

customer_note

string

A note about the customer

customer_orders_count

integer

The number of orders associated with this customer. Test and archived orders aren't counted

customer_phone

string

The unique phone number (<a href="https://en.wikipedia.org/wiki/E.164">E.164 format ) for this customer. Attempting to assign the same phone number to multiple customers returns an error. The property can be set using different formats, but each format must represent a number that can be dialed from anywhere in the world. The following formats are all valid: 6135551212 +16135551212 (613)555-1212 +1 613-555-1212

customer_sms_marketing_consent_consent_collected_from

string

The source for whether the customer has consented to receive marketing material by SMS

customer_sms_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by SMS. If no date is provided, then the date and time when the consent information was sent is used

customer_sms_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by SMS

customer_sms_marketing_consent_state

string

The current SMS marketing state for the customer

customer_state

string

The state of the customer's account with a shop. Default value: disabled . Valid values: disabled : The customer doesn't have an active account. Customer accounts can be disabled from the Shopify admin at any time. invited : The customer has received an email invite to create an account. enabled : The customer has created an account. declined : The customer declined the email invite to create an account

customer_tags

string

Tags that the shop owner has attached to the customer, formatted as a string of comma-separated values. A customer can have up to 250 tags. Each tag can have up to 255 characters

customer_tax_exempt

boolean

Whether the customer is exempt from paying taxes on their order. If true , then taxes won't be applied to an order at checkout. If false , then taxes will be applied at checkout

customer_total_spent

bigdecimal

The total amount of money that the customer has spent across their order history

customer_updated_at

timestamp

The date and time ( ISO 8601 format) when the customer information was last updated

customer_verified_email

boolean

Whether the customer has verified their email address

email

string

The customer's email address

invoice_sent_at

timestamp

The date and time ( ISO 8601 format) when the invoice was emailed to the customer

invoice_url

string

The URL for the invoice

note

string

The text of an optional note that a merchant can attach to the draft order

note_attributes

string

The extra information that's added to the order. The information appears in the Additional details section of an order details page. Each array entry must contain a hash with name and value keys

order_id

long

The ID of the order that's created and associated with the draft order after the draft order is completed

payment_terms

string

The terms and conditions under which a payment should be processed. amount : The amount that is owed according to the payment terms. currency : The presentment currency for the payment. payment_terms_name : The name of the selected payment terms template for the draft order. payment_terms_type : The type of selected payment terms template for the draft order. due_in_days : The number of days between the invoice date and due date that is defined in the selected payment terms template. payment_schedules : An array of schedules associated to the payment terms. amount : The amount that is owed according to the payment terms. currency : The presentment currency for the payment. issued_at : The date and time when the payment terms were initiated. due_at : The date and time when the payment is due. Calculated based on issued_at and due_in_days or a customized fixed date if the type is fixed. completed_at : The date and time when the purchase is completed. Returns null initially and updates when the payment is captured. expected_payment_method : The name of the payment method gateway

presentment_currency

string

The three letter code ( ISO 4217 format) for the currency used for the payment

shipping_address_address1

string

The street address of the shipping address

shipping_address_address2

string

An optional additional field for the street address of the shipping address

shipping_address_city

string

The city of the shipping address

shipping_address_company

string

The company of the person associated with the shipping address

shipping_address_country

string

The name of the country of the shipping address

shipping_address_country_code

string

The two-letter code for the country of the shipping address

shipping_address_first_name

string

The first name of the person associated with the payment method

shipping_address_last_name

string

The last name of the person associated with the payment method

shipping_address_latitude

bigdecimal

The latitude of the shipping address

shipping_address_longitude

bigdecimal

The longitude of the shipping address

shipping_address_name

string

The full name of the person associated with the payment method

shipping_address_phone

string

The phone number at the shipping address

shipping_address_province

string

The name of the state or province of the shipping address

shipping_address_province_code

string

The alphanumeric abbreviation of the state or province of the shipping address

shipping_address_zip

string

The zip or postal code of the shipping address

shipping_line_custom

boolean

Whether this is a regular shipping line or custom shipping line

shipping_line_handle

string

The handle of the shipping rate which was selected and applied. Required for regular shipping lines

shipping_line_price

bigdecimal

The price of the shipping method. Required for custom shipping lines

shipping_line_title

string

The title of the shipping method. Required for custom shipping lines. (maximum: 255 characters)

status

string

The status of a draft order as it transitions into an order. When a draft order is created it is set to open status. The invoice can then be sent to the customer, and status changes to invoice_sent . The draft order can then be paid, set to pending, or paid by credit card. In each case, the draft order is set to completed and an order is created. After a draft order is set to completed the only further modifications that can be made are adding tags or metafields. Valid values: open : Draft order is open. invoice_sent : Invoice has been sent for the draft order. completed : Draft order has been completed and turned into an order

subtotal_price

bigdecimal

The price of the order before shipping and taxes

subtotal_price_set_presentment_money_amount

bigdecimal

The price of the order before shipping and taxes. Presentment Money Amount

subtotal_price_set_presentment_money_currency_code

string

The price of the order before shipping and taxes. Presentment Money Currency code

subtotal_price_set_shop_money_amount

bigdecimal

The price of the order before shipping and taxes. Shop money Amount

subtotal_price_set_shop_money_currency_code

string

The price of the order before shipping and taxes. Shop money Currency code

tags

string

A comma-seperated list of additional short descriptors, commonly used for filtering and searching. Each individual tag is limited to 40 characters in length. For example, tags: "tag1","tag2","tag3"

tax_exempt

boolean

Whether taxes are exempt for the draft order. If set to false , then Shopify refers to the taxable field for each line_item . If a customer is applied to the draft order, then Shopify uses the customer's tax_exempt field instead

taxes_included

boolean

Whether taxes are included in the order subtotal. Valid values: true or false

total_additional_fees_set_presentment_money_amount

bigdecimal

Total additional fees. Presentment Money Amount

total_additional_fees_set_presentment_money_currency_code

string

Total additional fees. Presentment Money Currency code

total_additional_fees_set_shop_money_amount

bigdecimal

Total additional fees. Shop money Amount

total_additional_fees_set_shop_money_currency_code

string

Total additional fees. Shop money Currency code

total_discounts_set_presentment_money_amount

bigdecimal

Total discounts. Presentment Money Amount

total_discounts_set_presentment_money_currency_code

string

Total discounts. Presentment Money Currency code

total_discounts_set_shop_money_amount

bigdecimal

Total discounts. Shop money Amount

total_discounts_set_shop_money_currency_code

string

Total discounts. Shop money Currency code

total_duties_set_presentment_money_amount

bigdecimal

Total duties. Presentment Money Amount

total_duties_set_presentment_money_currency_code

string

Total duties. Presentment Money Currency code

total_duties_set_shop_money_amount

bigdecimal

Total duties. Shop money Amount

total_duties_set_shop_money_currency_code

string

Total duties. Shop money Currency code

total_line_items_price_set_presentment_money_amount

bigdecimal

Total line items price. Presentment Money Amount

total_line_items_price_set_presentment_money_currency_code

string

Total line items price. Presentment Money Currency code

total_line_items_price_set_shop_money_amount

bigdecimal

Total line items price. Shop money Amount

total_line_items_price_set_shop_money_currency_code

string

Total line items price. Shop money Currency code

total_price

bigdecimal

The sum of all the prices of all the items in the order, including taxes and discounts

total_price_set_presentment_money_amount

bigdecimal

The sum of all the prices of all the items in the order, including taxes and discounts. Presentment Money Amount

total_price_set_presentment_money_currency_code

string

The sum of all the prices of all the items in the order, including taxes and discounts. Presentment Money Currency code

total_price_set_shop_money_amount

bigdecimal

The sum of all the prices of all the items in the order, including taxes and discounts. Shop money Amount

total_price_set_shop_money_currency_code

string

The sum of all the prices of all the items in the order, including taxes and discounts. Shop money Currency code

total_shipping_price_set_presentment_money_amount

bigdecimal

Total shipping price. Presentment Money Amount

total_shipping_price_set_presentment_money_currency_code

string

Total shipping price. Presentment Money Currency code

total_shipping_price_set_shop_money_amount

bigdecimal

Total shipping price. Shop money Amount

total_shipping_price_set_shop_money_currency_code

string

Total shipping price. Shop money Currency code

total_tax

bigdecimal

The sum of all the taxes applied to the order

total_tax_set_presentment_money_amount

bigdecimal

The sum of all the taxes applied to the order. Presentment Money Amount

total_tax_set_presentment_money_currency_code

string

The sum of all the taxes applied to the order. Presentment Money Currency code

total_tax_set_shop_money_amount

bigdecimal

The sum of all the taxes applied to the order. Shop money Amount

total_tax_set_shop_money_currency_code

string

The sum of all the taxes applied to the order. Shop money Currency code

created_at

timestamp

The date and time ( ISO 8601 format) when the order was created in Shopify

updated_at

timestamp

The date and time ( ISO 8601 format) when the order was last modified

SQL
CREATE VIEW shopify_examples.example_DraftOrders AS
SELECT *
FROM (
CALL shopify.DraftOrders (
updated_at_min => NULL,
updated_at_max => NULL,
status => NULL,
since_id => NULL,
ids => NULL
)
) AS x;;

Events

List of events

Parameter
<filter> (optional): Show events specified in this filter
<created_at_max> (optional): Show events created at or before this date and time
<created_at_min> (optional): Show events created at or after this date and time
<since_id> (optional): Show only results after the specified ID
<verb> (optional): Show events of a certain type
<event_id> (optional): Event id
<order_id> (optional): Find Events by Order id
<product_id> (optional): Find Events by Product id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the event

arguments

string

Refers to a certain event and its resources

author

string


body

string

A text field containing information about the event

description

string

A human readable description of the event

message

string

A human readable description of the event. Can contain some HTML formatting

path

string

A relative URL to the resource the event is for, if applicable

subject_id

long

The ID of the resource that generated the event

subject_type

string

The type of the resource that generated the event

verb

string

The type of event that occurred. Different resources generate different types of event. See the Resources section for a list of possible verbs

created_at

timestamp

The date and time (ISO 8601 format) when the event was created

SQL
CREATE VIEW shopify_examples.example_Events AS
SELECT *
FROM (
CALL shopify.Events (
verb => NULL,
since_id => NULL,
"filter" => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

FulfillmentEvents

Fulfillment events for a specific fulfillment
Parameter
<fulfillment_id> (optional): The ID of the fulfillment that's associated with the fulfillment event
<order_id> (optional): The ID of the order that's associated with the fulfillment event
<event_id> (optional): The ID of the fulfillment event
<fulfillment_table> (optional): Table with fulfillment containing column id(containing fulfillment_id) of type long, order_id of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

An ID for the fulfillment event

address1

string

The street address where the fulfillment event occurred

address2

string

An optional additional field for the street address of the billing address

city

string

The city where the fulfillment event occurred

country

string

The country where the fulfillment event occurred

estimated_delivery_at

timestamp

The estimated delivery date based on the fulfillment's tracking number, as long as it's provided by one of the following carriers: USPS, FedEx, UPS, or Canada Post (Canada only). Value is null if no tracking number is available or if the tracking number is from an unsupported carrier. This property is available only when carrier calculated rates are in use.'

fulfillment_id

long

An ID for the fulfillment that's associated with the fulfillment event

happened_at

timestamp

The date and time ( ISO 8601 format) when the fulfillment event occurred

latitude

bigdecimal

A geographic coordinate specifying the latitude of the fulfillment event

longitude

bigdecimal

A geographic coordinate specifying the longitude of the fulfillment event

message

string

An arbitrary message describing the status. Can be provided by a shipping carrier

order_id

long

The ID of the order that's associated with the fulfillment event

province

string

The province where the fulfillment event occurred

shop_id

long

An ID for the shop that's associated with the fulfillment event

status

string

The status of the fulfillment event. Valid values: attempted_delivery : Delivery of the shipment was attempted, but unable to be completed. carrier_picked_up : A carrier picked up the shipment. confirmed : The carrier is aware of the shipment, but hasn't received it yet. delayed : The shipment is delayed. delivered : The shipment was successfully delivered. failure : Something went wrong when pulling tracking information for the shipment. For example, the tracking number was invalid or the shipment was canceled. in_transit : The shipment is being transported between shipping facilities on the way to its destination. label_printed : A label for the shipment was purchased and printed. label_purchased : A label for the shipment was purchased, but not printed. out_for_delivery : The shipment is being delivered to its final destination. picked_up : The shipment was successfully picked up. ready_for_pickup : The shipment is ready for pickup

zip

string

The zip code of the location where the fulfillment event occurred

created_at

timestamp

The date and time ( ISO 8601 format) when the fulfillment event was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the fulfillment event was updated

SQL
CREATE VIEW shopify_examples.example_FulfillmentEvents AS
SELECT *
FROM (
CALL shopify.FulfillmentEvents (
order_id => 5751369924864,
fulfillment_id => NULL
)
) AS x;;

FulfillmentOrders

Fulfillment orders for a specific order
Parameter
<include_financial_summaries> (optional): Include the financial summary data for each line item, if available
<include_order_reference_fields> (optional): Indicates whether the order reference fields should be returned in the result
<order_id> (optional): The ID of the order that is associated with the fulfillment orders
<fulfillment_order_id> (optional): Fulfillment order id
<order_table> (optional): Table with order containing column id(containing order_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

An ID for the fulfillment order

assigned_location_address1

string

The customer's mailing address

assigned_location_address2

string

An additional field for the customer's mailing address

assigned_location_city

string

The customer's city, town, or village

assigned_location_country_code

string

The two-letter country code corresponding to the customer's country

assigned_location_id

long

The unique identifier for the address

assigned_location_location_id

long

Location id

assigned_location_name

string

The customer's first and last names

assigned_location_phone

string

The customer's phone number at this address

assigned_location_province

string

The customer's region name. Typically a province, a state, or a prefecture

assigned_location_zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

channel_id

long

Channel id

delivery_method

string

Delivery method

destination_address1

string

The street address of the assigned location

destination_address2

string

An optional additional field for the street address of the assigned location

destination_city

string

The city of the destination

destination_company

string

The company of the destination

destination_country

string

The country of the destination

destination_email

string

The email of the customer at the destination

destination_first_name

string

The first name of the customer at the destination

destination_id

long

The ID of the fulfillment order destination

destination_last_name

string

The last name of the customer at the destination

destination_phone

string

The phone number of the customer at the destination

destination_province

string

The province of the destination

destination_zip

string

The ZIP code of the destination

fulfill_at

timestamp

The date and time at which the fulfillment order will be fulfillable. When this date and time is reached, a scheduled fulfillment order is automatically transitioned to open . For example, the fulfill_at date for a subscription order might be the 1st of each month, a pre-order fulfill_at date would be nil , and a standard order fulfill_at date would be the order creation date. For more information about fulfillment statuses, refer to the status property

fulfill_by

string

The latest date and time by which all items in the fulfillment order need to be fulfilled

international_duties_incoterm

string

The method of duties payment. Valid values:

order_id

long

The ID of the order that's associated with the fulfillment order

order_name

string

Order name

order_processed_at

timestamp

The date and time (ISO 8601 format) when the order was processed

request_status

string

The request status of the fulfillment order. Valid values: unsubmitted : The initial request status for newly-created fulfillment orders. This is the only valid request status for fulfillment orders that aren't assigned to a fulfillment service. submitted : The merchant requested fulfillment for this fulfillment order. accepted : The fulfillment service accepted the merchant's fulfillment request. rejected : The fulfillment service rejected the merchant's fulfillment request. cancellation_requested : The merchant requested a cancellation of the fulfillment request for this fulfillment order. cancellation_accepted : The fulfillment service accepted the merchant's fulfillment cancellation request. cancellation_rejected : The fulfillment service rejected the merchant's fulfillment cancellation request. closed : The fulfillment service closed the fulfillment order without completing it

shop_id

long

The ID of the shop that's associated with the fulfillment order

status

string

The status of the fulfillment order. Valid values: open : The fulfillment order is ready for fulfillment. in_progress : The fulfillment order is being processed. scheduled : The fulfillment order is deferred and will be ready for fulfillment after the datetime specified in fulfill_at . cancelled : The fulfillment order has been cancelled by the merchant. on_hold : The fulfillment order is on hold. The fulfillment process can't be initiated until the hold on the fulfillment order is released. incomplete : The fulfillment order cannot be completed as requested. closed : The fulfillment order has been completed and closed

supported_actions

string

The actions that can be performed on this fulfillment order

created_at

timestamp

The date and time ( ISO 8601 format) when the fulfillment order was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the fulfillment order was last updated

SQL
CREATE VIEW shopify_examples.example_FulfillmentOrders AS
SELECT *
FROM (
CALL shopify.FulfillmentOrders (
order_id => NULL,
include_order_reference_fields => NULL,
include_financial_summaries => NULL
)
) AS x;;

FulfillmentServices

FulfillmentServices
Parameter
<scope> (optional): Specify which fulfillment services to retrieve
<fulfillment_service_id> (optional): Fulfillment service id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique identifier of the location associated with the fulfillment service

name

string

The name of the fulfillment service as seen by merchants

callback_url

string

The callback URL that the fulfillment service has registered for requests. The following considerations apply: Shopify queries the callback_url/fetch_tracking_numbers endpoint to retrieve tracking numbers for orders, if tracking_support is set to true . Shopify queries the callback_url/fetch_stock endpoint to retrieve inventory levels, if inventory_management is set to true . Shopify uses the callback_url/fulfillment_order_notification endpoint to send fulfillment and cancellation requests if the fulfillment service has opted in to the fulfillment order based workflow for managing fulfillments ( fulfillment_orders_opt_in is set to true ). The callback_url field is required if inventory_management , tracking_support , or fulfillment_orders_opt_in is set to true

email

string

Email

fulfillment_orders_opt_in

boolean

Whether the fulfillment service uses the fulfillment order based workflow for managing fulfillments. As of 2022-07 API version , the fulfillment order based workflow is the only way to manage fulfillments, and fulfillment_orders_opt_in must be set to true . As the migration is now finished, the fulfillment_orders_opt_in property is deprecated and is always set to true on correctly functioning fulfillment services

handle

string

Human-readable unique identifier for this fulfillment service

include_pending_stock

boolean

Include pending stock

inventory_management

boolean

Whether the fulfillment service tracks product inventory and provides updates to Shopify. Valid values: true and false

location_id

long

The unique identifier of the location associated with the fulfillment service

provider_id

long

A unique identifier for the fulfillment service provider

service_name

string

Service name

tracking_support

boolean

Whether the fulfillment service provides tracking numbers for packages. Valid values: true and false

SQL
CREATE VIEW shopify_examples.example_FulfillmentServices AS
SELECT *
FROM (
CALL shopify.FulfillmentServices (
scope => NULL
)
) AS x;;

Fulfillments

Fulfillments associated with an order
Parameter
<created_at_max> (optional): Show fulfillments created before date (format: 2014-04-25T16:15:47-04:00)
<created_at_min> (optional): Show fulfillments created after date (format: 2014-04-25T16:15:47-04:00)
<order_id> (optional): Order id
<since_id> (optional): Restrict results to after the specified ID
<updated_at_max> (optional): Show fulfillments last updated before date (format: 2014-04-25T16:15:47-04:00)
<updated_at_min> (optional): Show fulfillments last updated after date (format: 2014-04-25T16:15:47-04:00)
<fulfillment_order_id> (optional): The ID of the fulfillment order that is associated with the fulfillments
<fulfillment_id> (optional): Fulfillment id
<order_table> (optional): Table with order containing column id(containing order_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the fulfillment

name

string

The uniquely identifying fulfillment name, consisting of two parts separated by a . . The first part represents the order name and the second part represents the fulfillment number. The fulfillment number automatically increments depending on how many fulfillments are in an order (e.g. #1001.1 , #1001.2 )

location_id

long

The unique identifier of the location that the fulfillment was processed at. To find the ID of the location, use the Location resource

order_id

long

The unique numeric identifier for the order

origin_address_address1

string

(string) The street address of the fulfillment location

origin_address_address2

string

(string) The second line of the address. Typically the number of the apartment, suite, or unit

origin_address_city

string

(string) The city of the fulfillment location

origin_address_country_code

string

(string) (required) The two-letter country code ( format) of the fulfillment location

origin_address_province_code

string

(string) The province of the fulfillment location

origin_address_zip

string

(string) The zip code of the fulfillment location

receipt_authorization

long

The authorization code

receipt_testcase

boolean

Whether the fulfillment was a testcase

service

string

The fulfillment service associated with the fulfillment

shipment_status

string

The current shipment status of the fulfillment. Valid values: label_printed : A label for the shipment was purchased and printed. label_purchased : A label for the shipment was purchased, but not printed. attempted_delivery : Delivery of the shipment was attempted, but unable to be completed. ready_for_pickup : The shipment is ready for pickup at a shipping depot. confirmed : The carrier is aware of the shipment, but hasn't received it yet. in_transit : The shipment is being transported between shipping facilities on the way to its destination. out_for_delivery : The shipment is being delivered to its final destination. delivered : The shipment was succesfully delivered. failure : Something went wrong when pulling tracking information for the shipment, such as the tracking number was invalid or the shipment was canceled

status

string

The status of the fulfillment. Valid values: pending : Shopify has created the fulfillment and is waiting for the third-party fulfillment service to transition it to 'open' or 'success'. open : The fulfillment has been acknowledged by the service and is in processing. success : The fulfillment was successful. cancelled : The fulfillment was cancelled. error : There was an error with the fulfillment request. failure : The fulfillment request failed

tracking_company

string

The name of the tracking company. For the tracking company names from the list below Shopify automatically builds tracking URLs for all of the provided tracking numbers, which makes the tracking numbers clickable in the interface. Additionally, for the tracking companies listed on the Shipping Carriers help page Shopify will automatically update the fulfillment's shipment_status field during the fulfillment process. Note Send the tracking company name exactly as written in the list below (capitalization matters). Supported tracking companies The following tracking companies display for shops located in any country: 4PX AGS Amazon Logistics UK Amazon Logistics US An Post Anjun Logistics APC Asendia USA Australia Post Bonshaw BPost BPost International Canada Post Canpar CDL Last Mile China Post Chronopost Chukou1 Colissimo Comingle Coordinadora Correios Correos CTT CTT Express Cyprus Post Delnext Deutsche Post DHL eCommerce DHL eCommerce Asia DHL Express DPD DPD Local DPD UK DTD Express DX Eagle Estes Evri FedEx First Global Logistics First Line FSC Fulfilla GLS Guangdong Weisuyi Information Technology (WSE) Heppner Internationale Spedition GmbH & Co. Iceland Post IDEX Israel Post Japan Post (EN) Japan Post (JA) La Poste Lasership Latvia Post Lietuvos Paštas Logisters Lone Star Overnight M3 Logistics Meteor Space Mondial Relay New Zealand Post NinjaVan North Russia Supply Chain (Shenzhen) Co. OnTrac Packeta Pago Logistics Ping An Da Tengfei Express Pitney Bowes Portal PostNord Poste Italiane PostNL PostNord DK PostNord NO PostNord SE Purolator Qxpress Qyun Express Royal Mail Royal Shipments Sagawa (EN) Sagawa (JA) Sendle SF Express SFC Fulfillment SHREE NANDAN COURIER Singapore Post Southwest Air Cargo StarTrack Step Forward Freight Swiss Post TForce Final Mile Tinghao TNT Toll IPEC United Delivery Service UPS USPS Venipak We Post Whistl Wizmo WMYC Xpedigo XPO Logistics Yamato (EN) Yamato (JA) YiFan Express YunExpress The following tracking companies are displayed for shops located in specific countries: Australia : Australia Post, Sendle, Aramex Australia, TNT Australia, Hunter Express, Couriers Please, Bonds, Allied Express, Direct Couriers, Northline, GO Logistics Austria : Österreichische Post Bulgaria : Speedy Canada : Intelcom, BoxKnight, Loomis, GLS China : China Post, DHL eCommerce Asia, WanbExpress, YunExpress, Anjun Logistics, SFC Fulfillment, FSC Czechia : Zásilkovna Germany : Deutsche Post (DE), Deutsche Post (EN), DHL, DHL Express, Swiship, Hermes, GLS Spain : SEUR France : Colissimo, Mondial Relay, Colis Privé, GLS United Kingdom : Evri, DPD UK, Parcelforce, Yodel, DHL Parcel, Tuffnells Greece : ACS Courier Hong Kong SAR : SF Express Ireland : Fastway, DPD Ireland India : DTDC, India Post, Delhivery, Gati KWE, Professional Couriers, XpressBees, Ecom Express, Ekart, Shadowfax, Bluedart Italy : BRT, GLS Italy Japan : エコ配, 西濃運輸, 西濃スーパーエキスプレス, 福山通運, 日本通運, 名鉄運輸, 第一貨物 Netherlands : DHL Parcel, DPD Norway : Bring Poland : Inpost Turkey : PTT, Yurtiçi Kargo, Aras Kargo, Sürat Kargo United States : GLS, Alliance Air Freight, Pilot Freight, LSO, Old Dominion, R+L Carriers, Southwest Air Cargo South Africa : Fastway, Skynet

tracking_number

string

A tracking number provided by the shipping company. If multiple tracking numbers are set on this fulfillment, only the first one will be returned in the tracking_number field. Use the tracking_numbers array field to access all tracking numbers associated with this fulfillment. Note With the REST API, you can set only one tracking number and one tracking URL per fulfillment. If you send multiple shipments with one fulfillment, you may want to specify tracking numbers and tracking URLs for all of them. You can do it with the equivalent GraphQL FulfillmentCreateV2 and fulfillmentTrackingInfoUpdateV2 mutations

tracking_numbers

string

A list of tracking numbers provided by the shipping company. Note With the REST API, you can set only one tracking number and one tracking URL per fulfillment. If you send multiple shipments with one fulfillment, you may want to specify tracking numbers and tracking URLs for all of them. You can do it with the equivalent GraphQL FulfillmentCreateV2 and fulfillmentTrackingInfoUpdateV2 mutations. The tracking numbers are clickable in the interface if one of the following applies (the highest in the list has the highest priority): Tracking URL provided in the url field. Shopify-known tracking company name specified in the company field. Shopify will build the tracking url automatically based on the tracking number specified. The tracking number has a Shopify-known format. Shopify will guess the tracking provider and build the tracking url based on the tracking number format. Not all tracking carriers are supported, and multiple tracking carriers may use similarly formatted tracking numbers. This can result in an invalid tracking URL. It is highly recommended that you send the tracking company and the tracking URL

tracking_url

string

The URL to track the fulfillment. If multiple tracking urls are set on this fulfillment, only the first one will be returned in the tracking_url field. Use the tracking_urls array field for accessing all tracking URLs associated with this fulfillment. Note With the REST API, you can set only one tracking number and one tracking URL per fulfillment. If you send multiple shipments with one fulfillment, you may want to specify tracking numbers and tracking URLs for all of them. You can do it with the equivalent GraphQL FulfillmentCreateV2 and fulfillmentTrackingInfoUpdateV2 mutations

tracking_urls

string

The URLs of tracking pages for the fulfillment. The tracking URLs are displayed in the merchant's admin on the order page. The tracking URLs are displayed in the shipping confirmation email, which can optionally be sent to the customer. When accounts are enabled, the tracking URLs are also displayed in the customer's order history. Note With the REST API, you can set only one tracking number and one tracking URL per fulfillment. If you send multiple shipments with one fulfillment, you may want to specify tracking numbers and tracking URLs for all of them. You can do it with the equivalent GraphQL FulfillmentCreateV2 and fulfillmentTrackingInfoUpdateV2 mutations

created_at

timestamp

The date and time when the fulfillment was created. The API returns this value in ISO 8601 format

updated_at

timestamp

The date and time ( ISO 8601 format ) when the fulfillment was last modified

SQL
CREATE VIEW shopify_examples.example_Fulfillments AS
SELECT *
FROM (
CALL shopify.Fulfillments (
updated_at_min => NULL,
updated_at_max => NULL,
since_id => NULL,
order_id => 5751369924864,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

GiftCards

Gift cards
Parameter
<since_id> (optional): Restrict results to after the specified ID
<status> (optional): Retrieve gift cards with a given status. Valid values:
<gift_card_id> (optional): Gift card id
<created_at_max> (optional): Show gift cards created at or before date
<created_at_min> (optional): Show gift cards created at or after date
<query> (optional): The text to search for
<updated_at_max> (optional): Show gift cards last updated at or before date
<updated_at_min> (optional): Show gift cards last updated at or after date
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the gift card

api_client_id

long

The ID of the client that issued the gift card

balance

bigdecimal

The balance of the gift card

currency

string

The currency of the gift card

customer_id

long

The ID of the customer associated with this gift card

disabled_at

timestamp

The date and time ( ISO 8601 format) when the gift card was disabled

expires_on

date

The date ( YYYY-MM-DD format) when the gift card expires. Returns null if the gift card doesn't have an expiration date

initial_value

bigdecimal

The initial value of the gift card when it was created

last_characters

string

The last four characters of the gift card code. Because gift cards are alternative payment methods, the full code cannot be retrieved

line_item_id

long

The ID of the line item that initiated the creation of this gift card, if it was created by an order

message

string

Message

note

string

An optional note that a merchant can attach to the gift card that isn't visible to customers

notify

string

Notify

order_id

long

The ID of the order that initiated the creation of this gift card, if it was created by an order

recipient_id

long

Recipient id

send_on

string

Send on

template_suffix

string

The suffix of the Liquid template that's used to render the gift card online. For example, if the value is birthday , then the gift card is rendered using the template gift_card.birthday.liquid . When the value is null , the default gift_card.liquid template is used

user_id

long

The ID of the user that issued the gift card, if it was issued by a user

created_at

timestamp

The date and time ( ISO 8601 format) when the gift card was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the gift card was last modified

SQL
CREATE VIEW shopify_examples.example_GiftCards AS
SELECT *
FROM (
CALL shopify.GiftCards (
status => NULL,
since_id => NULL
)
) AS x;;

InventoryItems

Detailed list for inventory items by IDs
Parameter
<ids> (optional): Show only inventory items specified by a comma-separated list of IDs
<inventory_item_id> (optional): Inventory item id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the inventory item

cost

bigdecimal

The unit cost of the inventory item. The shop's default currency is used

country_code_of_origin

string

The country code ( ISO 3166-1 alpha-2 ) of where the item came from

harmonized_system_code

long

The general Harmonized System (HS) code for the inventory item. Used if a country-specific HS code ('countryHarmonizedSystemCode') is not available

province_code_of_origin

string

The province code ( ISO 3166-2 alpha-2 ) of where the item came from. The province code is only used if the shipping provider for the inventory item is Canada Post

requires_shipping

boolean

Whether a customer needs to provide a shipping address when placing an order containing the inventory item

sku

string

The unique SKU (stock keeping unit) of the inventory item. Case-sensitive string

tracked

boolean

Whether inventory levels are tracked for the item. If true, then the inventory quantity changes are tracked by Shopify

created_at

timestamp

The date and time ( ISO 8601 format ) when the inventory item was created

updated_at

timestamp

The date and time ( ISO 8601 format ) when the inventory item was last modified

InventoryLevels

Inventory levels
Parameter
<inventory_item_ids> (optional): A comma-separated list of inventory item IDs. To find the ID of an inventory item, use the Inventory Item resource
<location_ids> (optional): A comma-separated list of location IDs. To find the ID of a location, use the Location resource
<updated_at_min> (optional): Show inventory levels updated at or after date (format: 2019-03-19T01:21:44-04:00)
<location_id> (optional): Location id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

available

boolean

The available quantity of an inventory item at the inventory level's associated location. Returns null if the inventory item is not tracked

inventory_item_id

long

The ID of the inventory item associated with the inventory level. To find the ID of an inventory item, use the Inventory Item resource

location_id

long

The ID of the location that the inventory level belongs to. To find the ID of the location, use the Location resource

updated_at

timestamp

The date and time ( ISO 8601 format ) when the inventory level was last modified

SQL
CREATE VIEW shopify_examples.example_InventoryLevels AS
SELECT *
FROM (
CALL shopify.InventoryLevels (
updated_at_min => NULL,
location_ids => NULL,
inventory_item_ids => NULL
)
) AS x;;

Locations

Locations
Parameter
<location_id> (optional): Location id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the location

name

string

The name of the location

active

boolean

Whether the location is active. If true , then the location can be used to sell products, stock inventory, and fulfill orders. Merchants can deactivate locations from the Shopify admin. Deactivated locations don't contribute to the shop's location limit

address1

string

The location's street address

address2

string

The optional second line of the location's street address

city

string

The city the location is in

country

string

The country the location is in

country_code

string

The two-letter code ( ISO 3166-1 alpha-2 format) corresponding to country the location is in

country_name

string

The localized name of the location's country

legacy

boolean

Whether this is a fulfillment service location. If true , then the location is a fulfillment service location. If false , then the location was created by the merchant and isn't tied to a fulfillment service

localized_country_name

string

The localized name of the location's country

localized_province_name

string

The localized name of the location's region. Typically a province, state, or district

phone

string

The phone number of the location. This value can contain special characters, such as - or +

province

string

The province, state, or district of the location

province_code

string

The province, state, or district code ( ISO 3166-2 alpha-2 format ) of the location

zip

string

The zip or postal code

created_at

timestamp

The date and time ( ISO 8601 format ) when the location was created

updated_at

timestamp

The date and time ( ISO 8601 format ) when the location was last updated

SQL
CREATE VIEW shopify_examples.example_InventoryLevels AS
SELECT *
FROM (
CALL shopify.InventoryLevels (
updated_at_min => NULL,
location_ids => NULL,
inventory_item_ids => NULL
)
) AS x;;

LocationsForMoves

Locations that a fulfillment order can potentially move to.
Parameter
<fulfillment_order_id> (optional): The ID of the fulfillment order
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

location_id

long

Location id

location_name

string

Location name

message

string

A human-readable string with the reason why the fulfillment order, or some of its line items, can't be moved to the location

movable

boolean

Whether the fulfillment order can be moved to the location

SQL
CREATE VIEW shopify_examples.example_LocationsForMoves AS
SELECT *
FROM (
CALL shopify.LocationsForMoves (
fulfillment_order_id => NULL
)
) AS x;;

MarketingEvents

Marketing events
Parameter
<marketing_event_id> (optional): Marketing event id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

Marketing event id

breadcrumb_id

string

Breadcrumb id

budget

bigdecimal

The budget of the ad campaign

budget_type

string

The type of the budget. Required if budget is specified. Valid values: daily , lifetime .'

currency

string

The currency for the budget. Required if budget is specified

description

string

A description of the marketing event

ended_at

timestamp

For events with a duration, the time when the event actually ended

event_type

string

The type of marketing event. Valid values: ad , post , message , retargeting , transactional , affiliate , loyalty , newsletter , abandoned_cart . Note If there are values that you'd like to use for event_type that are not in the list above, then please share your request in the Shopify Community APIs and SDKs discussion board providing as much detail as possible. Our approach is to be more structured than using freeform text, but to still allow for categorization of most types of marketing actions

manage_url

string

A link to manage the marketing event. In most cases, this links to the app that created the event

marketing_activity_id

string

marketing_activity_id

marketing_channel

string

The channel that your marketing event will use. Valid values: search , display , social , email , referral

paid

boolean

Whether the event is paid or organic

preview_url

string

A link to the live version of the event, or to a rendered preview in the app that created it

referring_domain

string

The destination domain of the marketing event. Required if the marketing_channel is set to search or social

remote_id

long

An optional remote identifier for a marketing event. The remote identifier lets Shopify validate engagement data

scheduled_to_end_at

timestamp

For events with a duration, the time when the event was scheduled to end

started_at

timestamp

The time when the marketing action was started

utm_campaign

string

UTM campaign

utm_medium

string

UTM medium

utm_source

string

UTM source

SQL
CREATE VIEW shopify_examples.example_MarketingEvents AS
SELECT *
FROM (
CALL shopify.MarketingEvents ()
) AS x;;

MobilePlatformApplications

Mobile platform applications associated with the app
Parameter
<mobile_platform_application_id> (optional): Mobile platform application id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

Unique numeric identifier for the mobile platform application

app_clip_application_id

string

iOS App ID of the app clip

application_id

long

iOS App ID or Android application ID of the application

enabled_app_clips

boolean

Whether the application supports iOS app clips

enabled_shared_webcredentials

boolean

Whether the application supports iOS shared web credentials

enabled_universal_or_app_links

boolean

Whether the application supports iOS universal links and Android App Links. If true, then URLs can be set up to link directly to the application. If false, then URLs can't link directly to the application

platform

string

The platform of the application

sha256_cert_fingerprints

string

The SHA256 fingerprints of the app's signing certificate. (Android only)

created_at

timestamp

Created at

updated_at

timestamp

Updated at

SQL
CREATE VIEW shopify_examples.example_MobilePlatformApplications AS
SELECT *
FROM (
CALL shopify.MobilePlatformApplications ()
) AS x;;

Orders

Orders
Parameter
<attribution_app_id> (optional): Show orders attributed to a certain app, specified by the app ID. Set as current to show orders for the app currently consuming the API
<created_at_max> (optional): Show orders created at or before date
<created_at_min> (optional): Show orders created at or after date
<financial_status> (optional): Filter orders by their financial status
<fulfillment_status> (optional): Filter orders by their fulfillment status
<ids> (optional): Retrieve only orders specified by a comma-separated list of order IDs
<processed_at_max> (optional): Show orders imported at or before date
<processed_at_min> (optional): Show orders imported at or after date
<since_id> (optional): Show orders after the specified ID
<status> (optional): Filter orders by their status
<updated_at_max> (optional): Show orders last updated at or before date
<updated_at_min> (optional): Show orders last updated at or after date
<customer_id> (optional): Customer id
<order_id> (optional): Order id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the order, used for API purposes. This is different from the order_number property, which is the ID used by the shop owner and customer.'

name

string

The order name, generated by combining the order_number property with the order prefix and suffix that are set in the merchant's general settings . This is different from the id property, which is the ID of the order used by the API. This field can also be set by the API to be any string value

app_id

long

The ID of the app that created the order

billing_address_address1

string

The street address of the billing address

billing_address_address2

string

An optional additional field for the street address of the billing address

billing_address_city

string

The city, town, or village of the billing address

billing_address_company

string

The company of the person associated with the billing address

billing_address_country

string

The name of the country of the billing address

billing_address_country_code

string

The two-letter code ( format) for the country of the billing address

billing_address_first_name

string

The first name of the person associated with the payment method

billing_address_last_name

string

The last name of the person associated with the payment method

billing_address_latitude

bigdecimal

The latitude of the billing address

billing_address_longitude

bigdecimal

The longitude of the billing address

billing_address_name

string

The full name of the person associated with the payment method

billing_address_phone

string

The phone number at the billing address

billing_address_province

string

The name of the region (for example, province, state, or prefecture) of the billing address

billing_address_province_code

string

The alphanumeric abbreviation of the region of the billing address

billing_address_zip

string

The postal code (for example, zip, postcode, or Eircode) of the billing address

browser_ip

string

The IP address of the browser used by the customer when they placed the order. Both IPv4 and IPv6 are supported

buyer_accepts_marketing

boolean

Whether the customer consented to receive email updates from the shop

cancel_reason

string

The reason why the order was canceled. Valid values: customer : The customer canceled the order. fraud : The order was fraudulent. inventory : Items in the order were not in inventory. declined : The payment was declined. other : A reason not in this list

cancelled_at

timestamp

The date and time when the order was canceled. Returns null if the order isn't canceled

cart_token

string

A unique value when referencing the cart that's associated with the order

checkout_id

long

Checkout id

checkout_token

string

A unique value when referencing the checkout that's associated with the order

client_details_accept_language

string

The languages and locales that the browser understands

client_details_browser_height

bigdecimal

The browser screen height in pixels, if available

client_details_browser_ip

string

The browser IP address

client_details_browser_width

bigdecimal

The browser screen width in pixels, if available

client_details_session_hash

string

A hash of the session

client_details_user_agent

string

Details of the browsing client, including software and operating versions

closed_at

timestamp

The date and time ( ISO 8601 format) when the order was closed. Returns null if the order isn't closed

confirmation_number

string

A randomly generated alpha-numeric identifier for the order that may be shown to the customer instead of the sequential order name. This value isn't guaranteed to be unique

confirmed

boolean

Whether inventory has been reserved for the order

contact_email

string

Contact email

currency

string

The three-letter code ( ISO 4217 format) for the shop currency

current_subtotal_price

bigdecimal

The sum of the prices for all line items after discounts and returns in the shop currency

current_subtotal_price_set_presentment_money_amount

bigdecimal

The sum of the prices for all line items after discounts and returns, in shop and presentment currencies. Presentment Money Amount

current_subtotal_price_set_presentment_money_currency_code

string

The sum of the prices for all line items after discounts and returns, in shop and presentment currencies. Presentment Money Currency code

current_subtotal_price_set_shop_money_amount

bigdecimal

The sum of the prices for all line items after discounts and returns, in shop and presentment currencies. Shop money Amount

current_subtotal_price_set_shop_money_currency_code

string

The sum of the prices for all line items after discounts and returns, in shop and presentment currencies. Shop money Currency code

current_total_additional_fees_set_presentment_money_amount

bigdecimal

The current total additional fees on the order in shop and presentment currencies. Presentment Money Amount

current_total_additional_fees_set_presentment_money_currency_code

string

The current total additional fees on the order in shop and presentment currencies. Presentment Money Currency code

current_total_additional_fees_set_shop_money_amount

bigdecimal

The current total additional fees on the order in shop and presentment currencies. Shop money Amount

current_total_additional_fees_set_shop_money_currency_code

string

The current total additional fees on the order in shop and presentment currencies. Shop money Currency code

current_total_discounts

bigdecimal

The current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds

current_total_discounts_set_presentment_money_amount

bigdecimal

The current total discounts on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Amount

current_total_discounts_set_presentment_money_currency_code

string

The current total discounts on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Currency code

current_total_discounts_set_shop_money_amount

bigdecimal

The current total discounts on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Amount

current_total_discounts_set_shop_money_currency_code

string

The current total discounts on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Currency code

current_total_duties_set_presentment_money_amount

bigdecimal

The current total duties charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Amount

current_total_duties_set_presentment_money_currency_code

string

The current total duties charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Currency code

current_total_duties_set_shop_money_amount

bigdecimal

The current total duties charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Amount

current_total_duties_set_shop_money_currency_code

string

The current total duties charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Currency code

current_total_price

bigdecimal

The current total price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds

current_total_price_set_presentment_money_amount

bigdecimal

The current total price of the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Amount

current_total_price_set_presentment_money_currency_code

string

The current total price of the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Currency code

current_total_price_set_shop_money_amount

bigdecimal

The current total price of the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Amount

current_total_price_set_shop_money_currency_code

string

The current total price of the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Currency code

current_total_tax

bigdecimal

The current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds

current_total_tax_set_presentment_money_amount

bigdecimal

The current total taxes charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Amount

current_total_tax_set_presentment_money_currency_code

string

The current total taxes charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Presentment Money Currency code

current_total_tax_set_shop_money_amount

bigdecimal

The current total taxes charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Amount

current_total_tax_set_shop_money_currency_code

string

The current total taxes charged on the order in shop and presentment currencies. The amount values associated with this field reflect order edits, returns, and refunds. Shop money Currency code

customer_created_at

timestamp

The date and time ( ISO 8601 format) when the customer was created

customer_currency

string

The three-letter code ( ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders

customer_default_address_address1

string

The first line of the customer's mailing address

customer_default_address_address2

string

An additional field for the customer's mailing address

customer_default_address_city

string

The customer's city, town, or village

customer_default_address_company

string

The customer's company

customer_default_address_country

string

The customer's country

customer_default_address_country_code

string

The two-letter country code corresponding to the customer's country

customer_default_address_country_name

string

The customer's normalized country name

customer_default_address_customer_id

long

Customer default address customer id

customer_default_address_default

boolean

Returns true for each default address

customer_default_address_first_name

string

The customer's first name

customer_default_address_id

long

A unique identifier for the address

customer_default_address_last_name

string

The customer's last name

customer_default_address_name

string

Default address name

customer_default_address_phone

string

The customer's phone number at this address

customer_default_address_province

string

The customer's region name. Typically a province, a state, or a prefecture

customer_default_address_province_code

string

The alphanumeric code for the customer's region

customer_default_address_zip

string

The customer's postal code, also known as zip, postcode, Eircode, etc

customer_email

string

The unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error

customer_email_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is used

customer_email_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by email

customer_email_marketing_consent_state

string

The current email marketing state for the customer

customer_first_name

string

The customer's first name

customer_id

long

Customer id

customer_last_name

string

The customer's last name

customer_locale

string

The two or three-letter language code, optionally followed by a region modifier

customer_multipass_identifier

string

A unique identifier for the customer that's used with Multipass login

customer_note

string

A note about the customer

customer_phone

string

The unique phone number (<a href="https://en.wikipedia.org/wiki/E.164">E.164 format ) for this customer. Attempting to assign the same phone number to multiple customers returns an error. The property can be set using different formats, but each format must represent a number that can be dialed from anywhere in the world. The following formats are all valid: 6135551212 +16135551212 (613)555-1212 +1 613-555-1212

customer_sms_marketing_consent_consent_collected_from

string

The source for whether the customer has consented to receive marketing material by SMS

customer_sms_marketing_consent_consent_updated_at

timestamp

The date and time when the customer consented to receive marketing material by SMS. If no date is provided, then the date and time when the consent information was sent is used

customer_sms_marketing_consent_opt_in_level

string

The marketing subscription opt-in level, as described in the , that the customer gave when they consented to receive marketing material by SMS

customer_sms_marketing_consent_state

string

The current SMS marketing state for the customer

customer_state

string

The state of the customer's account with a shop. Default value: disabled . Valid values: disabled : The customer doesn't have an active account. Customer accounts can be disabled from the Shopify admin at any time. invited : The customer has received an email invite to create an account. enabled : The customer has created an account. declined : The customer declined the email invite to create an account

customer_tags

string

Tags that the shop owner has attached to the customer, formatted as a string of comma-separated values. A customer can have up to 250 tags. Each tag can have up to 255 characters

customer_tax_exempt

boolean

Whether the customer is exempt from paying taxes on their order. If true , then taxes won't be applied to an order at checkout. If false , then taxes will be applied at checkout

customer_updated_at

timestamp

The date and time ( ISO 8601 format) when the customer information was last updated

customer_verified_email

boolean

Whether the customer has verified their email address

device_id

long

Device id

discount_codes

string

Discount codes

duties_included

boolean

Returns true if duties are included in the prices of products in the cart. Returns false if not

email

string

The customer's email address

estimated_taxes

boolean

Whether taxes on the order are estimated. Many factors can change between the time a customer places an order and the time the order is shipped, which could affect the calculation of taxes. This property returns false when taxes on the order are finalized and aren't subject to any changes

financial_status

string

The status of payments associated with the order. Can only be set when the order is created. Valid values: pending : The payments are pending. Payment might fail in this state. Check again to confirm whether the payments have been paid successfully. authorized : The payments have been authorized. partially_paid : The order has been partially paid. paid : The payments have been paid. partially_refunded : The payments have been partially refunded. refunded : The payments have been refunded. voided : The payments have been voided

fulfillment_status

string

The order's status in terms of fulfilled line items. You can use the FulfillmentOrder resource for a more granular view. Valid values: fulfilled : Every line item in the order has been fulfilled. null : None of the line items in the order have been fulfilled. partial : At least one line item in the order has been fulfilled. restocked : Every line item in the order has been restocked and the order canceled

landing_site

string

The URL for the page where the buyer landed when they entered the shop

landing_site_ref

string

Landing site ref

location_id

long

The ID of one of the locations that was assigned to fulfill the order when the order was created. Orders can have multiple fulfillment orders. These fulfillment orders can each be assigned to a different location which is responsible for fulfilling a subset of the items in an order. The Order.location_id field will only point to one of these locations. Use the FulfillmentOrder resource for up-to-date fulfillment location information

merchant_of_record_app_id

long

The application acting as Merchant of Record for the order

note

string

An optional note that a shop owner can attach to the order

note_attributes

string

Extra information that is added to the order. Appears in the Additional details section of an order details page. Each array entry must contain a hash with name and value keys

number

long

The order's position in the shop's count of orders. Numbers are sequential and start at 1

order_number

long

The order 's position in the shop's count of orders starting at 1001. Order numbers are sequential and start at 1001

order_status_url

string

The URL pointing to the order status web page , if applicable

original_total_additional_fees_set_presentment_money_amount

bigdecimal

Original total additional fees on the order in shop and presentment currencies. Presentment Money Amount

original_total_additional_fees_set_presentment_money_currency_code

string

Original total additional fees on the order in shop and presentment currencies. Presentment Money Currency code

original_total_additional_fees_set_shop_money_amount

bigdecimal

Original total additional fees on the order in shop and presentment currencies. Shop money Amount

original_total_additional_fees_set_shop_money_currency_code

string

Original total additional fees on the order in shop and presentment currencies. Shop money Currency code

original_total_duties_set_presentment_money_amount

bigdecimal

The original total duties charged on the order in shop and presentment currencies. Presentment Money Amount

original_total_duties_set_presentment_money_currency_code

string

The original total duties charged on the order in shop and presentment currencies. Presentment Money Currency code

original_total_duties_set_shop_money_amount

bigdecimal

The original total duties charged on the order in shop and presentment currencies. Shop money Amount

original_total_duties_set_shop_money_currency_code

string

The original total duties charged on the order in shop and presentment currencies. Shop money Currency code

payment_gateway_names

string

The list of payment gateways used for the order

payment_terms

string

The terms and conditions under which a payment should be processed. amount : The amount that is owed according to the payment terms. currency : The presentment currency for the payment. payment_terms_name : The name of the selected payment terms template for the order. payment_terms_type : The type of selected payment terms template for the order. due_in_days : The number of days between the invoice date and due date that is defined in the selected payment terms template. payment_schedules : An array of schedules associated to the payment terms. amount : The amount that is owed according to the payment terms. currency : The presentment currency for the payment. issued_at : The date and time when the payment terms were initiated. due_at : The date and time when the payment is due. Calculated based on issued_at and due_in_days or a customized fixed date if the type is fixed. completed_at : The date and time when the purchase is completed. Returns null initially and updates when the payment is captured. expected_payment_method : The name of the payment method gateway

phone

string

The customer's phone number for receiving SMS notifications

po_number

string

The purchase order number associated to this order

presentment_currency

string

The presentment currency that was used to display prices to the customer

reference

string

Reference

referring_site

string

The website where the customer clicked a link to the shop

shipping_address_address1

string

The street address of the shipping address

shipping_address_address2

string

An optional additional field for the street address of the shipping address

shipping_address_city

string

The city, town, or village of the shipping address

shipping_address_company

string

The company of the person associated with the shipping address

shipping_address_country

string

The name of the country of the shipping address

shipping_address_country_code

string

The two-letter code ( format) for the country of the shipping address

shipping_address_first_name

string

The first name of the person associated with the shipping address

shipping_address_last_name

string

The last name of the person associated with the shipping address

shipping_address_latitude

bigdecimal

The latitude of the shipping address

shipping_address_longitude

bigdecimal

The longitude of the shipping address

shipping_address_name

string

The full name of the person associated with the payment method

shipping_address_phone

string

The phone number at the shipping address

shipping_address_province

string

The name of the region (for example, province, state, or prefecture) of the shipping address

shipping_address_province_code

string

The alphanumeric abbreviation of the region of the shipping address

shipping_address_zip

string

The postal code (for example, zip, postcode, or Eircode) of the shipping address

source_identifier

string

The ID of the order placed on the originating platform. This value doesn't correspond to the Shopify ID that's generated from a completed draft

source_name

string

The source of the checkout. To use this field for sales attribution, you must register the channels that your app is managing. You can register the channels that your app is managing by completing this Google Form . After you've submited your request, you need to wait for your request to be processed by Shopify. You can find a list of your channels in the Partner Dashboard, in your app's Marketplace extension. You can specify a handle as the source_name value in your request

source_url

string

A valid URL to the original order on the originating surface. This URL is displayed to merchants on the Order Details page. If the URL is invalid, then it won't be displayed

subtotal_price

bigdecimal

The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips

subtotal_price_set_presentment_money_amount

bigdecimal

The subtotal of the order in shop and presentment currencies after discounts but before shipping, duties, taxes, and tips. Presentment Money Amount

subtotal_price_set_presentment_money_currency_code

string

The subtotal of the order in shop and presentment currencies after discounts but before shipping, duties, taxes, and tips. Presentment Money Currency code

subtotal_price_set_shop_money_amount

bigdecimal

The subtotal of the order in shop and presentment currencies after discounts but before shipping, duties, taxes, and tips. Shop money Amount

subtotal_price_set_shop_money_currency_code

string

The subtotal of the order in shop and presentment currencies after discounts but before shipping, duties, taxes, and tips. Shop money Currency code

tags

string

Tags attached to the order, formatted as a string of comma-separated values. Tags are additional short descriptors, commonly used for filtering and searching. Each individual tag is limited to 40 characters in length

tax_exempt

boolean

Whether the customer is exempt from paying taxes on their order. If true , then taxes won't be applied to an order at checkout. If false , then taxes will be applied at checkout

taxes_included

boolean

Whether taxes are included in the order subtotal

test

boolean

Whether this is a test order

token

string

A unique value when referencing the order

total_discounts

bigdecimal

The total discounts applied to the price of the order in the shop currency

total_discounts_set_presentment_money_amount

bigdecimal

The total discounts applied to the price of the order in shop and presentment currencies. Presentment Money Amount

total_discounts_set_presentment_money_currency_code

string

The total discounts applied to the price of the order in shop and presentment currencies. Presentment Money Currency code

total_discounts_set_shop_money_amount

bigdecimal

The total discounts applied to the price of the order in shop and presentment currencies. Shop money Amount

total_discounts_set_shop_money_currency_code

string

The total discounts applied to the price of the order in shop and presentment currencies. Shop money Currency code

total_line_items_price

bigdecimal

The sum of all line item prices in the shop currency

total_line_items_price_set_presentment_money_amount

bigdecimal

The total of all line item prices in shop and presentment currencies. Presentment Money Amount

total_line_items_price_set_presentment_money_currency_code

string

The total of all line item prices in shop and presentment currencies. Presentment Money Currency code

total_line_items_price_set_shop_money_amount

bigdecimal

The total of all line item prices in shop and presentment currencies. Shop money Amount

total_line_items_price_set_shop_money_currency_code

string

The total of all line item prices in shop and presentment currencies. Shop money Currency code

total_outstanding

bigdecimal

The total outstanding amount of the order in the shop currency

total_price

bigdecimal

The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive

total_price_set_presentment_money_amount

bigdecimal

The total price of the order in shop and presentment currencies. Presentment Money Amount

total_price_set_presentment_money_currency_code

string

The total price of the order in shop and presentment currencies. Presentment Money Currency code

total_price_set_shop_money_amount

bigdecimal

The total price of the order in shop and presentment currencies. Shop money Amount

total_price_set_shop_money_currency_code

string

The total price of the order in shop and presentment currencies. Shop money Currency code

total_shipping_price_set_presentment_money_amount

bigdecimal

The total shipping price of the order, excluding discounts and returns, in shop and presentment currencies. If taxes_included is set to true , then total_shipping_price_set includes taxes. Presentment Money Amount

total_shipping_price_set_presentment_money_currency_code

string

The total shipping price of the order, excluding discounts and returns, in shop and presentment currencies. If taxes_included is set to true , then total_shipping_price_set includes taxes. Presentment Money Currency code

total_shipping_price_set_shop_money_amount

bigdecimal

The total shipping price of the order, excluding discounts and returns, in shop and presentment currencies. If taxes_included is set to true , then total_shipping_price_set includes taxes. Shop money Amount

total_shipping_price_set_shop_money_currency_code

string

The total shipping price of the order, excluding discounts and returns, in shop and presentment currencies. If taxes_included is set to true , then total_shipping_price_set includes taxes. Shop money Currency code

total_tax

bigdecimal

The sum of all the taxes applied to the order in the shop currency. Must be positive

total_tax_set_presentment_money_amount

bigdecimal

The total tax applied to the order in shop and presentment currencies. Presentment Money Amount

total_tax_set_presentment_money_currency_code

string

The total tax applied to the order in shop and presentment currencies. Presentment Money Currency code

total_tax_set_shop_money_amount

bigdecimal

The total tax applied to the order in shop and presentment currencies. Shop money Amount

total_tax_set_shop_money_currency_code

string

The total tax applied to the order in shop and presentment currencies. Shop money Currency code

total_tip_received

bigdecimal

The sum of all the tips in the order in the shop currency

total_weight

bigdecimal

The sum of all line item weights in grams. The sum is not adjusted as items are removed from the order

user_id

long

The ID of the user logged into Shopify POS who processed the order, if applicable

processed_at

timestamp

The date and time ( ISO 8601 format) when an order was processed. This value is the date that appears on your orders and that's used in the analytic reports. If you're importing orders from an app or another platform, then you can set processed_at to a date and time in the past to match when the original order was created

created_at

timestamp

The autogenerated date and time ( ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed

updated_at

timestamp

The date and time ( ISO 8601 format) when the order was last modified. Filtering orders by updated_at is not an effective method for fetching orders because its value can change when no visible fields of an order have been updated. Use the Webhook and Event APIs to subscribe to order events instead

SQL
CREATE VIEW shopify_examples.example_Orders AS
SELECT *
FROM (
CALL shopify.Orders (
since_id => NULL,
processed_at_min => NULL,
processed_at_max => NULL,
ids => NULL,
fulfillment_status => NULL,
financial_status => NULL,
created_at_min => NULL,
created_at_max => NULL,
attribution_app_id => NULL,
updated_at_min => NULL,
updated_at_max => NULL,
status => NULL
)
) AS x;;

OrderRisks

Order risks for an order
Parameter
<order_id> (optional): Order id
<risk_id> (optional): Risk id
<order_table> (optional): Table with order containing column id(containing order_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

A unique numeric identifier for the order risk

cause_cancel

boolean

Whether this order risk is severe enough to force the cancellation of the order. If true , then this order risk is included in the Order canceled message that's shown on the details page of the canceled order. Note: Setting this property to true does not cancel the order. Use this property only if your app automatically cancels the order using the Order resource. If your app doesn't automatically cancel orders based on order risks, then leave this property set to false

checkout_id

long

The ID of the checkout that the order risk belongs to

display

boolean

Whether the order risk is displayed on the order details page in the Shopify admin. If false , then this order risk is ignored when Shopify determines your app's overall risk level for the order. It's not advised to create order risks with a display set to false . This property can't be changed after an order risk is created. This property might be removed in future API versions

merchant_message

string

The message that's displayed to the merchant to indicate the results of the fraud check. The message is displayed only if display is set to true

message

string

The message that's displayed to the merchant to indicate the results of the fraud check. The message is displayed only if display is set to true

order_id

long

The ID of the order that the order risk belongs to

recommendation

string

The recommended action given to the merchant. Valid values: cancel : There is a high level of risk that this order is fraudulent. The merchant should cancel the order. investigate : There is a medium level of risk that this order is fraudulent. The merchant should investigate the order. accept : There is a low level of risk that this order is fraudulent. The order risk found no indication of fraud

score

bigdecimal

For internal use only . A number between 0 and 1 that's assigned to the order. The closer the score is to 1, the more likely it is that the order is fraudulent. Note There is no guarantee of stability in risk scores. Scores are not probabilities. The relationship between scores and the probability of fraud can vary over time and between risk providers

source

string

The source of the order risk

SQL
CREATE VIEW shopify_examples.example_OrderRisks AS
SELECT *
FROM (
CALL shopify.OrderRisks (
order_id => 5751369924864
)
) AS x;;

Pages

List of all Pages

Parameter
<created_at_max> (optional): Show pages created before date
<created_at_min> (optional): Show pages created after date
<handle> (optional): Retrieve a page with a given handle
<published_at_max> (optional): Show pages published before date
<published_at_min> (optional): Show pages published after date
<published_status> (optional): Restrict results to pages with a given published status (default: any): - published - Show only published pages; - unpublished - Show only unpublished pages; - any - Show published and unpublished pages
<since_id> (optional): Restrict results to after the specified ID
<title> (optional): Retrieve pages with a given title
<updated_at_max> (optional): Show pages last updated before date
<updated_at_min> (optional): Show pages last updated after date
<page_id> (optional): Page id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique numeric identifier for the page

author

string

The name of the person who created the page

body_html

string

The text content of the page, complete with HTML markup

handle

string

A unique, human-friendly string for the page, generated automatically from its title. In online store themes, the Liquid templating language refers to a page by its handle

published_at

timestamp

The date and time (ISO 8601 format) when the page was published. Returns null when the page is hidden

shop_id

long

The ID of the shop to which the page belongs

template_suffix

string

The suffix of the Liquid template being used. For example, if the value is contact, then the page is using the page.contact.liquid template. If the value is an empty string, then the page is using the default page.liquid template

title

string

The page's title

created_at

timestamp

The date and time (ISO 8601 format) when the page was created

updated_at

timestamp

The date and time (ISO 8601 format) when the page was last updated

SQL
CREATE VIEW shopify_examples.example_Pages AS
SELECT *
FROM (
CALL shopify.Pages (
updated_at_min => NULL,
updated_at_max => NULL,
title => NULL,
since_id => NULL,
published_status => NULL,
published_at_min => NULL,
published_at_max => NULL,
handle => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

Payouts

Payouts
Parameter
<date> (optional): Filter the response to payouts made on the specified date
<date_max> (optional): Filter the response to payouts made inclusively before the specified date
<date_min> (optional): Filter the response to payouts made inclusively after the specified date
<last_id> (optional): Filter the response to payouts made before the specified ID
<since_id> (optional): Filter the response to payouts made after the specified ID
<status> (optional): Filter the response to payouts made with the specified status
<payout_id> (optional): Payout id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique identifier of the payout

amount

bigdecimal

The total amount of the payout, in a decimal formatted string

currency

string

The ISO 4217 currency code of the payout

date

date

Date

status

string

The transfer status of the payout. The value will be one of the following: scheduled : The payout has been created and had transactions assigned to it, but it has not yet been submitted to the bank. in_transit : The payout has been submitted to the bank for processing. paid : The payout has been successfully deposited into the bank. failed : The payout has been declined by the bank. canceled : The payout has been canceled by Shopify

summary_adjustments_fee_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_adjustments_gross_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_charges_fee_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_charges_gross_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_refunds_fee_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_refunds_gross_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_reserved_funds_fee_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_reserved_funds_gross_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_retried_payouts_fee_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

summary_retried_payouts_gross_amount

bigdecimal

The total amount of the payout, in a decimal formatted string

SQL
CREATE VIEW shopify_examples.example_Payouts AS
SELECT *
FROM (
CALL shopify.Payouts (
status => NULL,
since_id => NULL,
last_id => NULL,
date_min => NULL,
date_max => NULL,
"date" => NULL
)
) AS x;;

Policies

The shop's policies
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

title

string

The name of the policy

body

string

A description of the policy

handle

string

A unique identifer for the policy used to build the policy's URL

url

string

The public URL of the policy

created_at

timestamp

The date and time ( ISO 8601 format ) when the policy was created

updated_at

timestamp

The date and time ( ISO 8601 format ) when the policy was last modified

SQL
CREATE VIEW shopify_examples.example_Policies AS
SELECT *
FROM (
CALL shopify.Policies ()
) AS x;;

PriceRules

Price rules
Parameter
<created_at_max> (optional): Show price rules created before date (format 2017-03-25T16:15:47-04:00)
<created_at_min> (optional): Show price rules created after date (format 2017-03-25T16:15:47-04:00)
<ends_at_max> (optional): Show price rules ending before date (format 2017-03-25T16:15:47-04:00)
<ends_at_min> (optional): Show price rules ending after date (format 2017-03-25T16:15:47-04:00)
<since_id> (optional): Restrict results to after the specified ID
<starts_at_max> (optional): Show price rules starting before date (format 2017-03-25T16:15:47-04:00)
<starts_at_min> (optional): Show price rules starting after date (format 2017-03-25T16:15:47-04:00)
<times_used> (optional): Show price rules with times used
<updated_at_max> (optional): Show price rules last updated before date (format 2017-03-25T16:15:47-04:00)
<updated_at_min> (optional): Show price rules last updated after date (format 2017-03-25T16:15:47-04:00)
<price_rule_id> (optional): Price rule id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the price rule

title

string

The title of the price rule. This is used by the Shopify admin search to retrieve discounts. It is also displayed on the Discounts page of the Shopify admin for bulk discounts. For non-bulk discounts, the discount code is displayed on the admin. For a consistent search experience, use the same value for title as the code property of the associated discount code

allocation_limit

integer

The number of times the discount can be allocated on the cart - if eligible. For example a Buy 1 hat Get 1 hat for free discount can be applied 3 times on a cart having more than 6 hats, where maximum of 3 hats get discounted - if the allocation_limit is 3. Empty ( null ) allocation_limit means unlimited number of allocations. Caution allocation_limit is only working with Buy X Get Y discount. The default value on creation will be null (unlimited)

allocation_method

string

The allocation method of the price rule. Valid values: each : The discount is applied to each of the entitled items. For example, for a price rule that takes $15 off, each entitled line item in a checkout will be discounted by $15. across : The calculated discount amount will be applied across the entitled items. For example, for a price rule that takes $15 off, the discount will be applied across all the entitled items. When the value of target_type is shipping_line , then this value must be each

customer_segment_prerequisite_ids

string

A list of customer segment IDs. For the price rule to be applicable, the customer must be in the group of customers matching a customer segment. If customer_segment_prerequisite_ids is populated, then prerequisite_customer_ids must be empty

customer_selection

string

The customer selection for the price rule. Valid values: all : The price rule is valid for all customers. prerequisite : The customer must either belong to one of the customer segments specified by customer_segment_prerequisite_ids , or be one of the customers specified by prerequisite_customer_ids

ends_at

timestamp

The date and time ( ISO 8601 format) when the price rule ends. Must be after starts_at

entitled_collection_ids

string

A list of IDs of collections whose products will be eligible to the discount. It can be used only with target_type set to line_item and target_selection set to entitled . It can't be used in combination with entitled_product_ids or entitled_variant_ids

entitled_product_ids

string

A list of IDs of products that will be entitled to the discount. It can be used only with target_type set to line_item and target_selection set to entitled . If a product variant is included in entitled_variant_ids , then entitled_product_ids can't include the ID of the product associated with that variant

entitled_variant_ids

string

A list of IDs of product variants that will be entitled to the discount. It can be used only with target_type set to line_item and target_selection set to entitled . If a product is included in entitled_product_ids , then entitled_variant_ids can't include the ID of any variants associated with that product

once_per_customer

boolean

Whether the generated discount code will be valid only for a single use per customer. This is tracked using customer ID

prerequisite_collection_ids

string

List of collection ids that will be a prerequisites for a Buy X Get Y discount. The entitled_collection_ids can be used only with: target_type set to line_item , target_selection set to entitled , allocation_method set to each and prerequisite_to_entitlement_quantity_ratio defined. Cannot be used in combination with prerequisite_product_ids or prerequisite_variant_ids

prerequisite_customer_ids

string

A list of customer IDs. For the price rule to be applicable, the customer must match one of the specified customers . If prerequisite_customer_ids is populated, then customer_segment_prerequisite_ids must be empty

prerequisite_product_ids

string

List of product ids that will be a prerequisites for a Buy X Get Y type discount. The prerequisite_product_ids can be used only with: target_type set to line_item , target_selection set to entitled , allocation_method set to each and prerequisite_to_entitlement_quantity_ratio defined. Caution If a product variant is included in prerequisite_variant_ids , then prerequisite_product_ids can't include the ID of the product associated with that variant

prerequisite_quantity_range_greater_than_or_equal_to

integer

The minimum number of items for the price rule to be applicable. The quantity of an entitled cart item must be greater than or equal to this value

prerequisite_shipping_price_range_less_than_or_equal_to

bigdecimal

The shipping price must be less than or equal to this value

prerequisite_subtotal_range_greater_than_or_equal_to

bigdecimal

The subtotal of the entitled cart items must be greater than or equal to this value for the discount to apply

prerequisite_to_entitlement_purchase_prerequisite_amount

bigdecimal

The minimum purchase amount required to be entitled to the discount

prerequisite_to_entitlement_quantity_ratio_entitled_quantity

string

prerequisite_to_entitlement_quantity_ratio_entitled_quantity

prerequisite_to_entitlement_quantity_ratio_prerequisite_quantity

string

prerequisite_to_entitlement_quantity_ratio_prerequisite_quantity

prerequisite_variant_ids

string

List of variant ids that will be a prerequisites for a Buy X Get Y type discount. The entitled_variant_ids can be used only with: target_type set to line_item , target_selection set to entitled , allocation_method set to each and prerequisite_to_entitlement_quantity_ratio defined. Caution If a product is included in prerequisite_product_ids , then prerequisite_variant_ids can't include the ID of any variants associated with that product

starts_at

timestamp

The date and time ( ISO 8601 format) when the price rule starts

target_selection

string

The target selection method of the price rule. Valid values: all : The price rule applies the discount to all line items in the checkout. entitled : The price rule applies the discount to selected entitlements only

target_type

string

The target type that the price rule applies to. Valid values: line_item : The price rule applies to the cart's line items. shipping_line : The price rule applies to the cart's shipping lines

usage_limit

integer

The maximum number of times the price rule can be used, per discount code

value

string

The value of the price rule. If if the value of target_type is shipping_line , then only -100 is accepted. The value must be negative

value_type

string

The value type of the price rule. Valid values: fixed_amount : Applies a discount of value as a unit of the store's currency. For example, if value is -30 and the store's currency is USD, then $30 USD is deducted when the discount is applied. percentage : Applies a percentage discount of value . For example, if value is -30, then 30% will be deducted when the discount is applied. If target_type is shipping_line , then only percentage is accepted

created_at

timestamp

The date and time ( ISO 8601 format) when the price rule was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the price rule was updated

SQL
CREATE VIEW shopify_examples.example_PriceRules AS
SELECT *
FROM (
CALL shopify.PriceRules (
updated_at_min => NULL,
updated_at_max => NULL,
times_used => NULL,
starts_at_min => NULL,
starts_at_max => NULL,
since_id => NULL,
ends_at_min => NULL,
ends_at_max => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

ProductImages

Product Images
Parameter
<product_id> (optional): Product id
<since_id> (optional): Restrict results to after the specified ID
<image_id> (optional): Image id
<product_table> (optional): Table with product containing column id(containing product_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

A unique numeric identifier for the product image

alt

string

Image alt attribute

height

bigdecimal

Height dimension of the image which is determined on upload

position

integer

The order of the product image in the list. The first product image is at position 1 and is the "main" image for the product

product_id

long

The id of the product associated with the image

src

string

Specifies the location of the product image. This parameter supports Liquid filters that you can use to retrieve modified copies of the image

variant_ids

string

An array of variant ids associated with the imagee

width

bigdecimal

Width dimension of the image which is determined on upload

created_at

timestamp

The date and time when the product image was created. The API returns this value in ISO 8601 format

updated_at

timestamp

The date and time when the product image was last modified. The API returns this value in ISO 8601 format

SQL
CREATE VIEW shopify_examples.example_ProductImages AS
SELECT *
FROM (
CALL shopify.ProductImages (
since_id => NULL,
product_id => 4384690602080
)
) AS x;;

ProductVariants

Product variants
Parameter
<presentment_currencies> (optional): Return presentment prices in only certain currencies, specified by a comma-separated list of ISO 4217 currency codes
<product_id> (optional): Product id
<since_id> (optional): Restrict results to after the specified ID
<variant_id> (optional): Variant id
<product_table> (optional): Table with product containing column id(containing product_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique numeric identifier for the product variant

title

string

The title of the product variant. The title field is a concatenation of the option1 , option2 , and option3 fields. You can only update title indirectly using the option fields

barcode

string

The barcode, UPC, or ISBN number for the product

compare_at_price

bigdecimal

The original price of the item before an adjustment or a sale

fulfillment_service

string

The handle of a fulfillment service that stocks a product variant. This is the handle of a third-party fulfillment service if the following conditions are met: The product variant is stocked by a single fulfillment service. The FulfillmentService is a third-party fulfillment service. Third-party fulfillment services don't have a handle with the value manual . The fulfillment service hasn't opted into SKU sharing . If the conditions aren't met, then this is manual . The relationship between a product variant and a fulfillment service was changed in the 2022-07 API version . A ProductVariant can be stocked by multiple fulfillment services. As a result, we recommend that you use the InventoryLevel resource if you need to determine where a product variant is stocked. If you previously set this field, then we recommend that you instead connect an inventory item to a location . Each Location is associated with a single FulfillmentService . The value of this field after setting it will be as described above. If you need to determine whether a product is a gift card, then you should continue to use this field until an alternative is available. Learn more about managing inventory quantities and states

grams

long

The weight of the product variant in grams

image_id

long

The unique numeric identifier for a product's image. The image must be associated to the same product as the variant

inventory_item_id

long

The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information

inventory_management

string

The fulfillment service that tracks the number of items in stock for the product variant. Valid values: shopify : You are tracking inventory yourself using the admin. null : You aren't tracking inventory on the variant. the handle of a fulfillment service that has inventory management enabled: This must be the same fulfillment service referenced by the fulfillment_service property

inventory_policy

string

Whether customers are allowed to place an order for the product variant when it's out of stock. Valid values: deny : Customers are not allowed to place orders for the product variant if it's out of stock. continue : Customers are allowed to place orders for the product variant if it's out of stock. Default value: deny

inventory_quantity

bigdecimal

An aggregate of inventory across all locations. To adjust inventory at a specific location, use the InventoryLevel resource

old_inventory_quantity

bigdecimal

This property is deprecated. Use the InventoryLevel resource instead

option1

string

Option 1

option2

string

Option 2

option3

string

Option 3

position

integer

The order of the product variant in the list of product variants. The first position in the list is 1 . The position of variants is indicated by the order in which they are listed

price

bigdecimal

The price of the product variant

product_id

long

The unique numeric identifier for the product

requires_shipping

boolean

This property is deprecated. Use the 'requires_shipping' property on the InventoryItem resource instead

sku

string

A unique case-sensitive identifier for the product variant in the shop. Required in order to connect to a FulfillmentService

taxable

boolean

Whether a tax is charged when the product variant is sold

weight

bigdecimal

The weight of the product variant in the unit system specified with weight_unit

weight_unit

string

The unit of measurement that applies to the product variant's weight. If you don't specify a value for weight_unit , then the shop's default unit of measurement is applied. Valid values: g , kg , oz , and lb

created_at

timestamp

The date and time ( ISO 8601 format ) when the product variant was created

updated_at

timestamp

The date and time when the product variant was last modified. Gets returned in ISO 8601 format

SQL
CREATE VIEW shopify_examples.example_ProductVariants AS
SELECT *
FROM (
CALL shopify.ProductVariants (
since_id => NULL,
product_id => 4384690602080,
presentment_currencies => NULL
)
) AS x;;

Products

Products
Parameter
<collection_id> (optional): Return products by product collection ID
<created_at_max> (optional): Return products created before a specified date
<created_at_min> (optional): Return products created after a specified date
<handle> (optional): Return only products specified by a comma-separated list of product handles
<ids> (optional): Return only products specified by a comma-separated list of product IDs
<presentment_currencies> (optional): Return presentment prices in only certain currencies, specified by a comma-separated list of ISO 4217 currency codes
<product_type> (optional): Return products by product type
<published_at_max> (optional): Return products published before a specified date
<published_at_min> (optional): Return products published after a specified date
<published_status> (optional): Return products by their published status
<since_id> (optional): Return only products after the specified ID
<status> (optional): Return only products specified by a comma-separated list of statuses
<title> (optional): Return products by product title
<updated_at_max> (optional): Return products last updated before a specified date
<updated_at_min> (optional): Return products last updated after a specified date
<vendor> (optional): Return products by product vendor
<product_id> (optional): Product id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

An unsigned 64-bit integer that's used as a unique identifier for the product. Each id is unique across the Shopify system. No two products will have the same id , even if they're from different shops

title

string

The name of the product

body_html

string

A description of the product. Supports HTML formatting

handle

string

A unique human-friendly string for the product. Automatically generated from the product's title . Used by the Liquid templating language to refer to objects

image_alt

string

Image alt attribute

image_created_at

timestamp

The date and time ( ISO 8601 format ) when the product was created

image_height

integer

Height dimension of the image which is determined on upload

image_id

long

The unique numeric identifier for a product's image. The image must be associated to the same product as the variant

image_position

integer

The order of the product image in the list. The first product image is at position 1 and is the main image for the product

image_product_id

long

The id of the product associated with the image

image_src

string

Specifies the location of the product image. This parameter supports Liquid filters that you can use to retrieve modified copies of the image

image_updated_at

timestamp

The date and time ( ISO 8601 format ) when the product was last modified. A product's updated_at value can change for different reasons. For example, if an order is placed for a product that has inventory tracking set up, then the inventory adjustment is counted as an update

image_variant_ids

string

An array of variant ids associated with the image

image_width

integer

Width dimension of the image which is determined on upload

product_type

string

A categorization for the product used for filtering and searching products

published_at

timestamp

The date and time ( ISO 8601 format ) when the product was published. Can be set to null to unpublish the product from the Online Store channel

published_scope

string

Whether the product is published to the Point of Sale channel. Valid values: web : The product isn't published to the Point of Sale channel. global : The product is published to the Point of Sale channel

status

string

The status of the product. Valid values: active : The product is ready to sell and is available to customers on the online store, sales channels, and apps. By default, existing products are set to active. archived : The product is no longer being sold and isn't available to customers on sales channels and apps. draft : The product isn't ready to sell and is unavailable to customers on sales channels and apps. By default, duplicated and unarchived products are set to draft

tags

string

A string of comma-separated tags that are used for filtering and search. A product can have up to 250 tags. Each tag can have up to 255 characters

template_suffix

string

The suffix of the Liquid template used for the product page. If this property is specified, then the product page uses a template called "product.suffix.liquid", where "suffix" is the value of this property. If this property is "" or null , then the product page uses the default template "product.liquid". (default: null )

vendor

string

The name of the product's vendor

created_at

timestamp

The date and time ( ISO 8601 format ) when the product was created

updated_at

timestamp

The date and time ( ISO 8601 format ) when the product was last modified. A product's updated_at value can change for different reasons. For example, if an order is placed for a product that has inventory tracking set up, then the inventory adjustment is counted as an update

SQL
CREATE VIEW shopify_examples.example_Products AS
SELECT *
FROM (
CALL shopify.Products (
published_at_min => NULL,
published_at_max => NULL,
product_type => NULL,
presentment_currencies => NULL,
ids => NULL,
handle => NULL,
created_at_min => NULL,
created_at_max => NULL,
collection_id => NULL,
vendor => NULL,
updated_at_min => NULL,
updated_at_max => NULL,
title => NULL,
status => NULL,
since_id => NULL,
published_status => NULL
)
) AS x;;

Provinces

Provinces for a country
Parameter
<country_id> (optional): Country id
<since_id> (optional): Restrict results to after the specified ID
<province_id> (optional): Province id
<countries_table> (optional): Table with countries containing column id(containing country_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the province

name

string

The full name of the province

code

string

The standard abbreviation for the province

country_id

long

The ID for the country that the province belongs to

shipping_zone_id

long

The ID for the shipping zone that the province belongs to

tax

bigdecimal

The sales tax rate to be applied to orders made by customers from this province

tax_name

string

The name of the tax for this province

tax_percentage

bigdecimal

The province's tax in percent format

tax_type

string

The tax type. Valid values: null , normal , harmonized , or compounded . A harmonized tax is a combination of provincial and federal sales taxes. Normal and harmonized tax rates are applied to the pre-tax value of an order, but a compounded tax rate is applied on top of other tax rates. For example, if a $100 order receives a 5% normal tax rate and a 2% compound tax rate, then the post-tax total is $107.10 ( (100 x 1.05) x 1.02 = 107.1 )

SQL
CREATE VIEW shopify_examples.example_Provinces AS
SELECT *
FROM (
CALL shopify.Provinces (
since_id => NULL,
country_id => 241826398304
)
) AS x;;

RecurringApplicationCharges

Recurring application charges
Parameter
<since_id> (optional): Restrict results to after the specified ID
<recurring_application_charge_id> (optional): Recurring application charge id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the recurring application charge

name

string

The name of the recurring application charge

activated_on

timestamp

The date and time ( ISO 8601 format) when the customer activated the recurring application charge. Note: The recurring application charge must be activated or the returned value is null

api_client_id

string

API client id

billing_on

timestamp

The date and time ( ISO 8601 format) when the customer is billed. Note: The recurring application charge must be accepted or the returned value is null

cancelled_on

timestamp

The date and time ( ISO 8601 format) when the merchant canceled their recurring application charge. Note: Returns null when the recurring application charge is not canceled

confirmation_url

string

The URL where the merchant accepts or declines the recurring application charge

currency

string

The currency of the price of the recurring application charge

decorated_return_url

string

The URL where the merchant is redirected after accepting the charge

price

bigdecimal

The price of the recurring application charge. The maximum price is 10,000

return_url

string

The URL where the merchant is redirected after accepting the charge

status

string

The status of the recurring charge. Valid values: pending : The recurring charge is pending. accepted : Removed in version 2021-01 . The recurring charge has been accepted. As of API version 2021-01, when a merchant accepts a charge, the charge immediately transitions from pending to active . active : The recurring charge is activated. This is the only status that actually causes a merchant to be charged. As of API version 2021-01, when a merchant accepts a charge, the charge immediately transitions from pending to active . declined : The recurring charge has been declined. expired : The recurring charge was not accepted within 2 days of being created. frozen : The recurring charge is on hold due to a shop subscription non-payment. The charge will re-activate once subscription payments resume. cancelled : The developer cancelled the charge

test

boolean

Whether the application charge is a test transaction. Valid values: true , null

trial_days

long

The number of days that the customer is eligible for a free trial

trial_ends_on

timestamp

The date and time ( ISO 8601 format) when the free trial ends

created_at

timestamp

The date and time ( ISO 8601 format) when the recurring application charge was created

updated_at

timestamp

The date and time ( ISO 8601 format) when the recurring application charge was last updated

SQL
CREATE VIEW shopify_examples.example_RecurringApplicationCharges AS
SELECT *
FROM (
CALL shopify.RecurringApplicationCharges (
since_id => NULL
)
) AS x;;

Redirects

URL redirects
Parameter
<path> (optional): Show redirects with a given path
<since_id> (optional): Restrict results to after the specified ID
<target> (optional): Show redirects with a given target
<redirect_id> (optional): Redirect id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the redirect

path

string

The old path to be redirected. When the user visits this path, they will be redirected to the target. (maximum: 1024 characters)

target

string

The target location where the user will be redirected. When the user visits the old path specified by the path property, they will be redirected to this location. This property can be set to any path on the shop's site, or to an external URL. (maximum: 255 characters)

SQL
CREATE VIEW shopify_examples.example_Redirects AS
SELECT *
FROM (
CALL shopify.Redirects (
target => NULL,
since_id => NULL,
path => NULL
)
) AS x;;

Refunds

Refunds for an order
Parameter
<in_shop_currency> (optional): Show amounts in the shop currency for the underlying transaction
<order_id> (optional): Order id
<refund_id> (optional): Refund id
<order_table> (optional): Table with order containing column id(containing order_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique identifier for the refund

note

string

An optional note attached to a refund

order_id

long

The ID for the order that the transaction is associated with

restock

boolean

Whether to add the line items back to the store's inventory

return

boolean

return

total_additional_fees_set_presentment_money_amount

bigdecimal

Total additional fees. Presentment Money Amount

total_additional_fees_set_presentment_money_currency_code

string

Total additional fees. Presentment Money Currency code

total_additional_fees_set_shop_money_amount

bigdecimal

Total additional fees. Shop money Amount

total_additional_fees_set_shop_money_currency_code

string

Total additional fees. Shop money Currency code

total_duties_set_presentment_money_amount

bigdecimal

Total duties. Presentment Money Amount

total_duties_set_presentment_money_currency_code

string

Total duties. Presentment Money Currency code

total_duties_set_shop_money_amount

bigdecimal

Total duties. Shop money Amount

total_duties_set_shop_money_currency_code

string

Total duties. Shop money Currency code

user_id

long

The unique identifier of the user who performed the refund

processed_at

timestamp

The date and time ( ISO 8601 format) when the refund was imported. This value can be set to a date in the past when importing from other systems. If no value is provided, then it will be auto-generated as the current time in Shopify. Public apps need to be granted permission by Shopify to import orders with the processed_at timestamp set to a value earlier the created_at timestamp. Private apps can't be granted permission by Shopify

created_at

timestamp

The date and time ( ISO 8601 format) when the refund was created

SQL
CREATE VIEW shopify_examples.example_Refunds AS
SELECT *
FROM (
CALL shopify.Refunds (
order_id => 5751369924864,
in_shop_currency => NULL
)
) AS x;;

ResourceFeedbacks

ResourceFeedbacks
Parameter
<product_id> (optional): Retrieve feedback for a specific product, by product id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

feedback_generated_at

timestamp

The time at which the payload is constructed. Used to help determine whether incoming feedback is outdated compared to feedback already received, and if it should be ignored upon arrival. Type: ISO 8601 UTC datetime as string with year, month or week, day, hour, minute, second, millisecond, and time zone. Note If you queue a Feedback API payload for delivery at a later time, do not update this value when the API call is actually made; ensure that the current time is set when building the payload

messages

string

A concise set of copy strings to be displayed to merchants, to guide them in resolving problems your app encounters when trying to make use of their Shop and its resources. Required only when state is requires_action . Disallowed when state is success . Content restrictions for Shop feedback: one message up to 100 characters long

resource_id

long

Unique id of the resource

resource_type

string

Type of resource for which feedback is returned. eg. Shop, Product

resource_updated_at

timestamp

DateTime when the resource feedback record was last updated by Shopify. Type: ISO 8601 UTC DateTime as string with year, month (or week), day, hour, minute, second, time zone

state

string

Indicates the state that the Shop or resource is in, from the perspective of your app. Valid values are requires_action , or success

created_at

timestamp

DateTime when the resource feedback record was stored by Shopify. Type: ISO 8601 UTC DateTime as string with year, month (or week), day, hour, minute, second, time zone

updated_at

timestamp

DateTime when the resource feedback record was last updated by Shopify. Type: ISO 8601 UTC DateTime as string with year, month (or week), day, hour, minute, second, time zone

SQL
CREATE VIEW shopify_examples.example_ResourceFeedbacks AS
SELECT *
FROM (
CALL shopify.ResourceFeedbacks ()
) AS x;;

ScriptTags

Script tags
Parameter
<created_at_max> (optional): Show script tags created before this date
<created_at_min> (optional): Show script tags created after this date
<since_id> (optional): Restrict results to after the specified ID
<src> (optional): Show script tags with this URL
<updated_at_max> (optional): Show script tags last updated before this date
<updated_at_min> (optional): Show script tags last updated after this date
<script_tag_id> (optional): Script tag id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the script tag

cache

boolean

Whether the Shopify CDN can cache and serve the script tag. Valid values: true : The script will be cached and served by the CDN. The cache expires 15 minutes after the script tag is successfully returned. false : The script will be served as is. Default value: false

display_scope

string

The page or pages on the online store where the script should be included. Valid values: online_store : Include the script only on the web storefront. order_status : Include the script only on the order status page. all : Include the script on both the web storefront and the order status page

event

string

The DOM event that triggers the loading of the script. Valid values: onload

src

string

The URL of the remote script

created_at

timestamp

The date and time ( ISO 8601 ) when the script tag was created

updated_at

timestamp

The date and time ( ISO 8601 ) when the script tag was last updated

SQL
CREATE VIEW shopify_examples.example_ScriptTags AS
SELECT *
FROM (
CALL shopify.ScriptTags (
updated_at_min => NULL,
updated_at_max => NULL,
src => NULL,
since_id => NULL,
created_at_min => NULL,
created_at_max => NULL
)
) AS x;;

ShippingZones

Shipping Zones
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique numeric identifier for the shipping zone

name

string

The name of the shipping zone, specified by the user

location_group_id

string

The ID of the shipping zone's location group. Location groups allow merchants to create shipping rates that apply only to the specific locations in the group

profile_id

string

The ID of the shipping zone's delivery profile. Shipping profiles allow merchants to create product-based or location-based shipping rates

SQL
CREATE VIEW shopify_examples.example_ShippingZones AS
SELECT *
FROM (
CALL shopify.ShippingZones ()
) AS x;;

Shops

Shop's configuration
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the shop. A 64-bit unsigned integer

name

string

The name of the shop

address1

string

The shop's street address

address2

string

The optional second line of the shop's street address

auto_configure_tax_inclusivity

boolean

The setting for whether applicable taxes are included automatically, based on buyer's location

checkout_api_supported

boolean

Whether the shop is capable of accepting payments directly through the Checkout API

city

string

The shop's city

country

string

The shop's country. In most cases, this value matches the country_code

country_code

string

The two-letter country code corresponding to the shop's country

country_name

string

The shop's normalized country name

county_taxes

boolean

Whether the shop is applying taxes on a per-county basis. Only applicable to shops based in the US. Valid values: true or null ."

currency

string

The three-letter code ( ISO 4217 format) for the shop's default currency

customer_email

string

The contact email used for communication between the shop owner and the customer

domain

string

The shop's domain

eligible_for_payments

boolean

Whether the shop is eligible to use Shopify Payments

email

string

The contact email used for communication between Shopify and the shop owner

enabled_presentment_currencies

boolean

A list of enabled currencies ( ISO 4217 format) that the shop accepts. Merchants can enable currencies from their Shopify Payments settings in the Shopify Admin

google_apps_domain

string

The GSuite URL for the store, if applicable

google_apps_login_enabled

boolean

Whether the GSuite login is enabled. Shops with this feature will be able to log in through the GSuite login page. Valid values: true , null

has_discounts

boolean

Whether any active discounts exist for the shop

has_gift_cards

boolean

Whether any active gift cards exist for the shop

has_storefront

boolean

Whether the shop has an online store

iana_timezone

string

The name of the timezone assigned by the IANA

latitude

bigdecimal

The latitude of the shop's location

longitude

bigdecimal

The longitude of the shop's location

marketing_sms_consent_enabled_at_checkout

boolean

Whether SMS marketing has been enabled on the shop's checkout configuration settings

money_format

string

A string representing the way currency is formatted when the currency isn't specified

money_in_emails_format

string

A string representing the way currency is formatted in email notifications when the currency isn't specified

money_with_currency_format

string

A string representing the way currency is formatted when the currency is specified

money_with_currency_in_emails_format

string

A string representing the way currency is formatted in email notifications when the currency is specified

multi_location_enabled

boolean

This field has been deprecated, and is currently unused. Hardcoded to true

myshopify_domain

string

The shop's .myshopify.com domain

password_enabled

boolean

Whether the password protection page is enabled on the shop's online store

phone

string

The contact phone number for the shop

plan_display_name

string

The display name of the Shopify plan the shop is on

plan_name

string

The name of the Shopify plan the shop is on

pre_launch_enabled

boolean

Whether the pre-launch page is enabled on the shop's online store

primary_locale

string

The shop's primary locale, as configured in the language settings of the shop's theme

primary_location_id

long

Formerly used for the ID of the shipping origin location (read only)

province

string

The shop's normalized province or state name

province_code

string

The two- or three-letter code for the shop's province or state

requires_extra_payments_agreement

boolean

Whether the shop requires an extra Shopify Payments agreement

setup_required

boolean

Whether the shop has any outstanding setup steps

shop_owner

string

The username of the shop owner

source

string

The handle of the partner account that referred the merchant to Shopify, if applicable

tax_shipping

boolean

Whether taxes are charged for shipping. Valid values: true or false

taxes_included

boolean

Whether applicable taxes are included in product prices. Valid values: true or null

timezone

string

The name of the timezone the shop is in

transactional_sms_disabled

boolean

Whether transactional SMS sent by Shopify are disabled on the shop's online store

weight_unit

string

The default unit of weight measurement for the shop

zip

string

The shop's zip or postal code

created_at

timestamp

The date and time ( ISO 8601 ) when the shop was created

updated_at

timestamp

The date and time ( ISO 8601 ) when the shop was last updated

SQL
CREATE VIEW shopify_examples.example_Shops AS
SELECT *
FROM (
CALL shopify.Shops ()
) AS x;;

SmartCollections

Smart collections
Parameter
<handle> (optional): Filter results by smart collection handle
<ids> (optional): Show only the smart collections specified by a comma-separated list of IDs
<product_id> (optional): Show smart collections that includes the specified product
<published_at_max> (optional): Show smart collections published before this date
<published_at_min> (optional): Show smart collections published after this date
<published_status> (optional): Filter results based on the published status of smart collections
<since_id> (optional): Restrict results to after the specified ID
<title> (optional): Show smart collections with the specified title
<updated_at_max> (optional): Show smart collections last updated before this date
<updated_at_min> (optional): Show smart collections last updated after this date
<smart_collection_id> (optional): Smart collection id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the smart collection

title

string

The name of the smart collection. Maximum length: 255 characters

body_html

string

The description of the smart collection. Includes HTML markup. Many shop themes display this on the smart collection page

disjunctive

boolean

Whether the product must match all the rules to be included in the smart collection. Valid values: true : Products only need to match one or more of the rules to be included in the smart collection. false : Products must match all of the rules to be included in the smart collection

handle

string

A human-friendly unique string for the smart collection. Automatically generated from the title . Used in shop themes by the Liquid templating language to refer to the smart collection. (maximum: 255 characters)

image_alt

string

Image alt attribute

image_created_at

timestamp

The date and time when the product image was created

image_height

integer

Height dimension of the image

image_src

string

Specifies the location of the product image

image_width

integer

Width dimension of the image

published_at

timestamp

The date and time ( ISO 8601 format ) that the smart collection was published. Returns null when the collection is hidden

published_scope

string

Whether the smart collection is published to the Point of Sale channel. Valid values: web : The smart collection is published to the Online Store channel but not published to the Point of Sale channel. global : The smart collection is published to both the Online Store channel and the Point of Sale channel

rules

string

Rules

sort_order

string

The order of the products in the smart collection. Valid values: alpha-asc : The products are sorted alphabetically from A to Z. alpha-des : The products are sorted alphabetically from Z to A. best-selling : The products are sorted by number of sales. created : The products are sorted by the date they were created, from oldest to newest. created-desc : The products are sorted by the date they were created, from newest to oldest. manual : The products are manually sorted by the shop owner. price-asc : The products are sorted by price from lowest to highest. price-desc : The products are sorted by price from highest to lowest

template_suffix

string

The suffix of the Liquid template that the shop uses. By default, the original template is called product.liquid, and additional templates are called product. suffix .liquid

updated_at

timestamp

The date and time ( ISO 8601 format ) when the smart collection was last modified

SQL
CREATE VIEW shopify_examples.example_SmartCollections AS
SELECT *
FROM (
CALL shopify.SmartCollections (
updated_at_min => NULL,
updated_at_max => NULL,
title => NULL,
since_id => NULL,
published_status => NULL,
published_at_min => NULL,
published_at_max => NULL,
product_id => NULL,
ids => NULL,
handle => NULL
)
) AS x;;

StorefrontAccessTokens

Storefront access tokens that have been issued
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

Unique id that identifies a token and is used to perform operations on it

title

string

An arbitrary title for each token determined by the developer/application, used for reference purposes. Note No constraint on uniqueness

access_scope

string

An application-dependant, comma separated list of permissions associated with the token

access_token

string

The issued public access token

created_at

timestamp

The date and time when the public access token was created. The API returns this value in ISO 8601 format

SQL
CREATE VIEW shopify_examples.example_StorefrontAccessTokens AS
SELECT *
FROM (
CALL shopify.StorefrontAccessTokens ()
) AS x;;

TenderTransactions

Tender transactions
Parameter
<processed_at> (optional): Show tender transactions processed at the specified date
<processed_at_max> (optional): Show tender transactions processed_at or before the specified date
<processed_at_min> (optional): Show tender transactions processed_at or after the specified date
<since_id> (optional): Retrieve only transactions after the specified ID
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the transaction

amount

bigdecimal

The amount of the tender transaction in the shop's currency

currency

string

The three-letter code ( ISO 4217 format) for the currency used for the tender transaction

order_id

long

The ID of the order that the tender transaction belongs to

payment_details_credit_card_company

string

The name of the company that issued the customer's credit card

payment_details_credit_card_number

string

The customer's credit card number, with most of the leading digits redacted

payment_method

string

Information about the payment method used for this transaction. Valid values: credit_card cash android_pay apple_pay google_pay samsung_pay shopify_pay amazon klarna paypal unknown other

remote_reference

string

The remote (gateway) reference associated with the tender

test

boolean

Whether the tender transaction is a test transaction

user_id

long

The ID of the user logged into the Shopify POS device that processed the tender transaction, if applicable

processed_at

timestamp

The date and time ( ISO 8601 format) when the tender transaction was processed

SQL
CREATE VIEW shopify_examples.example_TenderTransactions AS
SELECT *
FROM (
CALL shopify.TenderTransactions (
since_id => NULL,
processed_at_min => NULL,
processed_at_max => NULL,
processed_at => NULL
)
) AS x;;

Themes

Themes
Parameter
<theme_id> (optional): Theme id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The unique numeric identifier for the theme

name

string

The name of the theme

previewable

boolean

Whether the theme can currently be previewed

processing

boolean

Whether files are still being copied into place for this theme

role

string

Specifies how the theme is being used within the shop. Valid values: main : The theme is published. Customers see it when they visit the online store. unpublished : The theme is unpublished. Customers can't see it. demo : The theme is installed on the store as a demo. The theme can't be published until the merchant buys the full version. development : The theme is used for development. The theme can't be published, and is temporary

theme_store_id

long

A unique identifier applied to Shopify-made themes that are installed from the Shopify Theme Store Theme Store. Not all themes available in the Theme Store are developed by Shopify. Returns null if the store's theme isn't made by Shopify, or if it wasn't installed from the Theme Store

created_at

timestamp

The date and time when the theme was created. (format: 2014-04-25T16:15:47-04:00)

updated_at

timestamp

The date and time of when the theme was last updated. (format: 2014-04-25T16:15:47-04:00)

SQL
CREATE VIEW shopify_examples.example_Themes AS
SELECT *
FROM (
CALL shopify.Themes ()
) AS x;;

Transactions

Transactions
Parameter
<in_shop_currency> (optional): Show amounts in the shop currency
<order_id> (optional): Order id
<since_id> (optional): Retrieve only transactions after the specified ID
<transaction_id> (optional): Transaction id
<order_table> (optional): Table with order containing column id(containing order_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID for the transaction

amount

bigdecimal

The amount of money included in the transaction. If you don't provide a value for 'amount', then it defaults to the total cost of the order (even if a previous transaction has been made towards it)

authorization

string

The authorization code associated with the transaction

currency

string

The three-letter code ( ISO 4217 format) for the currency used for the payment

currency_exchange_adjustment

bigdecimal

Currency exchange adjustment

device_id

long

The ID for the device

error_code

string

A standardized error code, independent of the payment provider. Valid values: incorrect_number invalid_number invalid_expiry_date invalid_cvc expired_card incorrect_cvc incorrect_zip incorrect_address card_declined processing_error call_issuer pick_up_card

gateway

string

The name of the gateway the transaction was issued through. A list of gateways can be found on Shopify's payment gateways page

kind

string

The transaction's type. Valid values: authorization : Money that the customer has agreed to pay. The authorization period can be between 7 and 30 days (depending on your payment service) while a store waits for a payment to be captured. capture : A transfer of money that was reserved during the authorization of a shop. sale : The authorization and capture of a payment performed in one single step. void : The cancellation of a pending authorization or capture. refund : The partial or full return of captured money to the customer

location_id

long

The ID of the physical location where the transaction was processed

manual_payment_gateway

string

The name of the gateway the transaction was issued through. A list of gateways can be found on Shopify's payment gateways page

message

string

A string generated by the payment provider with additional information about why the transaction succeeded or failed

order_id

long

The ID for the order that the transaction is associated with

parent_id

long

The ID of an associated transaction. For capture transactions, the parent needs to be an authorization transaction. For void transactions, the parent needs to be an authorization transaction. For refund transactions, the parent needs to be a capture or sale transaction

payment_details_avs_result_code

string

The response code from the address verification system. The code is always a single letter

payment_details_buyer_action_info

string

Details for payment methods that require additional buyer action to complete the order transaction

payment_details_credit_card_bin

string

Credit card bin

payment_details_credit_card_company

string

The name of the company that issued the customer's credit card

payment_details_credit_card_expiration_month

integer

The month in which the credit card expires

payment_details_credit_card_expiration_year

integer

The year in which the credit card expires

payment_details_credit_card_name

string

The holder of the credit card

payment_details_credit_card_number

string

The customer's credit card number, with most of the leading digits redacted

payment_details_credit_card_wallet

string

The wallet type where this credit card was retrieved from

payment_details_cvv_result_code

string

The response code from the credit card company indicating whether the customer entered the card security code , or card verification value, correctly. The code is a single letter or empty string

payment_details_payment_method_name

string

The name of the payment method used by the buyer to complete the order transaction

payment_id

string

Payment id

receipt_amount

bigdecimal

The amount of money included in the transaction. If you don't provide a value for 'amount', then it defaults to the total cost of the order (even if a previous transaction has been made towards it)

receipt_amount_capturable

bigdecimal

Amount capturable

receipt_amount_received

bigdecimal

Amount received

receipt_authorization

string

The authorization code associated with the transaction

receipt_canceled_at

timestamp

Canceled at

receipt_cancellation_reason

string

Cancellation reason

receipt_capture_method

string

Capture method

receipt_charges_has_more

boolean

Has more

receipt_charges_object

string

Charges object

receipt_charges_total_count

bigdecimal

Charges total count

receipt_charges_url

string

Charges URL

receipt_confirmation_method

string

Confirmation method

receipt_created

timestamp

Created

receipt_currency

string

The three-letter code ( ISO 4217 format) for the currency used for the payment

receipt_error_charge

string

Error charge

receipt_error_code

string

A standardized error code, independent of the payment provider. Valid values: incorrect_number invalid_number invalid_expiry_date invalid_cvc expired_card incorrect_cvc incorrect_zip incorrect_address card_declined processing_error call_issuer pick_up_card

receipt_error_decline_code

string

Decline code

receipt_error_message

string

A string generated by the payment provider with additional information about why the transaction succeeded or failed

receipt_error_payment_intent_amount

bigdecimal

The amount of money included in the transaction. If you don't provide a value for 'amount', then it defaults to the total cost of the order (even if a previous transaction has been made towards it)

receipt_error_payment_intent_amount_capturable

bigdecimal

Payment intent amount capturable

receipt_error_payment_intent_amount_received

bigdecimal

Payment intent amount received

receipt_error_payment_intent_canceled_at

timestamp

Payment intent canceled at

receipt_error_payment_intent_cancellation_reason

string

Payment intent cancellation reason

receipt_error_payment_intent_capture_method

string

Error payment intent capture_method

receipt_error_payment_intent_charges_has_more

boolean

Error payment intent charges_has_more

receipt_error_payment_intent_charges_object

string

Error payment intent charges_object

receipt_error_payment_intent_charges_total_count

integer

Error payment intent charges_total_count

receipt_error_payment_intent_charges_url

string

Error payment intent charges_url

receipt_error_payment_intent_confirmation_method

string

Error payment intent confirmation_method

receipt_error_payment_intent_created

timestamp

Error payment intent created

receipt_error_payment_intent_currency

string

The three-letter code ( ISO 4217 format) for the currency used for the payment

receipt_error_payment_intent_id

string

Payment intent id

receipt_error_payment_intent_last_payment_error_charge

string

Error payment intent last_payment_error_charge

receipt_error_payment_intent_last_payment_error_code

string

A standardized error code, independent of the payment provider. Valid values: incorrect_number invalid_number invalid_expiry_date invalid_cvc expired_card incorrect_cvc incorrect_zip incorrect_address card_declined processing_error call_issuer pick_up_card

receipt_error_payment_intent_last_payment_error_decline_code

string

Error payment intent last_payment_error_decline_code

receipt_error_payment_intent_last_payment_error_doc_url

string

Error payment intent last_payment_error_doc_url

receipt_error_payment_intent_last_payment_error_message

string

A string generated by the payment provider with additional information about why the transaction succeeded or failed

receipt_error_payment_intent_last_payment_error_payment_method_card_brand

string

Error payment intent last_payment_error_payment_method_card_brand

receipt_error_payment_intent_last_payment_error_payment_method_card_checks_address_line1_check

string

Error payment intent last_payment_error_payment_method_card_checks_address_line1_check

receipt_error_payment_intent_last_payment_error_payment_method_card_checks_address_postal_code_check

string

Error payment intent last_payment_error_payment_method_card_checks_address_postal_code_check

receipt_error_payment_intent_last_payment_error_payment_method_card_checks_cvc_check

string

Error payment intent last_payment_error_payment_method_card_checks_cvc_check

receipt_error_payment_intent_last_payment_error_payment_method_card_country

string

Error payment intent last_payment_error_payment_method_card_country

receipt_error_payment_intent_last_payment_error_payment_method_card_description

string

Error payment intent last_payment_error_payment_method_card_description

receipt_error_payment_intent_last_payment_error_payment_method_card_display_brand

string

Error payment intent last_payment_error_payment_method_card_display_brand

receipt_error_payment_intent_last_payment_error_payment_method_card_exp_month

integer

Error payment intent last_payment_error_payment_method_card_exp_month

receipt_error_payment_intent_last_payment_error_payment_method_card_exp_year

integer

Error payment intent last_payment_error_payment_method_card_exp_year

receipt_error_payment_intent_last_payment_error_payment_method_card_fingerprint

string

Error payment intent last_payment_error_payment_method_card_fingerprint

receipt_error_payment_intent_last_payment_error_payment_method_card_funding

string

Error payment intent last_payment_error_payment_method_card_funding

receipt_error_payment_intent_last_payment_error_payment_method_card_generated_from

string

Error payment intent last_payment_error_payment_method_card_generated_from

receipt_error_payment_intent_last_payment_error_payment_method_card_iin

string

Error payment intent last_payment_error_payment_method_card_iin

receipt_error_payment_intent_last_payment_error_payment_method_card_issuer

string

Error payment intent last_payment_error_payment_method_card_issuer

receipt_error_payment_intent_last_payment_error_payment_method_card_last4

string

Error payment intent last_payment_error_payment_method_card_last4

receipt_error_payment_intent_last_payment_error_payment_method_card_network_token

string

Error payment intent last_payment_error_payment_method_card_network_token

receipt_error_payment_intent_last_payment_error_payment_method_card_networks_available

string

Error payment intent last_payment_error_payment_method_card_networks_available

receipt_error_payment_intent_last_payment_error_payment_method_card_networks_preferred

string

Error payment intent last_payment_error_payment_method_card_networks_preferred

receipt_error_payment_intent_last_payment_error_payment_method_card_payment_account_reference

string

Error payment intent last_payment_error_payment_method_card_payment_account_reference

receipt_error_payment_intent_last_payment_error_payment_method_card_three_d_secure_usage_supported

boolean

Error payment intent last_payment_error_payment_method_card_three_d_secure_usage_supported

receipt_error_payment_intent_last_payment_error_payment_method_card_wallet

string

Error payment intent last_payment_error_payment_method_card_wallet

receipt_error_payment_intent_last_payment_error_payment_method_created

string

Error payment intent last_payment_error_payment_method_created

receipt_error_payment_intent_last_payment_error_payment_method_id

string

Payment method id

receipt_error_payment_intent_last_payment_error_payment_method_livemode

string

Error payment intent payment_error_payment_method_livemode

receipt_error_payment_intent_last_payment_error_payment_method_metadata

string

Error payment intent last_payment_error_payment_method_metadata

receipt_error_payment_intent_last_payment_error_payment_method_object

string

Error payment intent last_payment_error_payment_method_object

receipt_error_payment_intent_last_payment_error_payment_method_type

string

Error payment intent last_payment_error_payment_method_type

receipt_error_payment_intent_last_payment_error_type

string

Error payment intent last_payment_error_type

receipt_error_payment_intent_livemode

boolean

Error payment intent live mode

receipt_error_payment_intent_metadata_email

string

Error payment intent metadata_email

receipt_error_payment_intent_metadata_manual_entry

string

Error payment intent metadata_manual_entry

receipt_error_payment_intent_metadata_order_id

string

The ID for the order that the transaction is associated with

receipt_error_payment_intent_metadata_order_transaction_id

string

Order transaction id

receipt_error_payment_intent_metadata_payments_charge_id

string

Payments charge id

receipt_error_payment_intent_metadata_shop_id

long

An ID for the shop

receipt_error_payment_intent_metadata_shop_name

string

Error payment intent metadata_shop_name

receipt_error_payment_intent_next_action

string

Error payment intent next_action

receipt_error_payment_intent_object

string

Error payment intent object

receipt_error_payment_intent_payment_method

string

Error payment intent payment_method

receipt_error_payment_intent_payment_method_types

string

Error payment intent payment_method_types

receipt_error_payment_intent_source

string

Error payment intent source

receipt_error_payment_intent_status

string

The status of the transaction. Valid values: pending , failure , success , and error

receipt_error_type

string

Error type

receipt_id

string

Receipt id

receipt_last_payment_error

string

Last payment error

receipt_livemode

boolean

Live mode

receipt_metadata_email

string

Metadata email

receipt_metadata_manual_entry

boolean

Metadata manual entry

receipt_metadata_order_id

string

The ID for the order that the transaction is associated with

receipt_metadata_order_transaction_id

string

Order transaction id

receipt_metadata_payments_charge_id

string

Payments charge id

receipt_metadata_shop_id

long

An ID for the shop

receipt_metadata_shop_name

string

Metadata shop name

receipt_next_action

string

Next action

receipt_object

string

Object

receipt_payment_method

string

Payment method

receipt_payment_method_types

string

Payment method types

receipt_source

string

Source

receipt_status

string

The status of the transaction. Valid values: pending , failure , success , and error

receipt_testcase

boolean

Testcase

source_name

string

The origin of the transaction. This is set by Shopify and can't be overridden. Example values (not an exhaustive list): web , pos , iphone , and android

status

string

The status of the transaction. Valid values: pending , failure , success , and error

test

boolean

Whether the transaction is a test transaction

total_unsettled_set_presentment_money_amount

bigdecimal

The amount of money included in the transaction. If you don't provide a value for 'amount', then it defaults to the total cost of the order (even if a previous transaction has been made towards it)

total_unsettled_set_presentment_money_currency

string

The three-letter code ( ISO 4217 format) for the currency used for the payment

total_unsettled_set_shop_money_amount

bigdecimal

The amount of money included in the transaction. If you don't provide a value for 'amount', then it defaults to the total cost of the order (even if a previous transaction has been made towards it)

total_unsettled_set_shop_money_currency

string

The three-letter code ( ISO 4217 format) for the currency used for the payment

user_id

long

The ID for the user who was logged into the Shopify POS device when the order was processed, if applicable

processed_at

timestamp

The date and time ( ISO 8601 format) when a transaction was processed. This value is the date that's used in the analytic reports. By default, it matches the created_at value. If you're importing transactions from an app or another platform, then you can set processed_at to a date and time in the past to match when the original transaction was processed

created_at

timestamp

The date and time ( ISO 8601 format) when the transaction was created

SQL
CREATE VIEW shopify_examples.example_Transactions AS
SELECT *
FROM (
CALL shopify.Transactions (
since_id => NULL,
order_id => 5751369924864,
in_shop_currency => NULL
)
) AS x;;

UsageCharges

Usage charges
Parameter
<recurring_application_charge_id> (optional): Recurring application charge id
<usage_charge_id> (optional): Usage charge id
<recurring_application_charge_table> (optional): Table with recurring_application_charge containing column id(containing recurring_application_charge_id) of type long
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the usage charge

balance_remaining

bigdecimal

Balance remaining

balance_used

bigdecimal

Balance used

currency

string

The currency of the price of the usage charge

description

string

The description of the usage charge

price

bigdecimal

The price of the usage charge

risk_level

bigdecimal

Risk level

created_at

timestamp

The date and time ( ISO 8601 format) when the usage charge was created

SQL
CREATE VIEW shopify_examples.example_UsageCharges AS
SELECT *
FROM (
CALL shopify.UsageCharges (
recurring_application_charge_id => NULL
)
) AS x;;

UserCurrent

Currently logged-in user
Parameter
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the user's staff

account_owner

boolean

Whether the user is the owner of the Shopify account

bio

string

The description the user has written for themselves

email

string

The user's email address

first_name

string

The user's first name

im

string

This property is deprecated

last_name

string

The user's last name

locale

string

The user's preferred locale. Locale values use the format language or language-COUNTRY , where language is a two-letter language code, and COUNTRY is a two-letter country code. For example: en or en-US

permissions

string

The permissions granted to the user's staff account. Valid values: applications : The user can authorize the installation of applications. billing_application_charges : The user can approve application charges. billing_charges : The user can view and export billing charges. billing_invoices_view : The user can view billing invoices. billing_payment_methods_view : The user can view billing payment methods. customers : The user can view, create, edit, and delete customers, and respond to customer messages in Shopify Ping. dashboard : The user can view the Home page, which includes sales information and other store data. domains : The user can view, buy, and manage domains. draft_orders : The user can create, update, and delete draft orders. edit_orders : The user can edit orders. edit_private_apps : The user can give permission to private apps to read, write, and make changes to the store. export_customers : The user can export customers. export_draft_orders : The user can export draft orders. export_products : The user can export products and inventory. export_orders : The user can export orders. gift_cards : The user can view, create, issue, and export gift cards to a CSV file. links : The user can view and modify links and navigation menus. locations : The user can create, update, and delete locations where you stock or manage inventory. marketing : The user can view and create discount codes and automatic discounts, and export discounts to a CSV file. marketing_section : The user can view, create, and automate marketing campaigns. orders : The user can view, create, update, delete, and cancel orders, and receive order notifications. overviews : The user can view the Overview and Live view pages, which include sales information, and other store and sales channels data. pages : The user can view, create, update, publish, and delete blog posts and pages. preferences : The user can view the preferences and configuration of a shop. products : The user can view, create, import, and update products, collections, and inventory. reports : The user can view and create all reports, which includes sales information and other store data. shopify_payments_accounts : The user can view Shopify Payments account details. shopify_payments_transfers : The user can view Shopify Payments payouts. staff_audit_log_view : The user can view Shopify admin browser sessions. staff_management_activation : The user can activate or deactivate staff in the store. staff_management_create : The user can add staff to the store. staff_management_delete : The user can delete staff from the store. staff_management_update : The user can update staff in the store. themes : The user can view, update, and publish themes. view_private_apps : The user can view private apps installed on the store

phone

string

The user's phone number

receive_announcements

long

Whether this account will receive email announcements from Shopify. Valid values: 0 , 1

screen_name

string

This property is deprecated

tfa_enabled

boolean

TFA enabled

url

string

The user's homepage or other web address

user_type

string

The type of account the user has. Valid values: regular : The user's account can access the Shopify admin. restricted : The user's account cannot access the Shopify admin. invited : The user has not yet accepted the invitation to create staff. collaborator : The user account of a partner who collaborates with the merchant

SQL
CREATE VIEW shopify_examples.example_UserCurrent AS
SELECT *
FROM (
CALL shopify.UserCurrent ()
) AS x;;

Users

Users
Parameter
<user_id> (optional): User id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

The ID of the user's staff

account_owner

boolean

Whether the user is the owner of the Shopify account

bio

string

The description the user has written for themselves

email

string

The user's email address

first_name

string

The user's first name

im

string

This property is deprecated

last_name

string

The user's last name

locale

string

The user's preferred locale. Locale values use the format language or language-COUNTRY , where language is a two-letter language code, and COUNTRY is a two-letter country code. For example: en or en-US

permissions

string

The permissions granted to the user's staff account. Valid values: applications : The user can authorize the installation of applications. billing_application_charges : The user can approve application charges. billing_charges : The user can view and export billing charges. billing_invoices_view : The user can view billing invoices. billing_payment_methods_view : The user can view billing payment methods. customers : The user can view, create, edit, and delete customers, and respond to customer messages in Shopify Ping. dashboard : The user can view the Home page, which includes sales information and other store data. domains : The user can view, buy, and manage domains. draft_orders : The user can create, update, and delete draft orders. edit_orders : The user can edit orders. edit_private_apps : The user can give permission to private apps to read, write, and make changes to the store. export_customers : The user can export customers. export_draft_orders : The user can export draft orders. export_products : The user can export products and inventory. export_orders : The user can export orders. gift_cards : The user can view, create, issue, and export gift cards to a CSV file. links : The user can view and modify links and navigation menus. locations : The user can create, update, and delete locations where you stock or manage inventory. marketing : The user can view and create discount codes and automatic discounts, and export discounts to a CSV file. marketing_section : The user can view, create, and automate marketing campaigns. orders : The user can view, create, update, delete, and cancel orders, and receive order notifications. overviews : The user can view the Overview and Live view pages, which include sales information, and other store and sales channels data. pages : The user can view, create, update, publish, and delete blog posts and pages. preferences : The user can view the preferences and configuration of a shop. products : The user can view, create, import, and update products, collections, and inventory. reports : The user can view and create all reports, which includes sales information and other store data. shopify_payments_accounts : The user can view Shopify Payments account details. shopify_payments_transfers : The user can view Shopify Payments payouts. staff_audit_log_view : The user can view Shopify admin browser sessions. staff_management_activation : The user can activate or deactivate staff in the store. staff_management_create : The user can add staff to the store. staff_management_delete : The user can delete staff from the store. staff_management_update : The user can update staff in the store. themes : The user can view, update, and publish themes. view_private_apps : The user can view private apps installed on the store

phone

string

The user's phone number

receive_announcements

long

Whether this account will receive email announcements from Shopify. Valid values: 0 , 1

screen_name

string

This property is deprecated

tfa_enabled

boolean

TFA enabled

url

string

The user's homepage or other web address

user_type

string

The type of account the user has. Valid values: regular : The user's account can access the Shopify admin. restricted : The user's account cannot access the Shopify admin. invited : The user has not yet accepted the invitation to create staff. collaborator : The user account of a partner who collaborates with the merchant

SQL
CREATE VIEW shopify_examples.example_Users AS
SELECT *
FROM (
CALL shopify.Users ()
) AS x;;

Webhooks

Webhooks
Parameter
<address> (optional): Retrieve webhook subscriptions that send the POST request to this URI
<created_at_max> (optional): Retrieve webhook subscriptions that were created before a given date and time (format: 2014-04-25T16:15:47-04:00)
<created_at_min> (optional): Retrieve webhook subscriptions that were created after a given date and time (format: 2014-04-25T16:15:47-04:00)
<since_id> (optional): Restrict the returned list to webhook subscriptions whose id is greater than the specified since_id
<topic> (optional): Show webhook subscriptions with a given topic. For valid values, refer to the list of event topics
<updated_at_max> (optional): Retrieve webhooks that were updated after a given date and time (format: 2014-04-25T16:15:47-04:00)
<updated_at_min> (optional): Retrieve webhooks that were updated before a given date and time (format: 2014-04-25T16:15:47-04:00)
<webhook_id> (optional): Webhook id
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

id

long

Unique numeric identifier for the webhook subscription

address

string

Destination URI to which the webhook subscription should send the POST request when an event occurs

api_version

string

The Admin API version that Shopify uses to serialize webhook events. This value is inherited from the app that created the webhook subscription

format

string

Format in which the webhook subscription should send the data. Valid values are JSON and XML . Defaults to JSON

topic

string

Event that triggers the webhook. You can retrieve data in either JSON or XML. See list of webhook events

created_at

timestamp

Date and time when the webhook subscription was created. The API returns this value in ISO 8601 format

updated_at

timestamp

Date and time when the webhook subscription was updated. The API returns this value in ISO 8601 format

SQL
CREATE VIEW shopify_examples.example_Webhooks AS
SELECT *
FROM (
CALL shopify.Webhooks (
updated_at_min => NULL,
updated_at_max => NULL,
topic => NULL,
since_id => NULL,
created_at_min => NULL,
created_at_max => NULL,
address => NULL
)
) AS x;;
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.