Fields Available for Shopify CSV / Excel Export
- Victoria Markova (Unlicensed)
- Liliia Ostrovska
- Anna Odrynska
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.