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 |
-
|
|
TotalSpent |
decimal |
-
|
-
|
LastOrderID |
long |
-
|
-
|
Note |
string |
-
|
-
|
VerifiedEmail |
boolean |
-
|
-
|
MultipassIdentifier |
string |
-
|
-
|
TaxExempt |
boolean |
-
|
-
|
Phone |
string |
-
|
-
|
Tags |
string |
-
|
-
|
LastOrderName |
string |
-
|
-
|
Currency |
string |
-
|
-
|
AcceptsMarketingUpdatedAt |
datetime |
-
|
-
|
MarketingOptInLevel |
string |
-
|
-
|
DefaultAddressID |
long |
CustomerAddress → ID
|
-
|
CreatedAt |
datetime |
-
|
-
|
UpdatedAt |
datetime |
-
|
-
|
CustomerAddress
Documentation: https://shopify.dev/docs/admin-api/rest/reference/customers/customer
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/admin-api/rest/reference/shipping-and-fulfillment/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 |
-
|
-
|
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 |
-
|
-
|
LocalizedCountryName |
string |
-
|
-
|
LocalizedProvinceName |
string |
-
|
-
|
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/admin-api/rest/reference/orders/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 |
-
|
-
|
Tags |
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 |
-
|
-
|
Title |
string |
-
|
-
|
Quantity |
decimal |
-
|
-
|
Sku |
string |
-
|
-
|
VariantTitle |
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/admin-api/rest/reference/products/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 |
-
|
|
CreatedAt |
datetime |
-
|
-
|
UpdatedAt |
datetime |
-
|
-
|
ProductImage
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/admin-api/rest/reference/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 |
-
|
|
Test |
boolean |
-
|
-
|
ProcessedAt |
datetime |
-
|
-
|
RemoteReference |
string |
-
|
-
|
PaymentDetailsCreditCardNumber |
string |
-
|
-
|
PaymentDetailsCreditCardCompany |
string |
-
|
-
|
PaymentMethod |
string |
-
|
-
|
UpdatedAt |
datetime |
-
|
-
|
CreatedAt |
datetime |
-
|
-
|
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 |
-
|
-
|
FulfillmentLineItem
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 |
-
|
|
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 |
-
|
-
|
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
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
|
-
|
Amount |
decimal |
-
|
-
|
TaxAmount |
decimal |
-
|
-
|
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 |
-
|
-
|
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 |
-
|
-
|