Connector

Shopify Connector to Microsoft Excel

Own your Shopify data in Microsoft Excel with OWOX Data Marts. Collect granular, analytics-ready Shopify data, control schema and refresh logic, and reuse it across Microsoft Excel and AI Insights.

Get started free

Endpoints

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 seriesshopify_abandoned_checkouts
Article Metafields
Custom metadata attached to articles — namespace, key, value, and type.
9 fieldsshopify_metafield_articles
Articles
Blog articles — title, author, publication status, and timestamps.
15 fieldsshopify_articles
Blog Metafields
Custom metadata attached to blogs — namespace, key, value, and type.
9 fieldsshopify_metafield_blogs
Blogs
Blogs in the store — title, handle, and template settings.
6 fieldsshopify_blogs
Collection Metafields
Custom metadata attached to collections — namespace, key, value, and type.
9 fieldsshopify_metafield_collections
Collections
Product collections — title, sort order, product count, and last updated.
10 fieldsshopify_collections
Customer Metafields
Custom metadata attached to customers — namespace, key, value, and type.
9 fieldsshopify_metafield_customers
Customers
Customer accounts — contact info, marketing consent, order history, and lifetime spend.
22 fieldsTime seriesshopify_customers
Discount Codes
Discount codes — type, status, usage limits, and validity window.
12 fieldsshopify_discount_codes
Fulfillment Orders
Fulfillment orders — items to ship, assigned location, delivery method, and status.
11 fieldsshopify_fulfillment_orders
Inventory Items
Inventory items (SKUs) — tracking status, shipping requirements, and country of origin.
9 fieldsshopify_inventory_items
Location Metafields
Custom metadata attached to locations — namespace, key, value, and type.
9 fieldsshopify_metafield_locations
Locations
Physical and virtual store locations — activity status, fulfillment capabilities, and address.
19 fieldsshopify_locations
Order Metafields
Custom metadata attached to orders — namespace, key, value, and type.
9 fieldsshopify_metafield_orders
Orders
Orders placed in the store — financial and fulfillment status, customer info, totals, and timestamps.
47 fieldsTime seriesshopify_orders
Page Metafields
Custom metadata attached to pages — namespace, key, value, and type.
9 fieldsshopify_metafield_pages
Pages
Static store pages — title, handle, publication status, and timestamps.
10 fieldsshopify_pages
Product Metafields
Custom metadata attached to products — namespace, key, value, and type.
9 fieldsshopify_metafield_products
Product Variant Metafields
Custom metadata attached to product variants — namespace, key, value, and type.
9 fieldsshopify_metafield_product_variants
Product Variants
Product variants — SKU, price, inventory quantity, and availability.
18 fieldsshopify_product_variants
Products
Products in the store catalog — vendor, type, status, inventory, and price range.
21 fieldsTime seriesshopify_products
Shop
Store settings — domain, currency, timezone, and plan details.
20 fieldsshopify_shop
Shop Metafields
Custom metadata attached to the shop — namespace, key, value, and type.
9 fieldsshopify_metafield_shops
Tender Transactions
Payment tender transactions — amount, currency, order reference, and processing time.
7 fieldsshopify_tender_transactions

Data schema

Shopify data schema

Abandoned Checkouts 20 fields · shopify_abandoned_checkouts

Shopify Abandoned Checkouts fields
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.

Article Metafields 9 fields · shopify_metafield_articles

Shopify Article Metafields fields
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.

Articles 15 fields · shopify_articles

Shopify Articles fields
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.

Blog Metafields 9 fields · shopify_metafield_blogs

Shopify Blog Metafields fields
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.

Blogs 6 fields · shopify_blogs

Shopify Blogs fields
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.

Collection Metafields 9 fields · shopify_metafield_collections

Shopify Collection Metafields fields
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.

Collections 10 fields · shopify_collections

Shopify Collections fields
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.

Customer Metafields 9 fields · shopify_metafield_customers

Shopify Customer Metafields fields
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.

Customers 22 fields · shopify_customers

Shopify Customers fields
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.

Discount Codes 12 fields · shopify_discount_codes

Shopify Discount Codes fields
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.

Fulfillment Orders 11 fields · shopify_fulfillment_orders

Shopify Fulfillment Orders fields
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.

Inventory Items 9 fields · shopify_inventory_items

Shopify Inventory Items fields
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.

Location Metafields 9 fields · shopify_metafield_locations

Shopify Location Metafields fields
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.

Locations 19 fields · shopify_locations

Shopify Locations fields
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.

Order Metafields 9 fields · shopify_metafield_orders

Shopify Order Metafields fields
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.

Orders 47 fields · shopify_orders

Shopify Orders fields
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.

Page Metafields 9 fields · shopify_metafield_pages

Shopify Page Metafields fields
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.

Pages 10 fields · shopify_pages

Shopify Pages fields
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.

Product Metafields 9 fields · shopify_metafield_products

Shopify Product Metafields fields
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 9 fields · shopify_metafield_product_variants

Shopify Product Variant Metafields fields
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 Variants 18 fields · shopify_product_variants

Shopify Product Variants fields
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.

Products 21 fields · shopify_products

Shopify Products fields
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.

Shop 20 fields · shopify_shop

Shopify Shop fields
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.

Shop Metafields 9 fields · shopify_metafield_shops

Shopify Shop Metafields fields
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.

Tender Transactions 7 fields · shopify_tender_transactions

Shopify Tender Transactions fields
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.

Trust

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

npm installs

156K

In Open Source We Trust

Customers

ArtPix 3D — transparent KPI calculationsasset pending

Avrora — a partner we could trustasset pending

Avrora — clarity and confidence to decide fastasset pending

Avrora — reliable analytics systemasset pending

Avrora — transformed approach to BIasset pending

Better&Stronger — always there to helpasset pending

Better&Stronger — rich educational resourcesasset pending

Domas R. (G2) — data we can actually trustasset pending

Domas R. (G2) — solution to most data challengesasset pending

Hiveon — key metrics built our wayasset pending

Khrystyna G. (G2) — simple tool, amazing supportasset pending

MatahariMall — less time on reportingasset pending

MotionVFX — data quality to predict budgetasset pending

MotionVFX — exceeded our expectationsasset pending

MotionVFX — no decisions without analysisasset pending

MotionVFX — transparency behind every KPIasset pending

ON Clinic — cost per acquisition by serviceasset pending

ON Clinic — data for regional KPIsasset pending

ON Clinic — know AOV by segmentasset pending

QVC — reports in line with business needsasset pending

QVC — totally satisfied with resultasset pending

Retail

Wojciech W. (G2) — accurate data, more revenueasset pending

Wojciech W. (G2) — reliable business partnerasset pending

Wojciech W. (G2) — transparent, honest cooperation termsasset pending

Business & Consumer Services

ZOOD — foundation for years to comeasset pending

What users are saying

Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI

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.”

C9re: one source of truth

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.”

E7re: getting time back

Nodari RizunFounder & CEO, Pürblack®

“We regained time. And time is the one resource that never comes back.”

Turn your Shopify Connector to Microsoft Excel data into business decisions

Get started free