Back to plugin list
shopify
Official
Premium

Shopify

The CloudQuery Shopify plugin pulls data from Shopify and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v5.1.1

Type

Source

Platforms
Date Published

Feb 20, 2024

Price per 1M rows

$20

free quota

1M rows

  • shopify_abandoned_checkouts
  • shopify_customers
  • shopify_orders
  • shopify_price_rules
    • shopify_price_rule_discount_codes
  • shopify_products
    • shopify_product_variants
    • shopify_product_images

Shopify Orders

The shopify_orders 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
admin_graphql_api_idutf8
app_idint64
billing_addressjson
browser_iputf8
buyer_accepts_marketingbool
cancelled_attimestamp[us, tz=UTC]
cancel_reasonutf8
cart_tokenutf8
checkout_idint64
checkout_tokenutf8
client_detailsjson
closed_attimestamp[us, tz=UTC]
confirmedbool
contact_emailutf8
_cq_iduuid
_cq_parent_iduuid
created_attimestamp[us, tz=UTC]
currencyutf8
current_subtotal_priceutf8
current_subtotal_price_setjson
current_total_discountsutf8
current_total_discounts_setjson
current_total_duties_setjson
current_total_priceutf8
current_total_price_setjson
current_total_taxutf8
current_total_tax_setjson
customerjson
customer_localeutf8
device_idutf8
discount_applicationsjson
discount_codesjson
emailutf8
estimated_taxesbool
financial_statusutf8
fulfillmentsjson
fulfillment_statusutf8
gatewayutf8
idint64
landing_siteutf8
landing_site_refutf8
line_itemsjson
location_idint64
nameutf8
noteutf8
note_attributesjson
numberint64
order_numberint64
order_status_urlutf8
original_total_duties_setjson
payment_gateway_nameslist<item: utf8, nullable>
payment_termsjson
phoneutf8
presentment_currencyutf8
processed_attimestamp[us, tz=UTC]
processing_methodutf8
referenceutf8
referring_siteutf8
refundsjson
shipping_linesjson
source_identifierutf8
source_nameutf8
source_urlutf8
subtotal_priceutf8
subtotal_price_setjson
tagsutf8
taxes_includedbool
tax_linesjson
testbool
tokenutf8
total_discountsutf8
total_discounts_setjson
total_line_items_priceutf8
total_line_items_price_setjson
total_outstandingutf8
total_priceutf8
total_price_setjson
total_price_usdutf8
total_shipping_price_setjson
total_taxutf8
total_tax_setjson
total_tip_receivedutf8
total_weightint64
updated_attimestamp[us, tz=UTC]
user_idint64
Subscribe to product updates

Be the first to know about new features.