Fields Available for Export

Power BI Connector allows selecting the majority of fields and tables from your Shopify store for export into Microsoft Power BI.

Here is the full list of data tables supported by the application:

  • Balance - The account's current balance. This amount is comprised of any Transaction not yet included in a Payout.

  • Custom Collections - Represents a custom collection of products. A custom collection is a grouping of products that a merchant can create to make their store easier to browse.

  • Customers - Represents information about a customer of the shop, such as the customer's contact details, their order history, and whether they've agreed to receive email marketing.

  • Disputes - Disputes occur when a buyer questions the legitimacy of a charge with their financial institution.

  • Draft Orders - List of saved draft orders. Draft orders are used to create orders on behalf of store customers.

  • Locations - Represents the location where the physical good resides.

Represents the location where the physical good resides.

Field

Description

Field

Description

Id

A globally-unique ID.

Activatable

Whether this location can be reactivated.

Address verified

Whether the location address has been verified.

Deactivatable

Whether this location can be deactivated.

Deactivated at

The date and time that the location was deactivated at.

Deletable

Whether this location can be deleted.

Fulfills online orders

Whether this location can fulfill online orders.

Has active inventory

Whether this location has active inventory.

Has unfulfilled orders

Whether this location has orders that need to be fulfilled.

Is active

Whether the location is active.

Legacy resource id

The ID of the corresponding resource in the REST Admin API.

Name

The name of the location.

Ships inventory

Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored.

The address of this location.

Field

Description

Field

Description

First line

The first line of the address for the location.

Second line

The second line of the address for the location.

City

The city of the location.

Country

The country of the location.

Country code

The two-letter country code of the location.

Formatted

A formatted version of the location address.

Latitude

The latitude coordinates of the location.

Longitude

The longitude coordinates of the location.

Phone

The phone number of the location.

Province

The province of the location.

Province code

The code for the region of the address, such as the province, state, or district. For example QC for Quebec, Canada.

Zip

The ZIP code of the location.

A list of the quantities of the inventory items that can be stocked at this location.

Field

Description

Field

Description

Can deactivate

Whether the inventory items associated with the inventory level can be deactivated.

Created at

The date and time when the inventory level was created.

Deactivation alert

Describes either the impact of deactivating the inventory level, or why the inventory level can't be deactivated.

Updated at

The date and time when the inventory level was updated.

Inventory item associated with the inventory level.

Field

Description

Field

Description

Inventory item id

A globally-unique ID.

Location associated with the inventory level.

Field

Description

Field

Description

ID

Globally unique ID.

Activatable

Whether this location can be reactivated.

Address verified

Whether the location address has been verified.

Deactivatable

Whether this location can be deactivated.

Deactivated at

Date and time the location was deactivated (null if location is still active).

Deletable

Whether this location can be deleted.

Fulfills online orders

Indicates whether this location can fulfill online orders.

Has active inventory

Indicates whether or not this location has active inventory.

Has unfulfilled orders

Indicates whether or not this location has unfulfilled orders.

Is active

Whether the location is active.

Legacy resource ID

The ID of the corresponding resource in the REST Admin API.

Name

The name of the location.

Ships inventory

Indicates whether or not this location is used for calculating shipping rates.

Quantities for the requested names.

Field

Description

Field

Description

Name

The name that identifies the inventory quantity.

Quantity

The quantity for the quantity name.

Updated at

When the quantity was last updated.

A list of metafields that belong to the resource.

Field

Description

Field

Description

Metafield ID

Globally unique ID.

Description

The description of a metafield.

Key

The key name for a metafield.

Legacy resource ID

The ID of the corresponding resource in the REST Admin API.

Namespace

The namespace for a metafield.

Owner type

Owner type of a metafield visible to the Storefront API.

Value

The value of a metafield.

Type

The type of data that the metafield stores in the value field.

  • Metafields - Metafields represent custom metadata attached to a resource. Metafields can be sorted into namespaces and are composed of keys, values, and value types. This table will include only shop-level meta field data.

  • Orders - An order represents an agreement to do business between a customer and a merchant. It is a customer's completed request to purchase one or more products from a shop. An order is created when a customer completes the checkout process, during which time they provide an email address or phone number, billing address and payment information.

  • Payments Transactions - Balance Transactions make up the canonical "statement of account", or ledger for a Shopify Payments account. Every single movement of money in or out of the account is recorded here.

  • Payouts - Payouts represent the movement of money between a Shopify Payments account balance and a connected bank account.

  • Products - Contains a shop’s products.

  • Smart Collections - Represents a smart collection of products. A smart collection is a grouping of products defined by rules that are set by the merchant.

  • Product Variants - Represents a different version of a product, such as different sizes or differing colours.

  • Inventory Items - Represents the goods available to be shipped to a customer. It holds essential information about the goods, including SKU and whether it is tracked.

  • Product Images - All images of all products of the shop.

  • Fulfillment Orders (*new) - Represents fulfillment orders of merchant-managed and third-party.

Each of these data tables consists of many various fields available for export.

If you need to export a field type that is not in the list, please contact us at mailto:shopify@alpha-serve.com.