接続の確立

Sync App アプリケーションの接続ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Shopify への接続を作成します。Shopify アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからShopify コネクタをダウンロードおよびインストールします。

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

Shopify への接続

すべてのケースで、Shopify ショップの完全URL に設定する必要があります（https://yourshopname.myshopify.com）。以下のドキュメントは、すでに設定済みであることを前提として書かれています。

アクセストークン

カスタムアプリの作成

認証の前に、Shopify の管理画面からカスタムアプリを作成する必要があります。アプリを登録してアクセストークンを取得する方法は、次のとおりです。

管理画面からShopify にログインしApps -> Apps and sales channels に進みます。
Develop apps をクリックしてCreate an app を選択します。
Overview タブで、Configure Admin API scopes をクリックし、アプリに許可するストアのアクセス権を選択します。プロバイダーがすべてのテーブルとビューを使用するために必要な権限は次のとおりです。
- read_assigned_fulfillment_orders, write_assigned_fulfillment_orders
- read_content, write_content
- read_customers, write_customers
- read_draft_orders, write_draft_orders
- read_fulfillments, write_fulfillments
- read_gift_cards, write_gift_cards
- read_inventory, write_inventory
- read_marketing_events, write_marketing_events
- read_orders, write_orders
- read_price_rules, write_price_rules
- read_product_listings, write_product_listings
- read_products, write_products
- read_reports, write_reports
- read_script_tags, write_script_tags
- read_shopify_payments_payouts
- read_themes, write_themes
Save をクリックします。
API Credentials を選択します。
"Access tokens" の下でInstall app をクリックします。これでアクセストークンが作成されます。
Admin API Access token のアクセストークンをコピーします。NOTE：トークンの公開およびコピーは1回のみ可能です。

アクセストークン

アクセストークンで認証するには、次を設定します。

AuthScheme：AccessToken に設定。
AccessToken：カスタムアプリからコピーしたアクセストークンの値に設定。

OAuth

OAuth を使って接続するには、Shopify パートナーダッシュボードでパブリックアプリまたはカスタムアプリの作成が必要です。この処理中に、API key とAPI secret key の値が生成されます。これらのキーは、カスタムアプリケーションを使用して接続するときに必要です。手順については、カスタムOAuth アプリの作成を参照してください。

Note： AuthScheme をOAuth に設定する必要があります。以下のセクションは、すでに設定済みであることを前提として書かれています。設定されていない場合、接続できません。

デスクトップ認証

カスタムアプリケーションを作成し、クライアントId およびクライアントシークレットプロパティを指定する必要があります。

以下を設定して、接続してください。

InitiateOAuth：GETANDREFRESH に設定。InitiateOAuth を使って、OAuth 交換や、手動でのOAuthAccessToken 接続プロパティの設定の繰り返しを避けられます。
OAuthClientId：アプリのAPI キーの値に設定。
OAuthClientSecret：アプリのAPI シークレットキーの値に設定。
CallbackURL：アプリの登録時に定義されたリダイレクトURI に設定。

接続すると、Sync App はデフォルトブラウザでOAuth エンドポイントを開きます。ログインして、アプリケーションにアクセス許可を与えます。Sync App は接続間で持続するOAuthSettingsLocation にOAuth 値を保存し、古いトークンの期限が切れたときは新しいアクセストークンを取得することで、OAuth プロセスを完了します。

カスタムOAuth アプリでのWeb 認証

Web アプリケーション経由で接続する場合は、Shopify にカスタムOAuth アプリを登録する必要があります。それからSync App を使用してOAuth トークンの値を取得および管理します。

OAuth アクセストークンの取得

次の接続プロパティを設定し、OAuthAccessToken を取得します。

OAuthClientId：アプリのAPI キーの値に設定。
OAuthClientSecret：アプリのAPI シークレットキーの値に設定。

続いてストアドプロシージャを呼び出し、OAuth 交換を完了します。

GetOAuthAuthorizationURL ストアドプロシージャを呼び出します。AuthMode インプットをWEB に、CallbackURL インプットをアプリ設定で指定したリダイレクトURI に設定します。ストアドプロシージャがOAuth エンドポイントのURL を返します。
ログインして、アプリケーションを認可します。コールバックURL にリダイレクトされます。
GetOAuthAccessToken ストアドプロシージャを呼び出します。AuthMode インプットをWEB に設定します。Verifier インプットを、コールバックURL のクエリ文字列の"code" パラメータに設定します。

ヘッドレスマシン

ヘッドレスサーバーや、Sync App がブラウザを開くことができないその他のマシンにShopify データソースを作成するには、別のマシンから認証を行う必要があります。認証は、2段階認証プロセスになります。

Sync App を別のマシンにインストールする代わりに、次の手順に従ってOAuthVerifier 値を取得できます。または、別のマシンにSync App をインストールし、通常のブラウザベースのフローで認証した後でOAuth 認証値を転送することもできます。
その後、ヘッドレスマシンからアクセストークンを自動的にリフレッシュするようにSync App を設定します。

カスタムOAuth アプリのOAuth クレデンシャルを使用して、ヘッドレスOAuth 認証フローに従うことができます。

カスタムOAuth アプリの作成

手順については、カスタムOAuth アプリの作成を参照してください。下記の手順に従って、データの認証および接続を行うことができます。

Verifier code を取得

ヘッドレスマシンで次のプロパティを設定します。

InitiateOAuth：OFF に設定。
OAuthClientId：API キーに設定。
OAuthClientSecret：API シークレットキーに設定。

別のマシンから認証してOAuthVerifier 接続プロパティを取得する方法は次のとおりです。

CallbackURL 入力パラメータを、アプリ設定で指定した正確なリダイレクトURI に設定して、GetOAuthAuthorizationURL ストアドプロシージャを呼び出します。
返されたURL をブラウザで開きます。ログインして、Sync App にアクセス許可を与えます。すると、verifier code を含むコールバックURL にリダイレクトされます。
verifier code の値を保存します。これをOAuthVerifier 接続プロパティに設定します。

ヘッドレスマシンでは、次の接続プロパティを設定してOAuth 認証値を取得します。

OAuthClientId：API キーに設定。
OAuthClientSecret：API シークレットキーに設定。
OAuthVerifier：verifier code に設定。
OAuthSettingsLocation：これを設定すると、暗号化されたOAuth 認証値が指定されたファイルに永続化されます。
InitiateOAuth：REFRESH に設定。

OAuth 設定ファイルが生成されたら、次のプロパティを設定してデータに接続します。

OAuthClientId：API キーに設定。
OAuthClientSecret：API シークレットキーに設定。
OAuthSettingsLocation：暗号化されたOAuth 認証値を含むファイルに設定。アクセストークンの自動リフレッシュを有効にするために、このファイルがSync App に読み書きのアクセス許可を与えることを確認してください。
InitiateOAuth：REFRESH に設定。

OAuth 設定を転送

別のマシンにSync App をインストールして認証し、結果のOAuth 値を転送する方法は次のとおりです。

セカンドマシンに、Sync App をインストールして、次の接続プロパティセットで接続します。

OAuthSettingsLocation：書き込み可能なテキストファイルのパスに設定。
OAuthClientId：アプリのAPI キーの値に設定。
OAuthClientSecret：アプリのAPI シークレットキーの値に設定。
CallbackURL：アプリケーション設定で指定したリダイレクトURI に設定。

認証する接続をテストします。生成された認証値は、OAuthSettingsLocation で指定されたパスに暗号化されて書き込まれます。接続テストに成功したら、OAuth 設定ファイルをヘッドレスマシンにコピーします。ヘッドレスマシンで、次の接続プロパティを設定し、データに接続します。

InitiateOAuth：REFRESH に設定。
OAuthClientId：アプリのAPI キーの値に設定。
OAuthClientSecret：アプリのAPI シークレットキーの値に設定。
OAuthSettingsLocation：OAuth 設定ファイルのパスに設定。アクセストークンの自動リフレッシュを有効にするために、このファイルがSync App に読み書きのアクセス許可を与えることを確認してください。

高度な機能

このセクションでは、Shopify Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App を使用すると、事前設定されたクエリによって内容が決定されるユーザー定義ビューと呼ばれる仮想テーブルを定義できます。このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。カスタムビューの作成と設定の概要については、ユーザー定義ビューを参照してください。

SSL の設定

SSL の設定を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、接続文字列オプションにあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシに合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Shopify にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくはクエリ処理を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログを参照してください。基本的なロギングでは、次の2つの接続プロパティを設定するだけです。LogModules 接続プロパティを使用してログに記録する情報のサブセットを選択できる、より洗練されたロギングをサポートする多数の機能があります。

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

次のプロパティを設定します。

プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
接続をトンネルするには、FirewallType をTUNNEL に設定します。
認証するには、FirewallUser とFirewallPassword を設定します。
SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

データモデル

CData Sync App は、Shopify API のエンティティをテーブル、ビュー、およびストアドプロシージャにモデル化します。これらはスキーマファイルにて定義されます。スキーマファイルは、簡単にカスタマイズできるシンプルなテキストベースのコンフィギュレーションファイルです。

Key Features

Include Custom Fields connection property allows you to retrieve custom fields for Products and ProductVariants table. Set this property to True, to enable this feature.
Row Scan Depth connection property allows you to set the number of rows that will be filtered for custom fields. The default value for this property is 50. Setting a low value may result in not getting all the custom fields, but setting a high value will decrease the performance of the driver. To use this feature set the Include Custom Fields connection property to True.
Flexible Schema is used to retrieve custom fields for Products and ProductVariants table. This feature is enabled when Include Custom Fields connection property is set to True. Flexible schema will search at most 250 rows for custom fields. To retrieve more fields set the Row Scan Depth to a higher value.

Using Rest API

See REST データモデル for the available entities in the REST API.

Using GraphQL API

See GRAPHQL データモデル for the available entities in the GraphQL API.

REST データモデル

The CData Sync App models the Shopify API as relational views, and stored procedures.

To use REST Data Model, simply set Schema to REST.

Tables

テーブル are tables that can be modified, such as Orders, Products.

Views

ビュー are tables that cannot be modified, such as Events, Patouts, Reports. Typically, model data that is read-only and cannot be updated are shown as views.

Stored Procedures

ストアドプロシージャ are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

テーブル

Sync App はShopify のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Shopify テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

Shopify Connector for CData Sync テーブル


Name	Description
ApplicationCharges	Create or view Application Charges for Billing.
ApplicationCredit	Create or view Application Credit for Billing.
Articles	Create, read, update or delete articles
Assets	Create, read, update or delete assets
Blogs	Create, read, update or delete blogs
CollectionListings	Query and delete information regarding different collects.
Collects	Query, insert, or delete information regarding different collects.
Comments	Create, read, update and delete the comments.
Countries	Create, select, update, and delete information regarding countries.
CustomCollections	Query, insert, update, or delete information regarding different custom collections.
CustomerAddresses	Create, update, delete, and query customer addresses.
Customers	Create, update, delete, and query customers.
DiscountCodes	Create, select, update, and delete information regarding discount codes.
DraftOrders	Create, update, delete, and query draft orders.
FulfillmentEvents	Create, delete, and query information regarding fulfillment events.
Fulfillments	Create, update, and query fulfillments.
FulfillmentServices	Query, create, update, and delete information regarding different fulfillment services.
InventoryItems	Query and update information regarding different inventory items.
InventoryLevels	Query, create, and update information regarding different inventory levels.
MarketingEvents	Create, update, delete, and query marketing events.
Metafields	Retrieves a list of metafields that belong to a resource.
OrderRisks	Create, update, delete, and query order risks.
Orders	Create, update, delete, and query orders.
OrderTransactions	Create and query transactions.
Pages	Create, read, update or delete pages
PriceRules	Create, update, delete, and query price rules.
ProductImages	Query, Update and Delete Product Images
ProductListings	Query and delete product listings.
Products	Create, update, delete, and query products.
ProductVariants	Query and delete product listings.
Provinces	Query and update information regarding different provinces.
RecurringApplicationCharges	Create, update, delete, and query Recurring Application Charges.
Redirects	Create, read, update or delete redirects.
Refunds	Create and query refunds.
ScriptTags	Create, read, update or delete script tags.
SmartCollections	Query, insert, update, or delete information regarding different smart collections.
Themes	Create, read, update or delete themes
UsageCharges	Create or view Usage Charges for Recurring Application Charges.

ApplicationCharges

Create or view Application Charges for Billing.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM ApplicationCharges

SELECT * FROM ApplicationCharges WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

INSERT INTO ApplicationCharges ( Test ) VALUES ( 'true' )

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		The Unique Identifier of the Application Charge
Name	String	False		The Order Number
ApiClientId	Long	False		The API Client ID
Price	Decimal	False		The price of the application charge
Status	String	False		The status of the application charge. Valid Values are: pending, active, declined, expired
ReturnUrl	String	False		The URL where the merchant is redirected after accepting a charge.
Test	String	False		Whether the application charge is a test transaction. Valid values:true,null
CreatedAt	Datetime	False		The date and time (ISO 8601 format) when the application charge was created.
UpdatedAt	Datetime	False		The date and time (ISO 8601 format) when the application charge was last updated.
ChargeType	String	False		The type of the application charge
DecoratedReturnUrl	String	False		The decorated return url

ApplicationCredit

Create or view Application Credit for Billing.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM ApplicationCredit

SELECT * FROM ApplicationCredit WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

Insert Into ApplicationCredit (Amount, Description, Test) VALUES ('100', 'succes or failure', 'true')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		The ID of the application credit.
Amount	Decimal	False		The amount refunded by the application credit.
Description	String	False		The description of the application credit.
Test	String	False		Whether the application credit is a test transaction. Valid values: true,null

Articles

Create, read, update or delete articles

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Articles

SELECT * FROM Articles WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the Title to create an Article.

INSERT INTO Articles(BlogId,Author,Title) VALUES ('599421749','Adam','New Article')

Update

You must specify the blog id and id to update an article. For example:

UPDATE Articles SET Author='Harry' WHERE BlogId = '599421749' AND Id = '5557081211'

Delete

You must specify the Id and the Blog Id of the article to delete it.

DELETE FROM Articles WHERE BlogId = '599421749' AND Id = '5556952105'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The ID of the article.
BlogId [KEY]	Long	False	Blogs.Id	The ID of the blog containing the article.
AdminGraphqlApiId	String	True		Displays the Admin Graphql API id.
Author	String	False		The name of the author of the article.
BodyHtml	String	False		The text of the body of the article, complete with HTML markup.
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the article was created.
Handle	String	False		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	False		Alternative text that describes the image.
Image.createdAt	Datetime	True		The date and time when image is created.
Image.height	Integer	False		Height of the image.
Image.src	String	False		A source URL that specifies the location of the image.
Image.width	Integer	False		Width of the image.
Image.attachment	String	False		An image attached to article returned as Base64-encoded binary data.
PublishedAt	Datetime	False		The date and time (ISO 8601 format) when the article was published.
SummaryHtml	String	False		A summary of the article, complete with HTML markup.
Tags	String	False		Tags are additional short descriptors formatted as a string of comma-separated values.
Template_suffix	String	False		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.
Title	String	False		The title of the article.
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when the article was last updated.
UserId	Long	True		A unique numeric identifier for the author of the article.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
published_status	String	Filter articles by their publish status. Valid values are: published, unpublished and any ; default: any.

Assets

Create, read, update or delete assets

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Assets

SELECT * FROM Assets WHERE Key='assets/abc.gif'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Update

You must specify the Theme Id and Key to update an Asset. For example:

UPDATE Assets SET value='pqrs' WHERE Key = 'assets/abc.gif' AND ThemeId = '282977'

Delete

You must specify the Id and the Theme Id of the Asset to delete it.

DELETE FROM Assets WHERE Key = 'assets/abc.gif' AND ThemeId = '282977'

Columns


Name	Type	ReadOnly	References	Description
Key [KEY]	String	False		The path to the asset within a theme.
ThemeId	Long	True	Themes.Id	The ID for the theme that an asset belongs to.
Attachment	String	False		A base64-encoded image.
Checksum	String	True		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.
ContentType	String	True		The MIME representation of the content, consisting of the type and subtype of the asset.
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the asset was created.
PublicUrl	String	True		The public-facing URL of the asset.
Size	Integer	True		The asset size in bytes.
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when an asset was last updated.
Value	String	False		The text content of the asset, such as the HTML and Liquid markup of a template file.

Blogs

Create, read, update or delete blogs

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Blogs

SELECT * FROM Blogs WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the Title to create a Blog.

INSERT INTO Blogs(title) VALUES ('new blog')

Update

You must specify the id to update a Blog. For example:

UPDATE Blogs SET title='new blog' WHERE Id = '77171130'

Delete

You must specify the Id of the Blog to delete it.

DELETE FROM Blogs WHERE Id = '555695'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the blog.
AdminGraphqlApiId	String	True		Displays the Admin Graphql API id.
Commentable	String	False		Indicates whether readers can post comments to the blog and if comments are moderated or not. 使用できる値は次のとおりです。no, yes, moderate デフォルト値はnoです。
CreatedAt	Datetime	True		The date and time when the blog was created.
Feedburner	String	False		Feedburner is a web feed management provider and can be enabled to provide custom RSS feeds for Shopify bloggers. This property will default to blank or null unless feedburner is enabled through the shop admin.
FeedburnerLocation	String	False		URL to the feedburner location for blogs that have enabled feedburner through their store admin. This property will default to blank or null unless feedburner is enabled through the shop admin.
Handle	String	False		A human-friendly unique string for a blog automatically generated from its title.
Metafields	String	True		Attaches additional metadata to a store's resources.
Tags	String	False		Tags are additional short descriptors formatted as a string of comma-separated values.
TemplateSuffix	String	False		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.
Title	String	False		The title of the blog.
UpdatedAt	Datetime	True		The date and time when changes were last made to the blog's properties.

CollectionListings

Query and delete information regarding different collects.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM CollectionListings

SELECT * FROM CollectionListings WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Delete

You must specify the Id of the collection listing to delete it.

DELETE FROM CollectionListings WHERE id ='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False	CustomCollections.Id	The Id of the collection this listing belongs to.
Title	String	True		The titke of the collection listing.
BodyHtml	String	True		The HTML body/description for this listing.
DefaultProductImage	String	True		The default product image in this listing.
ImageCreatedAt	String	True		The date and time the image for this listing was created at.
ImageSource	String	True		The source/link of the image for this listing.
Handle	String	True		The handle of this listing.
UpdatedAt	Datetime	True		The date and time when the collection listing was last modified.
PublishedAt	Datetime	True		The date and time when the collection listing was created.

Collects

Query, insert, or delete information regarding different collects.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Collects

SELECT * FROM Collects WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the ProductId and CollectionId to create a collect.

INSERT INTO Collects (ProductId, CollectionId) VALUES ('512433520663','22892937239')

Delete

You must specify the Id of the collect to delete it.

DELETE FROM Collects WHERE id ='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the collect.
CollectionId	Long	False	CustomCollections.Id	The Id of the collection this collection is linked with.
ProductId	Long	False	Products.Id	The Id of the product this collection is linked with.
Position	Int	True		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.
SortValue	String	True		This is the same value as position but padded with leading zeroes to make it alphanumeric-sortable.
CreatedAt	Datetime	True		The date and time when the collect was created.
UpdatedAt	Datetime	True		The date and time when the collect was last modified.

Comments

Create, read, update and delete the comments.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Comments

SELECT * FROM Comments WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify Article Id, Author, Body, Email to create a Comment.

INSERT INTO Comments(articleid,author,body,email) VALUES ('5557001','Harry','test','[email protected]')

Update

You must specify the Id to update a Comment. For example:

UPDATE Comments SET Author='Adam' WHERE Id = '77171130'

Delete

You must specify the Id of the Comments to delete it.

DELETE FROM Comments WHERE Id = '555695'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the comment.
BlogId	Long	False	Blogs.Id	A unique numeric identifier for the blog containing the article that the comment belongs to.
ArticleId	Long	False	Articles.Id	A unique numeric identifier for the article that the comment belongs to.
Author	String	False		The name of the author of the comment.
Body	String	False		The basic Textile markup of a comment.
BodyHtml	String	False		The text of the comment, complete with HTML markup.
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the comment was created.
Email	String	False		The email address of the author of the comment.
Ip	String	False		The IP address from which the comment was posted.
PublishedAt	String	False		The date and time (ISO 8601 format) when the comment was published.
Status	String	True		The status of the comment. 使用できる値は次のとおりです。pending, approved, unapproved, spam, published, removed
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when the comment was last modified.
UserAgent	String	False		The user agent string provided by the software used to create the comment.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
published_status	String	Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any.
status	String	Filter comments by their status. Valid values are: published, pending and unapproved

Countries

Create, select, update, and delete information regarding countries.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Countries

SELECT * FROM Countries WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the Code to create a country.

INSERT INTO Countries (Code) VALUES ("FR")

Update

You must specify the country Id to update a country. For example:

UPDATE Countries SET Tax=0.1 WHERE Id='123'

Delete

You must specify the Id of the country to delete it.

DELETE FROM Countries WHERE id ='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the country.
Name	String	True		The name of the country.
Code	String	False		The code of the country.
Tax	Decimal	False		The amount of tax which should be applied for this country.
Provinces	String	False		The sub-regions of a country, such as its provinces or states. Each sub-region has the following properties: code: The two letter province or state code, country_id: The ID for the country to which this sub-region belongs, id: The ID for the particular sub-region, name: The name of the sub-region, tax: The tax value in decimal format, tax_name: The name of the tax as it is referred to in the applicable sub-region. For example, in Canada, the sales tax in the province Ontario is referred to as HST, tax_type: The tax type. Valid values: null, normal, or harmonized. If the value is harmonized, then the tax is compounded of the provincial and federal sales taxes, tax_percentage: The tax value in percent format

CustomCollections

Query, insert, update, or delete information regarding different custom collections.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, ProductId, Title, Handle, PublishedStatus, UpdatedAt, and PublishedAt columns. The supported SQL operators are '=' and 'IN' for Id, '=' for the ProductId, Title, Handle, and PublishedStatus columns, and '>' and '<' for UpdatedAt and PublishedAt. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side.

SELECT * FROM CustomCollections

SELECT * FROM CustomCollections WHERE Id='123'

SELECT * FROM CustomCollections WHERE Id IN ('123','456')

SELECT * FROM CustomCollections WHERE ProductId='123'

SELECT * FROM CustomCollections WHERE Title='Ducks'

SELECT * FROM CustomCollections WHERE Handle='frontpage'

SELECT * FROM CustomCollections WHERE PublishedStatus='published'

SELECT * FROM CustomCollections WHERE UpdatedAt > '2018-05-02'

SELECT * FROM CustomCollections WHERE PublishedAt < '2017-08-15'

Insert

You must specify the Title to create a custom collection.

INSERT INTO CustomCollections (Title) VALUES ('Macbooks')

INSERT INTO CustomCollections (Title, Published) VALUES ('Macbooks', false)

Update

You must specify the custom collection Id to update a custom collection. For example:

UPDATE CustomCollections SET Title='Updated title' WHERE Id='123'

Delete

You must specify the Id of the custom collection to delete it.

DELETE FROM CustomCollections WHERE Id ='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the custom collection.
Title	String	False		The title of the custom collection.
BodyHtml	String	False		The body/description of the custom collection.
Image	String	False		A JSON aggregate with information regarding the image of custom collection.
Metafields	String	False		Attaches additional metadata to a shop's resources: key: An identifier for the metafield. (maximum: 30 characters), namespace: A container for a set of metadata. Namespaces help distinguish between metadata created by different apps. (maximum: 20 characters), value: Information to be stored as metadata, value_type: The information type being stored. Valid values: string or integer, description (optional): Additional information about the metafield .
Handle	String	False		A human-friendly unique string for the custom collection automatically generated from its title.
SortOrder	String	False		The order in which products in the custom collection appear.
TemplateSuffix	String	False		The suffix of the liquid template being used.
PublishedScope	String	False		The sales channels in which the custom collection is visible.
UpdatedAt	Datetime	True		The date and time when the custom collection was last modified.
PublishedAt	Datetime	True		The date and time when the custom collection was published to the Online Store channel.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ProductId	String	Show custom collections that include a given product.
PublishedStatus	String	Show custom collection with a given published status: published: show only published custom collections, unpublished: show only unpublished custom collections, any: show custom collections of any published status. (default: any).

CustomerAddresses

Create, update, delete, and query customer addresses.

Table-Specific Information

Select

The Sync App uses the Shopify API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

CustomerId supports the '=,IN' comparison.
CustomerUpdatedAt supports the '=' comparison.
FirstName supports the '=' comparison.
LastName supports the '=' comparison.
Company supports the '=' comparison.
Address1 supports the '=' comparison.
Address2 supports the '=' comparison.
City supports the '=' comparison.
Province supports the '=' comparison.
Country supports the '=' comparison.
Phone supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CustomerAddresses

SELECT * FROM CustomerAddresses WHERE CustomerId='123'

SELECT * FROM CustomerAddresses WHERE CustomerId IN ('123','456')

SELECT * FROM CustomerAddresses WHERE CustomerUpdatedAt = '2018-05-04'

SELECT * FROM CustomerAddresses WHERE FirstName='abc'

SELECT * FROM CustomerAddresses WHERE LastName='xyz'

SELECT * FROM CustomerAddresses WHERE Company='cdata'

SELECT * FROM CustomerAddresses WHERE Address1='Electronic city'

SELECT * FROM CustomerAddresses WHERE City='Bangalore'

SELECT * FROM CustomerAddresses WHERE Country='India'

SELECT * FROM CustomerAddresses WHERE Phone='9769879890'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the customer Id to create an address.

INSERT INTO CustomerAddresses(CustomerId, Address1, City, Company) VALUES('123', '1 Rue des Carrieres', 'Suite 1234', 'Montreal')

Update

You must specify the customer Id and the Id of the customer address to update an address.

UPDATE CustomerAddresses SET Zip='90210' WHERE CustomerId='123' AND Id='456'

Delete

You must specify the customer Id and the Id of the customer address to delete an address. You cannot delete a customer's default address.

DELETE FROM CustomerAddresses WHERE CustomerId='183467180055' AND Id='292265787415'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the address.
CustomerId [KEY]	Long	False	Customers.Id	A unique numeric identifier for the customer.
CustomerUpdatedAt	Datetime	True		The date and time when the customer information was last updated.
Name	String	False		The customer's name.
FirstName	String	False		The customer's first name.
LastName	String	False		The customer's last name.
Company	String	False		The customer's company.
Address1	String	False		The customer's mailing address.
Address2	String	False		An additional field for the customer's mailing address.
City	String	False		The customer's city.
Province	String	False		The customer's province or state name.
Country	String	False		The customer's country.
Zip	String	False		The customer's zip or postal code.
Phone	String	False		The customer's phone number for this mailing address.
ProvinceCode	String	False		The two-letter pcode for the customer's province or state.
CountryCode	String	False		The two-letter country code corresponding to the customer's country.
CountryName	String	False		The customer's normalized country name.
Default	Boolean	True		Indicates whether this address is the default address for the customer.

Customers

Create, update, delete, and query customers.

Table-Specific Information

Select

The Sync App uses the Shopify API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

Id supports the '=,IN' comparison.
FirstName supports the '=' comparison.
LastName supports the '=' comparison.
Email supports the '=' comparison.
Phone supports the '=' comparison.
TotalSpent supports the '=' comparison.
OrdersCount supports the '=' comparison.
AcceptsMarketing supports the '=' comparison.
State supports the '=' comparison.
VerifiedEmail supports the '=' comparison.
CreatedAt supports the '>=,<=' comparison.
UpdatedAt supports the '>=,<=,=' comparison.

For example, the following queries are processed server side.

SELECT * FROM Customers

SELECT * FROM Customers WHERE Id = '123'

SELECT * FROM Customers WHERE Id IN ('123', '456')

SELECT * FROM Customers WHERE CreatedAt >= '2017-10-25'

SELECT * FROM Customers WHERE CreatedAt <= '2017-10-25'

SELECT * FROM Customers WHERE UpdatedAt <= '2017-10-25'

SELECT * FROM Customers WHERE UpdatedAt >= '2017-10-25'

SELECT * FROM Customers WHERE FirstName = 'abc'

SELECT * FROM Customers WHERE LastName = 'xyz'

SELECT * FROM Customers WHERE Email = '[email protected]'

SELECT * FROM Customers WHERE OrdersCount = 5

SELECT * FROM Customers WHERE Phone = '999999999'

SELECT * FROM Customers WHERE VerifiedEmail = true

SELECT * FROM Customers WHERE UpdatedAt = '2017-10-25'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

The Email field is required to insert.

INSERT INTO Customers(Email, Phone) VALUES('[email protected]', '+15142546011')

INSERT INTO Customers(Email, Phone, SendEmailInvite) VALUES('[email protected]', '+15142546011', true)

Update

You must specify the Id of the customer to update a customer.

UPDATE Customers SET Note='Customer is a great guy' WHERE Id='123'

UPDATE Customers SET Tags='New Customer, Repeat Customer' WHERE Id='123'

Delete

You must specify the Id of the customer to delete a customer.

DELETE FROM Customers WHERE Id='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the customer.
LastOrderId	Long	True	Orders.Id	The id of the customer's last order.
LastOrderName	String	True		The name of the customer's last order.
FirstName	String	False		The customer's first name.
LastName	String	False		The customer's last name.
Email	String	False		The unique email address of the customer.
Phone	String	False		The unique phone number for this customer.
TaxExempt	Boolean	False		Indicates whether the customer should be charged taxes when placing orders.
TotalSpent	Decimal	True		The total amount of money that the customer has spent at the shop.
OrdersCount	Integer	True		The number of orders associated with this customer.
AcceptsMarketing	Boolean	True		Indicates whether the customer has consented to be sent marketing material via email.
MultipassIdentifier	String	True		The customer's identifier used with Multipass login.
Note	String	False		A note about the customer.
State	String	True		The state of the customer's account in a shop.
Tags	String	False		The tags for this customer. Separate with comma for multiple tags.
VerifiedEmail	Boolean	True		States whether or not the email address has been verified.
CreatedAt	Datetime	True		The date and time when the customer was created.
UpdatedAt	Datetime	True		The date and time when the customer information was updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Password	String	Password of the customer
PasswordConfirmation	String	Password confirmation of the customer.
SendEmailWelcome	Boolean	Whether to send a welcome email to the customer or not.
SendEmailInvite	Boolean	Whether to send an invite email to the customer or not.

DiscountCodes

Create, select, update, and delete information regarding discount codes.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the PriceRuleId and Id columns. The supported SQL operator is '='. The Sync App processes other filters client-side within the Sync App.

For example, the following queries are processed server side: SELECT * FROM DiscountCodes WHERE PriceRuleId = '123' SELECT * FROM DiscountCodes WHERE PriceRuleId = '123' AND Id = '456'

Insert

You must specify the PriceRuleId and Code to create a discount code.

INSERT INTO DiscountCodes (PriceRuleId,Code) VALUES ('290807676951','SUMMERSALE100OFF')

Update

You must specify the PriceRuleId and Id to update a discount code. For example:

UPDATE DiscountCodes SET Code = 'WINTERSALE500OFF' WHERE PriceRuleId = '123' AND Id = '456'

Delete

You must specify the Id of the custom collection to delete it.

DELETE FROM DiscountCodes WHERE PriceRuleId = '123' AND Id = '456'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the discount code.
PriceRuleId [KEY]	Long	False	PriceRules.Id	The Id for the price rule that this discount code belongs to.
Code	String	False		The case-insensitive discount code that customers use at checkout.
UsageCount	Int	True		The number of times that the discount code has been redeemed.
CreatedAt	Datetime	True		The date and time when the discount code was created.
UpdatedAt	Datetime	True		The date and time when the discount code was last modified.

DraftOrders

Create, update, delete, and query draft orders.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, Status, and UpdatedAt columns. The supported SQL operators are "=" and "IN" for Id, "=" for Status, and ">" and "<" for UpdatedAt. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM DraftOrders

SELECT * FROM DraftOrders WHERE Id='123'

SELECT * FROM DraftOrders WHERE Id IN ('123', '456')

SELECT * FROM DraftOrders WHERE Status='completed'

SELECT * FROM DraftOrders WHERE UpdatedAt > '2018-02-05'

Insert

Create a simple draft order with only a product variant Id using aggregates.

INSERT INTO DraftOrders(LineAggregate) VALUES('[{\"variant_id\":\"4236041945111\",\"quantity\":2},{\"variant_id\":\"4236069011479\",\"quantity\":3}]')

Create a simple draft order with only a product variant Id using temporary table. The temporary table you are populating is dynamic and will be created at run time the first time you insert to it. Temporary tables are denoted by a # appearing in their name. When using a temporary table to insert, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be inserting to. For instance:
```
INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('123',2)
```
Once your temporary table is populated, it is now time to insert to the actual table in Shopify. You can do this by performing an INSERT to the actual table and setting as a value for LinesAggregate the name of the temporary table. For instance:
```
INSERT INTO DraftOrders (LineAggregate) VALUES ('OrdersItems#Temp')
```

Create a custom draft order using aggregates.

INSERT INTO DraftOrders(LineAggregate, CustomerId, UseCustomerDefaultAddress) VALUES('[{\"title\":\"Custom Tee\",\"price\":20.15,\"quantity\":5}]', '709015339031', true)

Create a custom draft order using temporary table.

INSERT INTO OrdersItems#Temp (ItemTitle, ItemPrice, ItemQuantity) VALUES ('Custom Tee', 20.15, 5)
INSERT INTO DraftOrders(LineAggregate, CustomerId, UseCustomerDefaultAddress) VALUES('OrdersItems#Temp', '709015339031', true)

Update

Add a Note to a draft order:

UPDATE DraftOrders SET Note = 'Customer contacted us about a custom engraving on this iPod' WHERE Id = '123'

Set a discount on a draft order:

UPDATE DraftOrders SET AppliedDiscountDescription = 'Custom discount', AppliedDiscountValueType = 'percentage', AppliedDiscountValue = 10.0, AppliedDiscountAmount = 19.90, AppliedDiscountTitle = 'Custom' WHERE Id = '123'

Delete

You must specify the Id of the draft order to delete it.

DELETE FROM DraftOrders WHERE Id = '123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the order.
CustomerId	Long	False	Customers.Id	A unique numeric identifier for the customer.
Currency	String	False		The three letter code (ISO 4217) for the currency used for the payment.
Email	String	False		The customer's email address.
Name	String	True		The customer's order name as represented by a number.
TotalPrice	Decimal	True		The sum of all the prices of all the items in the order, taxes and discounts included.
SubtotalPrice	Decimal	True		Price of the order before shipping and taxes.
TotalTax	Decimal	False		The sum of all the taxes applied to the order.
TaxesIncluded	Boolean	False		States whether or not taxes are included in the order subtotal.
InvoiceSentAt	Datetime	True		This auto-generated property is the date and time when the invoice was emailed to the customer. Only available for draft orders.
Note	String	False		The text of an optional note that a shop owner can attach to the order.
Tags	String	False		Additional short descriptors.
InvoiceUrl	String	True		The URL for the invoice. Only available for draft orders.
TaxExempt	Boolean	True		States whether or not taxes are exempt for this order. Only available for draft orders.
Status	String	True		The status of the order. Valid values: open: all open orders (default), invoice_sent: show only closed orders, completed: Show only cancelled orders.
LineAggregate	String	False		A JSON aggregate of line items associated with the draft order.
BillingAddressFirstName	String	False		The first name of the person associated with the payment method.
BillingAddressLastName	String	False		The last name of the person associated with the payment method.
BillingAddressAddress1	String	False		The street address of the billing address.
BillingAddressAddress2	String	False		An optional additional field for the street address of the billing address.
BillingAddressPhone	String	False		The phone number at the billing address.
BillingAddressCity	String	False		The city of the billing address.
BillingAddressCompany	String	False		The company of the person associated with the billing address.
BillingAddressZip	String	False		The zip or postal code of the billing address.
BillingAddressProvince	String	False		The name of the state or province of the billing address.
BillingAddressCountry	String	False		The name of the country of the billing address.
BillingAddressLatitude	Double	False		The latitude of the billing address.
BillingAddressLongitude	Double	False		The longitude of the billing address.
BillingAddressName	String	False		The full name of the person associated with the payment method.
BillingAddressCountryCode	String	False		The two-letter code for the country of the billing address.
BillingAddressProvinceCode	String	False		The two-letter abbreviation of the state or province of the billing address.
BillingAddressDefault	Boolean	False		Whether this address is the default one or not.
ShippingAddressFirstName	String	False		The first name of the person associated with the shipping method.
ShippingAddressLastName	String	False		The last name of the person associated with the shipping method.
ShippingAddressAddress1	String	False		The street address of the shipping address.
ShippingAddressAddress2	String	False		An optional additional field for the street address of the shipping address.
ShippingAddressPhone	String	False		The phone number at the shipping address.
ShippingAddressCity	String	False		The city of the shipping address.
ShippingAddressCompany	String	False		The company of the person associated with the shipping address.
ShippingAddressZip	String	False		The zip or postal code of the shipping address.
ShippingAddressProvince	String	False		The name of the state or province of the shipping address.
ShippingAddressCountry	String	False		The name of the country of the shipping address.
ShippingAddressLatitude	Double	False		The latitude of the shipping address.
ShippingAddressLongitude	Double	False		The longitude of the shipping address.
ShippingAddressName	String	False		The full name of the person associated with the shipping method.
ShippingAddressCountryCode	String	False		The two-letter code for the country of the shipping address.
ShippingAddressProvinceCode	String	False		The two-letter abbreviation of the state or province of the shipping address.
ShippingAddressDefault	Boolean	False		Whether this address is the default one or not.
AppliedDiscountTitle	String	False		The title of the applied discount for this order. Only available for draft orders.
AppliedDiscountDescription	String	False		The description of the applied discount for order. Only available for draft orders.
AppliedDiscountValue	Decimal	False		The value of the applied discount for this order. Only available for draft orders.
AppliedDiscountValueType	String	False		The value type of the applied discount for order. Only available for draft orders.
AppliedDiscountAmount	Decimal	False		The amount of the applied discount for this order. Only available for draft orders.
CreatedAt	Datetime	True		The date and time when the order was created.
UpdatedAt	Datetime	True		The date and time when the order was last modified.
CompletedAt	Datetime	True		The date and time when the order was completed at.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
UseCustomerDefaultAddress	Boolean	Optional boolean that you can send as part of a draft order object to load customer shipping information. Valid values: true or false.

FulfillmentEvents

Create, delete, and query information regarding fulfillment events.

Table-Specific Information

Select

The OrderId and FulfillmentId are required to query this table.

The Sync App uses the Shopify API to process search criteria that refer to the OrderId, FulfillmentId, and Id columns. The supported SQL operator is '='. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM FulfillmentEvents WHERE OrderId='123' AND FulfillmentId='456'

SELECT * FROM FulfillmentEvents WHERE OrderId='123' AND FulfillmentId='456' AND Id='789'

Insert

You must specify the OrderId, FulfillmentId, and Status to create a fulfillment event.

INSERT INTO FulfillmentEvents (Orderid,FulfillmentId, Status,Message,EstimatedDeliveryAt) VALUES ('202520330263','206541914135', 'in_transit','test','2018-08-02 10:15:25 PM')

Delete

You must specify the OrderId, FulfillmentId, and Id of the fulfillment event to delete it.

DELETE FROM FulfillmentEvents WHERE Orderid='202520330263' AND FulfillmentId='206541914135' AND Id='2374424264727'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A numeric unique identifier for the fulfillment event.
OrderId [KEY]	Long	False	Orders.Id	The id of the order the fulfillment event belongs to.
FulfillmentId [KEY]	Long	False	Fulfillments.Id	A numeric unique identifier for the fulfillment to which the fulfillment event belongs.
ShopId	Long	True	Shop.Id	A numeric unique identifier for the shop to which the fulfillment event belongs.
Status	String	False		The status of the fulfillment event. Valid values are: confirmed, in_transit, out_for_delivery, delivered, failure.
EstimatedDeliveryAt	Datetime	False		The status of the fulfillment event. Valid values are: confirmed, in_transit, out_for_delivery, delivered, failure.
Message	String	False		An arbitrary message describing the status. Can be provided by a shipping carrier.
City	String	False		The city in which the fulfillment event occurred.
Province	String	False		The province in which the fulfillment event occurred.
Zip	String	False		The zip code in the location in which the fulfillment event occurred.
Country	String	False		The country in which the fulfillment event occurred.
Address1	String	False		The fulfillment event's street address.
Latitude	Double	False		Geographic coordinate specifying the north/south location of a fulfillment event.
Longitude	Double	False		Geographic coordinate specifying the east/west location of a fulfillment event.
CreatedAt	Datetime	True		The date and time when the fulfillment event was created.
UpdatedAt	Datetime	True		The date and time when the fulfillment event was updated.
HappenedAt	Datetime	True		The date and time when the fulfillment event occurred.

Fulfillments

Create, update, and query fulfillments.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, OrderId, CreatedAt, and UpdatedAt columns. The Sync App processes other filters client-side within the Sync App.

For example, the following queries are processed server side.

If you specify the unique identifier of the order, then this view will only list fulfillment information concerning that order. You can also retrieve a specific fulfillment by specifying OrderId and Id.
```
SELECT * FROM Fulfillments

SELECT * FROM Fulfillments WHERE OrderId = '123'

SELECT * FROM Fulfillments WHERE OrderId = '123' AND Id='567'
```
This view supports filtering by the CreatedAt and UpdatedAt columns on the server side.
```
SELECT * FROM Fulfillments WHERE CreatedAt > '2017-10-25'
```

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. When SupportEnhancedSQL is false, you must specify at least OrderId. The Shopify API requires that queries contain this filter.

Insert

You must specify the OrderId column to insert a fulfillment.

Fulfill one line item using aggregates.

INSERT INTO Fulfillments(OrderId, LineAggregate) VALUES('123', '[{\"id\":\"123\"}]')

Fulfill one line item using temporary table. The temporary table you are populating is dynamic and will be created at run time the first time you insert to it. Temporary tables are denoted by a # appearing in their name. When using a temporary table to insert, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be inserting to. For instance:
```
Insert INTO OrdersItems#Temp (ItemId) Values ('123')
```
Once your temporary table is populated, it is now time to insert to the actual table in Shopify. You can do this by performing an INSERT to the actual table and setting as a value for LinesAggregate the name of the temporary table. For instance:
```
Insert INTO Fulfillments (OrderId, LinesAggregate) VALUES ('123', 'OrdersItems#Temp')
```
In cases that two ore more shop locations are specified in your Shopify account the LocationId needs to be added. For instance:
```
Insert INTO Fulfillments (OrderId, LocationId, LinesAggregate) VALUES ('123', '456', 'OrdersItems#Temp')
```

Fulfill many line items using aggregates.

INSERT INTO Fulfillments(OrderId, LineAggregate) VALUES('123', '[{\"id\":\"123\"},{\"id\":\"456\"},{\"id\":\"789\"}]')

Fulfill many line items using temporary table.

INSERT INTO OrdersItems#Temp (ItemId) VALUES ('123')
INSERT INTO OrdersItems#Temp (ItemId) VALUES ('456')
INSERT INTO OrdersItems#Temp (ItemId) VALUES ('789')
INSERT INTO Fulfillments (OrderId, LineAggregate) VALUES ('123', 'OrdersItems#Temp')

Fulfill all line items, notify the customer, and set a tracking number.

INSERT INTO Fulfillments(OrderId, TrackingNumbers, NotifyCustomer) VALUES('123', 'FEDEX1', true)

Partially fulfill a single line item by explicitly specifying the line item and quantity to be fulfilled using aggregates.
```
INSERT INTO Fulfillments(OrderId, LineAggregate) VALUES('123', '[{\"id\":\"123\",\"quantity\":5}]')
```

Partially fulfill a single line item by explicitly specifying the line item and quantity to be fulfilled using temporary table.

INSERT INTO OrdersItems#Temp (ItemId,ItemQuantity) VALUES ('123',5)
INSERT INTO Fulfillments (OrderId,LineAggregate) VALUES ('456','OrdersItems#Temp')

Complete a fulfillment (you must specify the Id of the fulfillment as well).

INSERT INTO Fulfillments(OrderId, Id, Operation) VALUES('123', '456', 'Complete')

Transition a fulfillment from pending to open (you must specify the Id of the fulfillment as well).
```
INSERT INTO Fulfillments(OrderId, Id, Operation) VALUES('123', '456', 'Open')
```

Cancel a fulfillment (you must specify Id of the fulfillment as well).

INSERT INTO Fulfillments(OrderId, Id, Operation) VALUES('123', '456', 'Cancel')

Update

You must specify the OrderId and Id of the fulfillment to fulfill an order.

UPDATE Fulfillments SET TrackingNumbers='FedEx123,UPS123' WHERE OrderId='123' AND Id='456'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the fulfillment.
OrderId [KEY]	Long	False	Orders.Id	A unique numeric identifier for the order.
LocationId [KEY]	Long	False		A unique numeric identifier for the Location.
NotifyCustomer	Boolean	False		A flag indicating whether the customer should be notified
Status	String	True		The status of the fulfillment.
Receipt	String	True		Provides information about the receipt of this fulfillment.
TrackingCompany	String	False		The name of the tracking company.
TrackingNumbers	String	False		A list of comma-separated tracking numbers, provided by the shipping company.
TrackingUrls	String	True		The sum of all the prices of all the items in the fulfillment.
VariantInventoryManagement	String	True		States the name of the inventory management service.
CreatedAt	Datetime	True		The date and time when the fulfillment was created.
UpdatedAt	Datetime	True		The date and time when the fulfillment was last modified.
LineAggregate	String	False		A JSON aggregate of line items associated with the fulfillment.
OrderUpdatedAt	Datetime	True		The date and time when the order was last modified.
OrderCreatedAt	Datetime	True		The date and time when the order was last created.
Operation	String	False		An operation to apply to the fulfillment. Complete, Open, or Cancel. 使用できる値は次のとおりです。Complete, Open, Cancel

FulfillmentServices

Query, create, update, and delete information regarding different fulfillment services.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM FulfillmentServices

SELECT * FROM FulfillmentServices WHERE Id='123'

Insert

You must specify the Name, CallbackUrl, and Format to create a fulfillment service.

INSERT INTO FulfillmentServices (Name,CallbackUrl,Format) VALUES ('testing fulfillment services','http://google.com','json')

Update

You must specify the Id to update a fulfillment service. For example:

UPDATE FulfillmentServices Set Name='test32', IncludePendingStock=true WHERE Id='123'

Delete

You must specify the Id of the fulfillment service to delete it.

DELETE FROM FulfillmentServices WHERE Id='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the fulfillment service.
LocationId	Long	True	Locations.Id	The unique identifier of the location tied to the fulfillment service.
ProviderId	String	True		A unique identifier for the fulfillment service provider.
Name	String	False		The name of the fulfillment service as seen by merchants and their customers.
Handle	String	True		A human-friendly unique string for the fulfillment service generated from its title.
ServiceName	String	True		The name of the fulfillment service.
Email	String	False		The email of the fulfillment service.
IncludePendingStock	Boolean	False		States if the fulfillment service includes a pending stock.
RequiresShippingMethod	Boolean	False		States if the fulfillment service requires products to be physically shipped. Valid values are 'true' and 'false'.
TrackingSupport	Boolean	False		States if the fulfillment service provides tracking numbers for packages. Valid values are
InventoryManagement	Boolean	False		States if the fulfillment service tracks product inventory and provides updates to Shopify. Valid values are
FulfillmentOrdersOptIn	Boolean	True		States if the fulfillment orders is opt in.
CallbackUrl	String	False		States the URL endpoint that Shopify needs to retrieve inventory and tracking updates. This field is necessary if either inventory_management or tracking_support is set to
Format	String	False		Specifies the format of the API output. Valid values are json and xml.

InventoryItems

Query and update information regarding different inventory items.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operators are '=' and 'IN'. The Sync App processes other filters client-side within the Sync App.

For example, the following queries are processed server side:

SELECT * FROM InventoryItems

SELECT * FROM InventoryItems WHERE Id='123'

SELECT * FROM InventoryItems WHERE Id IN ('123','456')

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false; the Shopify APIs require Id in the search criteria, and any other search criteria will cause an error.

Update

You must specify the Id to update an inventory item. For example:

UPDATE InventoryItems Set Sku='lamo', Tracked=false WHERE Id='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the fulfillment.
Cost	Decimal	False		The unit cost of the inventory item.
CountryCodeOfOrigin	String	False		The two-digit code for the country where the inventory item was made.
CountryHarmonizedSystemCodes	String	False		An array of country-specific Harmonized System (HS) codes for the item.
HarmonizedSystemCode	String	False		The general Harmonized System (HS) code for the inventory item. Used if a country-specific HS code is not available.
ProvinceCodeOfOrigin	String	False		The two-digit code for the province where the inventory item was made. Used only if the shipping provider for the inventory item is Canada Post.
SKU	String	False		The unique SKU (stock keeping unit) of the inventory item.
Tracked	Boolean	False		Whether the inventory item is tracked. If true, then inventory quantity changes are tracked by Shopify.
RequiresShipping	Boolean	True		Whether a customer needs to provide a shipping address when placing an order containing the inventory item.
CreatedAt	Datetime	True		The date and time when the inventory item was created.
UpdatedAt	Datetime	True		The date and time when the inventory item was last updated.

InventoryLevels

Query, create, and update information regarding different inventory levels.

Table-Specific Information

Select

To query this table InventoryItemId, LocationId or both should be specified. The supported SQL operators are '=' and 'IN'. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM InventoryLevels WHERE InventoryItemId='123' 

SELECT * FROM InventoryLevels WHERE InventoryItemId='123' AND LocationId='456'

SELECT * FROM InventoryLevels WHERE InventoryItemId IN ('123','456) AND LocationId IN ('123','456')

Insert

Adjust the available quantity of an inventory item at a single location:

INSERT INTO InventoryLevels (InventoryItemId, LocationId, Available, Operation) VALUES (534169354263,1448280087,5,'Adjust')

Connects an inventory item to a location by creating an inventory level at that location:

INSERT INTO InventoryLevels (InventoryItemId, LocationId, Operation) VALUES (534169354263,4484497431,'Connect')

Sets the inventory level for an inventory item at a location:

INSERT INTO InventoryLevels (InventoryItemId, LocationId, Available,Operation, DisconnectIfNecessary) VALUES (534169354263,4484497431,42,'Set', true)

Delete

You must specify the InventoryItemId and LocationId to delete an inventory level of an inventory item at a location.

DELETE FROM InventoryLevels WHERE InventoryItemId='153681943' AND LocationId='45678'

Columns


Name	Type	ReadOnly	References	Description
InventoryItemId [KEY]	Long	False	InventoryItems.Id	The ID of the inventory item that the inventory level belongs to.
LocationId [KEY]	Long	False	Locations.Id	The ID of the location that the inventory level belongs to. To find the ID of the location, use the Locations view.
Available	Int	False		The quantity of inventory items available for sale. Returns null if the inventory item is not tracked.
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when the inventory level was last modified.
Operation	String	False		An operation to apply to the InventoryLevel. Valid values for order: Adjust, Connect, Set. 使用できる値は次のとおりです。Adjust, Connect, Set

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
RelocateIfNecessary	Boolean	Whether inventory for any previously connected locations will be relocated. This property is ignored when no fulfillment service location is involved. Used in insertions.
DisconnectIfNecessary	Boolean	Whether inventory for any previously connected locations will be set to 0 and the locations disconnected. This property is ignored when no fulfillment service is involved. Used in insertions.

MarketingEvents

Create, update, delete, and query marketing events.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM MarketingEvents

SELECT * FROM MarketingEvents WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the MarketingChannel, EventType, Paid, ReferringDomain, and StartedAt columns to create a marketing event. For example:

INSERT INTO MarketingEvents (MarketingChannel,EventType,Paid,ReferringDomain,StartedAt) VALUES ('social', 'ad',true,'facebook.com','2018-12-15')

Update

You must specify the Id to update a marketing event. You can modify only timestamps, RemoteId, and budget/currency. For example:

UPDATE MarketingEvents SET RemoteId='1000:2000',StartedAt='2018-02-02T00:00 +00:00',EndedAt='2018-02-03T00:00 +00:00',ScheduledToEndAt='2018-02-04T00:00 +00:00',Budget=11.1, BudgetType='daily', Currency='USD' WHERE Id='123'

Delete

You must specify the Id of the marketing event to delete it.

DELETE FROM MarketingEvents WHERE Id ='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the marketing event.
RemoteId	String	False		An optional remote identifier for a marketing event.
BreadcrumbId	String	True		An optional identifier for the breadcrumb of a marketing event.
UTMCampaign	String	True		A unique name for the UTM campaign.
UTMSource	String	True		The source of the UTM campaign.
UTMMedium	String	True		The medium of the UTM campaign.
UTMContent	String	True		The content of the UTM campaign.
UTMTerm	String	True		The term of the UTM campaign.
EventTarget	String	True		The target of the event.
Description	String	True		A description for the marketing event.
MarketingChannel	String	False		A broader marketing event type that is focused only on the channel. Must be one of the allowed values (`search`, `display`, `social`, `email`, `referral`).
EventType	String	False		The specific type of marketing event. Must be one of the allowed values (`ad`, `post`, `message`, `retargeting`, `transactional`, `affiliate`, `loyalty`, `newsletter`, `abandoned_cart`, `receipt`).
Budget	Decimal	False		The budget of the ad campaign.
Paid	Boolean	False		A boolean field to specify whether this event is paid or organic.
BudgetType	String	False		The type of the budget; must be either `daily` or `lifetime`.
Currency	String	False		The currency for the budget.
ManageUrl	String	True		A link to manage the marketing event, generally in the Shopify app's interface.
PreviewUrl	String	True		A link to view the live version of the post/ad, or to view a rendered preview of the post/ad/email in the Shopify app.
ReferringDomain	String	False		The destination domain of the marketing event. Required unless MarketingChannel is one of email/referral/display.
MarketedResources	String	True		A list of the items that were marketed in the marketing event. It's a list of dictionaries with type keys and id keys. Valid values for type are: (`product`, `collection`, `price_rule`, `page`, `article`, `homepage`). All types, other than homepage, also require an id.
StartedAt	Datetime	False		The timestamp when the marketing action was started, or when the email was sent, or when the Facebook post was made live, etc.
EndedAt	Datetime	False		For events with a duration, when the event actually ended. This may differ from ScheduledToEndAt, if the ad was stopped early, etc.
ScheduledToEndAt	Datetime	False		For events with a duration, when the event was supposed to end.

Metafields

Retrieves a list of metafields that belong to a resource.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, OwnerId and OwnerResource columns. The supported SQL operators are '=,IN' for the Id, OwnerResource and OwnerId columns. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Metafields WHERE Id = 721389482

SELECT * FROM Metafields WHERE ID IN (SELECT Id FROM Customers)

SELECT * FROM Metafields WHERE ID IN (19422939054103,19422939185175,19422939250711,19431415152663,19431415185431)

SELECT * FROM Metafields WHERE OwnerId = 64146833431 AND OwnerResource = 'product'

SELECT * FROM Metafields WHERE OwnerId = 64146833431 AND OwnerResource IN ('product', 'customer')

SELECT * FROM Metafields WHERE OwnerId IN (64146833430, 64146833431) AND OwnerResource = 'product'

SELECT * FROM Metafields WHERE OwnerResource = 'customer' AND OwnerId IN (SELECT Id FROM Customers);

Insert

You must specify the NameSpace, Key, and Value to create Metafields.

INSERT INTO Metafields (NameSpace,Key,Value,Type,Description,OwnerResource) VALUES ('inventory','warehouse',25,'number_integer','This is description about data','factory')

Update

You must specify the Id to update Metafields. For example:

UPDATE Metafields SET Value = 26 WHERE Id = 19766614851607

Delete

You must specify the Id of the Metafields to delete it.

DELETE FROM Metafields WHERE Id = 19766614851607

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique ID of the metafield.
Namespace	String	False		A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps.
Key	String	False		The name of the metafield.
Value	String	False		The information to be stored as metadata.
Type	String	False		The metafield's information type.
Description	String	False		A description of the information that the metafield contains.
OwnerId	Long	False		The unique ID of the resource that the metafield is attached to.
OwnerResource	String	False		The type of resource that the metafield is attached to. 使用できる値は次のとおりです。shop, draft_order, product, variant, page, article, order, customer, collection, blog, product_image
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the metafield was created.
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when the metafield was last updated.
AdminGraphqlApiId	String	True		The admin graphql api id

OrderRisks

Create, update, delete, and query order risks.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the order risk.
CauseCancel	Boolean	False		Whether this order risk is severe enough to force the cancellation of the order.
CheckoutId	Long	True		The ID of the checkout that the order risk belongs to.
Display	Boolean	False		Whether the order risk is displayed on the order details page in the Shopify admin.
Message	String	False		The message that's displayed to the merchant to indicate the results of the fraud check.
OrderId	Long	True	Orders.Id	The ID of the order that the order risk belongs to.
Recommendation	String	False		The recommended action given to the merchant. 使用できる値は次のとおりです。cancel, investigate, accept
Score	Decimal	False		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.
Source	String	False		The source of the order risk.

Orders

Create, update, delete, and query orders.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, FinancialStatus, FulfillmentStatus, CreatedAt, ProcessedAt and UpdatedAt columns. The supported SQL operators are '=' and 'IN' for Id, '=' for FinancialStatus, and FulfillmentStatus, and '>' and '<' for the CreatedAt, ProcessedAt, and UpdatedAt columns. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Orders

SELECT * FROM Orders WHERE Id='123'

SELECT * FROM Orders WHERE FinancialStatus = 'pending'

SELECT * FROM Orders WHERE CreatedAt > '2017-10-25'

Insert

Create a simple order with only a product variant Id using aggregates.

INSERT INTO Orders(LineAggregate) VALUES('[{\"variant_id\":\"4236041945111\",\"quantity\":2}]')

Create a simple order with only a product variant Id using temporary table. The temporary table you are populating is dynamic and will be created at run time the first time you insert to it. Temporary tables are denoted by a # appearing in their name. When using a temporary table to insert, the temporary table must be named in the format [TableName]#TEMP, where TableName is the name of the table you will be inserting to. For instance:
```
INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('123',2)
```
Once your temporary table is populated, it is now time to insert to the actual table in Shopify. You can do this by performing an INSERT to the actual table and setting as a value for LinesAggregate the name of the temporary table. For instance:
```
INSERT INTO Orders (LineAggregate) VALUES ('OrdersItems#Temp')
```

Create a simple order, sending the order receipt and fulfillment receipt to the customer using aggregates.

INSERT INTO Orders(Email, FulfillmentStatus, SendReceipt, SendFulfillmentReceipt, LineAggregate) VALUES('[email protected]', 'fulfilled', true, true, '[{\"variant_id\":\"4236041945111\",\"quantity\":2},{\"variant_id\":\"4236069011479\",\"quantity\":3}]')

Create a simple order, sending the order receipt and fulfillment receipt to the customer using temporary table.

INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('4236041945111',2)
INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('4236069011479',3)
INSERT INTO Orders (Email, FulfillmentStatus, SendReceipt, SendFulfillmentReceipt,LineAggregate) VALUES ('[email protected]', 'fulfilled', true, true,'OrdersItems#Temp')

Create a simple order, with taxes using aggregates.

INSERT INTO Orders(LineAggregate, TaxAggregate) VALUES('[{\"variant_id\":\"4236041945111\",\"quantity\":2},{\"variant_id\":\"4236069011479\",\"quantity\":3}]', '[{\"price\":10.2,\"rate\":0.06,\"title\":\"State Tax\"}]')

Create a simple order, with taxes using temporary table.

INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('4236041945111',2)
INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('4236069011479',3)
INSERT INTO TaxItems#Temp (TaxItemPrice, TaxItemRate,TaxItemTitle) VALUES (10.2, 0.06, 'State Tax')
INSERT INTO Orders (LineAggregate,TaxAggregate) VALUES ('OrdersItems#Temp','TaxItems#Temp')

Create a simple order, with multiple taxes using aggregates.

INSERT INTO Orders(LineAggregate, TaxAggregate) VALUES('[{\"variant_id\":\"4236041945111\",\"quantity\":2},{\"variant_id\":\"4236069011479\",\"quantity\":3}]', '[{\"price\":10.2,\"rate\":0.06,\"title\":\"State Tax\"},{\"price\":4.25,\"rate\":0.025,\"title\":\"County Tax\"}]')

Create a simple order, with multiple taxes using temporary table.

INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('4236041945111',2)
INSERT INTO OrdersItems#Temp (ItemVariantId,ItemQuantity) VALUES ('4236069011479',3)
INSERT INTO TaxItems#Temp (TaxItemPrice, TaxItemRate,TaxItemTitle) VALUES (10.2, 0.06, 'State Tax')
INSERT INTO TaxItems#Temp (TaxItemPrice, TaxItemRate,TaxItemTitle) VALUES (4.25, 0.025, 'County Tax')
INSERT INTO Orders (LineAggregate,TaxAggregate) VALUES ('OrdersItems#Temp','TaxItems#Temp')

Create a simple partially paid order containing a captured transaction using aggregates.

INSERT INTO Orders(LineAggregate, FinancialStatus, TransactionAggregate) VALUES('[{\"title\":\"Big Brown Bear Boots\",\"price\":25.99,\"quantity\":2}]', 'partially_paid', '[{\"status\":\"success\",\"kind\":\"capture\",\"amount\":52.57,\"gateway\":\"bogus\"}]')

Create a simple partially paid order containing a captured transaction using temporary table.

INSERT INTO OrdersItems#Temp (ItemTitle,ItemQuantity,ItemPrice) VALUES ('Big Brown Bear Boots',2,25.99)
INSERT INTO Transactions#Temp (TransactionItemAmount, TransactionItemKind, TransactionItemStatus, TransactionItemGateway) VALUES (52.57, 'capture', 'success', 'bogus')
INSERT INTO Orders (LineAggregate,FinancialStatus,TransactionAggregate) VALUES ('OrdersItems#Temp','partially_paid','Transactions#Temp')

Create a more comprehensive order using aggregates.

INSERT INTO Orders(LineAggregate) VALUES([{\"title\":\"Big Brown Bear Boots\",\"price\":74.99,\"grams\":1300,\"quantity\":3}])

Create a more comprehensive order using temporary table.

INSERT INTO OrdersItems#Temp (ItemTitle,ItemPrice,ItemGrams,ItemQuantity) VALUES ('Big Brown Bear Boots', 74.99, 1300, 3)
INSERT INTO Orders (LineAggregate) VALUES ('OrdersItems#Temp')

Create a pending order with an existing customer using aggregates.

INSERT INTO Orders(LineAggregate, CustomerId, FinancialStatus) VALUES('[{\"variant_id\":\"123\",\"quantity\":3}]', '456', 'pending')

Create a pending order with an existing customer using temporary table.

INSERT INTO OrdersItems#Temp (ItemVariantId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Orders (LineAggregate,CustomerId, FinancialStatus) VALUES ('OrdersItems#Temp','456', 'pending')

Create a partially paid order with a new customer and addresses using aggregates.

INSERT INTO Orders(LineAggregate, CustomerFirstName, CustomerLastName, CustomerEmail, FinancialStatus) VALUES('[{\"variant_id\":\"123\",\"quantity\":3}]', 'Paul', 'Norman', '[email protected]', 'partially_paid')

Create a partially paid order with a new customer and addresses using temporary.

INSERT INTO OrdersItems#Temp (ItemVariantId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Orders(LineAggregate, CustomerFirstName, CustomerLastName, CustomerEmail, FinancialStatus) VALUES('OrdersItems#Temp', 'Paul', 'Norman', '[email protected]', 'partially_paid')

Close an order (you must specify the Id of the order).

  INSERT INTO Orders(Id, Operation) VALUES('123', 'Close')

Reopen an order (you must specify the Id of the order).

  INSERT INTO Orders(Id, Operation) VALUES('123', 'Open')

Cancel an order (you must specify the Id of the order).

  INSERT INTO Orders(Id, Operation) VALUES('123', 'Cancel')

Update

Only columns BuyerAcceptsMarketing, Email, Phone, Note, Tags, ShippingAddressFirstName, ShippingAddressLastName, ShippingAddressAddress1, ShippingAddressAddress2, ShippingAddressPhone, ShippingAddressCity, ShippingAddressCompany, ShippingAddressZip, ShippingAddressProvince, ShippingAddressCountry, ShippingAddressLatitude, ShippingAddressLongitude, ShippingAddressName, ShippingAddressCountryCode, ShippingAddressProvinceCode and ShippingAddressDefault can be updated.

Update the shipping address of an existing order.

UPDATE Orders SET ShippingAddressAddress1='123 Ship Street', ShippingAddressCity='Shipsville' WHERE Id='123'

Update an order's tags.

UPDATE Orders SET Tags='External, Inbound, Outbound' WHERE Id='123'

Delete

You must specify the Id of the order when deleting an item from this table.

DELETE FROM Orders WHERE Id='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the order.
Number	Long	True		A unique identifier for the order, used by the shop owner and customer.
CustomerId	Long	False	Customers.Id	A unique numeric identifier for the customer.
CustomerFirstName	String	False		The first name of the customer.
CustomerLastName	String	False		The last name of the customer.
Currency	String	False		The three letter code (ISO 4217) for the currency used for the payment.
Email	String	False		The customer's email address.
Name	String	True		The customer's order name as represented by a number.
TotalDiscounts	Decimal	True		The total amount of the discounts to be applied to the price of the order.
TotalOrderItemsPrice	Decimal	True		The sum of all the prices of all the items in the order.
TotalPrice	Decimal	True		The sum of all the prices of all the items in the order, taxes and discounts included.
SubtotalPrice	Decimal	True		Price of the order before shipping and taxes.
TotalTax	Decimal	False		The sum of all the taxes applied to the order.
TotalWeight	Integer	True		The sum of all the weights of the line items in the order, in grams.
BrowserIp	String	True		The IP address of the browser used by the customer when placing the order.
BuyerAcceptsMarketing	Boolean	False		Indicates whether or not the person who placed the order would like to receive email updates from the shop.
CancelReason	String	True		The reason why the order was canceled.
CartToken	String	True		Unique identifier for a particular cart that is attached to a particular order.
OrderStatusUrl	String	True		The URL pointing to the order status web page.
Token	String	True		Unique identifier for a particular order.
TaxesIncluded	Boolean	False		States whether or not taxes are included in the order subtotal.
SourceName	String	True		Where the order originated.
ReferringSite	String	True		The website that the customer clicked on to come to the shop.
ProcessingMethod	String	True		States the type of payment processing method.
Phone	String	False		The customer's phone number.
Note	String	False		The text of an optional note that a shop owner can attach to the order.
LocationId	Long	True		The unique numeric identifier for the physical location at which the order was processed.
LandingSite	String	True		The URL for the page where the buyer landed when entering the shop.
Tags	String	False		Additional short descriptors.
FulfillmentStatus	String	False		The fulfillment status of the order.
FinancialStatus	String	False		The financial status of the order.
CustomerLocale	String	True		The customer locale of the order.
InvoiceSentAt	Datetime	True		This auto-generated property is the date and time when the invoice was emailed to the customer. Only available for draft orders.
InvoiceUrl	String	True		The URL for the invoice. Only available for draft orders.
TaxExempt	Boolean	True		States whether or not taxes are exempt for this order. Only available for draft orders.
DiscountCodes	String	True		Applicable discount codes that can be applied to the order.
LineAggregate	String	False		A JSON aggregate of line items associated with the order.
TaxAggregate	String	False		A JSON aggregate of tax line items associated with the order. Note, these taxes are applied on the order, not on individual items. If you want them to be applied on individual items, use them in LineAggregate. Tax lines must be associated with either order or line item but not both.
ShippingAggregate	String	False		A JSON aggregate of shipping line items associated with the order.
NoteAttributesAggregate	String	False		A JSON aggregate of note attributes associated with the order.
DiscountApplicationsAggregate	String	True		An ordered list of stacked discount applications.
BillingAddressFirstName	String	False		The first name of the person associated with the payment method.
BillingAddressLastName	String	False		The last name of the person associated with the payment method.
BillingAddressAddress1	String	False		The street address of the billing address.
BillingAddressAddress2	String	False		An optional additional field for the street address of the billing address.
BillingAddressPhone	String	False		The phone number at the billing address.
BillingAddressCity	String	False		The city of the billing address.
BillingAddressCompany	String	False		The company of the person associated with the billing address.
BillingAddressZip	String	False		The zip or postal code of the billing address.
BillingAddressProvince	String	False		The name of the state or province of the billing address.
BillingAddressCountry	String	False		The name of the country of the billing address.
BillingAddressLatitude	Double	False		The latitude of the billing address.
BillingAddressLongitude	Double	False		The longitude of the billing address.
BillingAddressName	String	False		The full name of the person associated with the payment method.
BillingAddressCountryCode	String	False		The two-letter code for the country of the billing address.
BillingAddressProvinceCode	String	False		The two-letter abbreviation of the state or province of the billing address.
BillingAddressDefault	Boolean	False		Whether this address is the default one or not.
ShippingAddressFirstName	String	False		The first name of the person associated with the shipping method.
ShippingAddressLastName	String	False		The last name of the person associated with the shipping method.
ShippingAddressAddress1	String	False		The street address of the shipping address.
ShippingAddressAddress2	String	False		An optional additional field for the street address of the shipping address.
ShippingAddressPhone	String	False		The phone number at the shipping address.
ShippingAddressCity	String	False		The city of the shipping address.
ShippingAddressCompany	String	False		The company of the person associated with the shipping address.
ShippingAddressZip	String	False		The zip or postal code of the shipping address.
ShippingAddressProvince	String	False		The name of the state or province of the shipping address.
ShippingAddressCountry	String	False		The name of the country of the shipping address.
ShippingAddressLatitude	Double	False		The latitude of the shipping address.
ShippingAddressLongitude	Double	False		The longitude of the shipping address.
ShippingAddressName	String	False		The full name of the person associated with the shipping method.
ShippingAddressCountryCode	String	False		The two-letter code for the country of the shipping address.
ShippingAddressProvinceCode	String	False		The two-letter abbreviation of the state or province of the shipping address.
ShippingAddressDefault	Boolean	False		Whether this address is the default one or not.
AppliedDiscountTitle	String	False		The title of the applied discount for this order. Only available for draft orders.
AppliedDiscountDescription	String	False		The description of the applied discount for order. Only available for draft orders.
AppliedDiscountValue	Decimal	False		The value of the applied discount for this order. Only available for draft orders.
AppliedDiscountValueType	String	False		The value type of the applied discount for order. Only available for draft orders.
AppliedDiscountAmount	Decimal	False		The amount of the applied discount for this order. Only available for draft orders.
PaymentTermsAmount	Long	True		The amount that is owed according to the payment terms.
PaymentTermsCurrency	String	True		The presentment currency for the payment.
PaymentTermsPaymentTermsName	String	True		The name of the selected payment terms template for the order.
PaymentTermsPaymentTermsType	String	True		The type of selected payment terms template for the order.
PaymentTermsDueInDays	Integer	True		The number of days between the invoice date and due date that is defined in the selected payment terms template.
PaymentTermsPaymentSchedules	String	True		An array of schedules associated to the payment terms.
ProcessedAt	Datetime	True		The date and time when the order was imported, in ISO 8601 format.
CreatedAt	Datetime	True		The date and time when the order was created.
ClosedAt	Datetime	True		The date and time when the order was closed.
CancelledAt	Datetime	True		The date and time when the order was canceled.
UpdatedAt	Datetime	True		The date and time when the order was last modified.
SendReceipt	Boolean	False		Determines whether an order confirmation will be sent to the customer. デフォルト値はfalseです。
SendFulfillmentReceipt	Boolean	False		Determines whether a fulfillment confirmation will be sent to the customer. デフォルト値はfalseです。
InventoryBehaviour	String	False		Determines which inventory updating behavior is used. The following values are available: default, decrement_ignoring_policy, decrementobeying_policy 使用できる値は次のとおりです。default, decrement_ignoring_policy, decrementobeying_policy デフォルト値はdefaultです。
Operation	String	False		An operation to apply to the Order. Valid values for order: Close, Open, or Cancel. 使用できる値は次のとおりです。Close, Open, Cancel
TotalShippingPriceSetShopMoneyAmount	Double	True		The amount of the shop money in the total shipping price set.
TotalShippingPriceSetShopMoneyCurrencyCode	String	True		The currency code of the shop money in the total shipping price set.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Status	String	Filter orders by their status. Valid values are: open: show only open orders, closed: show only closed orders, cancelled: show only canceled orders, any: show orders of any status,default: open.

OrderTransactions

Create and query transactions.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId column. The Sync App processes other filters client-side within the Sync App.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server side.

SELECT * FROM OrderTransactions WHERE OrderId = '123'

When performing a query without a filter or a filter other then the OrderId column, the Sync App will retrieve the entire list of transactions and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving transactions. Therefore to retrieve all the transactions, the Sync App will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the Sync App will issue individual requests to the Shopify API to retrieve all the transactions for each OrderId to build the result set.

SELECT * FROM OrderTransactions

SELECT * FROM OrderTransactions WHERE Kind='Capture'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. Other search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the OrderId and Kind when inserting a transaction.

Capture a specified amount on a previously authorized order.

INSERT INTO OrderTransactions(OrderId, Amount, Kind) VALUES('123', 10.25, 'Capture')

Capture a previously authorized order for the full amount.

INSERT INTO OrderTransactions(OrderId, Kind) VALUES('123', 'Capture')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the transaction.
OrderId	Long	False	Orders.Id	A unique numeric identifier for the order.
UserId	Long	True		The unique identifier for the user.
LocationId	Long	True		The ID of the physical location where the transaction was processed.
Amount	Decimal	False		The amount of money that the transaction was for.
Authorization	String	True		The authorization code associated with the transaction.
Currency	String	True		The three letter code (ISO 4217) for the currency used for the payment.
DeviceId	String	True		The unique identifier for the device.
Gateway	String	False		The name of the gateway the transaction was issued through.
SourceName	String	True		The origin of the transaction.
Kind	String	False		The kind of transaction. Can be any of the following: Authorization, Capture, Sale, Void, Refund. 使用できる値は次のとおりです。Authorization, Capture, Sale, Void, Refund
Message	String	True		The message associated with this transaction.
ErrorCode	String	True		A standardized error code, independent of the payment provider.
Status	String	False		The status of the transaction.
Test	Boolean	True		The option to use the transaction for testing purposes.
AVSResultCode	String	True		The Response code from the address verification system.
CreditCardBin	String	True		The issuer identification number (IIN).
CVVResultCode	String	True		The Response code from the credit card company.
CreditCardNumber	String	True		The customer's credit card number, with most of the leading digits redacted with Xs.
CreditCardCompany	String	True		The name of the company who issued the customer's credit card.
CreatedAt	Datetime	True		The date and time when the customer was created.
PaymentsRefundsAttributesStatus	String	True		The current status of the refund 使用できる値は次のとおりです。pending, faliure, success, error
PaymentsRefundsAttributesAcquirerReferenceNumber	String	True		A unique number associated with the transaction that can be used to track the refund.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
TransactionItemAmount	Decimal	The amount of money that the transaction was for. Use this when inserting transactions into an order or refund.
TransactionItemGateway	String	The name of the gateway the transaction was issued through. Use this when inserting transactions into an order or refund.
TransActionItemKind	String	The kind of transaction. Can be any of the following: Authorization, Capture, Sale, Void, Refund. Use this when inserting transactions into an order or refund. 使用できる値は次のとおりです。Authorization, Capture, Sale, Void, Refund
TransactionItemStatus	String	The status of the transaction. Use this when inserting transactions into an order or refund.
TransactionItemParentId	String	The parent id of the transaction. Use this when inserting transactions into a refund.
UpdatedAt	Datetime	The last time the order is updated.

Pages

Create, read, update or delete pages

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Pages

SELECT * FROM Pages WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify the Title to create a Page.

INSERT INTO Pages(title) VALUES ('new Page')

Update

You must specify the id to update a Page. For example:

UPDATE Pages SET author='Harry' WHERE Id = '77171130'

Delete

You must specify the Id of the Page to delete it.

DELETE FROM Pages WHERE Id = '555695'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique numeric identifier for the page.
AdminGraphqlApiId	String	True		Displays the Admin Graphql API id.
Author	String	False		The name of the person who created the page.
BodyHtml	String	False		The text content of the page, complete with HTML markup.
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the page was created.
Handle	String	False		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.
Metafields	String	True		Additional information attached to the Page object.
PublishedAt	Datetime	False		The date and time (ISO 8601 format) when the page was published. Returns null when the page is hidden.
ShopId	Long	True		The ID of the shop to which the page belongs.
TemplateSuffix	String	False		The suffix of the Liquid template being used.
Title	String	False		The page's title.
UpdatedAt	Datetime	True		The date and time (ISO 8601 format) when the page was last updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
published_status	String	Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any.

PriceRules

Create, update, delete, and query price rules.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM PriceRules WHERE Id = '123'

Insert

You must specify the Title, TargetType, TargetSelection, ValueType, Value, CustomerSelection, StartsAt, and AllocationMethod columns to create a price rule. For example:

INSERT INTO PriceRules (Title,TargetType,TargetSelection,ValueType,Value,CustomerSelection,StartsAt,AllocationMethod) VALUES ('SUMMERSALE10OFF', 'line_item', 'all', 'fixed_amount', '-10.0', 'all', '2017-01-19T17:59:10Z','across')

Update

You must specify the Id to update a price rule. For example:

UPDATE PriceRules SET Title = 'SUMMERSALE10OFF' WHERE Id = '123'

Delete

You must specify the Id of the price rule to delete it.

DELETE FROM PriceRules WHERE Id = '123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the price rule.
AllocationMethod	String	False		The allocation method of the price rule. Valid values: each: The discount is applied to each of the entitled items. across: The calculated discount amount will be applied across the entitled items. 使用できる値は次のとおりです。each, across
CustomerSelection	String	False		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 saved searches specified by PrerequisiteSavedSearchIds. 使用できる値は次のとおりです。all, prerequisite
EntitledCollectionIds	String	False		A list of Ids of collections whose products will be eligible to the discount. It can be used only with TargetType set to line_item and TargetSelection set to entitled. It can't be used in combination with EntitledProductIds or EntitledVariantIds.
EntitledCountryIds	String	False		A list of Ids of shipping countries that will be entitled to the discount. It can be used only with TargetType set to shipping_line and TargetSelection set to entitled.
EntitledProductIds	String	False		A list of Ids of products that will be entitled to the discount. It can be used only with TargetType set to line_item and TargetSelection set to entitled.
EntitledVariantIds	String	False		A list of Ids of product variants that will be entitled to the discount. It can be used only with TargetType set to line_item and TargetSelection set to entitled.
OncePerCustomer	Boolean	False		Whether the generated discount code will be valid only for a single use per customer. This is tracked using customer Id.
PrerequisiteCustomerIds	String	False		A list of customer Ids which for the price rule to be applicable, the customer must match one of the specified customers. If PrerequisiteCustomerIds is populated, then PrerequisiteSavedSearchIds must be empty.
PrerequisiteQuantityRange	String	False		The minimum number of items for the price rule to be applicable. It has the following property: greater_than_or_equal_to: The quantity of an entitled cart item must be greater than or equal to this value.
PrerequisiteSavedSearchIds	String	False		A list of customer saved search Ids. For the price rule to be applicable, the customer must be in the group of customers matching a customer saved search. If PrerequisiteSavedSearchIds is populated, then PrerequisiteCustomerIds must be empty.
PrerequisiteShippingPriceRange	String	False		The maximum shipping price for the price rule to be applicable. It has the following property: less_than_or_equal_to: The shipping price must be less than or equal to this value.
PrerequisiteSubtotalRange	String	False		The minimum subtotal for the price rule to be applicable. It has the following property: greater_than_or_equal_to: The subtotal of the entitled cart items must be greater than or equal to this value for the discount to apply.
TargetSelection	String	False		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.
TargetType	String	False		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.
UsageLimit	Integer	False		The maximum number of times the price rule can be used, per discount code.
PrerequisiteProductIds	String	False		List of product ids that will be a prerequisites for a Buy X Get Y type discount. The PrerequisiteProductIds can be used only with: TargetType set to line_item, TargetSelection set to entitled, AllocationMethod set to each and PrerequisiteToEntitlementQuantityRatio defined. Caution: If a product variant is included in PrerequisiteVariantIds, then PrerequisiteProductIds can't include the ID of the product associated with that variant.
PrerequisiteVariantIds	String	False		List of variant ids that will be a prerequisites for a Buy X Get Y type discount. The EntitledVariantIds can be used only with: TargetType set to line_item, TargetSelection set to entitled, AllocationMethod set to each and PrerequisiteToEntitlementQuantityRatio defined. Caution: If a product is included in PrerequisiteProductIds, then PrerequisiteVariantIds can't include the ID of any variants associated with that product.
PrerequisiteCollectionIds	String	False		List of collection ids that will be a prerequisites for a Buy X Get Y discount. The EntitledCollectionIds can be used only with: TargetType set to line_item, TargetSelection set to entitled, AllocationMethod set to each and PrerequisiteToEntitlementQuantityRatio defined. Cannot be used in combination with PrerequisiteProductIds or PrerequisiteVariantIds.
Value	Decimal	False		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.
ValueType	String	False		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 TargetType is shipping_line, then only percentage is accepted.
PrerequisiteToEntitlementQuantityRatio	String	False		Buy/Get ratio for a Buy X Get Y discount. prerequisite_quantity defines the necessary 'buy' quantity and entitled_quantity the offered 'get' quantity. The PrerequisiteToEntitlementQuantityRatio can be used only with: ValueType set to percentage, TargetType set to line_item, TargetSelection set to entitled, AllocationMethod set to each, PrerequisiteProductIds or PrerequisiteVariantIds or PrerequisiteCollectionIds defined and EntitledProductIds or EntitledVariantIds or EntitledCollectionIds defined.
Images	String	False		A list of image objects.
ProductType	String	False		A categorization that a product can be tagged with, commonly used for filtering and searching.
Options	String	True		Custom product property names.
PublishedScope	String	False		Indicates whether the product is published to the Point of Sale channel.
Tags	String	False		A categorization that a product can be tagged with. Use commas to separate categories.
TemplateSuffix	String	True		The suffix of the liquid template being used.
Title	String	False		The name of the product.
Vendor	String	False		The name of the vendor of the product.
StartsAt	Datetime	False		The date and time when the price rule starts.
EndsAt	Datetime	False		The date and time when the price rule ends. Must be after StartsAt.
PublishedAt	Datetime	True		The date and time when the product was published to the Online Store channel.
CreatedAt	Datetime	True		The date and time when the price rule was created.
UpdatedAt	Datetime	True		The date and time when the price rule was last modified.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Published	Boolean	Set to true to publish the product or to false to not publish it
MetafieldsGlobalTitleTag	String	The name of the product, to be used for SEO purposes.
MetafieldsGlobalDescriptionTag	String	The description of the product, to be used for SEO purposes.

ProductImages

Query, Update and Delete Product Images

View-Specific Information

The Sync App uses the Shopify API to process search criteria that refer to the ProductId and ImageId. The supported SQL operators are '=' for ProductId and '=' for ImageId. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

Select

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

SELECT * FROM ProductImages WHERE ProductId = '123'

SELECT * FROM ProductImages WHERE ProductId = '123' AND ImageId = '2342'

Insert

To create a new product image with image data as attachment

INSERT INTO ProductImages (productid,filename,attachment) VALUES ('64146735127','test.png','iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg==')")

To create a new product image using a source URL that will be downloaded by Shopify

INSERT INTO ProductImages (productid,filepath) VALUES ('64146735127','http://example.com/rails_logo.gif')")

To create a new product image and make it the main image

INSERT INTO ProductImages (productid,position,filename,filepath) VALUES ('64146735127',1,'test.png','http://example.com/rails_logo.gif')")

To create a new product image and attach it to product variants

INSERT INTO ProductImages (productid,variantids,filename,attachment) VALUES ('64146735127','[808950810,457924702]','test.png','iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg==')")

Update

To update a product image you must specify its ProductId and ImageId.

To change the position and alt tag content for an image

UPDATE ProductImages SET Position = 1, Alt = 'This is the main image' WHERE ProductId = '123' AND ImageId = '2342'

To add it to product variants for an image

UPDATE ProductImages SET VariantIds = '[808950810,457924702]'  WHERE ProductId = '123' AND ImageId = '2342'

Delete

To delete a product image you must specify its Id.

DELETE FROM ProductImages WHERE ProductId = '123' AND ImageId = '2342'

Columns


Name	Type	ReadOnly	References	Description
ImageId [KEY]	Long	True		A unique numeric identifier for the product image.
ProductId	Long	True	Products.Id	The id of the product associated with the image.
VariantIds	String	False		The array of variant ids associated with the image.
Position	Integer	False		The order of the product image in the list.
FilePath	String	False		Full path to the image. Can be locally or online. Example: http://example.com/rails_logo.gif. Either this or Base64Content are required.
Width	Integer	True		The width of the image.
Height	Integer	True		The height of the image.
CreatedAt	Datetime	True		The datetime when the image was created.
UpdatedAt	Datetime	True		The datetime when the image was updated.
Alt	String	False		The Alt content of the image.
Src	String	False		Specifies the location of the product image. This parameter supports URL filters that you can use to retrieve modified copies of the image.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
FileName	String	The name that the image will be displayed in the application.
Attachment	String	Base64 encoded bytes of the image. Either this or FilePath are required.

ProductListings

Query and delete product listings.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the ProductId, UpdatedAt, and Handle columns. The supported SQL operators are '=' and 'IN' for ProductId, '=' for Handle, and '>' for the UpdatedAt column. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM ProductListings

SELECT * FROM ProductListings WHERE ProductId='123'

SELECT * FROM ProductListings WHERE ProductId IN ('123','456')

SELECT * FROM ProductListings WHERE UpdatedAt>'2018-02-21'

SELECT * FROM ProductListings WHERE Handle='ipod-nano'

Delete

Delete a product listing to unpublish a product from your app (ProductId is required):

DELETE FROM ProductListings WHERE Productid=512433520663

Columns


Name	Type	ReadOnly	References	Description
ProductId [KEY]	Long	False		The unique identifer of the product this listing is for. The primary key for this resource.
Title	String	False		The name of the product.
BodyHtml	String	False		The description of the product, complete with HTML formatting.
Handle	String	True		A human-friendly unique string for the Product automatically generated from its title.
Variants	String	True		A list of variant objects, each one representing a slightly different version of the product.
Images	String	False		A list of image objects, each one representing an image associated with the product.
ProductType	String	False		A categorization that a product can be tagged with, commonly used for filtering and searching.
Options	String	True		Custom product property names like 'Size', 'Color', and 'Material'.
Tags	String	False		A categorization that a product can be tagged with, commonly used for filtering.
Vendor	String	False		The name of the vendor of the product.
PublishedAt	Datetime	True		The date and time when the product was published to the Online Store channel.
CreatedAt	Datetime	True		The date and time when the product was created.
UpdatedAt	Datetime	True		The date and time when the product was last modified.

Products

Create, update, delete, and query products.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the following columns: Id, Title, Vendor, Handle, ProductType, PublishedStatus, CreatedAt, PublishedAt, and UpdatedAt. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side.

SELECT * FROM Products

SELECT * FROM Products WHERE Id = '123'

SELECT * FROM Products WHERE Id IN ('123','456')

SELECT * FROM Products WHERE CreatedAt > '2017-10-25'

SELECT * FROM Products WHERE Title = 'just a title'

SELECT * FROM Products WHERE Vendor = 'just a vendor'

Insert

Create a new product with the default product variant.

INSERT INTO Products(Title, BodyHtml, Vendor, ProductType, Tags) VALUES('Burton Custom Freestyle 151', 'Good snowboard!', 'Burton', 'Snowboard', 'Barnes & Noble, Johns Fav, Big Air')

Create a new unpublished product.

INSERT INTO Products(Title, BodyHtml, Vendor, ProductType, Tags, Published) VALUES('Burton Custom Freestyle 151', 'Good snowboard!', 'Burton', 'Snowboard', 'Barnes & Noble, Johns Fav, Big Air', false)

Update

To update a product you must specify its Id.

UPDATE Products SET Published=true  WHERE Id='123'

UPDATE Products SET MetafieldsGlobalTitleTag='Brand new title', MetafieldsGlobalDescriptionTag='Brand new description'  WHERE Id='123'

Delete

To delete a product you must specify its Id.

DELETE FROM Products WHERE Id='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the product.
BodyHtml	String	False		The description of the product, complete with HTML formatting.
Handle	String	True		A human-friendly unique string for the Product automatically generated from its title.
Images	String	False		A list of image objects.
ProductType	String	False		A categorization that a product can be tagged with, commonly used for filtering and searching.
Options	String	True		Custom product property names.
PublishedScope	String	False		Indicates whether the product is published to the Point of Sale channel.
Tags	String	False		A categorization that a product can be tagged with. Use commas to separate categories.
Status	String	False		The status of the product. 使用できる値は次のとおりです。active, archived, draft
TemplateSuffix	String	True		The suffix of the liquid template being used.
Title	String	False		The name of the product.
Vendor	String	False		The name of the vendor of the product.
PublishedAt	Datetime	True		The date and time when the product was published to the Online Store channel.
CreatedAt	Datetime	True		The date and time when the product was created.
UpdatedAt	Datetime	True		The date and time when the product was last modified.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
PublishedStatus	String	Return products by their published status: published: show only published products;unpublished: show only unpublished products; any: show all products.
Published	Boolean	Set to true to publish the product or to false to not publish it
MetafieldsGlobalTitleTag	String	The name of the product, to be used for SEO purposes.
MetafieldsGlobalDescriptionTag	String	The description of the product, to be used for SEO purposes.

ProductVariants

Query and delete product listings.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id and ProductId column. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side.

SELECT * FROM ProductVariants

SELECT * FROM ProductVariants WHERE Id = '123'

SELECT * FROM ProductVariants WHERE Id IN ('123','456')

SELECT * FROM ProductVariants WHERE ProductId = '456'

Insert

You must specify the ProductId to insert a product variant.

INSERT INTO ProductVariants(ProductId, Option1, Price) VALUES('123', 'Yellow', 3.5)

Update

You must specify the Id of the variant to edit a product variant.

Update the title and price of an existing variant.

UPDATE ProductVariants SET Option1='Pink', Price=99.99  WHERE Id='123'

Delete

You must specify the ProductId and the Id of the variant to delete a product variant.

DELETE FROM ProductVariants WHERE Id='123' AND ProductId='456'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the product variant.
ProductId	Long	False		A unique numeric identifier for the product this variant belongs to.
InventoryItemId	String	False		The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information.
ImageId	Long	False		A unique numeric identifier for the image this variant belongs to.
Price	Decimal	False		The price of the product variant.
CompareAtPrice	String	False		The competitors prices for the same item.
Title	String	False		The name of the product.
Grams	Integer	False		The weight of the product variant in grams.
Barcode	String	False		A human-friendly unique string for the Product automatically generated from its title.
Weight	Double	False		The weight of the product variant in the unit system specified.
WeightUnit	String	True		The unit of measurement that applies to the product's variant weight.
FulfillmentService	String	False		Service which is doing the fulfillment.
InventoryManagement	String	False		Specifies whether or not Shopify tracks the number of items in stock for this product variant.
InventoryPolicy	String	True		Specifies whether or not customers are allowed to place an order for a product variant when it's out of stock. Valid values are deny or continue.
InventoryQuantity	Integer	True		The number of items in stock for this product variant. Default value 1.
Option1	String	False		Custom properties that a shop owner can use to define product variants.
Option2	String	False		Custom properties that a shop owner can use to define product variants.
Option3	String	False		Custom properties that a shop owner can use to define product variants.
Position	Integer	False		The order of the product variant in the list of product variants.
RequiresShipping	Boolean	False		Specifies whether or not a customer needs to provide a shipping address when placing an order for this product variant.
Sku	String	False		A unique identifier for the product in the shop.
Taxable	Boolean	False		Specifies whether or not a tax is charged when the product variant is sold.
CreatedAt	Datetime	True		The date and time when the product variant was created.
UpdatedAt	Datetime	True		The date and time when the product was last modified.

Provinces

Query and update information regarding different provinces.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the ProductId, UpdatedAt, and Handle columns. The supported SQL operators are '=' and 'IN' for ProductId, '=' for Handle, and '>' for the CreatedAt column. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

For example, the following queries are processed server side:

SELECT * FROM Provinces

SELECT * FROM Provinces WHERE CountryId='123'

Update

You must specify the CountryId and Id to update a province. For example:

UPDATE Provinces Set Tax='3.4' WHERE CountryId='123' AND Id='456'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The ID for the province.
CountryId [KEY]	Long	True	Countries.Id	The ID for the country that the province belongs to.
Name	String	False		The full name of the province.
Code	String	False		The standard abbreviation for the province.
Tax	Decimal	False		The sales tax rate to be applied to orders made by customers from this province..
TaxPercentage	Double	False		The province's tax in percent format.
TaxName	String	False		The name of the tax for this province.
TaxType	String	False		The tax type. Valid values: normal, null, or harmonized. If the value is harmonized, then the tax is compounded of the provincial and federal sales taxes.
ShippingZoneId	Long	True	ShippingZones.Id	The ID for the shipping zone that the province belongs to.

RecurringApplicationCharges

Create, update, delete, and query Recurring Application Charges.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM RecurringApplicationCharges

SELECT * FROM RecurringApplicationCharges WHERE Id = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Update

UPDATE RecurringApplicationCharges SET Test = 'true', Name = 'cd' WHERE Id ='2'

Delete

You must specify the Id of the recurring application charge to delete it.

DELETE From RecurringApplicationCharges WHERE Id ='2'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		The ID of the recurring application charge.
Name	String	False		The name of the recurring application charge.
ApiClientId	String	False		The API Client Id
Price	Decimal	False		The price of the recurring application charge. The maximum price is 10,000.
Status	String	False		The status of the recurring charge
ReturnUrl	String	False		The URL where the merchant is redirected after accepting the charge.
BillingOn	Date	False		The date and time (ISO 8601 format) when the customer was billed.
Test	String	False		Whether the application charge is a test transaction.
CreatedAt	Datetime	False		The date and time (ISO 8601 format) when the recurring application charge was created.
UpdatedAt	Datetime	False		The date and time (ISO 8601 format) when the recurring application charge was last updated.
ActivatedOn	Datetime	False		The date and time (ISO 8601 format) when the customer activated the recurring application charge.
CancelledOn	Datetime	False		The date and time (ISO 8601 format) when the merchant canceled their recurring application charge.
TrialDays	Integer	False		The number of days that the customer is eligible for a free trial.
TrialEndsOn	Datetime	False		The date and time (ISO 8601 format) when the free trial ends.
DecoratedReturnUrl	String	False		The decorated return url.
CappedAmount	String	False		The limit a customer can be charged for usage based billing. If this property is provided, then you must also provide the terms property.
ConfirmationUrl	String	False		The URL where the merchant accepts or declines the recurring application charge.
Terms	String	False		The terms and conditions of usage based billing charges. Must be present in order to create usage charges,

Redirects

Create, read, update or delete redirects.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Redirects

SELECT * FROM Redirects WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify path and target to create a Redirect.

INSERT INTO Redirects(path,target) VALUES ('/abc.php','/pqr.jsp')

Update

You must specify the id to update a Redirect. For example:

UPDATE Redirects SET Path='/abc.php' WHERE Id = '77171130'

Delete

You must specify the Id of the Redirect to delete it.

DELETE FROM Redirects WHERE Id = '555695'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The ID for the redirect.
Path	String	False		The old path to be redirected.
Target	String	False		The target location where the user will be redirected.

Refunds

Create and query refunds.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId column. The Sync App processes other filters client-side within the Sync App.

For example, the following queries are processed server side. If you specify the unique identifier of the Order, then this view will only list refund information concerning that order.

SELECT * FROM Refunds

SELECT * FROM Refunds WHERE OrderId = '179098550295'

SELECT * FROM Refunds WHERE OrderId='179098550295' AND Id='7382073367'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. When SupportEnhancedSQL is false, you must specify at least OrderId. The Shopify APIs require that queries contain this filter. Search criteria that refers to other columns will cause an error.

Insert

You must specify the OrderId when inserting a refund.

Calculate a refund for a line item and shipping using aggregates.

INSERT INTO Refunds(OrderId, CalculateRefund, ShippingFullRefund, LineAggregate) VALUES('123', true, true, '[{\"id\":\"123\",\"quantity\":3,\"restock_type\": \"return\",\"location_id\": \"12346\"}]')

Calculate a refund for a line item and shipping using temporary table.

INSERT INTO OrdersItems#Temp (ItemId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Refunds(OrderId, CalculateRefund, ShippingFullRefund, LineAggregate) VALUES('123', true, true, 'OrdersItems#Temp')

Calculate a refund for a partial amount of shipping.

INSERT INTO Refunds(OrderId, CalculateRefund, ShippingAmount) VALUES('123', true, 2.56)

Create a new refund for an order using aggregates.

INSERT INTO Refunds(OrderId, Restock, Notify, Note, ShippingFullRefund, LineAggregate) VALUES('123', true, true, 'Wrong size', true, '[{\"id\":\"123\",\"quantity\":3,\"restock_type\": \"return\"}]')

Create a new refund for an order using temporary table.

INSERT INTO OrdersItems#Temp (ItemId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Refunds(OrderId, Restock, Notify, Note, ShippingFullRefund, LineAggregate) VALUES('123', true, true, 'Wrong size', true, 'OrdersItems#Temp')

Create a new refund for an order and attach a transaction to the refund as well using aggregates.

INSERT INTO Refunds(OrderId, LineAggregate, OrderTransactionAggregate) VALUES('123', '[{\"id\":\"123\",\"quantity\":3,\"restock_type\": \"return\"}]', '[{\"kind\":\"refund\",\"amount\":5.5,\"gateway\":\"bogus\",\"parent_id\":\"789\"}]')

Create a new refund for an order and attach a transaction to the refund as well using temporary table.

INSERT INTO OrdersItems#Temp (ItemId, ItemQuantity) VALUES ('123', 3)
INSERT INTO Transactions#Temp (TransactionItemParentId, TransactionItemAmount, TransactionItemKind, TransactionItemGateway) VALUES ('789', 5.5, 'refund', 'bogus')
INSERT INTO Refunds(OrderId, LineAggregate, OrderTransactionAggregate) VALUES('123', 'OrdersItems#Temp','Transactions#Temp')

Refund a specific amount of shipping using aggregates.

INSERT INTO Refunds(OrderId, ShippingAmount, OrderTransactionAggregate) VALUES('123', 5.3, '[{\"parent_id\":\"456\"}]')

Refund a specific amount of shipping using temporary table.

INSERT INTO Transactions#Temp (TransactionItemParentId) VALUES ('456')
INSERT INTO Refunds(OrderId, ShippingAmount, OrderTransactionAggregate) VALUES('123', 5.3, 'Transactions#Temp')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique identifier for the refund.
OrderId	Long	False	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime	True	Orders.UpdatedAt	The date and time when the order was last modified.
Note	String	False		The optional note attached to a refund.
Restock	Boolean	True		Whether or not the line items were added back to the store inventory.
UserId	Long	True		The unique identifier of the user who performed the refund.
CreatedAt	Datetime	True		The date and time when the refund was created.
ProcessedAt	Datetime	True		The date and time when the refund was imported.
LineAggregate	String	False		A JSON aggregate of line items associated with the refund.
OrderTransactionAggregate	String	False		A JSON aggregate of transactions associated with the refund.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Notify	Boolean	Whether or not to send a refund notification to the customer.
DiscrepancyReason	String	An optional comment, used if there is a discrepancy between calculated and actual refund amounts (one of: restock, damage, customer, other)
ShippingAmount	Decimal	Set specific amount of shipping to refund. Takes precedence over FullRefund.
ShippingFullRefund	Boolean	Whether or not to to refund all remaining shipping.
CalculateRefund	Boolean	Set to true to simply calculate the refund but not process it デフォルト値はfalseです。

ScriptTags

Create, read, update or delete script tags.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM ScriptTags

SELECT * FROM ScriptTags WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify event and src to create a ScriptTag.

INSERT INTO Scripttags(event,src) VALUES ('onload','https://js-aplenty.com/abc.js')

Update

You must specify the id to update a ScriptTag. For example:

UPDATE ScriptTags SET src='https://js-aplenty.com/abc.js' WHERE Id = '77171130'

Delete

You must specify the Id of the ScriptTag to delete it.

DELETE FROM ScriptTags WHERE Id = '555695'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The ID for the script tag.
Cache	Boolean	False		Whether the Shopify CDN can cache and serve the script tag.
CreatedAt	Datetime	True		The date and time (ISO 8601) when the script tag was created.
DisplayScope	String	False		The page or pages on the online store where the script should be included. 使用できる値は次のとおりです。online_store, order_status, all
Event	String	False		The DOM event that triggers the loading of the script. Valid values: onload.
Src	String	False		The URL of the remote script.
UpdatedAt	Datetime	True		The date and time (ISO 8601) when the script tag was last updated.

SmartCollections

Query, insert, update, or delete information regarding different smart collections.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, ProductId, Title, Handle, PublishedStatus, UpdatedAt, PublishedAt columns. The supported SQL operators are '=' and 'IN' for Id, '=' for the ProductId, Title, Handle, and PublishedStatus columns and '>' and '<' for the UpdatedAt and PublishedAt columns. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side.

SELECT * FROM SmartCollections

SELECT * FROM SmartCollections WHERE Id='123'

SELECT * FROM SmartCollections WHERE Id IN ('123','456')

SELECT * FROM SmartCollections WHERE ProductId='123'

SELECT * FROM SmartCollections WHERE Title='Ducks'

SELECT * FROM SmartCollections WHERE Handle='frontpage'

SELECT * FROM SmartCollections WHERE PublishedStatus='published'

SELECT * FROM SmartCollections WHERE UpdatedAt > '2018-05-02'

SELECT * FROM SmartCollections WHERE PublishedAt < '2017-08-15'

Insert

You must specify the Title and Rules to create a smart collection. For example:

INSERT INTO SmartCollections (Title, Rules) VALUES ('IPods', '[{"column": "vendor","relation": "equals","condition": "Apple"}]')

Update

You must specify the smart collection Id to update a smart collection. For example:

UPDATE SmartCollections SET BodyHtml='5000 songs in your pocket' WHERE Id='123'

Delete

You must specify the Id of the smart collection to delete it.

DELETE FROM SmartCollections WHERE Id ='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The ID of the smart collection.
Title	String	False		The name of the smart collection. Maximum length: 255 characters.
BodyHtml	String	False		The description of the smart collection. Includes HTML markup. Many shop themes display this on the smart collection page.
Image	String	False		A JSON aggregate with information regarding the image of smart collection.
Rules	String	False		A JSON aggregate with the list of rules that define what products go into the smart collection. Valid values for each rule field: column: tag, title, type, vendor, variant_price, variant_compare_at_price, variant_weight, variant_inventory, variant_title; relation: equals, greater_than, less_than, starts_with, ends_with, contains; condition: any string
Handle	String	False		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)
Disjunctive	Boolean	False		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.
SortOrder	String	False		The order in which products in the smart collection appear.
TemplateSuffix	String	False		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.
PublishedScope	String	False		Whether the smart collection is published to Point of Sale. Valid values: web: The smart collection is published to the shop's online channels and not published to the Point of Sale channel, global: The smart collection is published to both the online channels and the Point of Sale channel.
UpdatedAt	Datetime	True		The date and time when the smart collection was last modified.
PublishedAt	Datetime	True		The date and time when the smart collection was published. Returns null when the collection is hidden.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ProductId	String	Show smart collections that include a given product.
PublishedStatus	String	Show smart collection with a given published status: published: show only published smart collections, unpublished: show only unpublished smart collections, any: show all smart collections. (default: any).

Themes

Create, read, update or delete themes

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM Themes

SELECT * FROM Themes WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify name to create a Theme.

INSERT INTO Themes(name) VALUES ('NewTheme')

Update

You must specify the id to update a Theme. For example:

UPDATE Themes SET name='NewTheme' WHERE Id = '77171130'

Delete

You must specify the Id of the Theme to delete it.

DELETE FROM Themes WHERE Id = '555695'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the theme.
AdminGraphqlApiId	String	True		Displays the Admin Graphql API id.
CreatedAt	Datetime	True		The date and time (ISO 8601 format) when the theme was created.
Name	String	False		The name of the theme.
Previewable	Boolean	True		Whether the theme can currently be previewed.
Processing	Boolean	True		Whether files are still being copied into place for this theme.
Role	String	False		Specifies how the theme is being used within the shop. 使用できる値は次のとおりです。main, published, demo
ThemeStoreId	Long	True		A unique identifier applied to Shopify-made themes that are installed from the Shopify Theme Store Theme Store.
UpdatedAt	Datetime	True		The date and time ( ISO 8601 format) when the theme was last updated.

UsageCharges

Create or view Usage Charges for Recurring Application Charges.

Table-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. The following queries are the only ones processed server side:

SELECT * FROM UsageCharges WHERE Id = 123

SELECT * FROM UsageCharges WHERE RecurringApplicationId = 5569619

SELECT * FROM UsageCharges WHERE RecurringApplicationId = 5569619 AND Id = 123

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		The ID of the usage charge.
Description	String	False		The name of the usage charge.
Price	Decimal	False		The price of the usage charge.
CreatedAt	Datetime	False		The date and time (ISO 8601 format) when the usage charge was created.
BillingOn	Date	False		The date and time (ISO 8601 format) when the customer is billed.
BalanceUsed	Decimal	False		The used balance
BalanceRemaining	Decimal	False		The remaining balance
RiskLevel	Integer	False		The risk Level

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
RecurringApplicationId	Long	The Id of the RecurringApplication Charge

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Shopify Connector for CData Sync ビュー


Name	Description
AbandonedCheckouts	Query abandoned checkouts.
AbandonedCheckoutsItems	Query abandoned checkouts items.
AssignedFulfillmentOrders	The AssignedFulfillmentOrder resource allows you to retrieve all the fulfillment orders that are assigned to an app at the shop level.
DiscountApplications	Query note attributes belonging to an order or draft order.
DraftOrderItemProperties	Query order item properties.
DraftOrderItems	Query draft order items.
DraftOrderItemTaxLines	Query draft order items tax lines.
Events	Retrieve events which have happened in your shop.
FulfillmentOrders	Query fulfillment orders.
Locations	Retrieve information regarding store locations.
NoteAttributes	Query note attributes belonging to an order or draft order.
OrderDiscountCodes	Query note attributes belonging to an order or draft order.
OrderItemDiscountAllocations	Query order item discount allocations.
OrderItemProperties	Query order item properties.
OrdersItems	Query order items.
Payouts	Retrieves a list of all payouts ordered by payout date, with the most recent being first.
PayoutTransactions	Retrieves a list of all balance transactions ordered by processing time, with the most recent being first.
ProductOptions	Query product options.
RefundAdjustments	Create and query transactions.
RefundsItems	Get data on OrdersItems that have been refunded.
RefundTransactions	Query transactions for Refund Object.
Reports	To query all the Reports.
ShippingItemDiscountAllocations	Query Shipping item discount allocations.
ShippingItems	Query order shipping.
ShippingZones	Retrieve information regarding shipping zones.
Shop	Contains general settings and information about the shop.
TaxItems	Query order taxes.

AbandonedCheckouts

Query abandoned checkouts.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM AbandonedCheckouts

SELECT * FROM AbandonedCheckouts WHERE CreatedAt > '2017-10-25'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
Id	Long		The unique numeric identifier for the order.
AbandonedCheckoutUrl	String		The full recovery URL to be sent to a customer to recover their abandoned checkout.
BuyerAcceptsMarketing	Boolean		Indicates whether or not the person who placed the order would like to receive email updates from the shop.
CancelReason	String		The reason why the order was cancelled.
CartToken	String		Unique identifier for a particular cart that is attached to a particular order.
Currency	String		The three letter code (ISO 4217) for the currency used for the payment.
CustomerId	Long	Customers.Id	A unique numeric identifier for the customer.
DiscountCodes	String		Applicable discount codes that can be applied to the order.
Email	String		The customer's email address.
Note	String		The text of an optional note that a shop owner can attach to the order.
LandingSite	String		The URL for the page where the buyer landed when entering the shop.
ReferringSite	String		The website that the customer clicked on to come to the shop.
SourceName	String		Where the order originated.
SubtotalPrice	Decimal		Price of the order before shipping and taxes.
TotalDiscounts	Decimal		The total amount of the discounts to be applied to the price of the order.
TotalLineItemsPrice	Decimal		The sum of all the prices of all the items in the order.
TotalPrice	Decimal		The sum of all the prices of all the items in the order, taxes and discounts included.
TotalTax	Decimal		The sum of all the taxes applied to the order.
TotalWeight	Double		The sum of all the weights of the line items in the order, in grams.
TaxesIncluded	Boolean		States whether or not taxes are included in the order subtotal.
Token	String		Unique identifier for a particular order.
BillingAddressFirstName	String		The first name of the person associated with the payment method.
BillingAddressLastName	String		The last name of the person associated with the payment method.
BillingAddressAdress1	String		The street address of the billing address.
BillingAddressAdress2	String		An optional additional field for the street address of the billing address.
BillingAddressPhone	String		The phone number at the billing address.
BillingAddressCity	String		The city of the billing address.
BillingAddressCompany	String		The company of the person associated with the billing address.
BillingAddressZip	String		The zip or postal code of the billing address.
BillingAddressProvince	String		The name of the state or province of the billing address.
BillingAddressCountry	String		The name of the country of the billing address.
BillingAddressLatitude	Double		The latitude of the billing address.
BillingAddressLongitude	Double		The longitude of the billing address.
BillingAddressName	String		The full name of the person associated with the payment method.
BillingAddressCountryCode	String		The two-letter code for the country of the billing address.
BillingAddressProvinceCode	String		The two-letter abbreviation of the state or province of the billing address.
BillingAddressDefault	Boolean		Whether this address is the default one or not.
ShippingAddressFirstName	String		The first name of the person associated with the shipping address.
ShippingAddressLastName	String		The last name of the person associated with the shipping address.
ShippingAddressAdress1	String		The street address of the shipping address.
ShippingAddressAdress2	String		An optional additional field for the street address of the shipping address.
ShippingAddressPhone	String		The phone number at the shipping address.
ShippingAddressCity	String		The city of the shipping address.
ShippingAddressCompany	String		The company of the person associated with the shipping address.
ShippingAddressZip	String		The zip or postal code of the shipping address.
ShippingAddressProvince	String		The name of the state or province of the shipping address.
ShippingAddressCountry	String		The name of the country of the shipping address.
ShippingAddressLatitude	Double		The latitude of the shipping address.
ShippingAddressLongitude	Double		The longitude of the shipping address.
ShippingAddressName	String		The full name of the person associated with the shipping address.
ShippingAddressCountryCode	String		The two-letter code for the country of the shipping address.
ShippingAddressProvinceCode	String		The two-letter abbreviation of the state or province of the shipping address.
ShippingAddressDefault	Boolean		Whether this address is the default one or not.
ClosedAt	Datetime		The date and time when the order was closed.
CompletedAt	Datetime
CreatedAt	Datetime		The date and time when the order was created.
UpdatedAt	Datetime		The date and time when the order was last modified.

AbandonedCheckoutsItems

Query abandoned checkouts items.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM AbandonedCheckoutsItems

SELECT * FROM AbandonedCheckoutsItems WHERE CreatedAt > '2017-10-25'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
AbandonedCheckoutId	Long	AbandonedCheckouts.Id	The unique numeric identifier for the order.
ProductId	Long	Products.Id	The product ID od the item.
ItemVariantId	Long	ProductVariants.Id	The product variant ID of item.
ItemTitle	String		The title of the product.
ItemQuantity	Integer		The number of products that were purchased.
ItemPrice	Decimal		The price of the item in presentment currency.
ItemGrams	Integer		The weight of the item in grams.
SKU	String		A unique identifier for the item in the shop.
VariantTitle	String		The title of the product variant.
Vendor	String		The name of the item's supplier.
FulFillmentsService	String		The fulfillment service provider for the item.
CreatedAt	Datetime		The date and time when the order was created.
UpdatedAt	Datetime		The date and time when the order was last modified.

AssignedFulfillmentOrders

The AssignedFulfillmentOrder resource allows you to retrieve all the fulfillment orders that are assigned to an app at the shop level.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the AssignedLocationId and RequestStatus columns. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * from AssignedFulfillmentOrders WHERE AssignedLocationId IN (1,2)

SELECT * from AssignedFulfillmentOrders WHERE RequestStatus = 'cancellation_requested'

Columns


Name	Type	References	Description
Id [KEY]	Long		The ID of the fulfillment order.
ShopId	Long	Shop.Id	The ID of the shop that's associated with the fulfillment order.
OrderId	Long	Orders.Id	The ID of the order that's associated with the fulfillment order.
AssignedLocationId	Long		The ID of the location that has been assigned to do the work.
FulfillmentServiceHandle	String		A unique numeric identifier for the order.
RequestStatus	String		The status of the fulfillment.
DestinationId	String		The ID of the fulfillment order destination.
DestinationAddress1	String		The first line of the address of the destination.
DestinationAddress2	String		The second line of the address of the destination.
DestinationCity	String		The city of the destination.
DestinationCompany	String		The company of the destination.
DestinationFirstName	String		The first name of the customer at the destination.
DestinationLastName	String		The last name of the customer at the destination.
DestinationPhone	String		The phone number of the customer at the destination.
LineItems	String		Represents line items belonging to a fulfillment order.
Status	String		The status of the fulfillment order.
Operation	String		An operation to apply to the fulfillment. Complete, Open, or Cancel. 使用できる値は次のとおりです。Complete, Open, Cancel

DiscountApplications

Query note attributes belonging to an order or draft order.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM DiscountApplications WHERE OrderId = '1'

SELECT * FROM DiscountApplications WHERE OrderId IN ('1', '2')

SELECT * FROM DiscountApplications WHERE OrderUpdatedAt <= '2020-07-20 08:28:03.0'

SELECT * FROM DiscountApplications WHERE OrderUpdatedAt > '2020-07-20 08:28:03.0'

Columns


Name	Type	References	Description
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Type	String		The name of the note attribute.
Title	String		The value of the note attribute.
Description	String		The value of the note attribute.
Value	String		The value of the note attribute.
ValueType	String		The value of the note attribute.
AllocationMethod	String		The value of the note attribute.
TargetSelection	String		The value of the note attribute.
TargetType	String		The value of the note attribute.

DraftOrderItemProperties

Query order item properties.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the DraftOrderId column. The supported SQL operators are '=' for DraftOrderId. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side.

SELECT * FROM DraftOrderItemProperties WHERE DraftOrderId = '123'

Columns


Name	Type	References	Description
ItemId	Long	DraftOrderItems.ItemId	The id of the order item.
DraftOrderId	Long	DraftOrders.Id	The id of the draft.
Name	String		The name of the item property.
Value	String		The value of the item property.

DraftOrderItems

Query draft order items.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the DraftOrderId. The supported SQL operators are '=' for DraftOrderId. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side.

SELECT * FROM DraftOrderItems

SELECT * FROM DraftOrderItems WHERE DraftOrderId = '123'

Columns


Name	Type	References	Description
ItemId	Long		The id of the line item.
DraftOrderId	Long	DraftOrders.Id	The id of the draft.
ProductId	Long	Products.Id	The ID of the product corresponding to the line item product variant.
Custom	Boolean		States whether this is a custom line item or a product variant line item
FulfillableQuantity	Integer		The amount available to fulfill.
FulFillmentsService	String		Service provider responsible for fulfillment.
ItemGrams	Integer		The weight of the item in grams.
ItemPrice	Decimal		The price of the item before discounts have been applied.
ItemQuantity	Integer		The number of products that were purchased.
RequiresShipping	Boolean		States whether or not the fulfillment requires shipping.
SKU	String		A unique identifier of the item in the fulfillment.
ItemTitle	String		The title of the product or variant.
ItemVariantId	Long	ProductVariants.Id	The id of the product variant.
VariantTitle	String		The title of the product variant.
Vendor	String		The name of the supplier of the item.
Name	String		The name of the product variant.
GiftCard	Boolean		States whether or not the product is a gift card.
Properties	String		Shows custom properties for this order item.
Taxable	Boolean		States whether or not the product was taxable.
TaxLines	String		Shows tax lines for this order item.
AppliedDiscountTitle	String		The title of the applied discount for this order. Only available for draft orders.
AppliedDiscountDescription	String		The description of the applied discount for order. Only available for draft orders.
AppliedDiscountValue	Decimal		The value of the applied discount for this order. Only available for draft orders.
AppliedDiscountValueType	String		The value type of the applied discount for order. Only available for draft orders.
AppliedDiscountAmount	Decimal		The amount of the applied discount for this order. Only available for draft orders.

DraftOrderItemTaxLines

Query draft order items tax lines.

Columns


Name	Type	References	Description
ItemId	Long	DraftOrderItems.ItemId	The id of the draft line item.
DraftOrderId	Long	DraftOrders.Id	The id of the draft.
TaxTitle	String		The name of the tax.
TaxRate	Decimal		The rate of tax to be applied.
TaxPrice	Decimal		The amount of tax to be charged.

Events

Retrieve events which have happened in your shop.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, ProductId, OrderId, Verb, and CreatedAt columns. The supported SQL operators are '=' for the Id, ProductId, OrderId, and Verb columns and ">" and "<" for CreatedAt. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Events

SELECT * FROM Events WHERE Id='123'

SELECT * FROM Events WHERE ProductId='123'

SELECT * FROM Events WHERE OrderId='123'

SELECT * FROM Events WHERE Verb='Confirmed'

SELECT * FROM Events WHERE CreatedAt > '2018-05-02'

Columns


Name	Type	References	Description
Id [KEY]	Long		The ID of 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.
Body	String		A text field containing information about the event.
Path	String		A relative URL to the resource the event is for, if applicable.
SubjectId	Long		The ID of the resource that generated the event.
SubjectType	String		he type of the resource that generated the event. Valid values: Article, Blog, Collection, Comment, Order, Page, Product, ApiPermission.
Verb	String		The type of event that occurred. Different resources generate different types of event.
Author	String		The author of the event.
Arguments	String		Refers to a certain event and its resources.
CreatedAt	Datetime		The date and time when the event was created.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
OrderId	Long		The ID of the Order to retrieve events from.
ProductId	Long		The ID of the Product to retrieve events from.

FulfillmentOrders

Query fulfillment orders.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and Id columns. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM FulfillmentOrders WHERE OrderId = '1'

SELECT * FROM FulfillmentOrders WHERE Id = '1'

Columns


Name	Type	References	Description
Id [KEY]	Long		An ID for the fulfillment order.
ShopId	Long	Shop.Id	The ID of the shop that's associated with the fulfillment order.
OrderId [KEY]	Long	Orders.Id	The ID of the order that's associated with the fulfillment order.
AssignedLocationId	Long		The ID of the location that has been assigned to do the work.
DestinationId	String		The ID of the fulfillment order destination.
DestinationAddress1	String		The first line of the address of the destination.
DestinationAddress2	String		The second line of the address of the destination.
DestinationCity	String		The city of the destination.
DestinationCompany	String		The company of the destination.
DestinationFirstName	String		The first name of the customer at the destination.
DestinationLastName	String		The last name of the customer at the destination.
DestinationPhone	String		The phone number of the customer at the destination.
FullfillAt	Datetime		The datetime (in UTC) when the fulfillment order is ready for fulfillment.
LineItems	String		Represents line items belonging to a fulfillment order.
RequestStatus	String		The status of the fulfillment.
Status	String		The status of the fulfillment order.
SupportedActions	String		The actions that can be performed on this fulfillment order.
MerchantRequests	String		A list of requests sent by the merchant to the fulfillment service for this fulfillment order..
FulfillmentHolds	String		Represents the fulfillment holds applied on the fulfillment order.
InternationalDuties	String		The international duties relevant to the fulfillment order.
AssignedLocationAddress1	String		The street address of the assigned location
AssignedLocationAddress2	String		An optional additional field for the street address of the assigned location.
AssignedLocationCity	String		The city of the assigned location.
AssignedLocationCountryCode	String		The two-letter code for the country of the assigned location
AssignedLocationName	String		The name of the assigned location.
AssignedLocationPhone	String		The phone number of the assigned location.

Locations

Retrieve information regarding store locations.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Locations

SELECT * FROM Locations WHERE Id='123'

Columns


Name	Type	References	Description
Id [KEY]	Long		The ID for the location.
Name	String		The name of the location.
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.
Address1	String		The first line of the address.
Address2	String		The second line of the address.
City	String		The city the location is in.
Zip	String		The zip or postal code.
Province	String		The province the location is in.
Country	String		The country the location is in.
Phone	String		The phone number of the location. This value can contain special characters like - and +.
CountryCode	String		The two-letter code (ISO 3166-1 alpha-2 format) corresponding to country the location is in.
CountryName	String		The name of the country the location is in.
CreatedAt	Datetime		The date and time when the location was created.
UpdatedAt	Datetime		The date and time when the location was last updated.
DeletedAt	Datetime		The date and time when the location was deleted.

NoteAttributes

Query note attributes belonging to an order or draft order.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM NoteAttributes WHERE OrderId='123'

SELECT * FROM NoteAttributes WHERE OrderUpdatedAt > '2018-05-05'

Columns


Name	Type	References	Description
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Name	String		The name of the note attribute.
Value	String		The value of the note attribute.

OrderDiscountCodes

Query note attributes belonging to an order or draft order.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM OrderDiscountCodes WHERE OrderId = '1'

SELECT * FROM OrderDiscountCodes WHERE OrderId IN ('1', '2')

SELECT * FROM OrderDiscountCodes WHERE OrderUpdatedAt <= '2019-05-13 09:23:06.0'

SELECT * FROM OrderDiscountCodes WHERE OrderUpdatedAt >= '2019-05-13 09:23:06.0'

Columns


Name	Type	References	Description
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Code	String		The name of the note attribute.
Amount	String		The value of the note attribute.
Type	String		The value of the note attribute.

OrderItemDiscountAllocations

Query order item discount allocations.

Columns


Name	Type	References	Description
ItemId	Long	OrdersItems.ItemId	The id of the order item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
amount	String		The Amount of the item discount allocations.
ApplicationIndex	Int		The ApplicationIndex of the item discount allocations.
ShopMoneyAmount	Decimal		The ShopMoneyAmount of the item discount allocations.
ShopMoneyCurrencyCode	String		The ShopMoneyCurrencyCode of the item discount allocations.
PresentmentMoneyAmount	Decimal		The PresentmentMoneyAmount of the item discount allocations.
PresentmentMoneyCurrencyCode	String		The PresentmentMoneyCurrencyCode of the item discount allocations.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.

OrderItemProperties

Query order item properties.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId column. The supported SQL operators are '=' for OrderId. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side. You can set the Type pseudo column to "DraftOrder" to list order items belonging to draft orders instead of orders, or you can set Type to "AbandonedCheckout" to list order items belonging to abandoned checkouts.

SELECT * FROM OrderItemProperties WHERE OrderId = '123'

Columns


Name	Type	References	Description
ItemId	Long	OrdersItems.ItemId	The id of the order item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
Name	String		The name of the item property.
Value	String		The value of the item property.

OrdersItems

Query order items.

Columns


Name	Type	References	Description
ItemId	Long		The id of the order item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
ProductId	Long	Products.Id	The id of the of the product beloning to the order item.
ItemVariantId	Long	ProductVariants.Id	The id of the product variant.
ItemTitle	String		The title of the product.
Name	String		The name of the product variant.
ItemQuantity	Integer		The number of products that were purchased.
ItemPrice	Decimal		The price of the item before discounts have been applied.
ItemGrams	Integer		The weight of the item in grams.
SKU	String		A unique identifier of the item in the fulfillment.
VariantTitle	String		The title of the product variant.
Properties	String		Shows custom properties for this order item.
Vendor	String		The name of the supplier of the item.
FulFillmentsService	String		Service provider who is doing the fulfillment.
RequiresShipping	Boolean		States whether or not the fulfillment requires shipping.
Taxable	Boolean		States whether or not the product was taxable.
GiftCard	Boolean		States whether or not the order item is a gift card.
FulfillableQuantity	Integer		The amount available to fulfill.
TotalDiscount	Decimal		The total discount amount applied to this order item.
FulfillmentStatus	String		How far along an order is in terms order items fulfilled.
AppliedDiscountTitle	String		The title of the applied discount for this order. Only available for draft orders.
AppliedDiscountDescription	String		The description of the applied discount for order. Only available for draft orders.
AppliedDiscountValue	Decimal		The value of the applied discount for this order. Only available for draft orders.
AppliedDiscountValueType	String		The value type of the applied discount for order. Only available for draft orders.
AppliedDiscountAmount	Decimal		The amount of the applied discount for this order. Only available for draft orders.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Type	String		The type of order item, can be one of the following(Order, DraftOrder, AbandonedCheckout). 使用できる値は次のとおりです。Order, DraftOrder, AbandonedCheckout デフォルト値はOrderです。
Status	String		Filter orders by their status. Valid values are: open: show only open orders, closed: show only closed orders, cancelled: show only canceled orders, any: show orders of any status,default: open.

Payouts

Retrieves a list of all payouts ordered by payout date, with the most recent being first.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, Status and Date columns. The supported SQL operator is '=' for Id, Status and Date columns. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Payouts

SELECT * FROM Payouts WHERE Id='123'

SELECT * FROM Payouts WHERE Status='pending'

SELECT * FROM Payouts WHERE Date = '2018-10-30'

Columns


Name	Type	References	Description
Id [KEY]	Long		The unique identifier of the payout.
Status	String		The transfer status of the payout.
Currency	String		The ISO 4217 currency code of the payout.
Amount	Decimal		The total amount of the payout, in a decimal formatted string.
Date	Datetime		The date the payout was issued.

PayoutTransactions

Retrieves a list of all balance transactions ordered by processing time, with the most recent being first.

Columns


Name	Type	References	Description
Id [KEY]	Long		The unique identifier of the transaction.
Type	String		The type of the balance transaction.
Test	Boolean		If the transaction was created for a test mode Order or payment.
PayoutId	Long	Payouts.Id	The id of the payout the transaction was paid out in.
PayoutStatus	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.
Currency	String		The ISO 4217 currency code of the transaction.
Amount	Decimal		The gross amount of the transaction, in a decimal formatted string.
Fee	Decimal		The total amount of fees deducted from the transaction amount.
Net	Decimal		The net amount of the transaction.
SourceId	Long		The id of the resource leading to the transaction.
SourceType	String		The type of the resource leading to the transaction.
SourceOrderTransactionId	String		The id of the Order Transaction that resulted in this balance transaction.
SourceOrderId	String		The id of the Order that this transaction ultimately originated from.
ProcessedAt	Datetime		The time the transaction was processed.

ProductOptions

Query product options.

View-Specific Information

The Sync App uses the Shopify API to process search criteria that refer to the ProductId and ProductUpdatedAt columns. The supported SQL operators are '=' for ProductId and '>' and '<' for ProductUpdatedAt. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

Select

SELECT * FROM ProductOptions

SELECT * FROM ProductOptions WHERE ProductId='123'

SELECT * FROM ProductOptions WHERE ProductUpdatedAt > '2018-05-10'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
Id [KEY]	Long		The id of the product option.
ProductId	Long	Products.Id	The id of the product.
ProductUpdatedAt	Datetime		The date and time when the product was last modified.
Name	String		The name of the product option.
Position	Integer		The position of the product option.
Values	String		The values of the product option.

RefundAdjustments

Create and query transactions.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and RefundId column. The Sync App processes other filters client-side within the Sync App.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server side.

SELECT * FROM RefundAdjustments WHERE OrderId = '123'

When performing a query without a filter or a filter other then the OrderId column, the Sync App will retrieve the entire list of refunds and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving refunds. Therefore to retrieve all the refunds, the Sync App will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the Sync App will issue individual requests to the Shopify API to retrieve all the refunds for each OrderId to build the result set.

SELECT * FROM RefundAdjustments

SELECT * FROM RefundAdjustments WHERE OrderId = '123' AND RefundId = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. Other search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
Id [KEY]	Long		A unique numeric identifier for the refund adjustment.
OrderId	Long	Orders.Id	The unique identifier for the order that the order adjustment is associated with.
RefundId	Long	Refunds.Id	The unique identifier for the refund that the order adjustment is associated with.
Amount	Decimal		The value of the discrepancy between the calculated refund and the actual refund.
TaxAmount	Decimal		The taxes that are added to amount, such as applicable shipping taxes added to a shipping refund.
Kind	String		The order adjustment type.
Reason	String		The reason for the order adjustment.
AmountShopMoney	Decimal		The amount of the order adjustment in shop.
AmountShopCurrency	String		The currency of the order adjustment in shop.
AmountPresentmentMoney	Decimal		The amount of the order adjustment in presentment.
AmountPresentmentCurrency	String		The currency of the order adjustment in presentment.
TaxAmountShopMoney	Decimal		The tax amount of the order adjustment in shop.
TaxAmountShopCurrency	String		The tax currency of the order adjustment in shop.
TaxAmountPresentmentMoney	Decimal		The tax amount of the order adjustment in presentment.
TaxAmountPresentmentCurrency	String		The tax currency of the order adjustment in presentment.

RefundsItems

Get data on OrdersItems that have been refunded.

Columns


Name	Type	References	Description
ItemId [KEY]	Long	OrdersItems.ItemId	The id of the order item. Only available for orders.
OrderID [KEY]	Long	Refunds.Id	The id of the refund this refunded item belongs to.
RefundId [KEY]	Long	Refunds.Id	The id of the refund this refunded item belongs to.
LocationId	Long		The unique identifier of the location tied to the refund item
ProductId	Long	Products.Id	The id of the of the product beloning to the order item.
ItemVariantId	Long	ProductVariants.Id	The id of the product variant.
ItemTitle	String		The title of the product.
Name	String		The name of the product variant.
ItemQuantity	Integer		The number of products that were purchased.
ItemPrice	Decimal		The price of the item before discounts have been applied.
ItemGrams	Integer		The weight of the item in grams.
SKU	String		A unique identifier of the item in the fulfillment.
VariantTitle	String		The title of the product variant.
Properties	String		Shows custom properties for this order item.
Vendor	String		The name of the supplier of the item.
FulFillmentsService	String		Service provider who is doing the fulfillment.
RequiresShipping	Boolean		States whether or not the fulfillment requires shipping.
Taxable	Boolean		States whether or not the product was taxable.
GiftCard	Boolean		States whether or not the order item is a gift card.
FulfillableQuantity	Integer		The amount available to fulfill.
TotalDiscount	Decimal		The total discount amount applied to this order item.
FulfillmentStatus	String		How far along an order is in terms order items fulfilled.
RefundSubtotal	Decimal		The refunded amount for this item. This is calculated by multiplying ItemPrice with RefundQuantity.
RefundQuantity	Integer		The quantity of the item refunded.
RefundRestockType	String		The type of the restock action.
RefundSubtotalPresentmentAmount	Decimal		The total amount of the presentment money.
RefundSubtotalPresentmentCurrencyCode	String		The currency code of the presentment money.
RefundSubtotalShopAmount	Decimal		The total amount of the shop money.
RefundSubtotalShopCurrencyCode	String		The currency code of the shop money.
RefundTotalTax	Decimal		Total tax for the refunded item.
RefundTotalTaxPresentmentAmount	Decimal		Total tax amount for the presentment money.
RefundTotalTaxPresentmentCurrencyCode	String		Currency code for the tax on presentment money.
RefundTotalTaxShopAmount	Decimal		Total tax amount for the shop money.
RefundTotalTaxShopCurrencyCode	String		Currency code for the tax on shop money.
AppliedDiscountTitle	String		The title of the applied discount for this order. Only available for draft orders.
AppliedDiscountDescription	String		The description of the applied discount for order. Only available for draft orders.
AppliedDiscountValue	Decimal		The value of the applied discount for this order. Only available for draft orders.
AppliedDiscountValueType	String		The value type of the applied discount for order. Only available for draft orders.
AppliedDiscountAmount	Decimal		The amount of the applied discount for this order. Only available for draft orders.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Status	String		Filter orders by their status. Valid values are: open: show only open orders, closed: show only closed orders, cancelled: show only canceled orders, any: show orders of any status,default: open.

RefundTransactions

Query transactions for Refund Object.

Table-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and RefundId column. The Sync App processes other filters client-side within the Sync App.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server side.

SELECT * FROM RefundTransactions WHERE OrderId = '123'

When performing a query without a filter or a filter other then the OrderId column, the Sync App will retrieve the entire list of refunds and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving refunds. Therefore to retrieve all the refunds, the Sync App will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the Sync App will issue individual requests to the Shopify API to retrieve all the refunds for each OrderId to build the result set.

SELECT * FROM RefundTransactions

SELECT * FROM RefundTransactions WHERE OrderId = '123' AND RefundId = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. Other search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
TransactionsId [KEY]	Long		The ID for the refund transaction.
OrderId	Long	Orders.Id	The ID for the order that the transaction is associated with.
RefundId	Long	Refunds.Id	The unique identifier for the refund associated with.
Amount	Decimal		The amount of money included in the transaction.
Authorization	String		The authorization code associated with the transaction..
CreatedAt	Datetime		The date and time (ISO 8601 format) when the transaction was created.
Currency	String		The three-letter code (ISO 4217 format) for the currency used for the payment.
DeviceId	String		The ID for the device.
ErrorCode	String		A standardized error code, independent of the payment provider.
GraphqlAPIId	String		The order adjustment type.
Gateway	String		The name of the gateway the transaction was issued through.
Kind	String		The transaction's type.
LocationId	String		The ID of the physical location where the transaction was processed.
Message	String		A string generated by the payment provider with additional information about why the transaction succeeded or failed.
ParentId	Long		The ID of an associated transaction..
ProcessedAt	Datetime		The date and time (ISO 8601 format) when a transaction was processed.
Status	String		The status of the transaction.
SourceName	String		The origin of the transaction.
Test	Boolean		Whether the transaction is a test transaction.
UserId	String		The ID for the user who was logged into the Shopify POS device when the order was processed, if applicable.

Reports

To query all the Reports.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id and UpdatedAt columns. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

For example, the following queries are processed server side.

SELECT * FROM Reports

SELECT * FROM Reports WHERE Id = '123'

SELECT * FROM Reports WHERE UpdatedAt > '2017-10-25'

Columns


Name	Type	References	Description
Id [KEY]	Long		The unique numeric identifier for the report.
Name	String		The name of the report.
ShopifyQl	String		The ShopifyQL query that generates the report.
UpdatedAt	Datetime		The date and time (ISO 8601) when the report was last modified.
Category	String		The category for the report. When you create a report, the API will return custom_app_reports.

ShippingItemDiscountAllocations

Query Shipping item discount allocations.

Columns


Name	Type	References	Description
ItemId	Long	ShippingItems.ItemId	The id of the shipping item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
Amount	String		The Amount of the item discount allocations.
ShopMoneyAmount	Decimal		The ShopMoneyAmount of the item discount allocations.
ShopMoneyCurrencyCode	String		The ShopMoneyCurrencyCode of the item discount allocations.
PresentmentMoneyAmount	Decimal		The PresentmentMoneyAmount of the item discount allocations.
PresentmentMoneyCurrencyCode	String		The PresentmentMoneyCurrencyCode of the item discount allocations.
DiscountApplicationIndex	Integer		The Discount application index for an order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.

ShippingItems

Query order shipping.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

SELECT * FROM ShippingItems

SELECT * FROM ShippingItems WHERE OrderId='123'

SELECT * FROM ShippingItems WHERE OrderUpdatedAt > '2018-05-05'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
Id [KEY]	Long		The id of the shipping item.
OrderId [KEY]	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Price	Decimal		The price of this shipping method.
Code	String		A reference to the shipping method.
Title	String		The title of the shipping method.
Source	String		The source of the shipping method.
CarrierIdentifier	String		A reference to the carrier service that provided the rate.
RequestedFulfillmentServiceId	String		A reference to the fulfillment service that is being requested for the shipping method.

ShippingZones

Retrieve information regarding shipping zones.

View-Specific Information

Select

The Sync App processes all filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

The following query is the only one processed server side:

SELECT * FROM ShippingZones

Columns


Name	Type	References	Description
Id [KEY]	Long		The unique numeric identifier for the shipping zone.
Name	String		The name of the shipping zone, specified by the user.
ProfileId	String		The ID of the shipping zone's delivery profile. Shipping profiles allow merchants to create product-based or location-based shipping rates.
LocationGroupId	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.
Countries	String		A list of countries that belong to the shipping zone.
CarrierShippingRateProviders	String		Information about carrier shipping providers and the rates used.
PriceBasedShippingRates	String		Information about price based shipping rates used.
WeightBasedShippingRates	String		Information about weight based shipping rates used.

Shop

Contains general settings and information about the shop.

View-Specific Information

Select

The Sync App processes the WHERE clause client-side within the Sync App for all queries to this table. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned. For example, the following query is the only query processed server side:

SELECT * FROM Shop

Columns


Name	Type	References	Description
Id	Long		A unique numeric identifier for the shop.
Name	String		The name of the shop.
Email	String		The contact email address for the shop.
Address1	String		The shop's street address.
Address2	String		The shop's additional street address (apt, suite, etc.).
City	String		The city in which the shop is located.
Country	String		The shop's country (by default equal to the two-letter country code).
CountryCode	String		The two-letter country code corresponding to the shop's country.
CountryName	String		The shop's normalized country name.
CustomerEmail	String		The customer's email.
Currency	String		The three-letter code for the currency that the shop accepts.
Domain	String		The shop's domain.
GoogleAppsDomain	String		The URL of the domain if the shop has a google apps domain.
GoogleAppsLoginEnabled	String		Indicated whether the shop has google apps login enabled.
Latitude	Double		Geographic coordinate specifying the north/south location of a shop.
Longitude	Double		Geographic coordinate specifying the east/west location of a shop.
MoneyFormat	String		A string representing the way currency is formatted when the currency isn't specified.
MoneyWithCurrencyFormat	String		A string representing the way currency is formatted when the currency is specified.
WeightUnit	String		A string representing the default unit of weight measurement for the shop.
MyshopifyDomain	String		The shop's 'myshopify.com' domain.
PlanName	String		The name of the Shopify plan the shop is on.
HasDiscounts	Boolean		Indicates if any active discounts exist for the shop.
HasGiftCards	Boolean		Indicates if any active gift cards exist for the shop.
PlanDisplayName	String		The display name of the Shopify plan the shop is on.
PasswordEnabled	Boolean		Indicates whether the Storefront password protection is enabled.
Phone	String		The contact phone number for the shop.
PrimaryLocale	String		The shop's primary locale.
Province	String		The shop's normalized province or state name.
ProvinceCode	String		The two-letter code for the shop's province or state.
ShopOwner	String		The username of the shop owner.
Source	String
ForceSSL	Boolean		Indicates whether the shop forces requests made to its resources to be made over SSL.
TaxShipping	Boolean		Specifies whether or not taxes were charged for shipping.
TaxesIncluding	Boolean		The setting for whether applicable taxes are included in product prices.
CountryTaxes	Boolean		The setting for whether the shop is applying taxes on a per-county basis or not (US-only).
Timezone	String		The name of the timezone the shop is in.
IANATimezone	String		The named timezone assigned by the IANA.
Zip	String		The zip or postal code of the shop's address.
HasStorefront	Boolean		Indicates whether the shop has web-based storefront or not.
CreatedAt	Datetime		The date and time when the shop was created.
UpdatedAt	Datetime		The date and time when the shop was last updated.
SetupRequired	Boolean		Indicates whether the shop has any outstanding setup steps or not.

TaxItems

Query order taxes.

View-Specific Information

The Sync App uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side.

Select

SELECT * FROM TaxItems

SELECT * FROM TaxItems WHERE OrderId = '123'

SELECT * FROM TaxItems WHERE OrderUpdatedAt > '2018-05-21'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
ChannelLiable	Boolean		Whether the channel that submitted the tax line is liable for remitting.
TaxItemPrice	Decimal		The amount of tax to be charged.
TaxItemRate	Decimal		The rate of tax to be applied.
TaxItemTitle	String		The name of the tax.

GRAPHQL データモデル

The CData Sync App models the Shopify API as relational views, and stored procedures.

To use GraphQL Data Model, simply set Schema to GraphQL.

Views

ビュー are tables that cannot be modified, such as Events, Patouts, Reports. Typically, model data that is read-only and cannot be updated are shown as views.

Stored Procedures

ストアドプロシージャ are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Bulk API

When UseBulkApi is set to True CData Sync App performs Shopify Bulk Operations. This option offers better performance when you need to select or export a lot of data from Shopify.

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Shopify Connector for CData Sync ビュー


Name	Description
Customers	List of customers.
DraftOrders	List of saved draft orders.
FulfillmentEvents	Retrieves the history of events associated with one or many fulfillments.
FulfillmentOrders	FulfillmentOrders represents a group of one or more items in an order that are to be fulfilled from the same location.
Fulfillments	Fulfillment represents a shipment of one or more items in an order.
FulfillmentServices	Lists fulfillmentServices which Represents service that prepares and ships orders on behalf of the store owner.
Metafields	Retrieves a list of metafields that belong to one or many resource IDs.
OrderRisks	The order risks associated with this order.
Orders	Tax rates with their effective dates of application
OrderTransactions	List of all transactions associated with the orders.
ProductImages	The images associated with the product.
ProductOptions	A list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions.
Products	List of products.
ProductVariants	List of the product variants.
Refunds	Represents a refund of items or transactions in an order.

Customers

List of customers.

View-Specific Information

Select

The Sync App uses the Shopify API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

Id supports the '=' comparison.
Email supports the '=' comparison.
UpdatedAt supports the '>=,<=,=' comparison.
AcceptsMarketing supports the '=' comparison.
OrdersCount supports the '=,>,<,>=,<=' comparison.
Phone supports the '=' comparison.
State supports the '=' comparison.
TotalSpent supports the '=' comparison.

For example, the following queries are processed server side.

SELECT * FROM Customers

SELECT * FROM Customers WHERE Id = '123'

SELECT * FROM Customers WHERE UpdatedAt = '2017-10-25'

SELECT * FROM Customers WHERE UpdatedAt <= '2017-10-25'

SELECT * FROM Customers WHERE UpdatedAt >= '2017-10-25'

SELECT * FROM Customers WHERE Email = '[email protected]'

SELECT * FROM Customers WHERE OrdersCount = 5

SELECT * FROM Customers WHERE Phone = '999999999'

SELECT * FROM Customers WHERE State = 'State1'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
FirstName	String		The customer's first name.
LastName	String		The customer's last name.
Email	String		The customer's email address.
DisplayName	String		The full name of the customer, based on the values for first_name and last_name. If the first_name and last_name are not available, then this falls back to the customer's email address, and if that is not available, the customer's phone number.
CreatedAt	Datetime		The date and time when the customer was added to the store.
UpdatedAt	Datetime		The date and time when the customer was last updated.
LastOrderId	String	Orders.Id	The Id of the customer's last order.
AcceptsMarketing	Boolean		Whether the customer has agreed to receive marketing materials.
AcceptsMarketingUpdatedAt	Datetime		The date and time when the customer consented or objected to receiving marketing material by email.
AverageOrderAmount	Decimal		The average amount that the customer spent per order.
AverageOrderAmountCurrency	String		The currency of the average amount that the customer spent per order.
CanDelete	Boolean		Whether the merchant can delete the customer from their store. A customer can be deleted from a store only if they have not yet made an order. After a customer makes an order, they can't be deleted from a store.
DefaultAddress1	String		The first line of the address. Typically the street address or PO Box number.
DefaultAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
DefaultAddressCity	String		The name of the city, district, village, or town.
DefaultAddressCompany	String		The name of the customer's company or organization.
DefaultAddressCountry	String		The name of the country.
DefaultAddressCountryCode	String		The two-letter code for the country of the address. For example, US.
DefaultAddressFirstName	String		The first name of the customer.
DefaultAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
DefaultAddressId	String		Globally unique identifier.
DefaultAddressLastName	String		The last name of the customer.
DefaultAddressLatitude	Double		The latitude coordinate of the customer address.
DefaultAddressLongitude	Double		The longitude coordinate of the customer address.
DefaultAddressName	String		The full name of the customer, based on firstName and lastName.
DefaultAddressPhone	String		A unique phone number for the customer. Formatted using E.164 standard. For example, +16135551111.
DefaultAddressProvince	String		The region of the address, such as the province, state, or district.
DefaultAddressProvinceCode	String		The two-letter code for the region. For example, ON.
DefaultAddressZip	String		The zip or postal code of the address.
HasNote	Boolean		Whether the customer has a note associated with them.
HasTimelineComment	Boolean		Whether the merchant has added timeline comments about the customer on the customer's page.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
LifetimeDuration	String		The amount of time since the customer was first added to the store. Example: 'about 12 years'.
Locale	String		The customer's locale.
MarketingOptInLevel	String		The marketing subscription opt-in level (as described by the M3AAWG best practices guideline) that the customer gave when they consented to receive marketing material by email. If the customer does not accept email marketing, then this property will be null.
Note	String		A note about the customer.
OrdersCount	Long		The number of orders that the customer has made at the store in their lifetime.
Phone	String		The customer's phone number.
State	String		The state of the customer's account with the shop. 使用できる値は次のとおりです。DECLINED, DISABLED, ENABLED, INVITED
TaxExempt	Boolean		Whether the customer is exempt from being charged taxes on their orders.
TotalSpentAmount	Decimal		The total amount that the customer has spent on orders in their lifetime.
TotalSpentCurrency	String		The currency of the total amount that the customer has spent on orders in their lifetime.
ValidEmailAddress	Boolean		Whether the email address is formatted correctly. This does not guarantee that the email address actually exists.
VerifiedEmail	Boolean		Whether the customer has verified their email address.

DraftOrders

List of saved draft orders.

View-Specific Information

Select

The Sync App uses the Shopify API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

Id supports the '=' comparison.
Status supports the '=' comparison.
CustomerId supports the '=' comparison.
CreatedAt supports the '=,>,<,>=,<=' comparison.
UpdatedAt supports the '=,>,<,>=,<=' comparison.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM DraftOrders

SELECT * FROM DraftOrders WHERE Id='123'

SELECT * FROM DraftOrders WHERE Status='completed'

SELECT * FROM DraftOrders WHERE CreatedAt > '2018-02-05'

SELECT * FROM DraftOrders WHERE UpdatedAt > '2018-02-05'

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
Name	String		Unique identifier for the draft order, which is unique within the store. For example, #D1223.
CreatedAt	Datetime		Date and time when the draft order was created in Shopify.
UpdatedAt	Datetime		Date and time when the draft order was last changed. The format is YYYY-MM-DD HH:mm:ss (for example, 2016-02-05 17:04:01).
CompletedAt	Datetime		Date and time when the draft order converted to a new order, and the draft order's status changed to Completed.
AppliedDiscountAmount	Decimal		The total amount that the customer has spent on orders in their lifetime.
AppliedDiscountCurrency	String		The currency of the total amount that the customer has spent on orders in their lifetime.
AppliedDiscountDescription	String		Description of the order-level discount.
AppliedDiscountTitle	String		Name of the order-level discount.
AppliedDiscountValue	Float		Amount of the order level discount (when value_type is percentage, the value in this field is the percentage discount).
AppliedDiscountValueType	String		Type of the order-level discount.
BillingAddress1	String		The first line of the address. Typically the street address or PO Box number.
BillingAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
BillingAddressCity	String		The name of the city, district, village, or town.
BillingAddressCompany	String		The name of the customer's company or organization.
BillingAddressCountry	String		The name of the country.
BillingAddressCountryCodeV2	String		The two-letter code for the country of the address. For example, US.
BillingAddressFirstName	String		The first name of the customer.
BillingAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
BillingAddressId	String		Globally unique identifier.
BillingAddressLastName	String		The last name of the customer.
BillingAddressLatitude	Double		The latitude coordinate of the customer address.
BillingAddressLongitude	Double		The longitude coordinate of the customer address.
BillingAddressName	String		The full name of the customer, based on firstName and lastName.
BillingAddressPhone	String		A unique phone number for the customer. Formatted using E.164 standard. For example, +16135551111.
BillingAddressProvince	String		The region of the address, such as the province, state, or district.
BillingAddressProvinceCode	String		The two-letter code for the region. For example, ON.
BillingAddressZip	String		The zip or postal code of the address.
CurrencyCode	String		Three letter code for the currency of the store at the time that the invoice is sent.
CustomerId	String	Customers.Id	Customer who will be sent an invoice for the draft order, if there is one.
Email	String		Email address of the customer, which is used to send notifications to.
HasTimelineComment	Boolean		Whether the merchant has added timeline comments to the draft order.
InvoiceSentAt	Datetime		Date and time when the invoice was last emailed to the customer.
InvoiceUrl	String		Link to the checkout, which is sent to your customer in the invoice email.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
Note2	String		Text from an optional note attached to the draft order.
OrderId	String	Orders.Id	Order that was created from this draft order.
ShippingAddress1	String		The first line of the address. Typically the street address or PO Box number.
ShippingAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
ShippingAddressCity	String		The name of the city, district, village, or town.
ShippingAddressCompany	String		The name of the customer's company or organization.
ShippingAddressCountry	String		The name of the country.
ShippingAddressCountryCodeV2	String		The two-letter code for the country of the address. For example, US.
ShippingAddressFirstName	String		The first name of the customer.
ShippingAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
ShippingAddressId	String		Globally unique identifier.
ShippingAddressLastName	String		The last name of the customer.
ShippingAddressLatitude	Double		The latitude coordinate of the customer address.
ShippingAddressLongitude	Double		The longitude coordinate of the customer address.
ShippingAddressName	String		The full name of the customer, based on firstName and lastName.
ShippingAddressPhone	String		A unique phone number for the customer. Formatted using E.164 standard. For example, +16135551111.
ShippingAddressProvince	String		The region of the address, such as the province, state, or district.
ShippingAddressProvinceCode	String		The two-letter code for the region. For example, ON.
ShippingAddressZip	String		The zip or postal code of the address.
Status	String		Status of the draft order.
SubtotalPrice	Decimal		Subtotal of the line items and their discounts (does not contain shipping charges or shipping discounts, or taxes).
TaxExempt	Boolean		Whether the draft order is tax exempt.
TaxesIncluded	Boolean		Whether the line item prices include taxes.
TotalPrice	Decimal		Total amount of the draft order (includes taxes, shipping charges, and discounts).
TotalShippingPrice	Decimal		Total shipping charge for the draft order.
TotalTax	Decimal		Total amount of taxes for the draft order.
TotalWeight	Long		Total weight (grams) of the draft order.

FulfillmentEvents

Retrieves the history of events associated with one or many fulfillments.

Columns


Name	Type	References	Description
Id [KEY]	String		A globally-unique identifier.
OrderId	String	Orders.Id	A globally-unique identifier.
FulfillmentId	String	Fulfillments.Id	A globally-unique identifier.
Status	String		The status of this fulfillment event. 使用できる値は次のとおりです。LABEL_PURCHASED, LABEL_PRINTED, READY_FOR_PICKUP, CONFIRMED, IN_TRANSIT, OUT_FOR_DELIVERY, ATTEMPTED_DELIVERY, DELIVERED, FAILURE
HappenedAt	Datetime		The time at which this fulfillment event happened.

FulfillmentOrders

FulfillmentOrders represents a group of one or more items in an order that are to be fulfilled from the same location.

View-Specific Information

Select

The Sync App processes filters client-side within the Sync App.

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
AssignedLocationAddress1	String		The first line of the address for the location.
AssignedLocationAddress2	String		The second line of the address for the location.
AssignedLocationCity	String		The city of the location.
AssignedLocationCountryCode	String		The two-letter country code of the location.
AssignedLocationName	String		The name of the location.
AssignedLocationPhone	String		The phone number of the location.
AssignedLocationProvince	String		The province of the location.
AssignedLocationLocationActivatable	Boolean		Whether this location can be reactivated.
AssignedLocationLocationAddressVerified	Boolean		Whether the location address has been verified.
AssignedLocationLocationDeactivatable	Boolean		Whether this location can be deactivated.
AssignedLocationLocationDeactivatedAt	String		Date and time the location was deactivated (null if location is still active).
AssignedLocationLocationFulfillsOnlineOrder	String		Indicates whether this location can fulfill online orders.
AssignedLocationLocationHasActiveInventory	Boolean		Indicates whether or not this location has active inventory.
AssignedLocationLocationId	String		Globally unique identifier.
AssignedLocationLocationIsActive	Boolean		Whether the location is active.
AssignedLocationLocationLegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
AssignedLocationLocationName	String		The name of the location.
AssignedLocationLocationShipsInventory	Boolean		Indicates whether or not this location is used for calculating shipping rates.
DestinationAddress1	String		The first line of the address of the destination.
DestinationAddress2	String		The second line of the address of the destination.
DestinationCity	String		The city of the destination.
DestinationCompany	String		The company of the destination.
DestinationCountryCode	String		The two-letter country code of the destination.
DestinationEmail	String		The email of the customer at the destination.
DestinationFirstName	String		The first name of the customer at the destination.
DestinationId	String		Globally unique identifier for destination location.
DestinationLastName	String		The last name of the customer at the destination.
DestinationPhone	String		The phone number of the customer at the destination.
DestinationProvince	String		The province of the destination.
destinationZip	String		The ZIP code of the destination.
OrderId	String		Globally unique identifier for Orders.
RequestStatus	String		The date and time when the customer was last updated.
Status	String		Whether the customer has agreed to receive marketing materials.

Fulfillments

Fulfillment represents a shipment of one or more items in an order.

View-Specific Information

Select

The Sync App processes filters client-side within the Sync App.

The following queries are processed server-side:

SELECT * FROM Fulfillments
SELECT * FROM Fulfillments WHERE OrderId='gid://shopify/Order/1234'
SELECT * FROM Fulfillments WHERE OrderId IN ('gid://shopify/Order/1234', 'gid://shopify/Order/1235')

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
CreatedAt	Datetime		The date and time when the fulfillment was created.
DeliveredAt	Datetime		The date that this fulfillment was delivered.
DisplayStatus	String		Human readable display status for this fulfillment.
EstimatedDeliveryAt	Datetime		The estimated date that this fulfillment will arrive.
InTransitAt	Datetime		The date and time when the fulfillment went into transit.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
Name	String		Human readable reference identifier for this fulfillment.
OrderId	String		Globally unique identifier.
RequiresShipping	Boolean		Whether any of the line items in the fulfillment require shipping.
Status	String		The status of the fulfillment.
TotalQuantity	Integer		Sum of all line item quantities for the fulfillment.
UpdatedAt	Datetime		The date and time when the fulfillment was last modified.

FulfillmentServices

Lists fulfillmentServices which Represents service that prepares and ships orders on behalf of the store owner.

View-Specific Information

Select

The Sync App processes filters client-side within the Sync App.

Columns


Name	Type	References	Description
Id [KEY]	String		The ID of the fulfillment service.
CallbackUrl	String		The callback URL the fulfillment service has registered for requests.
FulfillmentOrdersOptIn	Boolean		Whether the fulfillment service has opted into fulfillment order based requests.
Handle	String		Human-readable unique identifier for this fulfillment service.
InventoryManagement	Boolean		Whether the fulfillment service tracks product inventory and provides updates to Shopify.
LocationActivatable	Boolean		Whether this location can be reactivated.
LocationAddressAddress1	String		The first line of the address for the location.
LocationAddressAddress2	String		The second line of the address for the location.
LocationAddressCity	String		The city of the location.
LocationAddressCountry	String		The country of the location.
LocationAddressCountryCode	String		The two-letter country code of the location.
LocationAddressLatitude	Decimal		The latitude coordinates of the location.
LocationAddressLongitude	Decimal		The longitude coordinates of the location.
LocationAddressPhone	String		The phone number of the location.
LocationAddressProvince	String		The province of the location.
LocationAddressProvinceCode	String		The code for the region of the address, such as the province, state, or district.
LocationAddressZip	String		The ZIP code of the location.
LocationAddressVerified	Boolean		Whether the location address has been verified.
LocationDeactivatable	Boolean		Whether this location can be deactivated.
LocationDeactivatedAt	String		Date and time the location was deactivated (null if location is still active).
LocationDeletable	Boolean		Whether this location can be deleted.
LocationFulfillsOnlineOrders	Boolean		Indicates whether this location can fulfill online orders.
LocationHasActiveInventory	Boolean		Indicates whether or not this location has active inventory.
LocationHasUnfulfilledOrders	Boolean		Indicates whether or not this location has unfulfilled orders.
LocationId	String		Globally unique identifier.
LocationIsActive	Boolean		Whether the location is active.
LocationLegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
LocationName	String		The name of the location.
LocationshipsInventory	Boolean		Indicates whether or not this location is used for calculating shipping rates.
LocationSuggestedAddressesAddress1	String		The first line of the suggested address.
LocationSuggestedAddressesAddress2	String		The second line of the suggested address.
LocationSuggestedAddressesCity	String		The city of the suggested address.
LocationSuggestedAddressesCountry	String		The country of the suggested address.
LocationSuggestedAddressesCountryCode	String		The country code of the suggested address.
LocationSuggestedAddressesFormatted	String		A formatted version of the suggested address.
LocationSuggestedAddressesProvince	String		The province of the suggested address.
LocationSuggestedAddressesProvinceCode	String		The province code of the suggested address.
LocationSuggestedAddressesZip	String		The ZIP code of the suggested address.
ProductBased	Boolean		Whether the fulfillment service supports local deliveries.
ServiceName	String		The name of the fulfillment service as seen by merchants.
ShippingMethodsCode	String		A unique code associated with the rate.
ShippingMethodsLabel	String		A description of the rate, which customers will see at checkout.
Type	String		Type associated with the fulfillment service.

Metafields

Retrieves a list of metafields that belong to one or many resource IDs.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, OwnerId and OwnerResource columns. The Sync App processes other filters client-side within the Sync App.

OwnerResource is a required column, and eligible values include "product" and "variant".

The following columns correspond to the same name columns in the REST table, except for Id and LegacyResourceId:

Id
LegacyResourceId
Namespace
Key
Value
Type
Description
OwnerId
OwnerResource
CreatedAt
UpdatedAt

Id corresponds to REST.Metafields.AdminGraphqlApiId, and LegacyResourceId corresponds to REST.Metafields.Id. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Metafields WHERE OwnerResource = 'product'

SELECT * FROM Metafields WHERE OwnerResource = 'product' AND Id = 'gid://shopify/Metafield/19334473318423'

SELECT * FROM Metafields WHERE OwnerId = 'gid://shopify/ProductVariant/39378393497623' AND OwnerResource = 'variant'

SELECT * FROM Metafields WHERE OwnerId IN ('gid://shopify/ProductVariant/39378393497623','gid://shopify/Product/1418248224791') AND OwnerResource = 'variant'

Columns


Name	Type	References	Description
Id [KEY]	String		The unique ID of the metafield.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
Namespace	String		A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps.
Key	String		The name of the metafield.
Value	String		The information to be stored as metadata.
Type	String		The metafield's information type.
Description	String		A description of the information that the metafield contains.
OwnerId	String		The ID of the resource that the metafield is attached to.
OwnerResource	String		The type of resource that the metafield is attached to. 使用できる値は次のとおりです。product, variant
CreatedAt	Datetime		The date and time when the metafield was created.
UpdatedAt	Datetime		The date and time when the metafield was last updated.

OrderRisks

The order risks associated with this order.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id column. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Orders

SELECT * FROM Orders WHERE Id='123'

Columns


Name	Type	References	Description
OrderId [KEY]	String		The order which this order risk is associated.
Display	Boolean		Whether the risk level is shown in the Shopify admin. If false, then this order risk is ignored when Shopify determines the overall risk level for the order.
Level	String		The likelihood that an order is fraudulent, based on this order risk. The level can be set by Shopify risk analysis or by an app.
Message	String		The risk message that's shown to the merchant in the Shopify admin.

Orders

Tax rates with their effective dates of application

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the Id, CreatedAt, CustomerId, DiscountCode, Email, Name, ProcessedAt, RiskLevel, Test, UpdatedAt columns. The supported SQL operators are '=' and 'IN' for Id, '=' and '!=' for CustomerId, DiscountCode, Email, Name, RiskLevel and Test, '=','!=','>','<','<=','>=' for the CreatedAt, ProcessedAt, and UpdatedAt columns. The Sync App processes other filters client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Orders
SELECT * FROM Orders WHERE Id='gid://shopify/Order/232220695'
SELECT * FROM Orders WHERE Id IN ('gid://shopify/Order/232220695', 'gid://shopify/Order/23220695')
SELECT * FROM Orders WHERE CustomerId='3514040471'
SELECT * FROM Orders WHERE CustomerId!='3514040471'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND Test=true
SELECT * FROM Orders WHERE CustomerId='3514040471' AND RiskLevel='LOW'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND RiskLevel!='LOW'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND Email='[email protected]'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND Email!='[email protected]'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND DiscountCode='BlackFriday'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND DiscountCode!='BlackFriday'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND UpdatedAt='2022-01-18 02:32:26.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND UpdatedAt!='2022-01-18 02:32:26.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND UpdatedAt<='2022-01-18 02:32:26.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND UpdatedAt>='2022-01-18 02:32:26.0' AND UpdatedAt<='2022-05-10 07:52:22.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND ProcessedAt='2017-09-19 06:10:39.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND ProcessedAt!='2017-09-19 06:10:39.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND ProcessedAt<='2017-09-19 06:10:39.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND ProcessedAt>='2017-09-19 06:10:39.0' AND ProcessedAt<='2021-10-07 23:45:38.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND CreatedAt='2017-09-19 06:10:39.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND CreatedAt!='2017-09-19 06:10:39.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND CreatedAt<='2017-09-19 06:10:39.0'
SELECT * FROM Orders WHERE CustomerId='3514040471' AND CreatedAt>='2017-09-19 06:10:39.0' AND CreatedAt<='2021-10-07 23:45:38.0'

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
BillingAddressMatchesShippingAddress	Boolean		Whether the billing address matches the shipping address.
BillingAddress1	String		The first line of the address. Typically the street address or PO Box number.
BillingAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
BillingAddressCity	String		The name of the city, district, village, or town.
BillingAddressCompany	String		The name of the customer's company or organization.
BillingAddressCountry	String		The name of the country.
BillingAddressCountryCodeV2	String		The two-letter code for the country of the address. For example, US.
BillingAddressFirstName	String		The first name of the customer.
BillingAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
BillingAddressId	String		Globally unique identifier.
BillingAddressLastName	String		The last name of the customer.
BillingAddressLatitude	Double		The latitude coordinate of the customer address.
BillingAddressLongitude	Double		The longitude coordinate of the customer address.
BillingAddressName	String		The full name of the customer, based on firstName and lastName.
BillingAddressPhone	String		A unique phone number for the customer. Formatted using E.164 standard. For example, +16135551111.
BillingAddressProvince	String		The region of the address, such as the province, state, or district.
BillingAddressProvinceCode	String		The two-letter code for the region. For example, ON.
BillingAddressZip	String		The zip or postal code of the address.
CanMarkAsPaid	Boolean		Whether the order can be manually marked as paid.
CanNotifyCustomer	Boolean		Whether notifications can be sent to the customer or not.
CancelReason	String		Reason the order was canceled. Returns null if the order wasn't canceled.
CancelledAt	Datetime		Date and time when the order was canceled. Returns null if the order wasn't canceled.
Capturable	Boolean		Whether payment for the order can be captured. Returns true when the customer's credit card has been authorized for payment and the authorization period has not expired.
CartDiscountPresentmentMoneyAmount	Decimal		The amount of the order-level discount in presentment currency.
CartDiscountPresentmentCurrencyCode	String		The presentment currency of the order-level discount.
CartDiscountShopMoneyAmount	Decimal		The amount of the order-level discount in shop currency.
CartDiscountShopCurrencyCode	String		The shop currency of the order-level discount.
ClientIp	String		The ip address of the client that is associated with this order.
Closed	Boolean		Whether the order is closed.
ClosedAt	Datetime		Date and time when the order closed. If the order is not closed, then this field is null.
Confirmed	Boolean		Whether inventory has been reserved for the order.
CreatedAt	Datetime		Date and time when the order was created in Shopify.
CurrencyCode	String		The currency of the store at the time of the order. If payment hasn't occurred, then this field is null.
CustomerId	String		Unique identifier of the customer who placed the order. Not all orders have customers associated with them.
CustomerFirstName	String		The first name of the customer who placed the order. Not all orders have customers associated with them.
CustomerLastName	String		The last name of the customer who placed the order. Not all orders have customers associated with them.
CustomerAcceptsMarketing	Boolean		Whether the customer agreed to receive marketing materials.
CustomerLocale	String		A two-letter or three-letter language code, optionally followed by a region modifier. Example values could be 'en', 'en-CA', 'en-PIRATE'.
DiscountCode	String		Discount code provided by the customer.
DisplayAddress1	String		The first line of the address. Typically the street address or PO Box number.
DisplayAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
DisplayAddressCity	String		The name of the city, district, village, or town.
DisplayAddressCompany	String		The name of the customer's company or organization.
DisplayAddressCountry	String		The name of the country.
DisplayAddressCountryCodeV2	String		The two-letter code for the country of the address. For example, US.
DisplayAddressFirstName	String		The first name of the customer.
DisplayAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
DisplayAddressId	String		Globally unique identifier.
DisplayAddressLastName	String		The last name of the customer.
DisplayAddressLatitude	Double		The latitude coordinate of the customer address.
DisplayAddressLongitude	Double		The longitude coordinate of the customer address.
DisplayAddressName	String		The full name of the customer, based on firstName and lastName.
DisplayAddressPhone	String		A unique phone number for the customer. Formatted using E.164 standard. For example, +16135551111.
DisplayAddressProvince	String		The region of the address, such as the province, state, or district.
DisplayAddressProvinceCode	String		The two-letter code for the region. For example, ON.
DisplayAddressZip	String		The zip or postal code of the address.
DisplayFinancialStatus	String		Financial status of the order that can be shown to the merchant. This field does not capture all the possible details of an order's financial state and should only be used for display summary purposes.
DisplayFulfillmentStatus	String		Fulfillment status for the order that can be shown to the merchant. This field does not capture all the possible details of an order's fulfillment state. It should only be used for display summary purposes.
Edited	Boolean		Whether the order has had any edits applied or not.
Email	String		Email address provided by the customer.
Fulfillable	Boolean		Whether there are items that can be fulfilled. After an order is completely fulfilled (or completely refunded without any fulfillments) then this field returns false.
FullyPaid	Boolean		Whether the order has been paid in full.
HasTimelineComment	Boolean		Whether the merchant added timeline comments to the order.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
MerchantEditable	Boolean		Whether the order can be edited or not.
Name	String		Unique identifier for the order that appears on the order. For example, #1000 or _Store1001. This value is not unique across multiple stores.
NetPaymentPresentmentMoneyAmount	Decimal		The amount of the net payment for the order in presentment currency.
NetPaymentPresentmentCurrencyCode	String		The presentment currency of the net payment for the order.
NetPaymentShopMoneyAmount	Decimal		The amount of the net payment for the order in shop currency.
NetPaymentShopCurrencyCode	String		The shop currency of the net payment for the order.
Note	String		Contents of the note associated with the order.
OriginalTotalPricePresentmentMoneyAmount	Decimal		The amount of the total price of the order prior to any applied edits in presentment currency.
OriginalTotalPricePresentmentCurrencyCode	String		The presentment currency of the total price of the order prior to any applied edits.
OriginalTotalPriceShopMoneyAmount	Decimal		The amount of the total price of the order prior to any applied edits in shop currency.
OriginalTotalPriceShopCurrencyCode	String		The shop currency of the total price of the order prior to any applied edits.
PaymentCollectionDetails	String		The payment collection details for an order requiring additional payment.
Phone	String		Phone number provided by the customer.
PresentmentCurrencyCode	String		The payment currency of the customer for this order.
ProcessedAt	Datetime		Date and time when the order was processed. When orders are imported from an app, this date and time may not match the date and time when the order was created.
PublicationId	String		The Id of the publication that created the order.
RefundDiscrepancyPresentmentMoneyAmount	Decimal		The amount of the difference between suggested and actual refund amounts in presentment currency.
RefundDiscrepancyPresentmentCurrencyCode	String		The presentment currency of the difference between suggested and actual refund amounts.
RefundDiscrepancyShopMoneyAmount	Decimal		The amount of the difference between suggested and actual refund amounts in shop currency.
RefundDiscrepancyShopCurrencyCode	String		The shop currency of the difference between suggested and actual refund amounts.
Refundable	Boolean		Whether the order can be refunded.
RequiresShipping	Boolean		Whether any line item in the order requires physical shipping.
Restockable	Boolean		Whether the order can be restocked.
RiskLevel	String		Fraud risk level of the order.
ShippingAddress1	String		The first line of the address. Typically the street address or PO Box number.
ShippingAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
ShippingAddressCity	String		The name of the city, district, village, or town.
ShippingAddressCompany	String		The name of the customer's company or organization.
ShippingAddressCountry	String		The name of the country.
ShippingAddressCountryCodeV2	String		The two-letter code for the country of the address. For example, US.
ShippingAddressFirstName	String		The first name of the customer.
ShippingAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
ShippingAddressId	String		Globally unique identifier.
ShippingAddressLastName	String		The last name of the customer.
ShippingAddressLatitude	Double		The latitude coordinate of the customer address.
ShippingAddressLongitude	Double		The longitude coordinate of the customer address.
ShippingAddressName	String		The full name of the customer, based on firstName and lastName.
ShippingAddressPhone	String		A unique phone number for the customer. Formatted using E.164 standard. For example, +16135551111.
ShippingAddressProvince	String		The region of the address, such as the province, state, or district.
ShippingAddressProvinceCode	String		The two-letter code for the region. For example, ON.
ShippingAddressZip	String		The zip or postal code of the address.
SubtotalLineItemsQuantity	Integer		The sum of the quantities for the line items that contribute to the order's subtotal.
SubtotalPricePresentmentMoneyAmount	Decimal		The amount of the subtotal of the line items and their discounts in presentment currency.
SubtotalPricePresentmentCurrencyCode	String		The presentment currency of the subtotal of the line items and their discounts.
SubtotalPriceShopMoneyAmount	Decimal		The amount of the subtotal of the line items and their discounts in shop currency.
SubtotalPriceShopCurrencyCode	String		The shop currency of the subtotal of the line items and their discounts.
TaxesIncluded	Boolean		Whether taxes are included in the subtotal price of the order.
Test	Boolean		Whether the order is a test. Test orders are made using the Shopify Bogus Gateway or the Shopify Payments test mode.
TotalCapturablePresentmentMoneyAmount	Decimal		The amount authorized for the order, that is uncaptured or undercaptured in presentment currency.
TotalCapturablePresentmentCurrencyCode	String		The presentment currency of the amount authorized for the order, that is uncaptured or undercaptured.
TotalCapturableShopMoneyAmount	Decimal		The amount authorized for the order, that is uncaptured or undercaptured in shop currency.
TotalCapturableShopCurrencyCode	String		The shop currency of the amount authorized for the order, that is uncaptured or undercaptured.
TotalDiscountPresentmentMoneyAmount	Decimal		The total amount discounted from the order (includes order-level and line item discounts) in presentment currency.
TotalDiscountPresentmentCurrencyCode	String		The presentment currency of the total amount discounted from the order (includes order-level and line item discounts).
TotalDiscountShopMoneyAmount	Decimal		The total amount discounted from the order (includes order-level and line item discounts) in shop currency.
TotalDiscountShopCurrencyCode	String		The shop currency of the total amount discounted from the order (includes order-level and line item discounts).
TotalOutstandingPresentmentMoneyAmount	Decimal		The total amount of money not yet authorized for the order in presentment currency.
TotalOutstandingPresentmentCurrencyCode	String		The presentment currency of the total amount of money not yet authorized for the order.
TotalOutstandingShopMoneyAmount	Decimal		The total amount of money not yet authorized for the order in shop currency.
TotalOutstandingShopCurrencyCode	String		The shop currency of the total amount of money not yet authorized for the order.
TotalPricePresentmentMoneyAmount	Decimal		The total amount of the order (includes taxes and discounts) in presentment currency.
TotalPricePresentmentCurrencyCode	String		The presentment currency of the total amount of the order (includes taxes and discounts).
TotalPriceShopMoneyAmount	Decimal		The total amount of the order (includes taxes and discounts) in shop currency.
TotalPriceShopCurrencyCode	String		The shop currency of the total amount of the order (includes taxes and discounts).
TotalReceivedPresentmentMoneyAmount	Decimal		The total amount received by the customer for the order in presentment currency.
TotalReceivedPresentmentCurrencyCode	String		The presentment currency of the total amount received by the customer for the order.
TotalReceivedShopMoneyAmount	Decimal		The total amount received by the customer for the order in shop currency.
TotalReceivedShopCurrencyCode	String		The shop currency of the total amount received by the customer for the order.
TotalRefundedPresentmentMoneyAmount	Decimal		The total amount refunded for the order in presentment currency.
TotalRefundedPresentmentCurrencyCode	String		The presentment currency of the total amount refunded for the order.
TotalRefundedShopMoneyAmount	Decimal		The total amount refunded for the order in shop currency.
TotalRefundedShopCurrencyCode	String		The shop currency of the total amount refunded for the order.
TotalRefundedShippingPresentmentMoneyAmount	Decimal		The total amount refunded for shipping in presentment currency.
TotalRefundedShippingPresentmentCurrencyCode	String		The presentment currency of the total amount refunded for shipping.
TotalRefundedShippingShopMoneyAmount	Decimal		The total amount refunded for shipping in shop currency.
TotalRefundedShippingShopCurrencyCode	String		The shop currency of the total amount refunded for shipping.
TotalShippingPresentmentMoneyAmount	Decimal		The total amount charged for shipping in presentment currency.
TotalShippingPresentmentCurrencyCode	String		The presentment currency of the total amount charged for shipping.
TotalShippingShopMoneyAmount	Decimal		The total amount charged for shipping in shop currency.
TotalShippingShopCurrencyCode	String		The shop currency of the total amount charged for shipping.
TotalTaxPresentmentMoneyAmount	Decimal		The total of all taxes applied to the order in presentment currency.
TotalTaxPresentmentCurrencyCode	String		The presentment currency of the total of all taxes applied to the order.
TotalTaxShopMoneyAmount	Decimal		The total of all taxes applied to the order in shop currency.
TotalTaxShopCurrencyCode	String		The shop currency of the total of all taxes applied to the order.
TotalWeight	Long		Total weight (grams) of the order.
Unpaid	Boolean		Whether no payments have been made for the order. If no payments have been made for the order, then this returns true.
UpdatedAt	Datetime		Date and time when the order was last modified.

OrderTransactions

List of all transactions associated with the orders.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the OrderId column. The Sync App processes other filters client-side within the Sync App.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server side.

SELECT * FROM OrderTransactions WHERE OrderId = '123'

When performing a query without a filter or a filter other then the OrderId column, the Sync App will retrieve the entire list of transactions and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving transactions. Therefore to retrieve all the transactions, the Sync App will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the Sync App will issue individual requests to the Shopify API to retrieve all the transactions for each OrderId to build the result set.

SELECT * FROM OrderTransactions

SELECT * FROM OrderTransactions WHERE Kind='Capture'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. Other search criteria will be ignored and an unfiltered response will be returned.

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
OrderId	String		The Id of the associated order.
AccountNumber	String		The masked account number associated with the payment method.
AmountSetPresentmentMoneyAmount	Decimal		The amount of the transaction in presentment currency.
AmountSetPresentmentMoneyCurrencyCode	String		The currency of the transaction in presentment currency.
AmountSetShopMoneyAmount	Decimal		The amount of the transaction in shop currency.
AmountSetShopMoneyCurrencyCode	String		The currency of the transaction in shop currency.
AuthorizationCode	String		Authorization code associated with the transaction.
CreatedAt	Datetime		Date and time when the transaction was created.
ErrorCode	String		A standardized error code, independent of the payment provider.
FormattedGateway	String		The human-readable payment gateway name used to process the transaction.
Gateway	String		The payment gateway used to process the transaction.
Kind	String		The kind of transaction.
ManuallyCapturable	Boolean		Whether the transaction can be manually captured.
MaximumRefundableMoneyAmount	Decimal		The available amount with currency to refund on the gateway.
MaximumRefundableMoneyCurrencyCode	String		The currency of the refund on the gateway.
ParentTransactionId	String		The associated parent transaction, for example the authorization of a capture.
ProcessedAt	Datetime		Date and time when the transaction was processed.
Status	String		The status of this transaction.
Test	Boolean		Whether the transaction is a test transaction.
TotalUnsettledSetPresentmentMoneyAmount	Decimal		The available amount to capture on the gateway in presentment currency.
TotalUnsettledSetPresentmentMoneyCurrencyCode	String		The available money currency to capture on the gateway in presentment currency.
TotalUnsettledSetShopMoneyAmount	Decimal		The available amount to capture on the gateway in shop currency.
TotalUnsettledSetShopMoneyCurrencyCode	String		The available money currency to capture on the gateway in shop currency.

ProductImages

The images associated with the product.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the ProductId column. The Sync App processes other filters client-side within the Sync App.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM ProductImages WHERE ProductId = 'gid://shopify/Product/1234567890123'

SELECT * FROM ProductImages WHERE ProductId IN ('gid://shopify/Product/1234567890123', 'gid://shopify/Product/1234567890124')

Columns


Name	Type	References	Description
Id [KEY]	String		A unique identifier for the image.
ProductId	String	Products.Id	A globally-unique identifier.
AltText	String		A word or phrase to share the nature or contents of an image.
Height	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
Width	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
Url	String		The location of the image as a URL.

ProductOptions

A list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the ProductId column. The Sync App processes other filters client-side within the Sync App.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM ProductOptions WHERE ProductId = 'gid://shopify/Product/1234567890123'

SELECT * FROM ProductOptions WHERE ProductId IN ('gid://shopify/Product/1234567890123', 'gid://shopify/Product/1234567890124')

Columns


Name	Type	References	Description
Id [KEY]	String		A globally-unique identifier.
ProductId	String	Products.Id	A globally-unique identifier.
Name	String		The product option's name.
Position	Int		The product option's position.
Values	String		The corresponding value to the product option name.

Products

List of products.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the following columns:

Id
Title
ProductType
Status
Vendor
TotalInventory
HasOnlyDefautlVariant
UpdatedAt
CreatedAt

The Sync App processes other filters client-side within the Sync App.

Note that server-side filter extends to =/!= for Bool/String type columns, and only includes other operators for datetime or number type columns.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM Products WHERE Id = 'gid://shopify/Product/6830135181335'

SELECT * FROM Products WHERE Id IN ('gid://shopify/Product/6830135181335', 'gid://shopify/Product/6830135181336')

SELECT * FROM Products WHERE Title = 'title'

SELECT * FROM Products WHERE Vendor = 'vendor'

SELECT * FROM Products WHERE CreatedAt > '2022-11-02T09:07:53.000-04:00'

Columns


Name	Type	References	Description
Id	String		A globally-unique identifier.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
Description	String		The description of the product, complete with HTML formatting.
DescriptionHtml	String		The description of the product, complete with HTML formatting.
Title	String		The title of the product.
Handle	String		A unique human-friendly string of the product's title.
ProductType	String		The product type specified by the merchant.
Tags	String		A comma separated list of tags associated with the product. Updating 'tags' overwrites any existing tags that were previously added to the product.
Status	String		The product status. This controls visibility across all channels.
Vendor	String		The name of the product's vendor.
OnlineStorePreviewUrl	String		The online store preview URL.
OnlineStoreUrl	String		The online store URL for the product.A value of 'null' indicates that the product is not published to the Online Store sales channel.
RequiresSellingPlan	Bool		Whether the product can only be purchased with a selling plan (subscription). Products that are sold on subscription ('requiresSellingPlan: true') can be updated only for online stores. If you update a product to be subscription only, then the product is unpublished from all channels except the online store.
SellingPlanGroupCount	Int		Count of selling plan groups associated with the product.
TracksInventory	Bool		Whether inventory tracking has been enabled for the product.
TotalInventory	Int		The quantity of inventory in stock.
HasOnlyDefaultVariant	Bool		Whether the product has only a single variant with the default option and value.
HasOutOfStockVariants	Bool		Whether the product has out of stock variants.
TotalVariants	Int		The number of variants that are associated with the product.
TemplateSuffix	String		The theme template used when viewing the product in a store.
GiftCardTemplateSuffix	String		The theme template used when viewing the gift card in a store.
IsGiftCard	Bool		Whether the product is a gift card.
PublishedAt	Datetime		The date and time when the product was published to the Online Store.
UpdatedAt	Datetime		The date and time when the product was last modified.A product's 'updatedAt' 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.
CreatedAt	Datetime		The date and time when the product was created.
FeedbackSummary	String		Summary of resource feedback pertaining to the resource.
PriceRangeMaxVariantPriceAmount	Decimal		Decimal money amount.
PriceRangeMaxVariantPriceCurrencyCode	String		Currency of the money.
PriceRangeMinVariantPriceAmount	Decimal		Decimal money amount.
PriceRangeMinVariantPriceCurrencyCode	String		Currency of the money.
SeoTitle	String		SEO Title.
SeoDescription	String		SEO Description.
MediaCount	Int		Total count of media belonging to a product.
FeaturedImageId	String		A unique identifier for the image.
FeaturedImageAltText	String		A word or phrase to share the nature or contents of an image.
FeaturedImageHeight	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
FeaturedImageWidth	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
FeaturedImageUrl	String		The location of the image as a URL.
ResourcePublicationOnCurrentPublicationIsPublished	Bool		Whether the resource publication is published. If true, then the resource publication is published to the publication. If false, then the resource publication is staged to be published to the publication.
ResourcePublicationOnCurrentPublicationPublishDate	Datetime		The date that the resource publication was or is going to be published to the publication.
ResourcePublicationOnCurrentPublicationPublicationId	String		A globally-unique identifier.
ResourcePublicationOnCurrentPublicationPublicationName	String		Name of the publication.
ResourcePublicationOnCurrentPublicationPublicationSupportsFuturePublishing	Bool		Whether the publication supports future publishing.

ProductVariants

List of the product variants.

View-Specific Information

Select

The Sync App uses the Shopify API to process search criteria that refer to the following columns:

Id
ProductId
Title
Barcode
Sku
Taxable
UpdatedAt
CreatedAt
InventoryQuantity
DeliveryProfileId

The Sync App processes other filters client-side within the Sync App. Note that server-side filter extends to =/!= for Bool/String type columns, and only includes other operators for datetime or number type columns.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side:

SELECT * FROM ProductVariants WHERE Id = 'gid://shopify/ProductVariant/6788079091735'

SELECT * FROM ProductVariants WHERE Id IN ('gid://shopify/ProductVariant/6830135181335', 'gid://ProductVariant/Product/6830135181336')

SELECT * FROM ProductVariants WHERE Title = 'title'

SELECT * FROM ProductVariants WHERE CreatedAt > '2018-02-05T15:47:32.000-05:00'

Columns


Name	Type	References	Description
Id	String		A globally-unique identifier.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
ProductId	String	Products.Id	A globally-unique identifier.
Position	Int		The order of the product variant in the list of product variants. The first position in the list is 1.
AvailableForSale	Bool		Whether the product variant is available for sale.
SellableOnlineQuantity	Int		The total sellable quantity of the variant for online channels. This doesn't represent the total available inventory or capture (limitations based on customer location).
SellingPlanGroupCount	Int		Count of selling plan groups associated with the product variant.
Price	Decimal		The price of the product variant in the default shop currency.
CompareAtPrice	Decimal		The compare-at price of the variant in the default shop currency.
Title	String		The title of the product variant.
DisplayName	String		Display name of the variant, based on product's title + variant's title.
Barcode	String		The value of the barcode associated with the product.
Weight	Float		The weight of the product variant in the unit system specified with weight_unit.
WeightUnit	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', 'lb'.
Sku	String		An identifier for the product variant in the shop. Required in order to connect to a fulfillment service.
Taxable	Bool		Whether a tax is charged when the product variant is sold.
TaxCode	String		The tax code for the product variant.
UpdatedAt	Datetime		The date and time when the product variant was last modified.
CreatedAt	Datetime		The date and time when the variant was created.
InventoryPolicy	String		Whether customers are allowed to place an order for the product variant when it's out of stock.
InventoryQuantity	Int		The total sellable quantity of the variant.
InventoryItemId	String		A globally-unique identifier.
InventoryItemLegacyResourceId	String		The ID of the corresponding resource in the REST Admin API.
InventoryItemSku	String		Inventory item SKU.
InventoryItemDuplicateSkuCount	Int		The number of inventory items that share the same SKU with this item.
InventoryItemHarmonizedSystemCode	String		The harmonized system code of the item.
InventoryItemLocationsCount	Int		The number of locations where this inventory item is stocked.
InventoryItemRequiresShipping	Bool		Whether the inventory item requires shipping.
InventoryItemCountryCodeOfOrigin	String		The ISO 3166-1 alpha-2 country code of where the item originated from.
InventoryItemProvinceCodeOfOrigin	String		The ISO 3166-2 alpha-2 province code of where the item originated from.
InventoryItemUnitCostAmount	Decimal		Decimal money amount.
InventoryItemUnitCostCurrencyCode	String		Currency of the money.
InventoryItemTracked	Bool		Whether inventory levels are tracked for the item.
InventoryItemTrackedEditableLocked	Bool		Whether the attribute is locked for editing.
InventoryItemTrackedEditableReason	String		The reason the attribute is locked for editing.
InventoryItemInventoryHistoryUrl	String		The URL that points to the inventory history for the item.
InventoryItemCreatedAt	Datetime		The date and time when the inventory item was created.
InventoryItemUpdatedAt	Datetime		The date and time when the inventory item was updated.
ImageId	String	ProductImages.Id	A unique identifier for the image.
ImageAltText	String		A word or phrase to share the nature or contents of an image.
ImageHeight	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageWidth	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageUrl	String		The location of the image as a URL.
DeliveryProfileId	String		A globally-unique identifier.
DeliveryProfileName	String		The name of the delivery profile.
DeliveryProfileDefault	Bool		Whether this is the default profile.
DeliveryProfileLegacyMode	Bool		Whether this shop has enabled legacy compatibility mode for delivery profiles.
DeliveryProfileActiveMethodDefinitionsCount	Int		The number of active shipping rates for the profile.
DeliveryProfileOriginLocationCount	Int		The number of active origin locations for the profile.
DeliveryProfileZoneCountryCount	Int		The number of countries with active rates to deliver to.
DeliveryProfileLocationsWithoutRatesCount	Int		The number of locations without rates defined.
DeliveryProfileProductVariantsCountCount	Int		The product variant count.
DeliveryProfileProductVariantsCountCapped	Bool		Whether the count has reached the cap of 500.
FulfillmentServiceEditableLocked	Bool		Whether the attribute is locked for editing.
FulfillmentServiceEditableReason	String		The reason the attribute is locked for editing.

Refunds

Represents a refund of items or transactions in an order.

View-Specific Information

Select

The Sync App processes filters client-side within the Sync App.

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
CreatedAt	Datetime		When the refund was created.
DutiesCountryCodeOfOrigin	Datetime		The ISO code of the country of origin of the line item.
DutiesHarmonizedSystemCode	Datetime		The harmonized system code of the line item.
DutiesId	String		Globally unique identifier.
DutiesTaxlineRate	Decimal		The tax rate to be applied.
DutiesTaxlineratePercentage	Decimal		The percentage of the price that the tax rate represents.
DutiesTaxlineTitle	String		The name of the tax.
LegacyResourceId	Long		The ID of the corresponding resource in the REST Admin API.
TotalRefundedSetPresentmentMoneyAmount	Decimal		Amount in presentment currency.
TotalRefundedSetPresentmentMoneyCurrencyCode	String		Amount in shop currency.
TotalRefundedSetShopMoneyAmount	Decimal		Amount in presentment currency.
TotalRefundedSetShopMoneyCurrencyCode	String		Amount in shop currency.
Note	String		Note associated with the refund.
OrderId	String		Order ID associated with the refund.
UpdatedAt	Datetime		When the refund was last updated.

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

プロパティ	説明
ShopURL	The full URL of your Shopify shop.
AuthScheme	The type of authentication to use when connecting to Shopify.
AccessToken	Admin API Access Token for a custom app.

OAuth

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

Firewall

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

Proxy

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

Logging

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

Schema

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。
Schema	Specify the Shopify server version to connect with.

Miscellaneous

プロパティ	説明
UseBulkAPI	Specifies whether to use Shopify Bulk Operations for GraphQL schema.
BulkPageSize	The number of records to retrieve before returning results to the user when UseBulkAPI=true.
IncludeCustomFields	Set whether to include custom fields in the query to the Products table. When off, performance will increase, but you can not get and change Products custom fields.
MaxPointsPerCall	Specifies how many points a call will cost.
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
ShopURL	The full URL of your Shopify shop.
AuthScheme	The type of authentication to use when connecting to Shopify.
AccessToken	Admin API Access Token for a custom app.

ShopURL

The full URL of your Shopify shop.

解説

The full URL of your Shopify shop.

AuthScheme

The type of authentication to use when connecting to Shopify.

解説

OAuth: Set this to perform OAuth authentication.
Access Token: Set this to use Access Token authentication.

AccessToken

Admin API Access Token for a custom app.

解説

Admin API Access Token for a custom app.

OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

OAuthClientId

OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId 値、およびクライアントシークレットOAuthClientSecret が提供されます。

OAuthClientSecret

OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId が提供されます。また、コンシューマーシークレットと呼ばれるクライアントシークレットも提供されます。クライアントシークレットをOAuthClientSecret プロパティに設定します。

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

SSLServerCert

TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Firewall

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

FirewallType

プロキシベースのファイアウォールで使われるプロトコル。

解説

このプロパティは、Sync App がFirewallServer プロキシ経由でトンネルトラフィックを使うためのプロトコルを指定します。デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し次のプロキシタイプのどれかで接続するには、ProxyAutoDetect をfalse に設定します。


タイプ	デフォルトポート	説明
TUNNEL	80	これが設定されている場合、Sync App はShopify への接続を開き、プロキシを経由して通信が行われます。
SOCKS4	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 4 プロキシ経由で送信し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 5 プロキシ経由で送信します。プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

FirewallServer

プロキシベースのファイアウォールの名前もしくはIP アドレス。

解説

ファイアウォールトラバーサルを許容するために設定するIP アドレス、DNS 名、もしくはプロキシホスト名を指定するプロパティです。プロトコルはFirewallType で指定されます。このプロパティとFirewallServer を使って、SOCKS 経由での接続、もしくはトンネリングが可能です。HTTP プロキシへの接続には、ProxyServer を使用します。

Sync App はデフォルトでシステムプロキシを使うので注意してください。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定してください。

FirewallPort

プロキシベースのファイアウォールのTCP ポート。

解説

ファイアウォールトラバーサルを許容するために設定するプロキシベースのファイアウォールのTCP ポート。名前もしくはIP アドレスを指定するには、FirewallServer を使います。FirewallType でプロトコルを指定します。

FirewallUser

プロキシベースのファイアウォールに認証するために使うユーザー名。

解説

FirewallUser およびFirewallPassword プロパティは、FirewallType により指定された認証方式に則り、FirewallServer、およびFirewallPort で指定されたプロキシに対しての認証に使われます。

FirewallPassword

プロキシベースのファイアウォールへの認証に使われるパスワード。

解説

このプロパティは、FirewallType により指定された認証メソッドに則り、FirewallServer およびFirewallPort で指定されたプロキシに渡されます。

Proxy

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

ProxyAutoDetect

これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

解説

これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

ProxyServer

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。

解説

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。HTTP プロキシへの認証には、Sync App はHTTP、Windows(NTLM)、もしくはKerberos 認証タイプを使用することができます。

SOCKS プロキシを経由して接続する、もしくは接続をトンネルするには、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定します。

ProxyPort

ProxyServer プロキシが起動しているTCP ポート。

解説

HTTP トラフィックをリダイレクトするHTTP プロキシが実行されているポート。ProxyServer でHTTP プロキシを指定します。その他のプロキシタイプについては、FirewallType を参照してください。

ProxyAuthScheme

ProxyServer プロキシへの認証で使われる認証タイプ。

解説

この値は、ProxyServer およびProxyPort で指定されるHTTP プロキシに認証するために使われる認証タイプを指定します。

Sync App は、デフォルトでsystem proxy settings を使い、追加での設定が不要です。他のプロキシへの接続をする場合には、ProxyServer およびProxyPort に加え、ProxyAutoDetect をfalse に設定します。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

認証タイプは、次のどれかになります。

BASIC： Sync App はHTTP BASIC 認証を行います。
DIGEST： Sync App はHTTP DIGEST 認証を行います。
NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKereros トークンを取得します。
PROPRIETARY： Sync App はNTLM もしくはKerberos トークンを発行しません。このトークンを、HTTP リクエストのAuthorization ヘッダーに含める必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyUser

ProxyServer プロキシへの認証に使われるユーザー名。

解説

ProxyUser および ProxyPassword オプションは、ProxyServer で指定されたHTTP プロキシに対して接続および認証するために使用されます。

ProxyAuthScheme で使用可能な認証タイプを選択することができます。HTTP 認証を使う場合、これをHTTP プロキシで識別可能なユーザーのユーザー名に設定します。Windows もしくはKerberos 認証を使用する場合、このプロパティを次の形式のどれかでユーザー名に設定します。

user@domain
domain\user

ProxyPassword

ProxyServer プロキシへの認証に使われるパスワード。

解説

このプロパティは、NTLM(Windows)、Kerberos、もしくはHTTP 認証をサポートするHTTP プロキシサーバーに認証するために使われます。HTTP プロキシを指定するためには、ProxyServer およびProxyPort を設定します。認証タイプを指定するためにはProxyAuthScheme を設定します。

HTTP 認証を使う場合、さらにHTTP プロキシにProxyUser およびProxyPassword を設定します。

NTLM 認証を使う場合、Windows パスワードにProxyUser およびProxyPassword を設定します。Kerberos 認証には、これらを入力する必要があります。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシに接続する場合には、これをfalse に設定します。

ProxySSLType

ProxyServer プロキシへの接続時に使用するSSL タイプ。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この値は、AUTO、ALWAYS、NEVER、TUNNEL のいずれかです。有効な値は次のとおりです。


AUTO	デフォルト設定。URL がHTTPS URL の場合、Sync App は、TUNNEL オプションを使います。URL がHTTP URL の場合、コンポーネントはNEVER オプションを使います。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続は、トンネリングプロキシを経由します。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyExceptions

ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Sync App は、追加設定なしにデフォルトでシステムのプロキシ設定を使います。この接続のプロキシ例外を明示的に構成するには、ProxyAutoDetect をfalse に設定して、ProxyServer およびProxyPort を設定する必要があります。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

LogModules

ログファイルに含めるコアモジュール。

解説

指定された（';' で区切られた）モジュールのみがログファイルに含まれます。デフォルトではすべてのモジュールが含まれます。

概要はログページを参照してください。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。
Schema	Specify the Shopify server version to connect with.

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。

解説

Sync App のスキーマファイル（テーブルとビューの場合は.rsd ファイル、ストアドプロシージャの場合は.rsb ファイル）を含むディレクトリへのパス。このフォルダの場所は、実行ファイルの場所からの相対パスにすることができます。Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

Note： このSync App は複数のスキーマをサポートするため、Shopify カスタムスキーマファイルの構造は以下のようになります。

各スキーマには、そのスキーマ名に対応するフォルダが作られます。
これらのスキーマフォルダは親フォルダに含まれています。
親フォルダは、個々のスキーマのフォルダではなく、Location として設定する必要があります。

指定しない場合、デフォルトの場所は"%APPDATA%\\CData\\Shopify Data Provider\\Schema" となり、%APPDATA% はユーザーのコンフィギュレーションディレクトリに設定されます：

BrowsableSchemas

このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

スキーマをデータベースからリストすると、負荷がかかる可能性があります。接続文字列でスキーマのリストを提供すると、パフォーマンスが向上します。

Tables

このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。

解説

テーブルを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でテーブルのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Views

使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

解説

ビューを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でビューのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Schema

Specify the Shopify server version to connect with.

解説

Set this property to REST to use the Shopify REST API or GRAPHQL to use the Shopify GraphQL API.

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
UseBulkAPI	Specifies whether to use Shopify Bulk Operations for GraphQL schema.
BulkPageSize	The number of records to retrieve before returning results to the user when UseBulkAPI=true.
IncludeCustomFields	Set whether to include custom fields in the query to the Products table. When off, performance will increase, but you can not get and change Products custom fields.
MaxPointsPerCall	Specifies how many points a call will cost.
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

UseBulkAPI

Specifies whether to use Shopify Bulk Operations for GraphQL schema.

解説

This property determines whether or not to use Shopify Bulk Operations for GraphQL schema. The driver automatically creates bulk query jobs and returns results as they are available.

BulkPageSize

The number of records to retrieve before returning results to the user when UseBulkAPI=true.

解説

The BulkPageSize indicates the number of records that are returned at a time when reading the data. In the background, the CData Sync App continues to read additional results from the data source. This connection property only has an impact when UseBulkAPI is set to true.

IncludeCustomFields

Set whether to include custom fields in the query to the Products table. When off, performance will increase, but you can not get and change Products custom fields.

解説

Set whether to include custom fields in the query to the Products table. When off, performance will increase, but you can not get and change Products custom fields.

MaxPointsPerCall

Specifies how many points a call will cost.

解説

The total cost of your queries cannot exceed 1,000 points at any given time, and that room is created in the app's bucket at a rate of 50 points per second.

MaxRows

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

解説

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

Other

これらの隠しプロパティは特定のユースケースでのみ使用されます。

解説

以下にリストされているプロパティは、特定のユースケースで使用可能です。通常のドライバーのユースケースおよび機能では、これらのプロパティは必要ありません。

複数のプロパティをセミコロン区切りリストで指定します。

統合およびフォーマット


DefaultColumnSize	データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。
ConvertDateTimeToGMT	日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換するかどうかを決定します。
RecordToFile=filename	基底のソケットデータ転送を指定のファイルに記録します。

PseudoColumns

このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。

解説

Entity Framework ではテーブルカラムでない疑似カラムに値を設定できないため、この設定はEntity Framework で特に便利です。この接続設定の値は、"Table1=Column1, Table1=Column2, Table2=Column3" の形式です。"*=*" のように"*" 文字を使用して、すべてのテーブルとすべてのカラムを含めることができます。

Timeout

タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。

解説

Timeout が0に設定されている場合は、操作がタイムアウトしません。処理が正常に完了するか、エラー状態になるまで実行されます。

Timeout の有効期限が切れても処理が完了していない場合は、Sync App は例外をスローします。

UserDefinedViews

カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

解説

ユーザー定義ビューは、UserDefinedViews.json というJSON 形式のコンフィギュレーションファイルで定義されています。Sync App は、このファイルで指定されたビューを自動的に検出します。

また、複数のビュー定義を持ち、UserDefinedViews 接続プロパティを使用して制御することも可能です。このプロパティを使用すると、指定されたビューのみがSync App によって検知されます。

このユーザー定義ビューのコンフィギュレーションファイルは、次のようにフォーマットされています。

各ルートエレメントはビューの名前を定義します。
各ルートエレメントには、query と呼ばれる子エレメントが含まれており、この子エレメントにはビューのカスタムSQL クエリが含まれています。

次に例を示します。

{
	"MyView": {
		"query": "SELECT * FROM Customers WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

UserDefinedViews 接続プロパティを使用して、JSON コンフィギュレーションファイルの場所を指定します。次に例を示します。

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"