Data source

Shopify data model: how orders, customers and products fit together

Trace a Shopify revenue figure back to the order, customer, payment and shipment rows behind it.

  1. Open source. OWOX Data Marts is open source: you can read the code that loads and models your data, and run it yourself.
  2. You own the data. Shopify tables load into your data warehouse, under your account. If you leave OWOX, they stay where they are.
  3. MCP-ready. Once the data is in, Claude or ChatGPT can work from your Data Marts through OWOX MCP.

Hand this to your AI

Don't wire up Shopify by hand. Have your AI assistant load it into your data warehouse.

Your assistant sets up the Shopify connector with you and loads the tables you pick; OWOX keeps them in your data warehouse, ready to use.

The prompt

set up the Shopify connector in OWOX Data Marts, let me pick the tables I need, load them into my data warehouse and show me the first rows

The Shopify data model

The Shopify data model

25 tables386 fields18 joinsView on GitHub

Abandoned Checkouts20 fields1 relationshipArticle Metafields9 fields1 relationshipArticles15 fields2 relationshipsBlog Metafields9 fields1 relationshipBlogs6 fields2 relationshipsCollection Metafields9 fields1 relationshipCollections10 fields1 relationshipCustomer Metafields9 fields1 relationshipCustomers22 fields3 relationshipsDiscount Codes12 fields0 relationshipsFulfillment Orders11 fields2 relationshipsInventory Items9 fields1 relationshipLocation Metafields9 fields1 relationshipLocations19 fields2 relationshipsOrder Metafields9 fields1 relationshipOrders47 fields4 relationshipsPage Metafields9 fields1 relationshipPages10 fields1 relationshipProduct Metafields9 fields1 relationshipProduct Variant Metaf…9 fields1 relationshipProduct Variants18 fields3 relationshipsProducts21 fields2 relationshipsShop20 fields1 relationshipShop Metafields9 fields1 relationshipTender Transactions7 fields1 relationship

Orders is the centre of the Shopify model, and every revenue question starts there.

  1. Its customerId points to Customers; Tender Transactions, Fulfillment Orders and Order Metafields point back to it on the order id.
  2. Products hold the catalog and Product Variants the sellable units: each variant names its product and, one to one, the Inventory Item behind its SKU.
  3. Fulfillment Orders also name the Locations they ship from, and Abandoned Checkouts record checkouts a customer started and did not complete.
  4. Blogs, Articles and Pages hold the store's content, and ten metafield tables, one for each kind of owner, carry the custom fields that apps and merchants add, joining on ownerId.
  5. Ids are Shopify global IDs, strings that begin with gid:// and name the object, not numbers.
  6. What has no column of its own, such as line items, refunds and discount codes, stays as JSON text to unnest in SQL.
How the tables join (18)

Land the tables in your data warehouse, then import the model as Data Marts so these joins become the definition every report shares.

Explore on canvas →Import this model

Why OWOX

Shopify revenue you can check against your books

Revenue questions about a Shopify store rarely stop at Shopify: finance wants the payments to match the books, and marketing wants the orders next to what the ads cost. Loading the store into your data warehouse puts its orders, payments and refunds on the same side of a join as QuickBooks and your ad platforms.

  • Payments you can reconcile. Tender Transactions record each movement of money with its currency, a remote payment reference and a flag for test transactions. Set them against the orders, and against your books on whatever reference the two sides share.
  • Orders next to ad spend. Orders, with their source and customer, sit in the same data warehouse as the Facebook Ads, Google Ads and TikTok Ads data OWOX loads. Match them by day, using the store's time zone from the Shop table, and spend per day beside orders per day is one query.
  • Custom fields as rows. A metafield attached to a product or an order arrives as a row in its owner's metafield table, ready to join on ownerId; the connector reads the first 250 metafields of each owner.
  • Nested data, labelled. The Admin GraphQL API returns nested objects. The model shows which become tables of their own and which stay as JSON text, so you know what to unnest and where.
  • Prices live on variants. The product row holds only the lowest and highest price, so price questions start at Product Variants, and the model draws the way from a product to its variants and their SKUs.

Endpoints

Shopify Endpoints

Documentation

25 Shopify endpoints you can import. Each lands in its own table in your data warehouse.

Abandoned Checkouts schema

Shopify Abandoned Checkouts schema

20 fieldsTime seriesSchema on GitHubshopify_abandoned_checkouts

Checkout sessions that did not complete — customer info, items, and pricing for recovery campaigns.

Questions this table answers

  • How many checkouts were abandoned each week, and what was their total value?
  • Which countries have the most abandoned checkouts?
  • How many abandoned checkouts belong to customers who have ordered before?
Shopify Abandoned Checkouts fields
FieldTypeDescription
idPKSTRINGA globally-unique ID for the abandoned checkout.
abandonedCheckoutUrlSTRINGThe URL for the buyer to recover their checkout.
completedAtTIMESTAMPThe date and time when the checkout was completed.
createdAtTIMESTAMPThe date and time when the checkout was created.
updatedAtTIMESTAMPThe date and time when the checkout was last updated.
defaultCursorSTRINGA default cursor that returns the single next record, sorted ascending by ID.
lineItemsQuantityINTEGERThe total number of line items in the checkout.
totalPriceSetSTRINGThe total price of the checkout including taxes, discounts, and shipping (MoneyBag as JSON string).
billingAddressCitySTRINGCity from the billing address.
billingAddressCountrySTRINGCountry from the billing address.
billingAddressProvinceSTRINGProvince or state from the billing address.
billingAddressZipSTRINGPostal/ZIP code from the billing address.
shippingAddressCitySTRINGCity from the shipping address.
shippingAddressCountrySTRINGCountry from the shipping address.
shippingAddressProvinceSTRINGProvince or state from the shipping address.
shippingAddressZipSTRINGPostal/ZIP code from the shipping address.
customerIdSTRINGCustomer globally-unique ID.
customerFirstNameSTRINGCustomer first name.
customerLastNameSTRINGCustomer last name.
customerEmailSTRINGCustomer email address.

Article Metafields schema

Shopify Article Metafields schema

9 fieldsSchema on GitHubshopify_metafield_articles

Custom metadata attached to articles — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on articles, and how many rows does each have?
  • Which articles have a given metafield set, and to what value?
Shopify Article Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Articles schema

Shopify Articles schema

15 fieldsSchema on GitHubshopify_articles

Blog articles — title, author, publication status, and timestamps.

Questions this table answers

  • How many articles were published per blog and month?
  • Which authors wrote the most articles?
  • Which articles are still unpublished, and since when?
Shopify Articles fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
titleSTRINGThe title of the article.
handleSTRINGA unique, human-friendly string for the article URL.
bodySTRINGThe text of the article body, complete with HTML markup.
summarySTRINGA summary of the article, which can include HTML markup.
authorNameSTRINGThe name of the author of the article.
blogIdSTRINGThe ID of the blog containing the article.
blogTitleSTRINGThe title of the blog containing the article.
isPublishedBOOLEANWhether or not the article is visible.
publishedAtTIMESTAMPThe date and time when the article became or will become visible.
tagsSTRINGA comma-separated list of tags.
templateSuffixSTRINGThe name of the template the article is using.
imageUrlSTRINGThe URL of the image associated with the article.
createdAtTIMESTAMPThe date and time when the article was created.
updatedAtTIMESTAMPThe date and time when the article was last updated.

Blog Metafields schema

Shopify Blog Metafields schema

9 fieldsSchema on GitHubshopify_metafield_blogs

Custom metadata attached to blogs — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on blogs, and how many rows does each have?
  • Which blogs have a given metafield set, and to what value?
Shopify Blog Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Blogs schema

Shopify Blogs schema

6 fieldsSchema on GitHubshopify_blogs

Blogs in the store — title, handle, and template settings.

Questions this table answers

  • How many blogs does the store have, and when was each last updated?
  • Which blogs use a custom template?
  • Which blog was created first?
Shopify Blogs fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
titleSTRINGThe title of the blog.
handleSTRINGA unique, human-friendly string for the blog URL.
templateSuffixSTRINGThe name of the template the blog is using.
createdAtTIMESTAMPThe date and time when the blog was created.
updatedAtTIMESTAMPThe date and time when the blog was last updated.

Collection Metafields schema

Shopify Collection Metafields schema

9 fieldsSchema on GitHubshopify_metafield_collections

Custom metadata attached to collections — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on collections, and how many rows does each have?
  • Which collections have a given metafield set, and to what value?
Shopify Collection Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Collections schema

Shopify Collections schema

10 fieldsSchema on GitHubshopify_collections

Product collections — title, sort order, product count, and last updated.

Questions this table answers

  • Which collections hold the most products?
  • Which collections were updated most recently?
  • How are collections sorted, and how many use each sort order?
Shopify Collections fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
titleSTRINGThe title of the collection.
handleSTRINGA unique, human-friendly string for the collection URL.
descriptionSTRINGThe description of the collection, including any HTML tags and formatting.
descriptionHtmlSTRINGThe description of the collection in HTML format.
sortOrderSTRINGThe order in which the products in the collection are displayed.
templateSuffixSTRINGThe name of the template the collection is using.
productsCountINTEGERThe number of products in the collection.
imageUrlSTRINGThe URL of the image associated with the collection.
updatedAtTIMESTAMPThe date and time when the collection was last updated.

Customer Metafields schema

Shopify Customer Metafields schema

9 fieldsSchema on GitHubshopify_metafield_customers

Custom metadata attached to customers — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on customers, and how many rows does each have?
  • Which customers have a given metafield set, and to what value?
Shopify Customer Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Customers schema

Shopify Customers schema

22 fieldsTime seriesSchema on GitHubshopify_customers

Customer accounts — contact info, marketing consent, order history, and lifetime spend.

Questions this table answers

  • How many customers placed one order, two orders, or more, and what did each group spend?
  • Which countries do customers with email marketing consent live in?
  • How many customers were created each month, and how many of them have ordered?
Shopify Customers fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
firstNameSTRINGThe customer first name.
lastNameSTRINGThe customer last name.
displayNameSTRINGThe full name of the customer.
emailSTRINGThe customer email address.
phoneSTRINGThe customer phone number.
stateSTRINGThe state of the customer account.
localeSTRINGThe customer locale.
taxExemptBOOLEANWhether the customer is exempt from being charged taxes.
verifiedEmailBOOLEANWhether the customer has verified their email.
emailMarketingConsentStateSTRINGThe current email marketing state for the customer.
smsMarketingConsentStateSTRINGThe current SMS marketing state for the customer.
numberOfOrdersINTEGERThe number of orders associated with this customer.
amountSpentSTRINGThe total amount spent by the customer (JSON string with amount and currencyCode).
tagsSTRINGA comma-separated list of tags associated with the customer.
noteSTRINGA note about the customer.
defaultAddressCitySTRINGCity from the default address.
defaultAddressCountrySTRINGCountry from the default address.
defaultAddressProvinceSTRINGProvince from the default address.
defaultAddressZipSTRINGPostal/ZIP code from the default address.
createdAtTIMESTAMPThe date and time when the customer was created.
updatedAtTIMESTAMPThe date and time when the customer was last updated.

Discount Codes schema

Shopify Discount Codes schema

12 fieldsSchema on GitHubshopify_discount_codes

Discount codes — type, status, usage limits, and validity window.

Questions this table answers

  • Which discount codes are active now, and which expire this month?
  • How many codes of each discount type exist?
  • Which codes are close to their usage limit?
Shopify Discount Codes fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
codeSTRINGThe discount code string.
discountTypeSTRINGThe type of discount (DiscountCodeBasic, DiscountCodeBxgy, DiscountCodeFreeShipping).
titleSTRINGThe title of the discount.
statusSTRINGThe status of the discount.
startsAtTIMESTAMPThe date and time when the discount becomes active.
endsAtTIMESTAMPThe date and time when the discount expires.
usageLimitINTEGERThe maximum number of times the discount can be used.
appliesOncePerCustomerBOOLEANWhether the discount can only be used once per customer.
asyncUsageCountINTEGERThe number of times the discount has been used.
createdAtTIMESTAMPThe date and time when the discount was created.
updatedAtTIMESTAMPThe date and time when the discount was last updated.

Fulfillment Orders schema

Shopify Fulfillment Orders schema

11 fieldsSchema on GitHubshopify_fulfillment_orders

Fulfillment orders — items to ship, assigned location, delivery method, and status.

Questions this table answers

  • How many fulfillment orders are open, in progress or closed, and which locations hold the open ones?
  • How long do fulfillment orders take from creation to closing, per location?
  • Which orders were split into more than one fulfillment order?
Shopify Fulfillment Orders fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
statusSTRINGThe status of the fulfillment order.
requestStatusSTRINGThe request status of the fulfillment order.
orderIdSTRINGThe ID of the order associated with this fulfillment order.
orderNameSTRINGThe name of the order.
assignedLocationIdSTRINGThe ID of the location assigned to fulfill this order.
assignedLocationNameSTRINGThe name of the assigned location.
fulfillAtTIMESTAMPThe date and time at which the fulfillment order will be ready to be fulfilled.
deliveryMethodSTRINGThe delivery method of the fulfillment order.
createdAtTIMESTAMPThe date and time when the fulfillment order was created.
updatedAtTIMESTAMPThe date and time when the fulfillment order was last updated.

Inventory Items schema

Shopify Inventory Items schema

9 fieldsSchema on GitHubshopify_inventory_items

Inventory items (SKUs) — tracking status, shipping requirements, and country of origin.

Questions this table answers

  • Which inventory items are not tracked, and which of them require shipping?
  • Which countries of origin appear most often across inventory items?
  • Which items have no harmonized system code?
Shopify Inventory Items fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
skuSTRINGThe unique SKU (stock keeping unit) of the inventory item.
trackedBOOLEANWhether inventory levels are tracked for the item.
requiresShippingBOOLEANWhether the item requires shipping.
harmonizedSystemCodeSTRINGThe harmonized system code of the item.
countryCodeOfOriginSTRINGThe ISO 3166-1 alpha-2 country code of where the item originated from.
variantIdSTRINGThe ID of the variant associated with this inventory item.
createdAtTIMESTAMPThe date and time when the inventory item was created.
updatedAtTIMESTAMPThe date and time when the inventory item was last updated.

Location Metafields schema

Shopify Location Metafields schema

9 fieldsSchema on GitHubshopify_metafield_locations

Custom metadata attached to locations — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on locations, and how many rows does each have?
  • Which locations have a given metafield set, and to what value?
Shopify Location Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Locations schema

Shopify Locations schema

19 fieldsSchema on GitHubshopify_locations

Physical and virtual store locations — activity status, fulfillment capabilities, and address.

Questions this table answers

  • Which locations are active and fulfill online orders?
  • Which locations hold active inventory but do not ship it?
  • How many locations are there per country?
Shopify Locations fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
nameSTRINGThe name of the location.
isActiveBOOLEANWhether the location is active.
isPrimaryBOOLEANWhether the location is the primary location.
isFulfillmentServiceBOOLEANWhether the location is a fulfillment service location.
fulfillsOnlineOrdersBOOLEANWhether the location can fulfill online orders.
hasActiveInventoryBOOLEANWhether the location has active inventory.
shipsInventoryBOOLEANWhether the location ships inventory.
addressLine1STRINGThe first line of the address.
addressLine2STRINGThe second line of the address.
citySTRINGThe city of the location.
provinceSTRINGThe province or state of the location.
provinceCodeSTRINGThe province or state code.
countrySTRINGThe country of the location.
countryCodeSTRINGThe country code of the location.
zipSTRINGThe postal or ZIP code.
phoneSTRINGThe phone number of the location.
createdAtTIMESTAMPThe date and time when the location was created.
updatedAtTIMESTAMPThe date and time when the location was last updated.

Order Metafields schema

Shopify Order Metafields schema

9 fieldsSchema on GitHubshopify_metafield_orders

Custom metadata attached to orders — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on orders, and how many rows does each have?
  • Which orders have a given metafield set, and to what value?
Shopify Order Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Orders schema

Shopify Orders schema

96 fieldsTime seriesSchema on GitHubshopify_orders

Orders placed in the store — financial and fulfillment status, customer info, totals, and timestamps.

Questions this table answers

  • What were net sales, tax and shipping per month, and how much of it was refunded?
  • Which discount codes brought in the most revenue, and what share of orders used one?
  • How many orders sit in each financial and fulfillment status, and how old is the oldest unfulfilled one?
Shopify Orders fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
nameSTRINGThe order name, generated by combining the order_number with the shop order prefix.
emailSTRINGThe email address of the customer.
phoneSTRINGThe phone number of the customer.
displayFinancialStatusSTRINGThe financial status of the order.
displayFulfillmentStatusSTRINGThe fulfillment status of the order.
confirmedBOOLEANWhether the order is confirmed.
closedBOOLEANWhether the order is closed.
cancelledAtTIMESTAMPThe date and time when the order was cancelled.
cancelReasonSTRINGThe reason for cancellation.
currencyCodeSTRINGThe currency of the order.
subtotalPriceNUMBERThe subtotal price of the order.
totalPriceNUMBERThe total price of the order.
totalTaxNUMBERThe total tax of the order.
totalShippingPriceNUMBERThe total shipping price.
totalDiscountsNUMBERThe total discounts applied.
discountCodesSTRINGDiscount codes applied to the order as JSON array (code, amount, type).
discountApplicationsSTRINGAll discount applications (codes, automatic, manual, script) as JSON array, ordered by index. Shipping discounts allocate to shipping lines, not to lineItems discountAllocations.
totalRefundedNUMBERThe total amount refunded.
totalOutstandingNUMBERThe total amount not yet transacted for the order.
totalWeightNUMBERThe total weight of the order.
fullyPaidBOOLEANWhether the order is fully paid.
taxesIncludedBOOLEANWhether taxes are included in the order subtotal.
taxExemptBOOLEANWhether the order is tax exempt.
customerIdSTRINGThe ID of the customer.
customerEmailSTRINGThe email of the customer.
shippingAddressCitySTRINGCity from the shipping address.
shippingAddressCountrySTRINGCountry from the shipping address.
shippingAddressProvinceSTRINGProvince from the shipping address.
shippingAddressZipSTRINGPostal/ZIP code from the shipping address.
billingAddressCitySTRINGCity from the billing address.
billingAddressCountrySTRINGCountry from the billing address.
billingAddressProvinceSTRINGProvince from the billing address.
billingAddressZipSTRINGPostal/ZIP code from the billing address.
tagsSTRINGA comma-separated list of tags.
noteSTRINGThe note attached to the order.
sourceNameSTRINGThe source of the order.
checkoutTokenSTRINGToken of the checkout that created the order. Useful for correlating the order with Web Pixel checkout events. NULL when no checkout is associated.
cartTokenSTRINGToken of the cart that was used to create the order. NULL when no cart is associated.
processedAtTIMESTAMPThe date and time when the order was processed.
closedAtTIMESTAMPThe date and time when the order was closed.
createdAtTIMESTAMPThe date and time when the order was created.
updatedAtTIMESTAMPThe date and time when the order was last updated.
customerSTRINGFull customer object as JSON (id, email, phone, defaultAddress).
currentTotalDiscountsNUMBERThe current total discounts (after edits).
currentTotalTaxNUMBERThe current total tax (after edits).
numberINTEGERThe order number used to generate the order name (with the shop's order number prefix/suffix). Not guaranteed to be unique.
confirmationNumberSTRINGA customer-facing order identifier, shown in some surfaces instead of the sequential order name. Not guaranteed to be unique.
legacyResourceIdSTRINGThe ID of the corresponding resource in the REST Admin API.
testBOOLEANWhether the order was placed in test mode.
editedBOOLEANWhether the order has had any edits applied after creation.
originalTotalPriceNUMBERThe total price of the order at the time it was created.
currentTotalPriceNUMBERThe total price of the order, after returns.
netPaymentNUMBERThe net payment for the order (total received minus total refunded).
totalReceivedNUMBERThe total amount received from the customer before returns.
totalCapturableNUMBERThe authorized amount that hasn't been captured yet.
totalTipReceivedNUMBERThe sum of all tip amounts for the order.
currentSubtotalPriceNUMBERThe subtotal price of the order, after returns and refunds.
cartDiscountAmountNUMBERThe total order-level (cart) discount amount applied at the time the order was created. Does not include line-level discounts.
currentCartDiscountAmountNUMBERThe current order-level (cart) discount amount after returns, refunds, order edits and cancellations. Does not include line-level discounts.
currentShippingPriceNUMBERThe current shipping price, after refunds and discounts.
totalRefundedShippingNUMBERThe total amount of shipping that was refunded.
currentTotalDutiesNUMBERThe current total import duties for the order, after returns or modifications.
originalTotalDutiesNUMBERThe total import duties calculated when the order was created.
currentTotalAdditionalFeesNUMBERThe current total of all additional fees for the order.
originalTotalAdditionalFeesNUMBERThe total of all additional fees calculated when the order was created.
refundDiscrepancyNUMBERThe difference between the suggested and the actual refunded amount. Positive values favor the merchant, negative values favor the customer.
presentmentCurrencyCodeSTRINGThe currency the customer used when placing the order. Amount fields in this table are in the shop currency (currencyCode).
unpaidBOOLEANWhether no payments have been made for the order.
refundableBOOLEANWhether the order can be refunded based on its payment transactions.
capturableBOOLEANWhether an authorized payment on the order can be captured.
canMarkAsPaidBOOLEANWhether the order can be manually marked as paid.
paymentGatewayNamesSTRINGThe names of all payment gateways used for the order, comma-separated.
estimatedTaxesBOOLEANWhether taxes on the order are estimated.
fulfillableBOOLEANWhether the order has any line items that can be fulfilled.
requiresShippingBOOLEANWhether the order requires physical shipping.
subtotalLineItemsQuantityINTEGERThe sum of quantities for all line items contributing to the subtotal.
currentSubtotalLineItemsQuantityINTEGERThe current sum of quantities for all line items contributing to the subtotal, after returns.
currentTotalWeightNUMBERThe total weight of the order in grams, after returns and refunds.
restockableBOOLEANWhether any line items on the order can be restocked into inventory.
canNotifyCustomerBOOLEANWhether order notifications can be sent to the customer.
statusPageUrlSTRINGThe URL where the customer can check the order's current status.
hasTimelineCommentBOOLEANWhether the merchant added a timeline comment to the order.
merchantEditableBOOLEANWhether the order can be edited by the merchant.
merchantEditableErrorsSTRINGReasons why the order can't be edited, comma-separated. Empty when the order is editable.
dutiesIncludedBOOLEANWhether duties are included in the subtotal price of the order.
poNumberSTRINGThe purchase order number associated with the order.
sourceIdentifierSTRINGA unique POS or third-party order identifier.
registeredSourceUrlSTRINGThe URL of the source the order originated from.
productNetworkBOOLEANWhether the customer purchased items from other stores in the same network.
customerAcceptsMarketingBOOLEANWhether the customer agreed to receive marketing emails at the time of purchase.
customerLocaleSTRINGThe customer's language and region preference at the time of purchase.
billingAddressMatchesShippingAddressBOOLEANWhether the billing address matches the shipping address. False when either address is missing.
lineItemsSTRINGThe line items in the order as JSON array, with discount amounts and per-discount allocations (discountAllocations; join to discountApplications by index). See the connector guide for how the amounts differ.
shippingLinesSTRINGShipping lines as JSON array.
refundsSTRINGRefunds as JSON array.

Page Metafields schema

Shopify Page Metafields schema

9 fieldsSchema on GitHubshopify_metafield_pages

Custom metadata attached to pages — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on pages, and how many rows does each have?
  • Which pages have a given metafield set, and to what value?
Shopify Page Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Pages schema

Shopify Pages schema

10 fieldsSchema on GitHubshopify_pages

Static store pages — title, handle, publication status, and timestamps.

Questions this table answers

  • Which pages are unpublished?
  • Which pages changed most recently?
  • How many pages use a custom template?
Shopify Pages fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
titleSTRINGThe title of the page.
handleSTRINGA unique, human-friendly string for the page URL.
bodySTRINGThe body content of the page.
bodySummarySTRINGA summary of the body content.
isPublishedBOOLEANWhether the page is published.
templateSuffixSTRINGThe name of the template the page is using.
publishedAtTIMESTAMPThe date and time when the page was published.
createdAtTIMESTAMPThe date and time when the page was created.
updatedAtTIMESTAMPThe date and time when the page was last updated.

Product Metafields schema

Shopify Product Metafields schema

9 fieldsSchema on GitHubshopify_metafield_products

Custom metadata attached to products — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on products, and how many rows does each have?
  • Which products have a given metafield set, and to what value?
Shopify Product Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Product Variant Metafields schema

Shopify Product Variant Metafields schema

9 fieldsSchema on GitHubshopify_metafield_product_variants

Custom metadata attached to product variants — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on product variants, and how many rows does each have?
  • Which product variants have a given metafield set, and to what value?
Shopify Product Variant Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Product Variants schema

Shopify Product Variants schema

18 fieldsSchema on GitHubshopify_product_variants

Product variants — SKU, price, inventory quantity, and availability.

Questions this table answers

  • How many variants does each product have, and what is the price spread inside a product?
  • Which variants are available for sale but have zero inventory quantity?
  • Which variants are priced below their compare-at price, and by how much?
Shopify Product Variants fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
titleSTRINGThe title of the variant.
displayNameSTRINGThe display name of the variant.
skuSTRINGThe SKU of the variant.
barcodeSTRINGThe barcode of the variant.
priceNUMBERThe price of the variant.
compareAtPriceNUMBERThe compare at price of the variant.
positionINTEGERThe position of the variant in the list.
inventoryQuantityINTEGERThe total inventory quantity.
inventoryPolicySTRINGThe inventory policy.
inventoryItemIdSTRINGThe ID of the inventory item.
productIdSTRINGThe ID of the product.
productTitleSTRINGThe title of the product.
taxableBOOLEANWhether the variant is taxable.
taxCodeSTRINGThe tax code.
availableForSaleBOOLEANWhether the variant is available for sale.
createdAtTIMESTAMPThe date and time when the variant was created.
updatedAtTIMESTAMPThe date and time when the variant was last updated.

Products schema

Shopify Products schema

21 fieldsTime seriesSchema on GitHubshopify_products

Products in the store catalog — vendor, type, status, inventory, and price range.

Questions this table answers

  • Which vendors and product types have the most active products?
  • Which active products have no inventory left?
  • How many products were published each month, and which are still drafts?
Shopify Products fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
titleSTRINGThe title of the product.
handleSTRINGA unique, human-friendly string for the product URL.
descriptionSTRINGThe description of the product.
descriptionHtmlSTRINGThe description of the product in HTML format.
vendorSTRINGThe name of the product vendor.
productTypeSTRINGThe product type.
statusSTRINGThe status of the product.
tagsSTRINGA comma-separated list of tags.
templateSuffixSTRINGThe name of the template the product is using.
totalInventoryINTEGERThe total inventory across all variants.
variantsCountINTEGERThe number of variants.
featuredImageUrlSTRINGThe URL of the featured image.
priceRangeMinAmountNUMBERThe minimum price of the product.
priceRangeMaxAmountNUMBERThe maximum price of the product.
seoTitleSTRINGThe SEO title.
seoDescriptionSTRINGThe SEO description.
onlineStoreUrlSTRINGThe URL of the product on the online store.
publishedAtTIMESTAMPThe date and time when the product was published.
createdAtTIMESTAMPThe date and time when the product was created.
updatedAtTIMESTAMPThe date and time when the product was last updated.

Shop schema

Shopify Shop schema

20 fieldsSchema on GitHubshopify_shop

Store settings — domain, currency, timezone, and plan details.

Questions this table answers

  • Which currency, time zone and plan is the store set up with?
  • Are taxes included in prices, and is shipping taxed?
  • What is the store's primary domain and billing country?
Shopify Shop fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
nameSTRINGThe name of the shop.
emailSTRINGThe email address of the shop.
myshopifyDomainSTRINGThe myshopify.com domain of the shop.
primaryDomainSTRINGThe primary domain of the shop.
currencyCodeSTRINGThe currency code of the shop.
timezoneAbbreviationSTRINGThe timezone abbreviation.
ianaTimezoneSTRINGThe IANA timezone.
weightUnitSTRINGThe default weight unit.
billingAddressCitySTRINGCity from the billing address.
billingAddressCountrySTRINGCountry from the billing address.
billingAddressProvinceSTRINGProvince from the billing address.
billingAddressZipSTRINGPostal/ZIP code from the billing address.
planSTRINGThe shop plan name.
contactEmailSTRINGThe contact email of the shop.
customerAccountsV2STRINGThe customer accounts version.
taxesIncludedBOOLEANWhether taxes are included in prices.
taxShippingBOOLEANWhether shipping is taxed.
createdAtTIMESTAMPThe date and time when the shop was created.
updatedAtTIMESTAMPThe date and time when the shop was last updated.

Shop Metafields schema

Shopify Shop Metafields schema

9 fieldsSchema on GitHubshopify_metafield_shops

Custom metadata attached to the shop — namespace, key, value, and type.

Questions this table answers

  • Which metafield namespaces and keys exist on the shop, and how many rows does each have?
  • What values do the shop's metafields hold, by namespace and key?
Shopify Shop Metafields fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
namespaceSTRINGThe namespace of the metafield.
keySTRINGThe key of the metafield.
valueSTRINGThe value of the metafield.
typeSTRINGThe type of the metafield.
ownerIdSTRINGThe ID of the owner resource.
ownerTypeSTRINGThe type of the owner resource.
createdAtTIMESTAMPThe date and time when the metafield was created.
updatedAtTIMESTAMPThe date and time when the metafield was last updated.

Tender Transactions schema

Shopify Tender Transactions schema

7 fieldsSchema on GitHubshopify_tender_transactions

Payment tender transactions — amount, currency, order reference, and processing time.

Questions this table answers

  • How much money moved per day, by currency, excluding test transactions?
  • Which orders have no tender transaction?
  • How many test transactions are mixed into the data?
Shopify Tender Transactions fields
FieldTypeDescription
idPKSTRINGA globally-unique ID.
amountNUMBERThe amount of the tender transaction.
currencyCodeSTRINGThe currency code.
remoteReferenceSTRINGThe remote gateway reference.
testBOOLEANWhether the transaction is a test transaction.
orderIdSTRINGThe ID of the order.
processedAtTIMESTAMPThe date and time when the transaction was processed.

What Shopify data answers

What Shopify data answers

Across the tables

  • How do orders, refunds and discounts add up to net sales per month and per customer?
  • Which customers placed repeat orders, and which started a checkout they never finished?
  • Which products and variants sell, and what stock record and location stand behind them?

Industry data models that use Shopify

Where Shopify data goes

Recent updates

Other data sources

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers