Table: shopify_orders

This table shows data for Shopify Orders.

The primary key for this table is id. It supports incremental syncs based on the (created_at, updated_at) columns.

Columns

NameType
_cq_source_nameutf8
_cq_sync_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
id (PK)int64
created_at (Incremental Key)timestamp[us, tz=UTC]
updated_at (Incremental Key)timestamp[us, tz=UTC]
admin_graphql_api_idutf8
app_idint64
browser_iputf8
buyer_accepts_marketingbool
cancelled_attimestamp[us, tz=UTC]
cart_tokenutf8
checkout_idint64
checkout_tokenutf8
closed_attimestamp[us, tz=UTC]
confirmedbool
contact_emailutf8
currencyutf8
current_subtotal_priceutf8
current_total_discountsutf8
current_total_priceutf8
current_total_taxutf8
customer_localeutf8
discount_codesjson
emailutf8
estimated_taxesbool
financial_statusutf8
gatewayutf8
landing_siteutf8
nameutf8
note_attributesjson
numberint64
order_numberint64
order_status_urlutf8
payment_gateway_nameslist<item: utf8, nullable>
phoneutf8
presentment_currencyutf8
processed_attimestamp[us, tz=UTC]
processing_methodutf8
referring_siteutf8
source_nameutf8
subtotal_priceutf8
tagsutf8
tax_linesjson
taxes_includedbool
testbool
tokenutf8
total_discountsutf8
total_line_items_priceutf8
total_outstandingutf8
total_priceutf8
total_price_usdutf8
total_taxutf8
total_tip_receivedutf8
total_weightint64
user_idint64
customerjson
discount_applicationsjson
fulfillmentsjson
line_itemsjson
refundsjson
shipping_linesjson