Shopify Products – Available Columns For Export And Import

While importing or exporting Shopify product data, it’s crucial to understand the concept of mapping fields. Mapping all fields correctly is essential for the plugin to function properly. Any errors in your import file could lead to unexpected issues with your product import.

This article provides a detailed overview of the data columns that can be imported or exported using the StoreRobo Import Export Suite.

>> Download sample CSV

Basic columns in a Shopify product export file typically contain the core product information essential for managing your product data.

Column	Explanation	Allowed values / Examples
ID	Unique character generated by Shopify to identify each Product.	Allowed values: Number Example:232342332
Title	Name of the product.	Allowed values: Text Example: Men’s T-Shirt
Vendor	refers to the manufacturer, supplier, or brand of the product	Allowed values: Text Example: Nike
Tags	User-defined keywords associated with a particular product. These tags are not categories or product types, but rather additional labels that help with organization and filtering. Multiple values can be separated with a comma.	Allowed values: Text Example: Color: Red Type: Skirt
Published	Indicates whether the product is live and visible on your online store for customers to purchase.	Allowed values TRUE FALSE Example: TRUE
Published scope	Specifies where the collections are published. Global – Product available on all sales channels. Web – Product only available on online storefront (web channel).	Allowed values global web
Gift Card	Acts as a flag to identify whether a product should be treated as a gift card.	Allowed values TRUE FALSE Example: TRUE
Created at	Date of creation of the product in Shopify. When migrating from another store, this is always the time of migration.	Allowed values: Date & Time Example: 2024-12-17 18:20:07 +0200
Handle	URL-friendly version of a product’s title. URL address has a great impact on SEO, so be sure to give it a meaningful name. For the give URL, men's-t-shirts is the handle. https://thestore.com/collections/mens-t-shirts	Allowed values: Any characters Example: men's-t-shirts
Body(HTML)	Description created using HTML markup. This description gets displayed on the product page itself.	Allowed values: Text/HTML Example:<b>Description</b> <p>This is a demo description in paragraph format</p>
Type	User-added category in addition to those provided by Shopify.	Allowed values: Text
Status	Indicates whether the product is in active, archived or draft mode.	Allowed values: Active Archived Draft
Published At	Indicates whether the product is in active, archived, or draft mode.	Allowed values: Date & Time Example: 2024-12-17 18:20:07 +0200
Template Suffix	Template Suffix allows you to use an existing template from your theme for this specific collection. The name of the template will be used here.	Allowed values: Text Example: Shirts
URL	Product page URL	Allowed values: Text
Updated At	Timestamp of the last modification made to the collection.	Allowed values: Date & Time Example: 2024-12-17 18:20:07 +0200

Product categories are groupings of similar products within a store that share characteristics. The category-related product columns are:

Product Fields	Explanation	Allowed values / Examples
Category ID	ID for the category of product.	Allowed values: Number Example: 232
Category	Full path of the Shopify product category.	Allowed values: Text Example: Clothing > Tops & T-shirts

Collections are virtual groupings of products within your Shopify store. They act like curated sections on your online store, allowing you to showcase specific sets of products based on various criteria. The collections-related product columns are:

Column	Explanation	Allowed values / Examples
Custom collections	Comma-separated list of custom collections where the product is appearing.	Allowed values: Text Example: daily-picks, bestsellers
Smart collections	Comma-separated list of smart collections where the product is appearing.	Allowed values: Text Example: red-t-shirts, discounted-items

A product can have multiple variations, which represent different versions of the same product based on options like size or color. You can import and export both the main product and all its variants.

Note that Shopify allows a maximum of 100 variants per product.

To add variants to a product during import, simply include an additional row for each variant in your spreadsheet. The system identifies these variants as belonging to the same product by matching the ID, handle, or title (whichever appears first) in the spreadsheet. All other product information columns (excluding variant-specific details) are ignored for these variant rows. This means you can leave them blank or conveniently copy the information from the main product row above. In essence, you don’t need to erase existing product details when copying rows for variants.

Column	Explanation	Allowed values / Examples
Variant Inventory Item ID	Unique identifier for each variant across all locations within your store.	Allowed values: Number Example: 232
Variant ID	Identify variants within the context of a single product. Variant ID is a product-specific code for variants, while Variant Inventory Item ID takes a broader view, acting as a unique identifier across all your Shopify locations.	Allowed values: Number Example: 5
Option1 Name	Name of the first product option used to define variants. If the importing product doesn’t have any variants, set the value to Title.	Allowed values: Text Example: Color
Option1 Value	Option1 Name defines the type of variation (e.g., Size, Color, Material). Option1 Value specifies the actual choices within that option (e.g., Small, Medium, Large for Size; Red, Blue, Green for Color). If the importing product doesn’t have any variants, set the value to Default Title.	Allowed values: Text Example: Blue
Variant Position	Variant Position refers to the order in which variants appear on your product page and in the Shopify admin panel. You can control and update this order using the export and import functionalities.	Allowed values: Number Example: 5
Variant SKU	unique alphanumeric code assigned to each individual variant within a product. It acts as an internal identifier for tracking inventory and managing specific variations	Allowed values: Text Example: BDJN3434S
Variant Barcode	While Shopify doesn’t directly assign unique barcodes to each variant within a product, it does officially support using specific barcode types for products and potentially leveraging them for variant identification during updates. UPC (Universal Product Code): A common barcode standard used for identifying consumer products in North America. ISBN (International Standard Book Number): A specific barcode type used for identifying books internationally.	Allowed values: Text Example: 32322-43343
Variant Image	Link to variant image	Allowed values: Text Example: https://images.com/image.jpg
Variant Price	Refers to the specific price assigned to each individual variant of a product in Shopify. Since a product can have multiple variations (e.g., different sizes, and colors), each variant can have its own unique price.	Allowed values: Decimal Number Example: 5.42
Variant Weight	Refers to the specific weight assigned to each individual variant of a product. This becomes important when calculating shipping costs, which can vary depending on the weight of the item being shipped.	Allowed values: Decimal Number Example: 5.42
Variant Weight Unit	Refers to the unit of measurement you assign to the weight of each individual variant within a product.	Allowed values: g kg oz lb Example: kg
Variant Compare At Price	Refers to the original price you set for each individual variant of a product. This price is displayed alongside the actual selling price (variant price) to create the perception of a discount and potentially incentivize customers to purchase.	Allowed values: Decimal Number Example: 5.42
Variant Taxable	Whether a specific variant of a product is subject to sales tax or other relevant taxes.	Allowed values: TRUE / FALSE Example: TRUE
Variant Tax Code	Allow you to assign a specific tax code to each variant within a product. This tax code would then determine the tax rate applied to that particular variant at checkout.	Allowed values: Text Example: BDJN3434S
Variant Inventory Tracker	This column tells you which inventory tracking method Shopify uses to manage the stock levels for that particular variant within a product.	Allowed values: shopify <empty> <Handle-of-tracking-service> Example: shopify
Variant Inventory Policy	This policy helps you define what happens to the product listing and customer interactions when a specific variant is out of stock. Deny: Customers cannot add that variant to their cart and the “Add to Cart” button becomes unavailable. This prevents overselling and ensures accurate stock representation. Continue: Customers can still add the variant to their cart. This might be useful for backordered items or situations where you anticipate restocking soon.	Allowed values: deny / continue Example: deny
Variant Fulfillment Service	Refers to a third-party warehouse or fulfillment center that stores, packages, and ships specific variants within a product. This functionality allows you to delegate fulfillment tasks for certain variations while potentially managing others yourself.You can have several Fulfillment Services connected to your store, and each Variant can be linked with one of them.If you want to fulfill orders manually, you can enter the value manual, or you can specify the name of the service you are using.	Allowed values: manual<Handle-of-fulfilment-service> Example: deny
Variant Requires Shipping	Determines whether a specific variant within a product needs to be shipped to the customer or not	Allowed values: TRUE / FALSE Example: TRUE
Variant Inventory Qty	Refers to the actual number of units available in stock for a specific variant within a product	Allowed values: Number Example: 592
Variant Inventory Adjust	Refers to the concept of modifying the inventory quantity of a specific variant within a product. This adjustment can be done for various reasons, such as adding new stock, fulfilling orders, or correcting stock discrepancies. a negative number will subtract the inventory quantity and positive number will add new quantity.	Allowed values: Number Example: -32
Cost per item	The cost of this item from your supplier.	Allowed values: Decimal Number Example: 532.42

Column	Explanation	Allowed values / Examples
Variant HS Code	The general Harmonized System (HS) code for the Variant.	Allowed values: Number Example: 342232
Variant Country of Origin	Refers to the two-digit code for the country where a specific variant within a product was manufactured or substantially transformed	Allowed values: Country code Example: US
Variant Province of Origin	The two-digit code for the province where the Variant was made. Used only if the shipping provider for the inventory item is Canada Post.	Allowed values: Province Code Example: QC

Column	Explanation	Allowed values / Examples
Image Src	Link to the media file. This link must be publicly available and direct link so that Shopify is able to download file from it.	Allowed values: Publically available image urlImages Image format: All formats supported by Shopify Example: https://store.com/images.png
Image Position	This functionality allows you to control the order in which product images are displayed on your Shopify product page.	Allowed values: Number Example: 3
Image Width	The width of the image, in pixels.	Allowed values: Number Example: 3222
Image Height	The hight of the image, in pixels.	Allowed values: Number Example: 3
Image Alt Text	Image Alt Text, also referred to as alternative text or alt attribute, is a critical element in web accessibility and SEO (Search Engine Optimization) for images on your Shopify store. It provides a textual description of the image content.	Allowed values: Text Example: Description about the image

Multi-location inventory management is a system used by businesses that operate out of multiple physical locations, such as warehouses, stores, or fulfillment centers. It involves tracking and managing inventory levels across all these locations to ensure efficient order fulfillment, minimize stockouts, and optimize storage space.

Column	Explanation	Allowed values / Examples
Multi Location Inventory Available	Displays the available inventory quantity for each of your locations associated with that product variant.	Allowed values: Number Example: 321
Multi Location Inventory Adjust	Refers to the concept of modifying the inventory quantity for each of your locations associated with that product variant. This adjustment can be done for various reasons, such as adding new stock, fulfilling orders, or correcting stock discrepancies. a negative number will subtract the inventory quantity and positive number will add new quantity.	Allowed values: Number Example: -32

The Meta Field column in the Shopify export data refers to custom data you’ve added to your products, collections, orders, or customers. Shopify itself doesn’t have data fields for every specific detail you might want to track. Meta fields are a way for you to add your own custom fields to store that extra information.

When exporting products with variants, you can leverage meta fields to add custom data specifically tied to each variant. This enables you to manage variant-specific details efficiently.

If you’re migrating your store to a new platform, having your SEO data readily available can save time and ensure a smoother transition. You can import the data into the new platform and potentially maintain your existing SEO efforts.

Column	Explanation	Allowed values / Examples
SEO title	The SEO title you set for each product is what matters for search engines. This title is displayed in search results when someone searches for terms related to your product.	Allowed values: Text Example: Polo Shirt
SEO description	SEO descriptions, displayed in search results beneath the title, are crucial for product visibility.	Allowed values: Text Example: Description about the product.