Connect Shopify to Power BI

Eliminate data silos by consolidating all your Shopify accounts and organizations under one roof with this solution. VIDI’s Shopify connector to Power BI enables you to centralize and manage your Shopify data effortlessly, saving time and resources.

Shopify Dashboards

Here’s what VIDI offers:

Unified Data Hub:

Consolidate Data: Bring all your Shopify accounts and organizations under one roof. Access all your data in a single, centralized location for seamless analysis.
Flexibility: Fetch data from multiple organizations, giving you a holistic view of your Shopify operations.

Storage Tailored Just For You:

Database Freedom: Choose your preferred database (SQL Server, PostgreSQL, MySQL, BigQuery, etc.) or data warehouse for data storage. Bring your existing database or leverage VIDI’s creation service for a new one.

Customization Made Easy:

Transform and Tailor: Mold your data to fit your organization’s specific needs. VIDI facilitates transformations to ensure your data aligns perfectly with your standards.
Granular Control: Specify the exact Shopify reporting tables you require, optimizing data retrieval for efficiency.

Ready-to-Use Reports:

Define Your Format: Describe your desired report structure, and VIDI will store your data in a consumption-ready format, eliminating the need for further manipulation.

Lightweight and Cost-Effective:

Serverless Advantage: This service leverages serverless architecture, significantly reducing costs associated with traditional data management solutions.
Minimal Maintenance: Enjoy a lightweight solution with minimal monitoring requirements, freeing up your IT resources for other tasks.

Tables:

Products

All your products in one place

Column	Data Type	Description
id	integer	The unique identifier of the product.
title	string	The title or name of the product.
body_html	string	The HTML-formatted description of the product.
vendor	string	The vendor or manufacturer of the product.
product_type	string	The type or category of the product.
created_at	datetime	The date and time when the product was created.
handle	string	The handle or URL-friendly version of the product title.
updated_at	datetime	The date and time when the product was last updated.
published_at	datetime	The date and time when the product was published (if applicable).
template_suffix	string	The template suffix used for the product (if applicable).
published_scope	string	The scope or visibility of the product publication (e.g., “web”, “global”, etc.).
tags	string	Tags associated with the product.
status	string	The status of the product (e.g., “active”, “archived”, etc.).
admin_graphql_api_id	string	The unique identifier for the product in the Shopify admin GraphQL API.
variants	array	An array containing information about product variants (e.g., different sizes, colors, etc.).
options	array	An array containing information about product options (e.g., “Title”, “Size”, “Color”, etc.).
images	array	An array containing information about product images.
image	object	An object containing information about the main product image.

Orders

All your historical orders at one place

Column	Data Type	Description
id	integer	The unique identifier of the order.
admin_graphql_api_id	string	The unique identifier for the order in the Shopify admin GraphQL API.
app_id	integer	The ID of the app associated with the order.
browser_ip	string	The IP address of the browser used to place the order.
buyer_accepts_marketing	boolean	Indicates whether the buyer has accepted marketing communications.
cancel_reason	string	The reason for canceling the order (if applicable).
cancelled_at	datetime	The date and time when the order was canceled (if applicable).
cart_token	string	The token associated with the cart from which the order was created.
checkout_id	integer	The ID of the checkout associated with the order.
checkout_token	string	The token associated with the checkout from which the order was created.
client_details	object	Details about the client, including browser information.
closed_at	datetime	The date and time when the order was closed.
confirmation_number	string	The confirmation number associated with the order.
confirmed	boolean	Indicates whether the order has been confirmed.
contact_email	string	The email address associated with the contact for the order.
created_at	datetime	The date and time when the order was created.
currency	string	The currency used for the order.
current_subtotal_price	string	The current subtotal price of the order.
current_total_discounts	string	The current total discounts applied to the order.
current_total_price	string	The current total price of the order.
current_total_tax	string	The current total tax applied to the order.
customer_locale	string	The locale of the customer associated with the order.
device_id	null	The ID of the device used to place the order.
discount_codes	array	An array containing information about discount codes applied to the order.
email	string	The email address associated with the order.
estimated_taxes	boolean	Indicates whether estimated taxes are enabled for the order.
financial_status	string	The financial status of the order.
fulfillment_status	string	The fulfillment status of the order.
landing_site	null	The landing site associated with the order.
landing_site_ref	null	The landing site reference associated with the order.
location_id	null	The location ID associated with the order.
merchant_of_record_app_id	null	The ID of the merchant of record app associated with the order.
name	string	The name or title of the order.
note	string	Any notes associated with the order.
note_attributes	array	An array containing additional note attributes associated with the order.
number	integer	The order number.
order_number	integer	The order number.
order_status_url	string	The URL for checking the order status.
original_total_additional_fees_set	null	The original total additional fees set for the order.
original_total_duties_set	null	The original total duties set for the order.
payment_gateway_names	array	An array containing the names of payment gateways used for the order.
phone	string	The phone number associated with the order.
po_number	null	The purchase order (PO) number associated with the order.
presentment_currency	string	The currency used for presentment of prices in the order.
processed_at	datetime	The date and time when the order was processed.
reference	string	A reference associated with the order.
referring_site	null	The referring site associated with the order.
source_identifier	string	The identifier of the source associated with the order.
source_name	string	The name of the source associated with the order.
source_url	null	The URL of the source associated with the order.
subtotal_price	string	The subtotal price of the order

Inventory Levels

An inventory level represents the quantities of an inventory item for a location.

Each inventory level belongs to one inventory item and has one location. For every location where an inventory item can be stocked, there’s an inventory level that represents the inventory item’s quantities relating to that location.

Column	Data Type	Description
inventory_item_id	integer	The unique identifier of the inventory item associated with the inventory level.
location_id	integer	The unique identifier of the location associated with the inventory level.
available	integer	The quantity of the item available at the location.
updated_at	datetime	The date and time when the inventory level was last updated.
admin_graphql_api_id	string	The unique identifier for the inventory level in the Shopify admin GraphQL API.

Inventory Items

An inventory item represents a physical good. It holds essential information about the physical good, including its SKU and whether its inventory is tracked.

Column	Data Type	Description
id	integer	The unique identifier of the inventory item.
sku	string	The stock-keeping unit (SKU) assigned to the inventory item.
created_at	datetime	The date and time when the inventory item was created.
updated_at	datetime	The date and time when the inventory item was last updated.
requires_shipping	boolean	A flag indicating whether the inventory item requires shipping.
cost	string	The cost of the inventory item.
country_code_of_origin	string	The country code of origin for the inventory item.
province_code_of_origin	string	The province code of origin for the inventory item.
harmonized_system_code	string	The harmonized system code associated with the inventory item.
tracked	boolean	A flag indicating whether the inventory item is tracked.
country_harmonized_system_codes	array	An array of country harmonized system codes associated with the inventory item.
admin_graphql_api_id	string	The unique identifier for the inventory item in the Shopify admin GraphQL API.

Metafields for Products

Metafields are a flexible way to attach additional information to a Shopify resource (e.g. Product, Collection, etc.). Some examples of data stored using metafields include specifications, size charts, downloadable documents, release dates, images, or part numbers. Metafields are identified by an owner resource, a namespace, and a key and they store a value along with type information for that context.

Column	Data Type	Description
id	integer	The unique identifier of the metafield.
namespace	string	The namespace of the metafield.
key	string	The key associated with the metafield.
value	string	The value of the metafield.
description	string	A description of the metafield, if available.
owner_id	integer	The ID of the resource that owns the metafield.
created_at	datetime	The date and time when the metafield was created.
updated_at	datetime	The date and time when the metafield was last updated.
owner_resource	string	The type of resource that owns the metafield (e.g., product, order).
type	string	The type of metafield (e.g., single_line_text_field, multi_line_text_field, integer, json_string).
admin_graphql_api_id	string	The unique identifier for the metafield in the Shopify admin GraphQL API.

We can fetch more tables from Shopify like Billing, Customers, Discounts, Events etc.,

Get Started Today!

Simplify your Shopify data management with VIDI’s robust and user-friendly Shopify Reporting service.