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

Nov 9, 2023

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
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
discount_codesjson
emailutf8
gatewayutf8
idint64
landing_siteutf8
line_itemsjson
nameutf8
note_attributesjson
presentment_currencyutf8
referring_siteutf8
shipping_linesjson
source_nameutf8
subtotal_priceutf8
taxes_includedbool
tax_linesjson
tokenutf8
total_discountsutf8
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.