Supernova home
Documentation menu

Shopify#

Connect Shopify with a shop domain and Admin API token. The source writes 19 fixed tables under titan.shopify.

sql
select
  id,
  email,
  created_at
from titan.shopify.customers
limit 10

Connect Shopify#

  1. Open Apps, choose Connect app, and select Shopify.

  2. Enter a shop domain and Admin API token.

  3. Review the tables, then save the source.

  4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Shopify data arrives through resumable GraphQL bulk operations. A saved bulk-operation id lets the next run resume rather than begin again.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

customers#

titan.shopify.customers has 17 source columns.

shopify.customers17 columns
idintegerpk

Source field id.

emailstring

Source field email.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

first_namestring

Source field firstName.

last_namestring

Source field lastName.

phonestring

Source field phone.

number_of_ordersinteger

Source field numberOfOrders.

multipass_identifierstring

Source field multipassIdentifier.

notestring

Source field note.

statestring

Source field state.

tax_exemptboolean

Source field taxExempt.

amount_spentjson

Source field amountSpent.

verified_emailboolean

Source field verifiedEmail.

currency_codestring

Source field currencyCode.

tagsjson

Source field tags.

mailing_addresses#

titan.shopify.mailing_addresses has 17 source columns.

shopify.mailing_addresses17 columns
idintegerpk

Source field id.

customer_idinteger

Source field customerId.

first_namestring

Source field firstName.

last_namestring

Source field lastName.

address1string

Source field address1.

address2string

Source field address2.

citystring

Source field city.

companystring

Source field company.

coordinates_validatedboolean

Source field coordinatesValidated.

phonestring

Source field phone.

countrystring

Source field country.

country_codestring

Source field countryCode.

provincestring

Source field province.

province_codestring

Source field provinceCode.

zipstring

Source field zip.

latitudefloat

Source field latitude.

longitudefloat

Source field longitude.

orders#

titan.shopify.orders has 42 source columns.

shopify.orders42 columns
idintegerpk

Source field id.

notestring

Source field note.

emailstring

Source field email.

taxes_includedboolean

Source field taxesIncluded.

currency_codestring

Source field currencyCode.

namestring

Source field name.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

subtotal_price_setjson

Source field subtotalPriceSet.

total_tax_setjson

Source field totalTaxSet.

total_price_setjson

Source field totalPriceSet.

total_discounts_setjson

Source field totalDiscountsSet.

total_tip_received_setjson

Source field totalTipReceivedSet.

total_shipping_price_setjson

Source field totalShippingPriceSet.

current_total_price_setjson

Source field currentTotalPriceSet.

current_total_discounts_setjson

Source field currentTotalDiscountsSet.

current_subtotal_price_setjson

Source field currentSubtotalPriceSet.

current_total_tax_setjson

Source field currentTotalTaxSet.

original_total_duties_setjson

Source field originalTotalDutiesSet.

total_weightinteger

Source field totalWeight.

source_namestring

Source field sourceName.

client_ipstring

Source field clientIp.

shipping_addressjson

Source field shippingAddress.

billing_addressjson

Source field billingAddress.

customer_idinteger

Source field customerId.

retail_locationjson

Source field retailLocation.

app_idinteger

Source field appId.

po_numberstring

Source field poNumber.

display_financial_statusstring

Source field displayFinancialStatus.

display_fulfillment_statusstring

Source field displayFulfillmentStatus.

processed_atdatetime

Source field processedAt.

customer_journey_summaryjson

Source field customerJourneySummary.

cancel_reasonstring

Source field cancelReason.

cancelled_atdatetime

Source field cancelledAt.

closed_atdatetime

Source field closedAt.

customer_accepts_marketingboolean

Source field customerAcceptsMarketing.

confirmedboolean

Source field confirmed.

presentment_currency_codestring

Source field presentmentCurrencyCode.

status_page_urlstring

Source field statusPageUrl.

tagsjson

Source field tags.

transactionsjson

Source field transactions.

custom_attributesjson

Source field customAttributes.

order_line_items#

titan.shopify.order_line_items has 23 source columns.

shopify.order_line_items23 columns
idintegerpk

Source field id.

order_idinteger

Source field orderId.

product_idinteger

Source field productId.

variant_idinteger

Source field variantId.

titlestring

Source field title.

namestring

Source field name.

quantityinteger

Source field quantity.

current_quantityinteger

Source field currentQuantity.

variantjson

Source field variant.

tax_linesjson

Source field taxLines.

vendorstring

Source field vendor.

skustring

Source field sku.

custom_attributesjson

Source field customAttributes.

discounted_unit_price_after_all_discounts_setjson

Source field discountedUnitPriceAfterAllDiscountsSet.

discounted_total_setjson

Source field discountedTotalSet.

discounted_unit_price_setjson

Source field discountedUnitPriceSet.

original_total_setjson

Source field originalTotalSet.

original_unit_price_setjson

Source field originalUnitPriceSet.

taxableboolean

Source field taxable.

total_discount_setjson

Source field totalDiscountSet.

unfulfilled_original_total_setjson

Source field unfulfilledOriginalTotalSet.

unfulfilled_quantityinteger

Source field unfulfilledQuantity.

variant_titlestring

Source field variantTitle.

discount_applications#

titan.shopify.discount_applications has 8 source columns.

shopify.discount_applications8 columns
order_idintegerpk

Source field orderId.

indexintegerpk

Source field index.

target_selectionstring

Source field targetSelection.

target_typestring

Source field targetType.

valuejson

Source field value.

codestring

Source field code.

typestring

Source field type.

allocation_methodstring

Source field allocationMethod.

refunds#

titan.shopify.refunds has 6 source columns.

shopify.refunds6 columns
idintegerpk

Source field id.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

notestring

Source field note.

restockboolean

Source field restock.

order_idinteger

Source field orderId.

order_adjustments#

titan.shopify.order_adjustments has 6 source columns.

shopify.order_adjustments6 columns
idintegerpk

Source field id.

order_idinteger

Source field orderId.

refund_idinteger

Source field refundId.

amount_setjson

Source field amountSet.

tax_amount_setjson

Source field taxAmountSet.

reasonstring

Source field reason.

refund_line_items#

titan.shopify.refund_line_items has 10 source columns.

shopify.refund_line_items10 columns
idintegerpk

Source field id.

refund_idinteger

Source field refundId.

location_idinteger

Source field locationId.

line_item_idinteger

Source field lineItemId.

subtotal_setjson

Source field subtotalSet.

price_setjson

Source field priceSet.

total_tax_setjson

Source field totalTaxSet.

quantityinteger

Source field quantity.

restockedboolean

Source field restocked.

restock_typestring

Source field restockType.

inventory_items#

titan.shopify.inventory_items has 16 source columns.

shopify.inventory_items16 columns
idintegerpk

Source field id.

skustring

Source field sku.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

requires_shippingboolean

Source field requiresShipping.

unit_costjson

Source field unitCost.

country_code_of_originstring

Source field countryCodeOfOrigin.

province_code_of_originstring

Source field provinceCodeOfOrigin.

trackedboolean

Source field tracked.

tracked_editablejson

Source field trackedEditable.

inventory_history_urlstring

Source field inventoryHistoryUrl.

duplicate_sku_countinteger

Source field duplicateSkuCount.

measurementjson

Source field measurement.

harmonized_system_codestring

Source field harmonizedSystemCode.

legacy_resource_idinteger

Source field legacyResourceId.

variant_idinteger

Source field variantId.

inventory_levels#

titan.shopify.inventory_levels has 5 source columns.

shopify.inventory_levels5 columns
idintegerpk

Source field id.

inventory_item_idintegerpk

Source field inventoryItemId.

location_idintegerpk

Source field locationId.

updated_atdatetime

Source field updatedAt.

quantitiesjson

Source field quantities.

locations#

titan.shopify.locations has 6 source columns.

shopify.locations6 columns
idintegerpk

Source field id.

addressjson

Source field address.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

is_activeboolean

Source field isActive.

namestring

Source field name.

products#

titan.shopify.products has 14 source columns.

shopify.products14 columns
idintegerpk

Source field id.

titlestring

Source field title.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

published_atdatetime

Source field publishedAt.

handlestring

Source field handle.

product_typestring

Source field productType.

vendorstring

Source field vendor.

statusstring

Source field status.

template_suffixstring

Source field templateSuffix.

tagsjson

Source field tags.

descriptionstring

Source field description.

description_htmlstring

Source field descriptionHtml.

product_variants#

titan.shopify.product_variants has 23 source columns.

shopify.product_variants23 columns
idintegerpk

Source field id.

barcodestring

Source field barcode.

compare_at_pricefloat

Source field compareAtPrice.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

display_namestring

Source field displayName.

inventory_item_idinteger

Source field inventoryItemId.

inventory_quantityinteger

Source field inventoryQuantity.

legacy_resource_idinteger

Source field legacyResourceId.

positioninteger

Source field position.

pricefloat

Source field price.

product_idinteger

Source field productId.

requires_componentsboolean

Source field requiresComponents.

selected_optionsjson

Source field selectedOptions.

sellable_online_quantityinteger

Source field sellableOnlineQuantity.

show_unit_priceboolean

Source field showUnitPrice.

skustring

Source field sku.

taxableboolean

Source field taxable.

tax_codestring

Source field taxCode.

titlestring

Source field title.

unit_pricejson

Source field unitPrice.

unit_price_measurementjson

Source field unitPriceMeasurement.

imagejson

Source field image.

tender_transactions#

titan.shopify.tender_transactions has 7 source columns.

shopify.tender_transactions7 columns
idintegerpk

Source field id.

order_idinteger

Source field orderId.

amountjson

Source field amount.

processed_atdatetime

Source field processedAt.

payment_methodstring

Source field paymentMethod.

remote_referencestring

Source field remoteReference.

testboolean

Source field test.

order_transactions#

titan.shopify.order_transactions has 22 source columns.

shopify.order_transactions22 columns
idintegerpk

Source field id.

order_idinteger

Source field orderId.

created_atdatetime

Source field createdAt.

processed_atdatetime

Source field processedAt.

amount_rounding_setjson

Source field amountRoundingSet.

amount_setjson

Source field amountSet.

currency_exchange_adjustmentjson

Source field currencyExchangeAdjustment.

error_codestring

Source field errorCode.

formatted_gatewaystring

Source field formattedGateway.

gatewaystring

Source field gateway.

kindstring

Source field kind.

location_idinteger

Source field locationId.

parent_transaction_idinteger

Source field parentTransactionId.

payment_idstring

Source field paymentId.

receipt_jsonjson

Source field receiptJson.

settlement_currencystring

Source field settlementCurrency.

settlement_currency_ratefloat

Source field settlementCurrencyRate.

statusstring

Source field status.

testboolean

Source field test.

total_unsettled_setjson

Source field totalUnsettledSet.

user_idinteger

Source field userId.

amountfloat

Source field amount.

fulfillments#

titan.shopify.fulfillments has 16 source columns.

shopify.fulfillments16 columns
idintegerpk

Source field id.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

delivered_atdatetime

Source field deliveredAt.

display_statusstring

Source field displayStatus.

estimated_delivery_atdatetime

Source field estimatedDeliveryAt.

in_transit_atdatetime

Source field inTransitAt.

legacy_resource_idinteger

Source field legacyResourceId.

location_idinteger

Source field locationId.

order_idinteger

Source field orderId.

namestring

Source field name.

requires_shippingboolean

Source field requiresShipping.

servicejson

Source field service.

statusstring

Source field status.

total_quantityinteger

Source field totalQuantity.

tracking_infojson

Source field trackingInfo.

metafields#

titan.shopify.metafields has 11 source columns.

shopify.metafields11 columns
idintegerpk

Source field id.

created_atdatetime

Source field createdAt.

updated_atdatetime

Source field updatedAt.

typestring

Source field type.

keystring

Source field key.

valuestring

Source field value.

json_valuejson

Source field jsonValue.

namespacestring

Source field namespace.

owner_idinteger

Source field ownerId.

owner_typestring

Source field ownerType.

legacy_resource_idinteger

Source field legacyResourceId.

staff_members#

titan.shopify.staff_members has 13 source columns.

shopify.staff_members13 columns
idintegerpk

Source field id.

account_typestring

Source field accountType.

activeboolean

Source field active.

avatarjson

Source field avatar.

emailstring

Source field email.

existsboolean

Source field exists.

first_namestring

Source field firstName.

last_namestring

Source field lastName.

namestring

Source field name.

initialsjson

Source field initials.

is_shop_ownerboolean

Source field isShopOwner.

localestring

Source field locale.

phonestring

Source field phone.

product_images#

titan.shopify.product_images has 6 source columns.

shopify.product_images6 columns
idintegerpk

Source field id.

product_idinteger

Source field productId.

urlstring

Source field url.

widthinteger

Source field width.

heightinteger

Source field height.

alt_textstring

Source field altText.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.