Collect Shopify data. Deliver reports. Automate AI Insights.
Easily collect Shopify data with OWOX Data Marts, store in your data warehouse, automate reporting across major BI Tools and AI Insights (the ones that matter) delivered straight to corporate messengers on a schedule.
Data Partner You Can Trust
users
175K
Executives and data analysts across 20+ industries
G2 rating
4.9★
“A trusted data analytics partner” — verified review
Customers
Available connectors
Shopify endpoints
25 Shopify endpoints you can import. Each lands in its own table in your warehouse.
Abandoned Checkouts
Checkout sessions that did not complete — customer info, items, and pricing for recovery campaigns.
20 fieldsTime seriesArticle Metafields
Custom metadata attached to articles — namespace, key, value, and type.
9 fieldsArticles
Blog articles — title, author, publication status, and timestamps.
15 fieldsBlog Metafields
Custom metadata attached to blogs — namespace, key, value, and type.
9 fieldsBlogs
Blogs in the store — title, handle, and template settings.
6 fieldsCollection Metafields
Custom metadata attached to collections — namespace, key, value, and type.
9 fieldsCollections
Product collections — title, sort order, product count, and last updated.
10 fieldsCustomer Metafields
Custom metadata attached to customers — namespace, key, value, and type.
9 fieldsCustomers
Customer accounts — contact info, marketing consent, order history, and lifetime spend.
22 fieldsTime seriesDiscount Codes
Discount codes — type, status, usage limits, and validity window.
12 fieldsFulfillment Orders
Fulfillment orders — items to ship, assigned location, delivery method, and status.
11 fieldsInventory Items
Inventory items (SKUs) — tracking status, shipping requirements, and country of origin.
9 fieldsLocation Metafields
Custom metadata attached to locations — namespace, key, value, and type.
9 fieldsLocations
Physical and virtual store locations — activity status, fulfillment capabilities, and address.
19 fieldsOrder Metafields
Custom metadata attached to orders — namespace, key, value, and type.
9 fieldsOrders
Orders placed in the store — financial and fulfillment status, customer info, totals, and timestamps.
47 fieldsTime seriesPage Metafields
Custom metadata attached to pages — namespace, key, value, and type.
9 fieldsPages
Static store pages — title, handle, publication status, and timestamps.
10 fieldsProduct Metafields
Custom metadata attached to products — namespace, key, value, and type.
9 fieldsProduct Variant Metafields
Custom metadata attached to product variants — namespace, key, value, and type.
9 fieldsProduct Variants
Product variants — SKU, price, inventory quantity, and availability.
18 fieldsProducts
Products in the store catalog — vendor, type, status, inventory, and price range.
21 fieldsTime seriesShop
Store settings — domain, currency, timezone, and plan details.
20 fieldsShop Metafields
Custom metadata attached to the shop — namespace, key, value, and type.
9 fieldsTender Transactions
Payment tender transactions — amount, currency, order reference, and processing time.
7 fields
Shopify Abandoned Checkouts schema
20 fieldsTime seriesshopify_abandoned_checkoutsSchema on GitHub
Checkout sessions that did not complete — customer info, items, and pricing for recovery campaigns.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID for the abandoned checkout. |
abandonedCheckoutUrl | STRING | The URL for the buyer to recover their checkout. |
completedAt | TIMESTAMP | The date and time when the checkout was completed. |
createdAt | TIMESTAMP | The date and time when the checkout was created. |
updatedAt | TIMESTAMP | The date and time when the checkout was last updated. |
defaultCursor | STRING | A default cursor that returns the single next record, sorted ascending by ID. |
lineItemsQuantity | INTEGER | The total number of line items in the checkout. |
totalPriceSet | STRING | The total price of the checkout including taxes, discounts, and shipping (MoneyBag as JSON string). |
billingAddressCity | STRING | City from the billing address. |
billingAddressCountry | STRING | Country from the billing address. |
billingAddressProvince | STRING | Province or state from the billing address. |
billingAddressZip | STRING | Postal/ZIP code from the billing address. |
shippingAddressCity | STRING | City from the shipping address. |
shippingAddressCountry | STRING | Country from the shipping address. |
shippingAddressProvince | STRING | Province or state from the shipping address. |
shippingAddressZip | STRING | Postal/ZIP code from the shipping address. |
customerId | STRING | Customer globally-unique ID. |
customerFirstName | STRING | Customer first name. |
customerLastName | STRING | Customer last name. |
customerEmail | STRING | Customer email address. |
Shopify Article Metafields schema
9 fieldsshopify_metafield_articlesSchema on GitHub
Custom metadata attached to articles — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Articles schema
15 fieldsshopify_articlesSchema on GitHub
Blog articles — title, author, publication status, and timestamps.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
title | STRING | The title of the article. |
handle | STRING | A unique, human-friendly string for the article URL. |
body | STRING | The text of the article body, complete with HTML markup. |
summary | STRING | A summary of the article, which can include HTML markup. |
authorName | STRING | The name of the author of the article. |
blogId | STRING | The ID of the blog containing the article. |
blogTitle | STRING | The title of the blog containing the article. |
isPublished | BOOLEAN | Whether or not the article is visible. |
publishedAt | TIMESTAMP | The date and time when the article became or will become visible. |
tags | STRING | A comma-separated list of tags. |
templateSuffix | STRING | The name of the template the article is using. |
imageUrl | STRING | The URL of the image associated with the article. |
createdAt | TIMESTAMP | The date and time when the article was created. |
updatedAt | TIMESTAMP | The date and time when the article was last updated. |
Shopify Blog Metafields schema
9 fieldsshopify_metafield_blogsSchema on GitHub
Custom metadata attached to blogs — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Blogs schema
6 fieldsshopify_blogsSchema on GitHub
Blogs in the store — title, handle, and template settings.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
title | STRING | The title of the blog. |
handle | STRING | A unique, human-friendly string for the blog URL. |
templateSuffix | STRING | The name of the template the blog is using. |
createdAt | TIMESTAMP | The date and time when the blog was created. |
updatedAt | TIMESTAMP | The date and time when the blog was last updated. |
Shopify Collection Metafields schema
9 fieldsshopify_metafield_collectionsSchema on GitHub
Custom metadata attached to collections — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Collections schema
10 fieldsshopify_collectionsSchema on GitHub
Product collections — title, sort order, product count, and last updated.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
title | STRING | The title of the collection. |
handle | STRING | A unique, human-friendly string for the collection URL. |
description | STRING | The description of the collection, including any HTML tags and formatting. |
descriptionHtml | STRING | The description of the collection in HTML format. |
sortOrder | STRING | The order in which the products in the collection are displayed. |
templateSuffix | STRING | The name of the template the collection is using. |
productsCount | INTEGER | The number of products in the collection. |
imageUrl | STRING | The URL of the image associated with the collection. |
updatedAt | TIMESTAMP | The date and time when the collection was last updated. |
Shopify Customer Metafields schema
9 fieldsshopify_metafield_customersSchema on GitHub
Custom metadata attached to customers — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Customers schema
22 fieldsTime seriesshopify_customersSchema on GitHub
Customer accounts — contact info, marketing consent, order history, and lifetime spend.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
firstName | STRING | The customer first name. |
lastName | STRING | The customer last name. |
displayName | STRING | The full name of the customer. |
email | STRING | The customer email address. |
phone | STRING | The customer phone number. |
state | STRING | The state of the customer account. |
locale | STRING | The customer locale. |
taxExempt | BOOLEAN | Whether the customer is exempt from being charged taxes. |
verifiedEmail | BOOLEAN | Whether the customer has verified their email. |
emailMarketingConsentState | STRING | The current email marketing state for the customer. |
smsMarketingConsentState | STRING | The current SMS marketing state for the customer. |
numberOfOrders | INTEGER | The number of orders associated with this customer. |
amountSpent | STRING | The total amount spent by the customer (JSON string with amount and currencyCode). |
tags | STRING | A comma-separated list of tags associated with the customer. |
note | STRING | A note about the customer. |
defaultAddressCity | STRING | City from the default address. |
defaultAddressCountry | STRING | Country from the default address. |
defaultAddressProvince | STRING | Province from the default address. |
defaultAddressZip | STRING | Postal/ZIP code from the default address. |
createdAt | TIMESTAMP | The date and time when the customer was created. |
updatedAt | TIMESTAMP | The date and time when the customer was last updated. |
Shopify Discount Codes schema
12 fieldsshopify_discount_codesSchema on GitHub
Discount codes — type, status, usage limits, and validity window.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
code | STRING | The discount code string. |
discountType | STRING | The type of discount (DiscountCodeBasic, DiscountCodeBxgy, DiscountCodeFreeShipping). |
title | STRING | The title of the discount. |
status | STRING | The status of the discount. |
startsAt | TIMESTAMP | The date and time when the discount becomes active. |
endsAt | TIMESTAMP | The date and time when the discount expires. |
usageLimit | INTEGER | The maximum number of times the discount can be used. |
appliesOncePerCustomer | BOOLEAN | Whether the discount can only be used once per customer. |
asyncUsageCount | INTEGER | The number of times the discount has been used. |
createdAt | TIMESTAMP | The date and time when the discount was created. |
updatedAt | TIMESTAMP | The date and time when the discount was last updated. |
Shopify Fulfillment Orders schema
11 fieldsshopify_fulfillment_ordersSchema on GitHub
Fulfillment orders — items to ship, assigned location, delivery method, and status.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
status | STRING | The status of the fulfillment order. |
requestStatus | STRING | The request status of the fulfillment order. |
orderId | STRING | The ID of the order associated with this fulfillment order. |
orderName | STRING | The name of the order. |
assignedLocationId | STRING | The ID of the location assigned to fulfill this order. |
assignedLocationName | STRING | The name of the assigned location. |
fulfillAt | TIMESTAMP | The date and time at which the fulfillment order will be ready to be fulfilled. |
deliveryMethod | STRING | The delivery method of the fulfillment order. |
createdAt | TIMESTAMP | The date and time when the fulfillment order was created. |
updatedAt | TIMESTAMP | The date and time when the fulfillment order was last updated. |
Shopify Inventory Items schema
9 fieldsshopify_inventory_itemsSchema on GitHub
Inventory items (SKUs) — tracking status, shipping requirements, and country of origin.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
sku | STRING | The unique SKU (stock keeping unit) of the inventory item. |
tracked | BOOLEAN | Whether inventory levels are tracked for the item. |
requiresShipping | BOOLEAN | Whether the item requires shipping. |
harmonizedSystemCode | STRING | The harmonized system code of the item. |
countryCodeOfOrigin | STRING | The ISO 3166-1 alpha-2 country code of where the item originated from. |
variantId | STRING | The ID of the variant associated with this inventory item. |
createdAt | TIMESTAMP | The date and time when the inventory item was created. |
updatedAt | TIMESTAMP | The date and time when the inventory item was last updated. |
Shopify Location Metafields schema
9 fieldsshopify_metafield_locationsSchema on GitHub
Custom metadata attached to locations — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Locations schema
19 fieldsshopify_locationsSchema on GitHub
Physical and virtual store locations — activity status, fulfillment capabilities, and address.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
name | STRING | The name of the location. |
isActive | BOOLEAN | Whether the location is active. |
isPrimary | BOOLEAN | Whether the location is the primary location. |
isFulfillmentService | BOOLEAN | Whether the location is a fulfillment service location. |
fulfillsOnlineOrders | BOOLEAN | Whether the location can fulfill online orders. |
hasActiveInventory | BOOLEAN | Whether the location has active inventory. |
shipsInventory | BOOLEAN | Whether the location ships inventory. |
addressLine1 | STRING | The first line of the address. |
addressLine2 | STRING | The second line of the address. |
city | STRING | The city of the location. |
province | STRING | The province or state of the location. |
provinceCode | STRING | The province or state code. |
country | STRING | The country of the location. |
countryCode | STRING | The country code of the location. |
zip | STRING | The postal or ZIP code. |
phone | STRING | The phone number of the location. |
createdAt | TIMESTAMP | The date and time when the location was created. |
updatedAt | TIMESTAMP | The date and time when the location was last updated. |
Shopify Order Metafields schema
9 fieldsshopify_metafield_ordersSchema on GitHub
Custom metadata attached to orders — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Orders schema
47 fieldsTime seriesshopify_ordersSchema on GitHub
Orders placed in the store — financial and fulfillment status, customer info, totals, and timestamps.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
name | STRING | The order name, generated by combining the order_number with the shop order prefix. |
email | STRING | The email address of the customer. |
phone | STRING | The phone number of the customer. |
displayFinancialStatus | STRING | The financial status of the order. |
displayFulfillmentStatus | STRING | The fulfillment status of the order. |
confirmed | BOOLEAN | Whether the order is confirmed. |
closed | BOOLEAN | Whether the order is closed. |
cancelledAt | TIMESTAMP | The date and time when the order was cancelled. |
cancelReason | STRING | The reason for cancellation. |
currencyCode | STRING | The currency of the order. |
subtotalPrice | NUMBER | The subtotal price of the order. |
totalPrice | NUMBER | The total price of the order. |
totalTax | NUMBER | The total tax of the order. |
totalShippingPrice | NUMBER | The total shipping price. |
totalDiscounts | NUMBER | The total discounts applied. |
discountCodes | STRING | Discount codes applied to the order as JSON array (code, amount, type). |
discountApplications | STRING | All discount applications (codes, automatic, manual) as JSON array. |
totalRefunded | NUMBER | The total amount refunded. |
totalOutstanding | NUMBER | The total amount not yet transacted for the order. |
totalWeight | NUMBER | The total weight of the order. |
fullyPaid | BOOLEAN | Whether the order is fully paid. |
taxesIncluded | BOOLEAN | Whether taxes are included in the order subtotal. |
taxExempt | BOOLEAN | Whether the order is tax exempt. |
customerId | STRING | The ID of the customer. |
customerEmail | STRING | The email of the customer. |
shippingAddressCity | STRING | City from the shipping address. |
shippingAddressCountry | STRING | Country from the shipping address. |
shippingAddressProvince | STRING | Province from the shipping address. |
shippingAddressZip | STRING | Postal/ZIP code from the shipping address. |
billingAddressCity | STRING | City from the billing address. |
billingAddressCountry | STRING | Country from the billing address. |
billingAddressProvince | STRING | Province from the billing address. |
billingAddressZip | STRING | Postal/ZIP code from the billing address. |
tags | STRING | A comma-separated list of tags. |
note | STRING | The note attached to the order. |
sourceName | STRING | The source of the order. |
processedAt | TIMESTAMP | The date and time when the order was processed. |
closedAt | TIMESTAMP | The date and time when the order was closed. |
createdAt | TIMESTAMP | The date and time when the order was created. |
updatedAt | TIMESTAMP | The date and time when the order was last updated. |
customer | STRING | Full customer object as JSON (id, email, phone, defaultAddress). |
currentTotalDiscounts | NUMBER | The current total discounts (after edits). |
currentTotalTax | NUMBER | The current total tax (after edits). |
lineItems | STRING | The line items in the order as JSON array. |
shippingLines | STRING | Shipping lines as JSON array. |
refunds | STRING | Refunds as JSON array. |
Shopify Page Metafields schema
9 fieldsshopify_metafield_pagesSchema on GitHub
Custom metadata attached to pages — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Pages schema
10 fieldsshopify_pagesSchema on GitHub
Static store pages — title, handle, publication status, and timestamps.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
title | STRING | The title of the page. |
handle | STRING | A unique, human-friendly string for the page URL. |
body | STRING | The body content of the page. |
bodySummary | STRING | A summary of the body content. |
isPublished | BOOLEAN | Whether the page is published. |
templateSuffix | STRING | The name of the template the page is using. |
publishedAt | TIMESTAMP | The date and time when the page was published. |
createdAt | TIMESTAMP | The date and time when the page was created. |
updatedAt | TIMESTAMP | The date and time when the page was last updated. |
Shopify Product Metafields schema
9 fieldsshopify_metafield_productsSchema on GitHub
Custom metadata attached to products — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Product Variant Metafields schema
Shopify Product Variant Metafields schema
9 fieldsshopify_metafield_product_variantsSchema on GitHub
Custom metadata attached to product variants — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Product Variants schema
18 fieldsshopify_product_variantsSchema on GitHub
Product variants — SKU, price, inventory quantity, and availability.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
title | STRING | The title of the variant. |
displayName | STRING | The display name of the variant. |
sku | STRING | The SKU of the variant. |
barcode | STRING | The barcode of the variant. |
price | NUMBER | The price of the variant. |
compareAtPrice | NUMBER | The compare at price of the variant. |
position | INTEGER | The position of the variant in the list. |
inventoryQuantity | INTEGER | The total inventory quantity. |
inventoryPolicy | STRING | The inventory policy. |
inventoryItemId | STRING | The ID of the inventory item. |
productId | STRING | The ID of the product. |
productTitle | STRING | The title of the product. |
taxable | BOOLEAN | Whether the variant is taxable. |
taxCode | STRING | The tax code. |
availableForSale | BOOLEAN | Whether the variant is available for sale. |
createdAt | TIMESTAMP | The date and time when the variant was created. |
updatedAt | TIMESTAMP | The date and time when the variant was last updated. |
Shopify Products schema
21 fieldsTime seriesshopify_productsSchema on GitHub
Products in the store catalog — vendor, type, status, inventory, and price range.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
title | STRING | The title of the product. |
handle | STRING | A unique, human-friendly string for the product URL. |
description | STRING | The description of the product. |
descriptionHtml | STRING | The description of the product in HTML format. |
vendor | STRING | The name of the product vendor. |
productType | STRING | The product type. |
status | STRING | The status of the product. |
tags | STRING | A comma-separated list of tags. |
templateSuffix | STRING | The name of the template the product is using. |
totalInventory | INTEGER | The total inventory across all variants. |
variantsCount | INTEGER | The number of variants. |
featuredImageUrl | STRING | The URL of the featured image. |
priceRangeMinAmount | NUMBER | The minimum price of the product. |
priceRangeMaxAmount | NUMBER | The maximum price of the product. |
seoTitle | STRING | The SEO title. |
seoDescription | STRING | The SEO description. |
onlineStoreUrl | STRING | The URL of the product on the online store. |
publishedAt | TIMESTAMP | The date and time when the product was published. |
createdAt | TIMESTAMP | The date and time when the product was created. |
updatedAt | TIMESTAMP | The date and time when the product was last updated. |
Shopify Shop schema
20 fieldsshopify_shopSchema on GitHub
Store settings — domain, currency, timezone, and plan details.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
name | STRING | The name of the shop. |
email | STRING | The email address of the shop. |
myshopifyDomain | STRING | The myshopify.com domain of the shop. |
primaryDomain | STRING | The primary domain of the shop. |
currencyCode | STRING | The currency code of the shop. |
timezoneAbbreviation | STRING | The timezone abbreviation. |
ianaTimezone | STRING | The IANA timezone. |
weightUnit | STRING | The default weight unit. |
billingAddressCity | STRING | City from the billing address. |
billingAddressCountry | STRING | Country from the billing address. |
billingAddressProvince | STRING | Province from the billing address. |
billingAddressZip | STRING | Postal/ZIP code from the billing address. |
plan | STRING | The shop plan name. |
contactEmail | STRING | The contact email of the shop. |
customerAccountsV2 | STRING | The customer accounts version. |
taxesIncluded | BOOLEAN | Whether taxes are included in prices. |
taxShipping | BOOLEAN | Whether shipping is taxed. |
createdAt | TIMESTAMP | The date and time when the shop was created. |
updatedAt | TIMESTAMP | The date and time when the shop was last updated. |
Shopify Shop Metafields schema
9 fieldsshopify_metafield_shopsSchema on GitHub
Custom metadata attached to the shop — namespace, key, value, and type.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
namespace | STRING | The namespace of the metafield. |
key | STRING | The key of the metafield. |
value | STRING | The value of the metafield. |
type | STRING | The type of the metafield. |
ownerId | STRING | The ID of the owner resource. |
ownerType | STRING | The type of the owner resource. |
createdAt | TIMESTAMP | The date and time when the metafield was created. |
updatedAt | TIMESTAMP | The date and time when the metafield was last updated. |
Shopify Tender Transactions schema
7 fieldsshopify_tender_transactionsSchema on GitHub
Payment tender transactions — amount, currency, order reference, and processing time.
| Field | Type | Description |
|---|---|---|
id | STRING | A globally-unique ID. |
amount | NUMBER | The amount of the tender transaction. |
currencyCode | STRING | The currency code. |
remoteReference | STRING | The remote gateway reference. |
test | BOOLEAN | Whether the transaction is a test transaction. |
orderId | STRING | The ID of the order. |
processedAt | TIMESTAMP | The date and time when the transaction was processed. |
Why collect Shopify data into your warehouse with OWOX?
Your Shopify data shouldn’t be trapped in a platform you can’t query. OWOX collects it into your warehouse on autopilot — no per-connector fees, no vendor lock-in. The entire platform is open-source on GitHub, so you can self-host it today and never worry about losing access to your own data pipelines.
Collect to your warehouse
No per-connector pricing — connect as many sources as you need, all included
Zero-maintenance syncs
Fully open-source on GitHub — self-host anytime, no vendor lock-in, your data stays yours
Full-funnel joins
Full transparency and control — every query, every schema, every schedule is visible and auditable
R01 · Collect
Collect all your Shopify data with zero engineering
Pull everything your company needs from Shopify without touching code or maintaining custom scripts. OWOX Data Marts handle the heavy lifting.
- Your Shopify data is stored in one place – your own infrastructure. OWOX Data Marts automatically land your data into BigQuery, Snowflake, or Redshift.
- Your Shopify data lands on a schedule: clean, complete, and ready to re-use across reports, dashboards, BI tools, and spreadsheets.
- No API maintenance, no broken scripts — just reliable daily syncs
R02 · Report
Build reports with Shopify data that everyone trusts
Once your Shopify data lands in your warehouse, OWOX Data Marts make it instantly reusable across spreadsheets and BI tools.
- Pre-built data marts for e-commerce revenue, orders, and product performance
- Join Shopify with ad platforms, CRM, and financial data in one query
- Self-serve reporting for marketing teams — no analyst tickets needed
R03 · Visualize
Visualize Shopify data instantly in your BI tools
With OWOX Data Marts, your Shopify data becomes instantly available for charts, dashboards, pivots, and spreadsheets.
- Whether you use Google Sheets, Looker Studio, Excel, or Power BI, OWOX delivers clean, scheduled Shopify data that just works.
- Deliver to Looker Studio, Google Sheets, Power BI, or Excel automatically
- Same numbers everywhere — one source of truth for all stakeholders
Why use OWOX connectors to collect your Shopify data?
Eight outcomes you get the moment your data marts go live.
Full picture, one screen
Send Shopify orders, products, and customers into charts, pivots, and dashboards from one governed source — a comprehensive view of the store you can analyze faster.
Beyond native dashboards
Shopify shows its data one way; in your warehouse you slice orders, refunds, and cohorts however the business needs — for deeper, revenue-level insight.
Your questions, your reports
Build reports that answer your questions — margin by product, repeat-purchase rate, campaign payback — on your definitions, not Shopify’s defaults.
Faster decisions, better data
With a consolidated view and trusted numbers, your team decides faster — turning Shopify data into true revenue and margin, not gross-sales guesses.
Always fresh, always complete
OWOX Data Marts automate Shopify collection — orders, line items, customers, refunds — on a schedule, cutting manual exports and keeping data complete.
All sources, one warehouse
Merge Shopify with ad spend, CRM, and finance to make ROAS real — revenue and margin by campaign, the join CEOs actually ask for.
Zero manual work
Automate transfer into BigQuery, Snowflake, or Redshift — governed and reusable across every report, saving time and removing copy-paste errors.
Blended reports
Blend Shopify into your wider reporting, then let anyone ask in their own AI chat — “what was margin by product last month?” — every number tracing to analyst-written SQL.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
Nodari RizunFounder & CEO, Pürblack®“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”
Start collecting Shopify data for free
Set up your Shopify connector in minutes. No credit card, no engineering team required.
