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

Type

Source

Platforms
Date Published

Feb 27, 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 Abandoned Checkouts

The shopify_abandoned_checkouts table shows data for Shopify Abandoned Checkouts.

The primary key for this table is id.

It supports incremental syncs based on the updated_at column.

Columns
NameType
abandoned_checkout_urlutf8
billing_addressjson
buyer_accepts_marketingbool
buyer_accepts_sms_marketingbool
cart_tokenutf8
closed_attimestamp[us, tz=UTC]
completed_attimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
created_attimestamp[us, tz=UTC]
currencyutf8
customerjson
customer_localeutf8
device_idutf8
discount_codesjson
emailutf8
gatewayutf8
idint64
landing_siteutf8
line_itemsjson
location_idint64
nameutf8
noteutf8
note_attributesjson
phoneutf8
presentment_currencyutf8
referring_siteutf8
shipping_linejson
shipping_ratejson
sms_marketing_phoneutf8
sourceutf8
source_identifierutf8
source_nameutf8
source_urlutf8
subtotal_priceutf8
taxes_includedbool
tax_linesjson
tokenutf8
total_discountsutf8
total_dutiesjson
total_line_items_priceutf8
total_priceutf8
total_taxutf8
total_weightint64
updated_attimestamp[us, tz=UTC]
user_idint64
Subscribe to product updates

Be the first to know about new features.