Fields Available for Shopify CSV / Excel Export

Here you can find the full list of all fields, available for selection and export with Exportier - Data Export.

Using this document you can define if the tables and fields you need to export are available. The table of contents will navigate you.

 

Table of contents

 

Fields, sorted by the data types

 

Products

 

Represents products in your Shopify store.

Field

Description

Field

Description

ID

Globally unique identifier.

Handle

The date and time the metafield was created.

Created at

Description of the metafield.

Description

Key name for the meta field.

Description HTML

The namespace for the metafield.

Gift card template suffix

Owner type of metafield visible to the Storefront API.

Has only default variant

The date and time the metafield was updated.

Has out of stock variants

The value of the metafield.

Is gift card

Represents the metafield value type.

Media count

The date and time when metafield was updated.

Online store preview URL

The value of metafield.

Online store URL

Represents the metafield value type.

Options

A list of custom product options (maximum of 3 per product).

Highest variant's price

The highest variant's price of the product, formatted as decimals.

Lowest variant's price

The lowest variant's price of the product, formatted as decimals.

Product type

The product type specified by merchant.

Published at

The date and time (in ISO 8601 format) when the product was published on the online store.

SEO title

SEO information about the product.

SEO description

SEO informational description of the product.

Status

Product status.

Storefront ID

Product storefront ID.

Tags

Comma-separated list of tags associated with the product.

Theme template

The theme template used when viewing the item in the store.

Title

The product's name.

Total inventory

Quantity of goods in stock.

Variants count

The number of variants associated with the product.

Tracks inventory

Whether inventory tracking has been enabled for the product.

Updated at

The date and time (ISO 8601 format) when the product was last modified.

Vendor

The product's vendor name.

List of collections containing products.

Field

Description

Field

Description

ID

Globally unique identifier.

Handle

A unique human-friendly string for the collection. Automatically generated from the collection's title.

Description

The stripped description of the collection, in a single line with HTML tags removed.

Description HTML

The description of the collection, complete with HTML formatting.

Image alt text

A word or phrase to share the nature or contents of an image associated with the collection.

Original image URL

The location of the original image associated with the collection as a URL.

Transformed image URL

The location of the transformed image associated with the collection as a URL.

Products count

The number of products included in the collection.

Rule set

The rules are used to assign products to the collection. This applies only to smart collections.

SEO title

SEO information title for the collection.

SEO description

SEO information description for the collection.

Sort order

The order in which the collection's products are sorted.

Storefront ID

The storefront ID of the collection.

Title

The title of the collection.

Updated at

The date and time (ISO 8601 format) when the collection was last modified.

Image ID

A unique identifier for the image associated with the collection.

Template suffix

The suffix of the Liquid template being used to show the collection in an online store.

Represents a product variant.

Field

Description

Field

Description

ID

Globally unique identifier.

Title

The title of the product variant.

Available for sale

Whether the product variant is available for sale.

Barcode

The value of the barcode associated with the product.

Compare-at price

The compare-at price of the variant in the default shop currency.

Created at

The date and time when the variant was created.

Display name

Display name of the variant, based on product's title + variant's title.

Image alt text

A word or phrase to share the nature or contents of the featured image for the variant.

Original image URL

The location of the original featured image for the variant as a URL.

Transformed image URL

The location of the transformed featured image for the variant as a URL.

Inventory policy

Whether customers are allowed to place an order for the product variant when it's out of stock.

Inventory quantity

The total sellable quantity of the variant.

Position

The order of the product variant in the list of product variants. The first position in the list is 1.

Price

The price of the product variant in the default shop currency.

SKU

An identifier for the product variant in the shop.

Storefront ID

The storefront ID of the product variant.

Tax code

The tax code for the product variant.

Taxable

Whether a tax is charged when the product variant is sold.

Updated at

The date and time (ISO 8601 format) when the product variant was last modified.

Weight

The weight of the product variant in the unit system specified with weight_unit.

Weight unit

The unit of measurement that applies to the product variant's weight.

Image ID

A unique identifier of the featured image for the variant.

Represents custom metadata attached to a resource.

Fields

Description

Fields

Description

ID

Globally unique identifier.

Created at

The date and time when the metafield was created.

Description

The description of a metafield.

Key

The key name for a metafield.

Namespace

The namespace for a metafield.

Owner type

Owner type of a metafield visible to the Storefront API.

Updated at

The date and time when the metafield was updated.

Value

The value of a metafield.

Type

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

Customers

 

Orders

 

Inventory Items

 

Product variants

 

Draft Orders

 

Tender transactions

 

Bank accounts

 

Disputes

 

Discount

 

Payouts

 

Collections

 

Locations

 

Fulfillment orders

 

Visit the https://aserve.atlassian.net/l/c/GS5hAcYQ page, if you have a question or need any kind of assistance.