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.

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.
Total variants	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.

Table of contents