本記事について
本記事では、Shopify(パブリックアプリ)で連携することができる『オブジェクト』と『カラム』について紹介します。
※なお、紹介するカラムは、『A』~『Z』の順に記載しています
b→dashとShopify(パブリックアプリ)の連携については、「Shopify(パブリックアプリ)のデータを取り込みたい」をご参照ください。
連携することができる『オブジェクト』と『カラム』
以下では、Shopify(パブリックアプリ)で連携することができる『オブジェクト』と『カラム』について紹介します。
AbandonedCheckouts
『AbandonedCheckouts』のカラム一覧
| 連携可能なカラム |
| AbandonedCheckoutUrl |
| BuyerAcceptsMarketing |
| BillingAddressFirstName |
| BillingAddressLastName |
| BillingAddressAdress1 |
| BillingAddressAdress2 |
| BillingAddressPhone |
| BillingAddressCity |
| BillingAddressCompany |
| BillingAddressZip |
| BillingAddressProvince |
| BillingAddressCountry |
| BillingAddressLatitude |
| BillingAddressLongitude |
| BillingAddressName |
| BillingAddressCountryCode |
| BillingAddressProvinceCode |
| BillingAddressDefault |
| CancelReason |
| CartToken |
| Currency |
| CustomerId |
| ClosedAt |
| CompletedAt |
| CreatedAt |
| DiscountCodes |
| Id |
| LandingSite |
| Note |
| ReferringSite |
| SourceName |
| SubtotalPrice |
| ShippingAddressFirstName |
| ShippingAddressLastName |
| ShippingAddressAdress1 |
| ShippingAddressAdress2 |
| ShippingAddressPhone |
| ShippingAddressCity |
| ShippingAddressCompany |
| ShippingAddressZip |
| ShippingAddressProvince |
| ShippingAddressCountry |
| ShippingAddressLatitude |
| ShippingAddressLongitude |
| ShippingAddressName |
| ShippingAddressCountryCode |
| ShippingAddressProvinceCode |
| ShippingAddressDefault |
| TotalDiscounts |
| TotalLineItemsPrice |
| TotalPrice |
| TotalTax |
| TotalWeight |
| TaxesIncluded |
| Token |
| UpdatedAt |
AbandonedCheckoutsItems
『AbandonedCheckoutsItems』のカラム一覧
| 連携可能なカラム |
| AbandonedCheckoutId |
| CreatedAt |
| FulFillmentsService |
| ItemVariantId |
| ItemTitle |
| ItemQuantity |
| ItemPrice |
| ItemGrams |
| ProductId |
| SKU |
| UpdatedAt |
| VariantTitle |
| Vendor |
ApplicationCharges
『ApplicationCharges』のカラム一覧
| 連携可能なカラム |
| ApiClientId |
| ChargeType |
| CreatedAt |
| DecoratedReturnUrl |
| Id |
| Name |
| Price |
| ReturnUrl |
| Status |
| Test |
| UpdatedAt |
ApplicationCredit
『ApplicationCredit』のカラム一覧
| 連携可能なカラム |
| Amount |
| Description |
| Id |
| Test |
Articles
『Articles』のカラム一覧
| 連携可能なカラム |
| AdminGraphqlApiId |
| Author |
| BlogId |
| BodyHtml |
| CreatedAt |
| Handle |
| Id |
| ImageAlt |
| ImageCreatedAt |
| ImageHeight |
| ImageSrc |
| ImageWidth |
| ImageAttachment |
| PublishedAt |
| PublishedStatus |
| SummaryHtml |
| Tags |
| TemplateSuffix |
| Title |
| UpdatedAt |
| UserId |
Assets
『Assets』のカラム一覧
| 連携可能なカラム |
| Attachment |
| Checksum |
| ContentType |
| CreatedAt |
| Key |
| PublicUrl |
| Size |
| ThemeId |
| UpdatedAt |
| Value |
AssignedFulfillmentOrders
『AssignedFulfillmentOrders』のカラム一覧
| 連携可能なカラム |
| AssignedLocationId |
| DestinationId |
| DestinationAddress1 |
| DestinationAddress2 |
| DestinationCity |
| DestinationCompany |
| DestinationFirstName |
| DestinationLastName |
| DestinationPhone |
| FulfillmentServiceHandle |
| Id |
| LineItems |
| OrderId |
| Operation |
| RequestStatus |
| ShopId |
| Status |
Blogs
『Blogs』のカラム一覧
| 連携可能なカラム |
| AdminGraphqlApiId |
| Commentable |
| CreatedAt |
| Feedburner |
| FeedburnerLocation |
| Handle |
| Id |
| Metafields |
| Tags |
| TemplateSuffix |
| Title |
| UpdatedAt |
CarrierServices
『CarrierServices』のカラム一覧
| 連携可能なカラム |
| Active |
| AdminGraphqlApiId |
| CallbackUrl |
| Format |
| Id |
| Name |
| ServiceDiscovery |
| Type |
CollectionListings
『CollectionListings』のカラム一覧
| 連携可能なカラム |
| BodyHtml |
| DefaultProductImage |
| Handle |
| Id |
| ImageCreatedAt |
| ImageSource |
| PublishedAt |
| Title |
| UpdatedAt |
Collects
『Collects』のカラム一覧
| 連携可能なカラム |
| CollectionId |
| CreatedAt |
| Id |
| ProductId |
| Position |
| SortValue |
| UpdatedAt |
Comments
『Comments』のカラム一覧
| 連携可能なカラム |
| ArticleId |
| Author |
| BlogId |
| Body |
| BodyHtml |
| CreatedAt |
| Id |
| Ip |
| PublishedAt |
| PublishedStatus |
| Status |
| UpdatedAt |
| UserAgent |
Countries
『Countries』のカラム一覧
| 連携可能なカラム |
| CollectionId |
| CreatedAt |
| Id |
| ProductId |
| Position |
| SortValue |
| UpdatedAt |
CustomCollections
『CustomCollections』のカラム一覧
| 連携可能なカラム |
| BodyHtml |
| Handle |
| Id |
| Image |
| Metafields |
| ProductId |
| PublishedAt |
| PublishedScope |
| PublishedStatus |
| SortOrder |
| TemplateSuffix |
| Title |
| UpdatedAt |
CustomerAddresses
『CustomerAddresses』のカラム一覧
| 連携可能なカラム |
| Address1 |
| Address2 |
| City |
| Company |
| Country |
| CountryCode |
| CountryName |
| CustomerId |
| CustomerUpdatedAt |
| Default |
| FirstName |
| Id |
| LastName |
| Name |
| Phone |
| Province |
| ProvinceCode |
| Zip |
Customers
『Customers』のカラム一覧
| 連携可能なカラム |
| AcceptsMarketing |
| CreatedAt |
| EmailMarketingState |
| EmailMarketingLevel |
| EmailMarketingUpdatedAt |
| FirstName |
| Id |
| LastName |
| LastOrderId |
| LastOrderName |
| MultipassIdentifier |
| Note |
| OrdersCount |
| Phone |
| State |
| Tags |
| TaxExempt |
| TotalSpent |
| UpdatedAt |
| VerifiedEmail |
DiscountApplications
『DiscountApplications』のカラム一覧
| 連携可能なカラム |
| AllocationMethod |
| Description |
| OrderId |
| OrderUpdatedAt |
| TargetSelection |
| TargetType |
| Title |
| Type |
| Value |
| ValueType |
DiscountCodes
『DiscountCodes』のカラム一覧
| 連携可能なカラム |
| Code |
| CreatedAt |
| Id |
| PriceRuleId |
| UpdatedAt |
| UsageCount |
DraftOrderItemProperties
『DraftOrderItemProperties』のカラム一覧
| 連携可能なカラム |
| DraftOrderId |
| ItemId |
| Name |
| Value |
DraftOrderItems
『DraftOrderItems』のカラム一覧
| 連携可能なカラム |
| AppliedDiscountTitle |
| AppliedDiscountDescription |
| AppliedDiscountValue |
| AppliedDiscountValueType |
| AppliedDiscountAmount |
| Custom |
| DraftOrderId |
| FulfillableQuantity |
| FulFillmentsService |
| GiftCard |
| ItemGrams |
| ItemId |
| ItemPrice |
| ItemQuantity |
| ItemTitle |
| ItemVariantId |
| Name |
| ProductId |
| Properties |
| RequiresShipping |
| SKU |
| Taxable |
| TaxLines |
| VariantTitle |
| Vendor |
DraftOrderItemTaxLines
『DraftOrderItemTaxLines』のカラム一覧
| 連携可能なカラム |
| DraftOrderId |
| ItemId |
| LineNumber |
| TaxTitle |
| TaxRate |
| TaxPrice |
DraftOrders
『DraftOrders』のカラム一覧
| 連携可能なカラム |
| AppliedDiscountTitle |
| AppliedDiscountDescription |
| AppliedDiscountValue |
| AppliedDiscountValueType |
| AppliedDiscountAmount |
| BillingAddressFirstName |
| BillingAddressLastName |
| BillingAddressAddress1 |
| BillingAddressAddress2 |
| BillingAddressPhone |
| BillingAddressCity |
| BillingAddressCompany |
| BillingAddressZip |
| BillingAddressProvince |
| BillingAddressCountry |
| BillingAddressLatitude |
| BillingAddressLongitude |
| BillingAddressName |
| BillingAddressCountryCode |
| BillingAddressProvinceCode |
| BillingAddressDefault |
| CompletedAt |
| CreatedAt |
| CustomerId |
| Currency |
| Id |
| InvoiceUrl |
| InvoiceSentAt |
| LineAggregate |
| Name |
| Note |
| Tags |
| TaxesIncluded |
| TaxExempt |
| TotalPrice |
| TotalTax |
| ShippingAddressFirstName |
| ShippingAddressLastName |
| ShippingAddressAddress1 |
| ShippingAddressAddress2 |
| ShippingAddressPhone |
| ShippingAddressCity |
| ShippingAddressCompany |
| ShippingAddressZip |
| ShippingAddressProvince |
| ShippingAddressCountry |
| ShippingAddressLatitude |
| ShippingAddressLongitude |
| ShippingAddressName |
| ShippingAddressCountryCode |
| ShippingAddressProvinceCode |
| ShippingAddressDefault |
| Status |
| SubtotalPrice |
| UpdatedAt |
Events
『Events』のカラム一覧
| 連携可能なカラム |
| Arguments |
| Author |
| Body |
| CreatedAt |
| Description |
| Id |
| Message |
| Path |
| SubjectId |
| SubjectType |
| Verb |
Fulfillments
『Fulfillments』のカラム一覧
| 連携可能なカラム |
| CreatedAt |
| FulfillmentOrderId |
| Id |
| LineAggregate |
| LocationId |
| NotifyCustomer |
| OrderCreatedAt |
| OrderId |
| OrderUpdatedAt |
| Receipt |
| Status |
| TrackingCompany |
| TrackingNumbers |
| TrackingUrls |
| UpdatedAt |
| VariantInventoryManagement |
FulfillmentServices
『FulfillmentServices』のカラム一覧
| 連携可能なカラム |
| Cost |
| CountryCodeOfOrigin |
| CountryHarmonizedSystemCodes |
| CreatedAt |
| HarmonizedSystemCode |
| Id |
| ProvinceCodeOfOrigin |
| RequiresShipping |
| SKU |
| Tracked |
| UpdatedAt |
InventoryItems
『InventoryItems』のカラム一覧
| 連携可能なカラム |
| Cost |
| CountryCodeOfOrigin |
| CountryHarmonizedSystemCodes |
| CreatedAt |
| HarmonizedSystemCode |
| Id |
| ProvinceCodeOfOrigin |
| RequiresShipping |
| SKU |
| Tracked |
| UpdatedAt |
Locations
『Locations』のカラム一覧
| 連携可能なカラム |
| Address1 |
| Address2 |
| City |
| Country |
| CountryCode |
| CountryName |
| CreatedAt |
| DeletedAt |
| Id |
| Legacy |
| Name |
| Phone |
| Province |
| UpdatedAt |
| Zip |
Metafield_Customer
『Metafield_Customer』のカラム一覧
| 連携可能なカラム |
| Id |
| Key |
| Namespace |
| OwnerId |
| UpdatedAt |
| Value |
Metafield_Product
『Metafield_Product』のカラム一覧
| 連携可能なカラム |
| Id |
| Key |
| Namespace |
| OwnerId |
| UpdatedAt |
| Value |
NoteAttributes
『NoteAttributes』のカラム一覧
| 連携可能なカラム |
| Name |
| OrderId |
| OrderUpdatedAt |
| Value |
OrderDiscountCodes
『OrderDiscountCodes』のカラム一覧
| 連携可能なカラム |
| Amount |
| Code |
| OrderId |
| OrderUpdatedAt |
| Type |
OrderItemDiscountAllocations
『OrderItemDiscountAllocations』のカラム一覧
| 連携可能なカラム |
| amount |
| ApplicationIndex |
| ItemId |
| LineNumber |
| OrderId |
| OrderUpdatedAt |
| PresentmentMoneyAmount |
| PresentmentMoneyCurrencyCode |
| ShopMoneyAmount |
| ShopMoneyCurrencyCode |
OrderItemProperties
『OrderItemProperties』のカラム一覧
| 連携可能なカラム |
| ItemId |
| LineNumber |
| Name |
| OrderId |
| OrderUpdatedAt |
| Value |
Orders
『Orders』のカラム一覧
| 連携可能なカラム |
| AppliedDiscountAmount |
| AppliedDiscountDescription |
| AppliedDiscountTitle |
| AppliedDiscountValue |
| AppliedDiscountValueType |
| BillingAddressAddress1 |
| BillingAddressAddress2 |
| BillingAddressCity |
| BillingAddressCompany |
| BillingAddressCountry |
| BillingAddressCountryCode |
| BillingAddressDefault |
| BillingAddressFirstName |
| BillingAddressLastName |
| BillingAddressLatitude |
| BillingAddressLongitude |
| BillingAddressName |
| BillingAddressPhone |
| BillingAddressProvince |
| BillingAddressProvinceCode |
| BillingAddressZip |
| BrowserIp |
| BuyerAcceptsMarketing |
| CancelledAt |
| CancelReason |
| CartToken |
| CheckoutId |
| CheckoutToken |
| ClosedAt |
| ConfirmationNumber |
| CreatedAt |
| Currency |
| CurrentTotalDutiesSetPresentmentMoneyAmount |
| CurrentTotalDutiesSetShopMoneyAmount |
| CurrentTotalPriceSetPresentmentMoneyAmount |
| CurrentTotalPriceSetShopMoneyAmount |
| CurrentTotalTaxSetPresentmentMoneyAmount |
| CurrentTotalTaxSetShopMoneyAmount |
| CurSubtotalPriceSetPresentmentMoneyAmount |
| CurSubtotalPriceSetShopMoneyAmount |
| CurTotalAdditionalFeesSetPresentmentMoneyAmount |
| CurTotalAdditionalFeesSetShopMoneyAmount |
| CurTotalDiscountsSetPresentmentMoneyAmount |
| CurTotalDiscountsSetShopMoneyAmount |
| CustomerFirstName |
| CustomerId |
| CustomerLastName |
| CustomerLocale |
| DiscountApplicationsAggregate |
| DiscountCodes |
| EstimatedTaxes |
| FinancialStatus |
| FulfillmentAggregate |
| FulfillmentStatus |
| Id |
| InventoryBehaviour |
| InvoiceSentAt |
| InvoiceUrl |
| LandingSite |
| LineAggregate |
| LocationId |
| Name |
| Note |
| NoteAttributesAggregate |
| Number |
| Operation |
| OrderStatusUrl |
| OriginalTotalDutiesSetPresentmentMoneyAmount |
| OriginalTotalDutiesSetShopMoneyAmount |
| OrigTotalAdditionalFeesSetPresentmentMoneyAmount |
| OrigTotalAdditionalFeesSetShopMoneyAmount |
| PaymentGatewayNames |
| PaymentTermsAmount |
| PaymentTermsCurrency |
| PaymentTermsDueInDays |
| PaymentTermsPaymentSchedules |
| PaymentTermsPaymentTermsName |
| PaymentTermsPaymentTermsType |
| Phone |
| PresentmentCurrency |
| ProcessedAt |
| ProcessingMethod |
| ReferringSite |
| RefundAggregate |
| SendFulfillmentReceipt |
| SendReceipt |
| ShippingAddressAddress1 |
| ShippingAddressAddress2 |
| ShippingAddressCity |
| ShippingAddressCompany |
| ShippingAddressCountry |
| ShippingAddressCountryCode |
| ShippingAddressDefault |
| ShippingAddressFirstName |
| ShippingAddressLastName |
| ShippingAddressLatitude |
| ShippingAddressLongitude |
| ShippingAddressName |
| ShippingAddressPhone |
| ShippingAddressProvince |
| ShippingAddressProvinceCode |
| ShippingAddressZip |
| ShippingAggregate |
| SourceName |
| SubtotalPrice |
| Tags |
| TaxAggregate |
| TaxesIncluded |
| TaxExempt |
| Test |
| Token |
| TotalDiscounts |
| TotalDiscountsSetPresentmentMoneyAmount |
| TotalDiscountsSetShopMoneyAmount |
| TotalLineItemsPriceSetPresentmentMoneyAmount |
| TotalLineItemsPriceSetShopMoneyAmount |
| TotalOrderItemsPrice |
| TotalOutstanding |
| TotalPrice |
| TotalPriceSetPresentmentMoneyAmount |
| TotalPriceSetShopMoneyAmount |
| TotalShippingPriceSetPresentmentMoneyAmount |
| TotalShippingPriceSetShopMoneyAmount |
| TotalShippingPriceSetShopMoneyCurrencyCode |
| TotalSubtotalSetPresentmentMoneyAmount |
| TotalSubtotalSetShopMoneyAmount |
| TotalTax |
| TotalTaxSetPresentmentMoneyAmount |
| TotalTaxSetShopMoneyAmount |
| TotalTipReceived |
| TotalWeight |
| UpdatedAt |
OrdersItems
『OrdersItems』のカラム一覧
| 連携可能なカラム |
| AppliedDiscountAmount |
| AppliedDiscountDescription |
| AppliedDiscountTitle |
| AppliedDiscountValue |
| AppliedDiscountValueType |
| FulfillableQuantity |
| FulFillmentsService |
| FulfillmentStatus |
| GiftCard |
| ItemGrams |
| ItemId |
| ItemPrice |
| ItemQuantity |
| ItemTitle |
| ItemVariantId |
| Name |
| OrderId |
| OrderUpdatedAt |
| ProductId |
| Properties |
| RequiresShipping |
| SKU |
| Taxable |
| TotalDiscount |
| VariantTitle |
| Vendor |
OrderTransactions
『OrderTransactions』のカラム一覧
| 連携可能なカラム |
| Amount |
| Authorization |
| AVSResultCode |
| CreatedAt |
| CreditCardBin |
| CreditCardCompany |
| CreditCardExpMonth |
| CreditCardExpYear |
| CreditCardName |
| CreditCardNumber |
| CreditCardWallet |
| Currency |
| CVVResultCode |
| DeviceId |
| ErrorCode |
| Gateway |
| Id |
| Kind |
| LocationId |
| Message |
| OrderId |
| PaymentId |
| PaymentsRefundsAttributesAcquirerReferenceNumber |
| PaymentsRefundsAttributesStatus |
| ProcessedAt |
| Receipt |
| ReceiptAuthorization |
| ReceiptTestcase |
| SourceName |
| Status |
| Test |
| TotalUnsettledSetPresentmentMoneyAmount |
| TotalUnsettledSetShopMoneyAmount |
| UserId |
Pages
『Pages』のカラム一覧
| 連携可能なカラム |
| AdminGraphqlApiId |
| Author |
| BodyHtml |
| CreatedAt |
| Handle |
| Id |
| Metafields |
| PublishedAt |
| PublishedStatus |
| ShopId |
| TemplateSuffix |
| Title |
| UpdatedAt |
Payouts
『Payouts』のカラム一覧
| 連携可能なカラム |
| Amount |
| Currency |
| Date |
| Id |
| Status |
PayoutTransactions
『PayoutTransactions』のカラム一覧
| 連携可能なカラム |
| Amount |
| Currency |
| Fee |
| Id |
| Net |
| PayoutId |
| PayoutStatus |
| ProcessedAt |
| SourceId |
| SourceOrderId |
| SourceOrderTransactionId |
| SourceType |
| Test |
| Type |
PriceRules
『PriceRules』のカラム一覧
| 連携可能なカラム |
| AllocationMethod |
| CreatedAt |
| CustomerSelection |
| EndsAt |
| EntitledCollectionIds |
| EntitledCountryIds |
| EntitledProductIds |
| EntitledVariantIds |
| Id |
| Images |
| OncePerCustomer |
| Options |
| PrerequisiteCollectionIds |
| PrerequisiteCustomerIds |
| PrerequisiteProductIds |
| PrerequisiteQuantityRange |
| PrerequisiteSavedSearchIds |
| PrerequisiteShippingPriceRange |
| PrerequisiteSubtotalRange |
| PrerequisiteToEntitlementQuantityRatio |
| PrerequisiteVariantIds |
| ProductType |
| PublishedAt |
| PublishedScope |
| StartsAt |
| Tags |
| TargetSelection |
| TargetType |
| TemplateSuffix |
| Title |
| UpdatedAt |
| UsageLimit |
| Value |
| ValueType |
| Vendor |
ProductImages
『ProductImages』のカラム一覧
| 連携可能なカラム |
| Alt |
| CreatedAt |
| FilePath |
| Height |
| ImageId |
| Position |
| ProductId |
| Src |
| UpdatedAt |
| VariantIds |
| Width |
ProductListings
『ProductListings』のカラム一覧
| 連携可能なカラム |
| BodyHtml |
| CreatedAt |
| Handle |
| Images |
| Options |
| ProductId |
| ProductType |
| PublishedAt |
| Tags |
| Title |
| UpdatedAt |
| Variants |
| Vendor |
ProductOptions
『ProductOptions』のカラム一覧
| 連携可能なカラム |
| Id |
| Name |
| Position |
| ProductId |
| ProductUpdatedAt |
| Values |
Products
『Products』のカラム一覧
| 連携可能なカラム |
| BodyHtml |
| CreatedAt |
| Handle |
| Id |
| Images |
| Options |
| ProductType |
| PublishedAt |
| PublishedScope |
| PublishedStatus |
| Status |
| Tags |
| TemplateSuffix |
| Title |
| UpdatedAt |
| Variants |
| Vendor |
ProductVariants
『ProductVariants』のカラム一覧
| 連携可能なカラム |
| Barcode |
| CompareAtPrice |
| CreatedAt |
| FulfillmentService |
| Grams |
| Id |
| ImageId |
| InventoryItemId |
| InventoryManagement |
| InventoryPolicy |
| InventoryQuantity |
| Option1 |
| Option2 |
| Option3 |
| Position |
| Price |
| ProductId |
| RequiresShipping |
| Sku |
| Taxable |
| Title |
| UpdatedAt |
| Weight |
| WeightUnit |
Provinces
『Provinces』のカラム一覧
| 連携可能なカラム |
| Code |
| CountryId |
| Id |
| Name |
| ShippingZoneId |
| Tax |
| TaxName |
| TaxPercentage |
| TaxType |
RecurringApplicationCharges
『RecurringApplicationCharges』のカラム一覧
| 連携可能なカラム |
| ActivatedOn |
| ApiClientId |
| BillingOn |
| CancelledOn |
| CappedAmount |
| ConfirmationUrl |
| CreatedAt |
| DecoratedReturnUrl |
| Id |
| Name |
| Price |
| ReturnUrl |
| Status |
| Terms |
| Test |
| TrialDays |
| TrialEndsOn |
| UpdatedAt |
Redirects
『Redirects』のカラム一覧
| 連携可能なカラム |
| Id |
| Path |
| Target |
RefundAdjustments
『RefundAdjustments』のカラム一覧
| 連携可能なカラム |
| Amount |
| AmountPresentmentCurrency |
| AmountPresentmentMoney |
| AmountShopCurrency |
| AmountShopMoney |
| Id |
| Kind |
| OrderId |
| Reason |
| RefundId |
| TaxAmount |
| TaxAmountPresentmentCurrency |
| TaxAmountPresentmentMoney |
| TaxAmountShopCurrency |
| TaxAmountShopMoney |
Refunds
『Refunds』のカラム一覧
| 連携可能なカラム |
| CreatedAt |
| Id |
| LineAggregate |
| Note |
| OrderId |
| OrderTransactionAggregate |
| OrderUpdatedAt |
| ProcessedAt |
| Restock |
| UserId |
RefundsItems
『RefundsItems』のカラム一覧
| 連携可能なカラム |
| AppliedDiscountAmount |
| AppliedDiscountDescription |
| AppliedDiscountTitle |
| AppliedDiscountValue |
| AppliedDiscountValueType |
| FulfillableQuantity |
| FulFillmentsService |
| FulfillmentStatus |
| GiftCard |
| ItemGrams |
| ItemId |
| ItemPrice |
| ItemQuantity |
| ItemTitle |
| ItemVariantId |
| LocationId |
| Name |
| OrderID |
| ProductId |
| Properties |
| RefundId |
| RefundQuantity |
| RefundRestockType |
| RefundSubtotal |
| RefundSubtotalPresentmentAmount |
| RefundSubtotalPresentmentCurrencyCode |
| RefundSubtotalShopAmount |
| RefundSubtotalShopCurrencyCode |
| RefundTotalTax |
| RefundTotalTaxPresentmentAmount |
| RefundTotalTaxPresentmentCurrencyCode |
| RefundTotalTaxShopAmount |
| RefundTotalTaxShopCurrencyCode |
| RequiresShipping |
| SKU |
| Taxable |
| TotalDiscount |
| VariantTitle |
| Vendor |
RefundTransactions
『RefundTransactions』のカラム一覧
| 連携可能なカラム |
| Amount |
| Authorization |
| CreatedAt |
| Currency |
| DeviceId |
| ErrorCode |
| Gateway |
| GraphqlAPIId |
| Kind |
| LocationId |
| Message |
| OrderId |
| ParentId |
| ProcessedAt |
| RefundId |
| SourceName |
| Status |
| Test |
| TransactionsId |
| UserId |
Reports
『Reports』のカラム一覧
| 連携可能なカラム |
| Category |
| Id |
| Name |
| ShopifyQl |
| UpdatedAt |
ScriptTags
『ScriptTags』のカラム一覧
| 連携可能なカラム |
| Cache |
| CreatedAt |
| DisplayScope |
| Event |
| Id |
| Src |
| UpdatedAt |
ShippingItemDiscountAllocations
『ShippingItemDiscountAllocations』のカラム一覧
| 連携可能なカラム |
| Amount |
| DiscountApplicationIndex |
| ItemId |
| LineNumber |
| OrderId |
| OrderUpdatedAt |
| PresentmentMoneyAmount |
| PresentmentMoneyCurrencyCode |
| ShopMoneyAmount |
| ShopMoneyCurrencyCode |
ShippingItems
『ShippingItems』のカラム一覧
| 連携可能なカラム |
| CarrierIdentifier |
| Code |
| Id |
| OrderId |
| OrderUpdatedAt |
| Price |
| RequestedFulfillmentServiceId |
| Source |
| Title |
ShippingZones
『ShippingZones』のカラム一覧
| 連携可能なカラム |
| CarrierShippingRateProviders |
| Countries |
| Id |
| LocationGroupId |
| Name |
| PriceBasedShippingRates |
| ProfileId |
| WeightBasedShippingRates |
Shop
『Shop』のカラム一覧
| 連携可能なカラム |
| Address1 |
| Address2 |
| City |
| Country |
| CountryCode |
| CountryName |
| CountryTaxes |
| CreatedAt |
| Currency |
| CustomerEmail |
| Domain |
| GoogleAppsDomain |
| GoogleAppsLoginEnabled |
| HasDiscounts |
| HasGiftCards |
| HasStorefront |
| IANATimezone |
| Id |
| Latitude |
| Longitude |
| MoneyFormat |
| MoneyWithCurrencyFormat |
| MyshopifyDomain |
| Name |
| PasswordEnabled |
| Phone |
| PlanDisplayName |
| PlanName |
| PrimaryLocale |
| Province |
| ProvinceCode |
| SetupRequired |
| ShopOwner |
| Source |
| TaxesIncluding |
| TaxShipping |
| Timezone |
| UpdatedAt |
| WeightUnit |
| Zip |
SmartCollections
『SmartCollections』のカラム一覧
| 連携可能なカラム |
| BodyHtml |
| Disjunctive |
| Handle |
| Id |
| Image |
| ProductId |
| PublishedAt |
| PublishedScope |
| PublishedStatus |
| Rules |
| SortOrder |
| TemplateSuffix |
| Title |
| UpdatedAt |
TaxItems
『TaxItems』のカラム一覧
| 連携可能なカラム |
| ChannelLiable |
| LineNumber |
| OrderId |
| OrderUpdatedAt |
| TaxItemPrice |
| TaxItemRate |
| TaxItemTitle |
Themes
『Themes』のカラム一覧
| 連携可能なカラム |
| AdminGraphqlApiId |
| CreatedAt |
| Id |
| Name |
| Previewable |
| Processing |
| Role |
| ThemeStoreId |
| UpdatedAt |
UsageCharges
『UsageCharges』のカラム一覧
| 連携可能なカラム |
| BalanceRemaining |
| BalanceUsed |
| BillingOn |
| CreatedAt |
| Description |
| Id |
| Price |
| RecurringApplicationId |
| RiskLevel |
Users
『Users』のカラム一覧
| 連携可能なカラム |
| AccountOwner |
| AdminGraphQLAPIId |
| Bio |
| FirstName |
| Id |
| IM |
| LastName |
| Locale |
| Permissions |
| Phone |
| ReceiveAnnouncements |
| ScreenName |
| TFAEnabled |
| Url |
| UserType |