Integration of Shopify with BigQuery
Learn how to create a Shopify custom app and connect Shopify to Google BigQuery using WitCloud to collect orders, products, refunds, returns, store navigation, inventory levels and marketing consents.
Updated
Introduction
This module connects WitCloud to your Shopify store and stores its data in Google Cloud BigQuery: orders, products, refunds, returns, store navigation menus, inventory levels per location and customers' marketing consents. Use it to analyze your ecommerce results next to your advertising data.
WitCloud connects to Shopify with the Client ID and Client secret of a custom app that you create in your own Shopify account. The first part of this page shows how to create it. The second part shows how to set up the integration in WitCloud.
Before you start: custom app setup
The steps in this section are done in Shopify's own interface (the Shopify Dev Dashboard and your store's admin), not in WitCloud. Shopify may change its screens over time; the images show how they looked when this page was written. They do not contain any real store data.
Step 1: Open the Dev Dashboard
Go to the Shopify Dev Dashboard and open the Apps section. Click Create app in the top right corner. If you don't have a Shopify Partners account yet, you can create one at partners.shopify.com.

Step 2: Create the app
On the Create an app screen choose Start from Dev Dashboard (the card on the right). Enter an App name, for example "WitCloud Connector", and click Create.

Step 3: Create a version
In your app open the Versions section and click Create a version.

Step 4: Add the scopes and release the version
In the Access section, paste the permissions (scopes) that WitCloud needs into the Scopes field.
| Scope | Required | Used for |
|---|---|---|
read_orders | Yes | Orders, refunds and returns |
read_all_orders | Yes | Orders older than 60 days |
read_products | Yes | Products |
read_discounts | Yes | Discount codes used in orders |
read_returns | Yes | Returns |
read_inventory | Yes | Stock levels |
read_locations | Yes | Inventory levels per location |
read_customers | Yes | Customer details in orders and marketing consents |
read_online_store_navigation | No | Store navigation menus |
WitCloud checks that all required scopes are granted when you save the credentials. Without read_online_store_navigation the integration works, but the store_navigation table stays empty or reports an error.
Paste all scopes at once, separated by commas: read_all_orders,read_customers,read_discounts,read_inventory,read_locations,read_orders,read_products,read_returns,read_online_store_navigation
The orders and marketing consents tables contain customers' names, email addresses and phone numbers. Shopify gives an app access to them only after you request access to protected customer data in the app's settings (the name, email and phone fields). Without it, these fields stay empty.
Then click Release at the top of the page.
Step 5: Confirm the release
In the Release this new version? dialog you can optionally enter a version name and message. Click Release to confirm.

Already connected Shopify before and adding new scopes now? Add them to your app, release a new version and accept the new permissions in your store. The integration keeps working in the meantime; only the tables that need the new scopes report an error until then.
Step 6: Install the app on your store
Open the Home section of the app and click Install app. Shopify asks you to choose the store (if you have several) and shows the permissions the app requests. Click Install to confirm.

After the installation Shopify may open an Example Domain page. This is expected: the app uses a placeholder app URL. Close that tab and go back to the Dev Dashboard.
Step 7: Copy the Client ID and the secret
In the app open the Settings section. In Credentials copy the Client ID, then click the eye icon next to Secret to reveal it and copy it too. You will paste both values into WitCloud. Treat the secret like a password and do not share it.
Done! You have the Client ID and Client secret you need to authorize Shopify in WitCloud.
Configuration guide
Follow the steps below to connect Shopify with BigQuery. Once the setup is complete, your Shopify data is transferred to your BigQuery project.
Module setup
Go to Integrations in the menu and click Add integration.

Select Shopify from the list of available integrations.

Enter the Collect name, e.g. "Shopify PL". A good name helps you identify the data source later.

Enter the Shop URI: the address of your store in the myshopify.com domain, including https://, e.g. https://your-store.myshopify.com (not your custom domain). The Authorize button stays inactive until you enter a valid address.

Authorization
If you have already authorized Shopify in WitCloud, you can pick the existing token from the Shopify authorization drop-down and skip the next two steps.
Click Authorize.

In the Authorize pop-up enter the Client ID and the Client secret you copied from Shopify and click Create. If Shopify does not accept the credentials, or the app lacks a required permission, the reason is shown under the form.

The saved token is selected automatically. You can also choose a token from the Shopify authorization drop-down.

Advanced settings
Click Show advanced settings to see two more fields.
In Data freshness (products, stocks) enter how often, in hours, tables that hold the whole catalogue (products, inventory levels and store navigation) are refreshed. The value must be between 4 and 12 hours; the default is 4.

In Tables to collect you can remove the tables you do not need: products, orders, returns, refunds, store_navigation, inventory_levels and marketing_consents. All of them are selected by default and at least one must stay selected. Collecting fewer tables makes the data retrieval faster.

In an integration created earlier, new tables are not added to Tables to collect automatically. Edit the integration and select them to start collecting them.
Click Next.

Historical data and scheduling
In Historical Data enter the number of days to fetch on the first run, up to 365.

A data synchronization schedule is created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your Shopify data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your store.
Data schema
Expand the tables below to view the full data schema collected from Shopify.
- Orders, returns and refunds are collected day by day, by the date they were created. A day is a calendar day in the timezone of the integration's schedule.
- Marketing consents are collected day by day too, by the date the customer was last updated. A day holds the customers created that day and those whose email or SMS consent changed that day, so the newest row of each customer is their current consent. The
is_new,email_consent_changedandsms_consent_changedcolumns tell why a customer is in a given day. - Products, inventory levels and store navigation are collected as a full copy of the current state and are refreshed according to Data freshness.
To get each customer's current consent, take their newest row:
SELECT *
FROM `your_project.your_dataset.shopify_marketing_consents_<collect_id>`
WHERE TRUE
QUALIFY ROW_NUMBER() OVER (PARTITION BY admin_graphql_api_id ORDER BY updated_at DESC) = 1
Join it to orders on customer.admin_graphql_api_id. Marketing consent states are SUBSCRIBED, NOT_SUBSCRIBED, UNSUBSCRIBED, PENDING, REDACTED and INVALID; only SUBSCRIBED customers have agreed to marketing.
Data schema for shopify_orders
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| order_number | NULLABLE | INTEGER |
| number | NULLABLE | INTEGER |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
| processed_at | NULLABLE | TIMESTAMP |
| cancelled_at | NULLABLE | TIMESTAMP |
| currency | NULLABLE | STRING |
| tags | REPEATED | STRING |
| note | NULLABLE | STRING |
| financial_status | NULLABLE | STRING |
| fulfillment_status | NULLABLE | STRING |
| discount_codes | REPEATED | STRING |
| payment_gateway_names | REPEATED | STRING |
| taxes_included | NULLABLE | BOOLEAN |
| subtotal_price_set | NULLABLE | RECORD |
| subtotal_price_set.shop_money | NULLABLE | RECORD |
| subtotal_price_set.shop_money.amount | NULLABLE | FLOAT |
| subtotal_price_set.shop_money.currency_code | NULLABLE | STRING |
| subtotal_price_set.presentment_money | NULLABLE | RECORD |
| subtotal_price_set.presentment_money.amount | NULLABLE | FLOAT |
| subtotal_price_set.presentment_money.currency_code | NULLABLE | STRING |
| total_tax_set | NULLABLE | RECORD |
| total_tax_set.shop_money | NULLABLE | RECORD |
| total_tax_set.shop_money.amount | NULLABLE | FLOAT |
| total_tax_set.shop_money.currency_code | NULLABLE | STRING |
| total_tax_set.presentment_money | NULLABLE | RECORD |
| total_tax_set.presentment_money.amount | NULLABLE | FLOAT |
| total_tax_set.presentment_money.currency_code | NULLABLE | STRING |
| total_price_set | NULLABLE | RECORD |
| total_price_set.shop_money | NULLABLE | RECORD |
| total_price_set.shop_money.amount | NULLABLE | FLOAT |
| total_price_set.shop_money.currency_code | NULLABLE | STRING |
| total_price_set.presentment_money | NULLABLE | RECORD |
| total_price_set.presentment_money.amount | NULLABLE | FLOAT |
| total_price_set.presentment_money.currency_code | NULLABLE | STRING |
| tax_lines | REPEATED | RECORD |
| tax_lines.title | NULLABLE | STRING |
| tax_lines.price_set | NULLABLE | RECORD |
| tax_lines.price_set.shop_money | NULLABLE | RECORD |
| tax_lines.price_set.shop_money.amount | NULLABLE | FLOAT |
| tax_lines.price_set.shop_money.currency_code | NULLABLE | STRING |
| tax_lines.price_set.presentment_money | NULLABLE | RECORD |
| tax_lines.price_set.presentment_money.amount | NULLABLE | FLOAT |
| tax_lines.price_set.presentment_money.currency_code | NULLABLE | STRING |
| tax_lines.rate | NULLABLE | FLOAT |
| tax_lines.rate_percentage | NULLABLE | FLOAT |
| tax_lines.channel_liable | NULLABLE | BOOLEAN |
| customer | NULLABLE | RECORD |
| customer.admin_graphql_api_id | NULLABLE | STRING |
| customer.first_name | NULLABLE | STRING |
| customer.last_name | NULLABLE | STRING |
| customer.email | NULLABLE | STRING |
| billing_address | NULLABLE | RECORD |
| billing_address.name | NULLABLE | STRING |
| billing_address.address1 | NULLABLE | STRING |
| billing_address.address2 | NULLABLE | STRING |
| billing_address.city | NULLABLE | STRING |
| billing_address.province | NULLABLE | STRING |
| billing_address.province_code | NULLABLE | STRING |
| billing_address.country | NULLABLE | STRING |
| billing_address.zip | NULLABLE | STRING |
| billing_address.phone | NULLABLE | STRING |
| shipping_address | NULLABLE | RECORD |
| shipping_address.name | NULLABLE | STRING |
| shipping_address.address1 | NULLABLE | STRING |
| shipping_address.address2 | NULLABLE | STRING |
| shipping_address.city | NULLABLE | STRING |
| shipping_address.province | NULLABLE | STRING |
| shipping_address.province_code | NULLABLE | STRING |
| shipping_address.country | NULLABLE | STRING |
| shipping_address.zip | NULLABLE | STRING |
| shipping_address.phone | NULLABLE | STRING |
| shipping_lines | REPEATED | RECORD |
| shipping_lines.title | NULLABLE | STRING |
| shipping_lines.original_price_set | NULLABLE | RECORD |
| shipping_lines.original_price_set.shop_money | NULLABLE | RECORD |
| shipping_lines.original_price_set.shop_money.amount | NULLABLE | FLOAT |
| shipping_lines.original_price_set.shop_money.currency_code | NULLABLE | STRING |
| shipping_lines.discounted_price_set | NULLABLE | RECORD |
| shipping_lines.discounted_price_set.shop_money | NULLABLE | RECORD |
| shipping_lines.discounted_price_set.shop_money.amount | NULLABLE | FLOAT |
| shipping_lines.discounted_price_set.shop_money.currency_code | NULLABLE | STRING |
| shipping_lines.tax_lines | REPEATED | RECORD |
| shipping_lines.tax_lines.title | NULLABLE | STRING |
| shipping_lines.tax_lines.price_set | NULLABLE | RECORD |
| shipping_lines.tax_lines.price_set.shop_money | NULLABLE | RECORD |
| shipping_lines.tax_lines.price_set.shop_money.amount | NULLABLE | FLOAT |
| shipping_lines.tax_lines.price_set.shop_money.currency_code | NULLABLE | STRING |
| shipping_lines.tax_lines.price_set.presentment_money | NULLABLE | RECORD |
| shipping_lines.tax_lines.price_set.presentment_money.amount | NULLABLE | FLOAT |
| shipping_lines.tax_lines.price_set.presentment_money.currency_code | NULLABLE | STRING |
| shipping_lines.tax_lines.rate | NULLABLE | FLOAT |
| shipping_lines.tax_lines.rate_percentage | NULLABLE | FLOAT |
| shipping_lines.tax_lines.channel_liable | NULLABLE | BOOLEAN |
| fulfillments | REPEATED | RECORD |
| fulfillments.admin_graphql_api_id | NULLABLE | STRING |
| fulfillments.created_at | NULLABLE | TIMESTAMP |
| fulfillments.status | NULLABLE | STRING |
| fulfillments.tracking_info | REPEATED | RECORD |
| fulfillments.tracking_info.company | NULLABLE | STRING |
| fulfillments.tracking_info.number | NULLABLE | STRING |
| fulfillments.tracking_info.url | NULLABLE | STRING |
| line_items | REPEATED | RECORD |
| line_items.admin_graphql_api_id | NULLABLE | STRING |
| line_items.title | NULLABLE | STRING |
| line_items.quantity | NULLABLE | INTEGER |
| line_items.taxable | NULLABLE | BOOLEAN |
| line_items.tax_lines | REPEATED | RECORD |
| line_items.tax_lines.title | NULLABLE | STRING |
| line_items.tax_lines.price_set | NULLABLE | RECORD |
| line_items.tax_lines.price_set.shop_money | NULLABLE | RECORD |
| line_items.tax_lines.price_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.tax_lines.price_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.tax_lines.price_set.presentment_money | NULLABLE | RECORD |
| line_items.tax_lines.price_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.tax_lines.price_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.tax_lines.rate | NULLABLE | FLOAT |
| line_items.tax_lines.rate_percentage | NULLABLE | FLOAT |
| line_items.tax_lines.channel_liable | NULLABLE | BOOLEAN |
| line_items.discounted_total_set | NULLABLE | RECORD |
| line_items.discounted_total_set.shop_money | NULLABLE | RECORD |
| line_items.discounted_total_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discounted_total_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discounted_total_set.presentment_money | NULLABLE | RECORD |
| line_items.discounted_total_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discounted_total_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.original_total_set | NULLABLE | RECORD |
| line_items.original_total_set.shop_money | NULLABLE | RECORD |
| line_items.original_total_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.original_total_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.original_total_set.presentment_money | NULLABLE | RECORD |
| line_items.original_total_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.original_total_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.discount_allocations | REPEATED | RECORD |
| line_items.discount_allocations.allocated_amount_set | NULLABLE | RECORD |
| line_items.discount_allocations.allocated_amount_set.shop_money | NULLABLE | RECORD |
| line_items.discount_allocations.allocated_amount_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discount_allocations.allocated_amount_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discount_allocations.allocated_amount_set.presentment_money | NULLABLE | RECORD |
| line_items.discount_allocations.allocated_amount_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discount_allocations.allocated_amount_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_after_all_discounts_set | NULLABLE | RECORD |
| line_items.discounted_unit_price_after_all_discounts_set.shop_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_after_all_discounts_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_after_all_discounts_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_after_all_discounts_set.presentment_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_after_all_discounts_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_after_all_discounts_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_set | NULLABLE | RECORD |
| line_items.discounted_unit_price_set.shop_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_set.shop_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_set.shop_money.currency_code | NULLABLE | STRING |
| line_items.discounted_unit_price_set.presentment_money | NULLABLE | RECORD |
| line_items.discounted_unit_price_set.presentment_money.amount | NULLABLE | FLOAT |
| line_items.discounted_unit_price_set.presentment_money.currency_code | NULLABLE | STRING |
| line_items.variant | NULLABLE | RECORD |
| line_items.variant.admin_graphql_api_id | NULLABLE | STRING |
| line_items.variant.title | NULLABLE | STRING |
| line_items.variant.sku | NULLABLE | STRING |
| line_items.variant.price | NULLABLE | FLOAT |
| line_items.variant.product | NULLABLE | RECORD |
| line_items.variant.product.admin_graphql_api_id | NULLABLE | STRING |
| line_items.variant.product.title | NULLABLE | STRING |
| line_items.variant.product.handle | NULLABLE | STRING |
| line_items.variant.inventory_item | NULLABLE | RECORD |
| line_items.variant.inventory_item.admin_graphql_api_id | NULLABLE | STRING |
| line_items.variant.inventory_item.measurement | NULLABLE | RECORD |
| line_items.variant.inventory_item.measurement.weight | NULLABLE | RECORD |
| line_items.variant.inventory_item.measurement.weight.value | NULLABLE | FLOAT |
| line_items.variant.inventory_item.measurement.weight.unit | NULLABLE | STRING |
Data schema for shopify_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| title | NULLABLE | STRING |
| handle | NULLABLE | STRING |
| status | NULLABLE | STRING |
| tags | REPEATED | STRING |
| vendor | NULLABLE | STRING |
| product_type | NULLABLE | STRING |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
| published_at | NULLABLE | TIMESTAMP |
| body_html | NULLABLE | STRING |
| category_name | NULLABLE | STRING |
| is_bundle | NULLABLE | BOOLEAN |
| bundle_components | REPEATED | RECORD |
| bundle_components.product_id | NULLABLE | STRING |
| bundle_components.admin_graphql_api_id | NULLABLE | STRING |
| bundle_components.product_title | NULLABLE | STRING |
| bundle_components.quantity | NULLABLE | INTEGER |
| collections | REPEATED | RECORD |
| collections.admin_graphql_api_id | NULLABLE | STRING |
| collections.title | NULLABLE | STRING |
| collections.handle | NULLABLE | STRING |
| image | NULLABLE | RECORD |
| image.admin_graphql_api_id | NULLABLE | STRING |
| image.alt | NULLABLE | STRING |
| image.src | NULLABLE | STRING |
| images | REPEATED | RECORD |
| images.admin_graphql_api_id | NULLABLE | STRING |
| images.alt | NULLABLE | STRING |
| images.src | NULLABLE | STRING |
| options | REPEATED | RECORD |
| options.admin_graphql_api_id | NULLABLE | STRING |
| options.name | NULLABLE | STRING |
| options.values | REPEATED | STRING |
| variants | REPEATED | RECORD |
| variants.admin_graphql_api_id | NULLABLE | STRING |
| variants.title | NULLABLE | STRING |
| variants.sku | NULLABLE | STRING |
| variants.price | NULLABLE | FLOAT |
| variants.compare_at_price | NULLABLE | FLOAT |
| variants.barcode | NULLABLE | STRING |
| variants.created_at | NULLABLE | TIMESTAMP |
| variants.updated_at | NULLABLE | TIMESTAMP |
| variants.position | NULLABLE | INTEGER |
| variants.inventory_quantity | NULLABLE | INTEGER |
| variants.selected_options | REPEATED | RECORD |
| variants.selected_options.name | NULLABLE | STRING |
| variants.selected_options.value | NULLABLE | STRING |
| variants.inventory_item | NULLABLE | RECORD |
| variants.inventory_item.admin_graphql_api_id | NULLABLE | STRING |
| variants.inventory_item.measurement | NULLABLE | RECORD |
| variants.inventory_item.measurement.weight | NULLABLE | RECORD |
| variants.inventory_item.measurement.weight.value | NULLABLE | FLOAT |
| variants.inventory_item.measurement.weight.unit | NULLABLE | STRING |
Data schema for shopify_refunds
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
| note | NULLABLE | STRING |
| order | NULLABLE | RECORD |
| order.admin_graphql_api_id | NULLABLE | STRING |
| order.name | NULLABLE | STRING |
| order.order_number | NULLABLE | INTEGER |
| total_refunded_set | NULLABLE | RECORD |
| total_refunded_set.shop_money | NULLABLE | RECORD |
| total_refunded_set.shop_money.amount | NULLABLE | FLOAT |
| total_refunded_set.shop_money.currency_code | NULLABLE | STRING |
| total_refunded_set.presentment_money | NULLABLE | RECORD |
| total_refunded_set.presentment_money.amount | NULLABLE | FLOAT |
| total_refunded_set.presentment_money.currency_code | NULLABLE | STRING |
| refund_line_items | REPEATED | RECORD |
| refund_line_items.admin_graphql_api_id | NULLABLE | STRING |
| refund_line_items.quantity | NULLABLE | INTEGER |
| refund_line_items.subtotal_set | NULLABLE | RECORD |
| refund_line_items.subtotal_set.shop_money | NULLABLE | RECORD |
| refund_line_items.subtotal_set.shop_money.amount | NULLABLE | FLOAT |
| refund_line_items.subtotal_set.shop_money.currency_code | NULLABLE | STRING |
| refund_line_items.total_tax_set | NULLABLE | RECORD |
| refund_line_items.total_tax_set.shop_money | NULLABLE | RECORD |
| refund_line_items.total_tax_set.shop_money.amount | NULLABLE | FLOAT |
| refund_line_items.total_tax_set.shop_money.currency_code | NULLABLE | STRING |
| refund_line_items.line_item | NULLABLE | RECORD |
| refund_line_items.line_item.admin_graphql_api_id | NULLABLE | STRING |
| refund_line_items.line_item.title | NULLABLE | STRING |
| refund_line_items.line_item.sku | NULLABLE | STRING |
| transactions | REPEATED | RECORD |
| transactions.admin_graphql_api_id | NULLABLE | STRING |
| transactions.gateway | NULLABLE | STRING |
| transactions.kind | NULLABLE | STRING |
| transactions.status | NULLABLE | STRING |
| transactions.amount_set | NULLABLE | RECORD |
| transactions.amount_set.shop_money | NULLABLE | RECORD |
| transactions.amount_set.shop_money.amount | NULLABLE | FLOAT |
| transactions.amount_set.shop_money.currency_code | NULLABLE | STRING |
Data schema for shopify_returns
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| status | NULLABLE | STRING |
| decline_reason | NULLABLE | STRING |
| order | NULLABLE | RECORD |
| order.admin_graphql_api_id | NULLABLE | STRING |
| order.name | NULLABLE | STRING |
| order.order_number | NULLABLE | INTEGER |
| return_line_items | REPEATED | RECORD |
| return_line_items.admin_graphql_api_id | NULLABLE | STRING |
| return_line_items.quantity | NULLABLE | INTEGER |
| return_line_items.return_reason | NULLABLE | STRING |
| return_line_items.return_reason_note | NULLABLE | STRING |
| return_line_items.customer_note | NULLABLE | STRING |
| reverse_fulfillment_orders | REPEATED | RECORD |
| reverse_fulfillment_orders.admin_graphql_api_id | NULLABLE | STRING |
| reverse_fulfillment_orders.status | NULLABLE | STRING |
Data schema for shopify_store_navigation
| Field Name | Mode | Type |
|---|---|---|
| menu_handle | NULLABLE | STRING |
| menu_title | NULLABLE | STRING |
| collection_handle | NULLABLE | STRING |
| collection_title | NULLABLE | STRING |
| breadcrumb | NULLABLE | STRING |
| level1_title | NULLABLE | STRING |
| level1_handle | NULLABLE | STRING |
| level2_title | NULLABLE | STRING |
| level2_handle | NULLABLE | STRING |
| level3_title | NULLABLE | STRING |
| level3_handle | NULLABLE | STRING |
Data schema for shopify_inventory_levels
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| sku | NULLABLE | STRING |
| variant_admin_graphql_api_id | NULLABLE | STRING |
| variant_title | NULLABLE | STRING |
| product_admin_graphql_api_id | NULLABLE | STRING |
| product_title | NULLABLE | STRING |
| location | NULLABLE | RECORD |
| location.id | NULLABLE | STRING |
| location.admin_graphql_api_id | NULLABLE | STRING |
| location.name | NULLABLE | STRING |
| available | NULLABLE | INTEGER |
| on_hand | NULLABLE | INTEGER |
| committed | NULLABLE | INTEGER |
| incoming | NULLABLE | INTEGER |
| updated_at | NULLABLE | TIMESTAMP |
Data schema for shopify_marketing_consents
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| admin_graphql_api_id | NULLABLE | STRING |
| NULLABLE | STRING | |
| phone | NULLABLE | STRING |
| email_marketing_state | NULLABLE | STRING |
| email_marketing_opt_in_level | NULLABLE | STRING |
| email_marketing_updated_at | NULLABLE | TIMESTAMP |
| sms_marketing_state | NULLABLE | STRING |
| sms_marketing_opt_in_level | NULLABLE | STRING |
| sms_marketing_updated_at | NULLABLE | TIMESTAMP |
| data_sale_opt_out | NULLABLE | BOOLEAN |
| is_new | NULLABLE | BOOLEAN |
| email_consent_changed | NULLABLE | BOOLEAN |
| sms_consent_changed | NULLABLE | BOOLEAN |
| created_at | NULLABLE | TIMESTAMP |
| updated_at | NULLABLE | TIMESTAMP |
