Shopify Plugin documentation

Report an issue

Back to plugin list

Official

Premium

Shopify

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

Make sure to sign up and run cloudquery login before running your first sync.

Publisher

cloudquery

Latest version

v5.1.11

Type

Source

Platforms

Date Published

April 16, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

shopify_abandoned_checkouts
shopify_customers
shopify_orders
shopify_price_rules
shopify_products

Shopify Product Variants

This is a premium table. To sync this table you must be logged in via cloudquery login or use a valid API Key which can be generated via the CloudQuery Cloud Website.

The shopify_product_variants table shows data for Shopify Product Variants.

The composite primary key for this table is id, product_id.

Columns

Name	Type
admin_graphql_api_id	`utf8`
barcode	`utf8`
compare_at_price	`utf8`
_cq_id	`uuid`
_cq_parent_id	`uuid`
created_at	`timestamp[us, tz=UTC]`
fulfillment_service	`utf8`
grams	`int64`
id	`int64`
image_id	`utf8`
inventory_item_id	`int64`
inventory_management	`utf8`
inventory_policy	`utf8`
inventory_quantity	`int64`
old_inventory_quantity	`int64`
option1	`utf8`
option2	`utf8`
option3	`utf8`
position	`int64`
price	`utf8`
product_id	`int64`
requires_shipping	`bool`
sku	`utf8`
taxable	`bool`
title	`utf8`
updated_at	`timestamp[us, tz=UTC]`
weight	`float64`
weight_unit	`utf8`

Relations

This table depends on:

Shopify Products