Explore the Shopify API data model

See how the various Shopify endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Shopify API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Shopify API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

AbandonedCheckout

Documentation: https://shopify.dev/docs/api/admin-rest/latest/resources/abandoned-checkouts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CustomerID long Customer → ID -
CompletedAt datetime - -
Email string - -
BuyerAcceptsMarketing boolean - -
Note string - -
TaxesIncluded boolean - -
SourceUrl string - -
Phone string - -
CustomerLocale string - -
Source string - -
AbandonedCheckoutUrl string - -
BuyerAcceptsSmsMarketing boolean - -
SmsMarketingPhone string - -
TotalDiscounts decimal - -
TotalLineItemsPrice decimal - -
TotalPrice decimal - -
TotalTax decimal - -
SubtotalPrice decimal - -
TotalDuties decimal - -
ReservationToken string - -
BillingFirstName string - -
BillingLastName string - -
BillingAddress1 string - -
BillingAddress2 string - -
BillingPhone string - -
BillingCity string - -
BillingZip string - -
BillingProvince string - -
BillingCountry string - -
BillingCompany string - -
ShippingFirstName string - -
ShippingLastName string - -
ShippingAddress1 string - -
ShippingAddress2 string - -
ShippingPhone string - -
ShippingCity string - -
ShippingZip string - -
ShippingProvince string - -
ShippingCountry string - -
ShippingCompany string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Collection

Documentation: https://shopify.dev/docs/admin-api/rest/reference/products/collection

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Handle string - -
Title string - -
BodyHtml string - -
PublishedAt datetime - -
SortOrder string - -
TemplateSuffix string - -
ProductsCount int - -
ImageCreatedAt datetime - -
ImageAlt string - -
ImageWidth int - -
ImageHeight int - -
ImageSrc string - -
CreatedAt datetime - -
UpdatedAt datetime - -

CollectionProduct

Documentation: https://shopify.dev/docs/admin-api/rest/reference/products/product

Column Type Relates to Notes
RemoteID string - -
CollectionRemoteID string Collection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProductID long Product → ID -
CollectionID long Collection → ID -
CreatedAt datetime - -
UpdatedAt datetime - -

Customer

Documentation: https://shopify.dev/docs/admin-api/rest/reference/customers/customer

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Email string - -
AcceptsMarketing boolean - -
FirstName string - -
LastName string - -
OrdersCount int - -
State string -
  • 12 Aug 2020 Note that customers created manually in the Shopify backend are 'disabled' status by default. I don't think that this warrants a status of 'deleted' here though
TotalSpent decimal - -
LastOrderID long - -
Note string - -
VerifiedEmail boolean - -
MultipassIdentifier string - -
TaxExempt boolean - -
Phone string - -
LastOrderName string - -
Currency string - -
AcceptsMarketingUpdatedAt datetime - -
EmailMarketingConsentState string - -
EmailMarketingConsentOptInLevel string - -
EmailMarketingConsentUpdatedAt datetime - -
DefaultAddressID long CustomerAddress → ID -
CreatedAt datetime - -
UpdatedAt datetime - -

CustomerAddress

Documentation: https://shopify.dev/docs/api/admin-rest/latest/resources/customer#resource-object

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CustomerID long Customer → ID -
FirstName string - -
LastName string - -
Company string - -
Address1 string - -
Address2 string - -
City string - -
Province string - -
Country string - -
Zip string - -
Phone string - -
ProvinceCode string - -
CountryCode string - -
CountryName string - -
Default boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

Fulfillment

Documentation: https://shopify.dev/docs/api/admin-rest/latest/resources/fulfillment

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
OrderID long Order → ID -
Status string - -
Service string - -
TrackingCompany string - -
ShipmentStatus string - -
LocationID long Location → ID -
TrackingNumber string - -
TrackingUrl string - -
CreatedAt datetime - -
UpdatedAt datetime - -

InventoryItem

Documentation: https://shopify.dev/docs/admin-api/rest/reference/inventory/inventoryitem

Column Type Relates to Notes
RemoteID string - -
ProductVariantRemoteID string ProductVariant → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProductVariantID long ProductVariant → ID -
Sku string - -
RequiresShipping boolean - -
Cost decimal - -
CountryCodeOfOrigin string - -
ProvinceCodeOfOrigin string - -
HarmonizedSystemCode string - -
Tracked boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

InventoryLevel

Documentation: https://shopify.dev/docs/admin-api/rest/reference/inventory/inventorylevel

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
InventoryItemID long InventoryItem → ID -
LocationID long Location → ID -
Available decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -

Location

Documentation: https://shopify.dev/docs/admin-api/rest/reference/inventory/location

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Address1 string - -
Address2 string - -
City string - -
Zip string - -
Province string - -
Country string - -
Phone string - -
CountryCode string - -
CountryName string - -
ProvinceCode string - -
Legacy boolean - -
Active boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

ShopMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
ShopID long Shop → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Order

Documentation: https://shopify.dev/docs/api/admin-rest/latest/resources/order

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
BillingAddressFirstName string - -
BillingAddressLastName string - -
BillingAddressName string - -
BillingAddressCompany string - -
BillingAddressCountry string - -
BillingAddressPhone string - -
BillingAddressProvince string - -
BillingAddressAddress1 string - -
BillingAddressAddress2 string - -
BillingAddressZip string - -
BillingAddressLatitude string - -
BillingAddressLongitude string - -
BillingAddressCountryCode string - -
BillingAddressProvinceCode string - -
MailingAddressFirstName string - -
MailingAddressLastName string - -
MailingAddressName string - -
MailingAddressCompany string - -
MailingAddressCountry string - -
MailingAddressPhone string - -
MailingAddressProvince string - -
MailingAddressAddress1 string - -
MailingAddressAddress2 string - -
MailingAddressZip string - -
MailingAddressLatitude string - -
MailingAddressLongitude string - -
MailingAddressCountryCode string - -
MailingAddressProvinceCode string - -
Email string - -
ClosedAt datetime - -
Number int - -
Note string - -
Token string - -
Test boolean - -
TotalPrice decimal - -
SubtotalPrice decimal - -
TotalWeight decimal - -
TotalTax decimal - -
TaxesIncluded boolean - -
Currency string - -
FinancialStatus string - -
Confirmed boolean - -
TotalDiscounts decimal - -
TotalLineItemsPrice decimal - -
CartToken string - -
BuyerAcceptsMarketing boolean - -
ReferringSite string - -
LandingSite string - -
CancelledAt datetime - -
CancelReason string - -
TotalPriceUsd decimal - -
CheckoutToken string - -
Reference string - -
UserID long - -
LocationID long - -
SourceIdentifier string - -
SourceUrl string - -
ProcessedAt datetime - -
DeviceID long - -
Phone string - -
CustomerLocale string - -
AppID long - -
BrowserIp string - -
LandingSiteRef string - -
OrderNumber int - -
CurrentTotalDiscounts decimal - -
CurrentTotalPrice decimal - -
CurrentSubtotalPrice decimal - -
CurrentTotalTax decimal - -
CurrentTotalAdditionalFeesSetShopMoneyAmount decimal - -
CurrentTotalAdditionalFeesSetShopMoneyCurrencyCode string - -
CurrentTotalAdditionalFeesSetPresentmentMoneyAmount decimal - -
CurrentTotalAdditionalFeesSetPresentmentMoneyCurrencyCode string - -
CurrentTotalDiscountsSetShopMoneyAmount decimal - -
CurrentTotalDiscountsSetShopMoneyCurrencyCode string - -
CurrentTotalDiscountsSetPresentmentMoneyAmount decimal - -
CurrentTotalDiscountsSetPresentmentMoneyCurrencyCode string - -
CurrentTotalDutiesSetShopMoneyAmount decimal - -
CurrentTotalDutiesSetShopMoneyCurrencyCode string - -
CurrentTotalDutiesSetPresentmentMoneyAmount decimal - -
CurrentTotalDutiesSetPresentmentMoneyCurrencyCode string - -
CurrentTotalPriceSetShopMoneyAmount decimal - -
CurrentTotalPriceSetShopMoneyCurrencyCode string - -
CurrentTotalPriceSetPresentmentMoneyAmount decimal - -
CurrentTotalPriceSetPresentmentMoneyCurrencyCode string - -
CurrentSubTotalPriceSetShopMoneyAmount decimal - -
CurrentSubTotalPriceSetShopMoneyCurrencyCode string - -
CurrentSubTotalPriceSetPresentmentMoneyAmount decimal - -
CurrentSubTotalPriceSetPresentmentMoneyCurrencyCode string - -
CurrentTotalTaxSetShopMoneyAmount decimal - -
CurrentTotalTaxSetShopMoneyCurrencyCode string - -
CurrentTotalTaxSetPresentmentMoneyAmount decimal - -
CurrentTotalTaxSetPresentmentMoneyCurrencyCode string - -
CheckoutID long - -
SourceName string - -
FulfillmentStatus string - -
ContactEmail string - -
OrderStatusUrl string - -
PresentmentCurrency string - -
TotalLineItemsPriceSetShopAmount decimal - -
TotalLineItemsPriceSetShopCurrencyCode string - -
TotalLineItemsPriceSetPresentmentAmount decimal - -
TotalLineItemsPriceSetPresentmentCurrencyCode string - -
TotalDiscountsSetShopAmount decimal - -
TotalDiscountsSetShopCurrencyCode string - -
TotalDiscountsSetPresentmentAmount decimal - -
TotalDiscountsSetPresentmentCurrencyCode string - -
TotalShippingPriceSetShopAmount decimal - -
TotalShippingPriceSetShopCurrencyCode string - -
TotalShippingPriceSetPresentmentAmount decimal - -
TotalShippingPriceSetPresentmentCurrencyCode string - -
SubTotalPriceSetShopAmount decimal - -
SubTotalPriceSetShopCurrencyCode string - -
SubTotalPriceSetPresentmentAmount decimal - -
SubTotalPriceSetPresentmentCurrencyCode string - -
TotalPriceSetShopAmount decimal - -
TotalPriceSetShopCurrencyCode string - -
TotalPriceSetPresentmentAmount decimal - -
TotalPriceSetPresentmentCurrencyCode string - -
TotalTaxSetShopAmount decimal - -
TotalTaxSetShopCurrencyCode string - -
TotalTaxSetPresentmentAmount decimal - -
TotalTaxSetPresentmentCurrencyCode string - -
CreatedAt datetime - -
UpdatedAt datetime - -

OrderLineItem

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/order

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
OrderID long Order → ID -
VariantID long ProductVariant → ID -
Title string - -
Quantity decimal - -
Sku string - -
Vendor string - -
FulfillmentService string - -
ProductID long Product → ID -
RequiresShipping boolean - -
Taxable boolean - -
GiftCard boolean - -
VariantInventoryManagement string - -
ProductExists boolean - -
FulfillableQuantity decimal - -
Grams decimal - -
Price decimal - -
TotalDiscount decimal - -
FulfillmentStatus string - -
PriceSetShopAmount decimal - -
PriceSetShopCurrencyCode string - -
PriceSetPresentmentAmount decimal - -
PriceSetPresentmentCurrencyCode string - -
TotalDiscountSetShopAmount decimal - -
TotalDiscountSetShopCurrencyCode string - -
TotalDiscountSetPresentmentAmount decimal - -
TotalDiscountSetPresentmentCurrencyCode string - -
CurrentQuantity decimal - -

Product

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/product

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Status string - -
Title string - -
BodyHtml string - -
Vendor string - -
ProductType string - -
Handle string - -
PublishedAt datetime - -
TemplateSuffix string - -
PublishedScope string - -
Tags string -
  • 19 Aug 2020 Have confirmed that Shopify does not allow commas in individual tags
CreatedAt datetime - -
UpdatedAt datetime - -

ProductImage

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/product-image

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProductID long Product → ID -
Position int - -
Width string - -
Height string - -
Src string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Refund

Documentation: https://shopify.dev/api/admin-rest/2022-01/resources/refund#resource-object

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
OrderID long Order → ID -
Note string - -
UserID long - -
ProcessedAt datetime - -
Restock boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

Shop

Documentation: https://shopify.dev/docs/admin-api/rest/reference/store-properties/shop

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Domain string - -
IanaTimezone string - -
Email string - -
Province string - -
Country string - -
Address1 string - -
Zip string - -
City string - -
Phone string - -
Latitude decimal - -
Longitude decimal - -
PrimaryLocale string - -
Address2 string - -
CountryCode string - -
CountryName string - -
Currency string - -
CustomerEmail string - -
Timezone string - -
ShopOwner string - -
MoneyFormat string - -
MoneyWithCurrencyFormat string - -
WeightUnit string - -
ProvinceCode string - -
TaxesIncluded boolean - -
TaxShipping boolean - -
CountyTaxes boolean - -
PlanDisplayName string - -
PlanName string - -
HasDiscounts boolean - -
HasGiftCards boolean - -
MyshopifyDomain string - -
GoogleAppsDomain string - -
GoogleAppsLoginEnabled boolean - -
MoneyInEmailsFormat string - -
MoneyWithCurrencyInEmailsFormat string - -
EligibleForPayments boolean - -
RequiresExtraPaymentsAgreement boolean - -
PasswordEnabled boolean - -
HasStorefront boolean - -
EligibleForCardReaderGiveaway boolean - -
Finances boolean - -
CookieConsentLevel string - -
VisitorTrackingConsentPreference string - -
ForceSsl boolean - -
CheckoutApiSupported boolean - -
MultiLocationEnabled boolean - -
SetupRequired boolean - -
PreLaunchEnabled boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

SmartCollection

Documentation: https://shopify.dev/docs/admin-api/rest/reference/products/collection

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Handle string - -
Title string - -
BodyHtml string - -
PublishedAt datetime - -
SortOrder string - -
TemplateSuffix string - -
PublishedScope string - -
ImageCreatedAt datetime - -
ImageAlt string - -
ImageWidth int - -
ImageHeight int - -
ImageSrc string - -
CreatedAt datetime - -
UpdatedAt datetime - -

SmartCollectionProduct

Documentation: https://shopify.dev/docs/admin-api/rest/reference/products/product

Column Type Relates to Notes
RemoteID string - -
SmartCollectionRemoteID string SmartCollection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProductID long Product → ID -
SmartCollectionID long SmartCollection → ID -
CreatedAt datetime - -
UpdatedAt datetime - -

TenderTransaction

Documentation: https://shopify.dev/docs/api/admin-rest/latest/resources/tendertransaction

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
OrderID long Order → ID -
Amount decimal - -
Currency string - -
UserID long -
  • 25 Aug 2020 Foreign Key - References `User` (not implemented)
Test boolean - -
ProcessedAt datetime - -
RemoteReference string - -
PaymentDetailsCreditCardNumber string - -
PaymentDetailsCreditCardCompany string - -
PaymentMethod string - -
UpdatedAt datetime - -
CreatedAt datetime - -

AbandonedCheckoutNoteAttribute

Column Type Relates to Notes
RemoteID string - -
AbandonedCheckoutRemoteID string AbandonedCheckout → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
AbandonedCheckoutID long AbandonedCheckout → ID -
Value string - -

AbandonedCheckoutShippingLine

Column Type Relates to Notes
RemoteID string - -
AbandonedCheckoutRemoteID string AbandonedCheckout → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AbandonedCheckoutID long AbandonedCheckout → ID -
LineNumber int - -
Code string - -
Price decimal - -
OriginalShopPrice decimal - -
OriginalShopMarkup decimal - -
Source string - -
Title string - -
PresentmentTitle string - -
Phone string - -
Markup decimal - -
ApiClientID string - -
DeliveryOptionGroupToken string - -
DeliveryOptionGroupType string - -

AbandonedCheckoutLineItem

Column Type Relates to Notes
RemoteID string - -
AbandonedCheckoutRemoteID string AbandonedCheckout → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AbandonedCheckoutID long AbandonedCheckout → ID -
LineNumber int - -
Key string - -
DestinationLocationID long - -
GiftCard boolean - -
OriginLocationID long - -
PresentmentTitle string - -
PresentmentVariantTitle string - -
ProductID long Product → ID -
VariantID long ProductVariant → ID -
Quantity decimal - -
LinePrice decimal - -
Price decimal - -

AbandonedCheckoutTaxLine

Column Type Relates to Notes
RemoteID string - -
AbandonedCheckoutRemoteID string AbandonedCheckout → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AbandonedCheckoutID long AbandonedCheckout → ID -
LineNumber int - -
Price decimal - -
Rate decimal - -
Title string - -
ChannelLiable boolean - -

CollectionMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
CollectionRemoteID string Collection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
CollectionID long Collection → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

CustomerMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
CustomerID long Customer → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

CustomerTag

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerID long Customer → ID -
Tag string - -

FulfillmentLineItem

Column Type Relates to Notes
RemoteID string - -
FulfillmentRemoteID string Fulfillment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long OrderLineItem → ID -
FulfillmentID long Fulfillment → ID -
OrderID long Order → ID -

LocationMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
LocationRemoteID string Location → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
LocationID long Location → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

OrderDiscountCode

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderID long Order → ID -
DiscountNumber int -
  • 17 May 2024 We add an iterator here in case Shopify allows the same discount code to be applied multiple times to an order. This lets us retain a unique RemoteID for all order discounts
Code string - -
Amount decimal - -
Type string - -

OrderTaxLine

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderID long Order → ID -
ChannelLiable boolean - -
Price decimal - -
Rate decimal - -
Title string - -
ShopAmount decimal - -
ShopCurrencyCode string - -
PresentmentAmount decimal - -
PresentmentCurrencyCode string - -

OrderMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
OrderID long Order → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

OrderTag

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderID long Order → ID -
Tag string - -

OrderLineDiscountAllocation

Column Type Relates to Notes
RemoteID string - -
OrderLineItemRemoteID string OrderLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderLineItemID long OrderLineItem → ID -
Iterator int - -
Amount decimal - -
DiscountApplicationIndex string - -
ShopAmount decimal - -
ShopCurrencyCode string - -
PresentmentAmount decimal - -
PresentmentCurrencyCode string - -

OrderLineItemTaxLine

Column Type Relates to Notes
RemoteID string - -
OrderLineItemRemoteID string OrderLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderLineItemID long OrderLineItem → ID -
ChannelLiable boolean - -
Price decimal - -
Rate decimal - -
Title string - -
ShopAmount decimal - -
ShopCurrencyCode string - -
PresentmentAmount decimal - -
PresentmentCurrencyCode string - -

ProductVariant

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/product-variant

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProductID long Product → ID -
Title string - -
Price decimal - -
Sku string - -
Position int - -
InventoryPolicy string - -
CompareAtPrice decimal - -
FulfillmentService string - -
InventoryManagement string - -
Option1 string - -
Option2 string - -
Option3 string - -
Taxable boolean - -
Barcode string - -
Grams decimal - -
ImageID long - -
Weight decimal - -
WeightUnit string - -
InventoryQuantity decimal - -
OldInventoryQuantity decimal - -
RequiresShipping boolean - -
InventoryItemID long InventoryItem → ID -
CreatedAt datetime - -
UpdatedAt datetime - -

ProductTag

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID long Product → ID -
Tag string - -

ProductOption

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ProductID long Product → ID -
Position int - -

ProductMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
ProductID long Product → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

RefundLineItem

Column Type Relates to Notes
RemoteID string - -
RefundRemoteID string Refund → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
RefundID long Refund → ID -
Quantity decimal - -
LineItemID long OrderLineItem → ID -
LocationID long Location → ID -
RestockType string - -
Subtotal decimal - -
TotalTax decimal - -
SubTotalShopMoneyAccount decimal - -
SubTotalShopMoneyCurrencyCode string - -
SubTotalPresentmentMoneyAccount decimal - -
SubTotalPresentmentMoneyCurrencyCode string - -
TotalTaxShopMoneyAccount decimal - -
TotalTaxShopMoneyCurrencyCode string - -
TotalTaxPresentmentMoneyAccount decimal - -
TotalTaxPresentmentMoneyCurrencyCode string - -

RefundOrderAdjustment

Column Type Relates to Notes
RemoteID string - -
RefundRemoteID string Refund → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
RefundID long Refund → ID -
OrderID long Order → ID -
Kind string - -
Reason string - -
AmountSetShopMoneyAmount decimal - -
AmountSetShopMoneyCurrencyCode string - -
AmountSetPresentmentMoneyAmount decimal - -
AmountSetPresentmentMoneyCurrencyCode string - -
TaxAmountSetShopMoneyAmount decimal - -
TaxAmountSetShopMoneyCurrencyCode string - -
TaxAmountSetPresentmentMoneyAmount decimal - -
TaxAmountSetPresentmentMoneyCurrencyCode string - -

SmartCollectionMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
SmartCollectionRemoteID string SmartCollection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
SmartCollectionID long SmartCollection → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

AbandonedCheckoutShippingLineTaxLine

Column Type Relates to Notes
RemoteID string - -
AbandonedCheckoutShippingLineRemoteID string AbandonedCheckoutShippingLine → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ShippingLineRemoteID string AbandonedCheckoutShippingLine → RemoteID -
LineNumber int - -
Price decimal - -
Rate decimal - -
Title string - -
Source string - -
CompareAt decimal - -
ChannelLiable boolean - -

ProductVariantMetaField

Documentation: https://shopify.dev/docs/api/admin-rest/2025-04/resources/metafield#resource-object

Column Type Relates to Notes
RemoteID string - -
ProductVariantRemoteID string ProductVariant → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
ProductVariantID long ProductVariant → ID -
Key string - -
Namespace string - -
Value string - -
Type string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ProductOptionValue

Column Type Relates to Notes
RemoteID string - -
ProductOptionRemoteID string ProductOption → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductOptionID long ProductOption → ID -
Value string - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Shopify data Querying Shopify using regular SQL