Back to source list
Official
Premium
Shopify
The CloudQuery Shopify plugin pulls data from Shopify and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v8.3.1
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Shopify Orders
The shopify_orders table shows data for Shopify Orders.
Primary Keys #
| Name | Type |
|---|---|
| id | utf8 |
Incremental Sync Keys #
| Name | Type |
|---|---|
| updated_at | timestamp[us, tz=UTC] |
Columns #
| Name | Type |
|---|---|
| additional_fees | json |
| billing_address | json |
| billing_address_matches_shipping_address | bool |
| cancellation | json |
| cancel_reason | utf8 |
| can_mark_as_paid | bool |
| can_notify_customer | bool |
| cart_discount_amount_set | json |
| channel_information | json |
| client_ip | utf8 |
| closed | bool |
| closed_at | timestamp[us, tz=UTC] |
| confirmation_number | utf8 |
| confirmed | bool |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| created_at | timestamp[us, tz=UTC] |
| currency_code | utf8 |
| current_subtotal_line_items_quantity | int64 |
| current_subtotal_price_set | json |
| current_tax_lines | json |
| current_total_additional_fees_set | json |
| current_total_discounts_set | json |
| current_total_duties_set | json |
| current_total_price_set | json |
| current_total_tax_set | json |
| current_total_weight | int64 |
| custom_attributes | json |
| customer | json |
| customer_accepts_marketing | bool |
| customer_locale | utf8 |
| discount_code | utf8 |
| discount_codes | list<item: utf8, nullable> |
| display_address | json |
| display_financial_status | utf8 |
| display_fulfillment_status | utf8 |
utf8 | |
| fulfillable | bool |
| fulfillments | json |
| fully_paid | bool |
| id | utf8 |
| legacy_resource_id | utf8 |
| name | utf8 |
| note | utf8 |
| original_total_additional_fees_set | json |
| original_total_price_set | json |
| payment_gateway_names | list<item: utf8, nullable> |
| phone | utf8 |
| po_number | utf8 |
| processed_at | timestamp[us, tz=UTC] |
| refunds | json |
| registered_source_url | utf8 |
| requires_shipping | bool |
| return_status | utf8 |
| shipping_address | json |
| source_identifier | utf8 |
| source_name | utf8 |
| subtotal_price_set | json |
| tags | list<item: utf8, nullable> |
| tax_exempt | bool |
| tax_lines | json |
| test | bool |
| total_price_set | json |
| total_received_set | json |
| total_refunded_set | json |
| total_refunded_shipping_set | json |
| total_shipping_price_set | json |
| total_tax_set | json |
| total_tip_received_set | json |
| total_weight | int64 |
| unpaid | bool |
| updated_at | timestamp[us, tz=UTC] |