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 CSVRequired Columns
The article gives you a peek into all the available columns. When you import a new CSV file to your store, make sure you’ve filled in at least the mentioned columns. Otherwise, the file won’t upload properly.
- Title
- ID
- Variable ID
- Handle
Basic columns
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:
|
| Published | Indicates whether the product is live and visible on your online store for customers to purchase. | Allowed values
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
|
| Gift Card | Acts as a flag to identify whether a product should be treated as a gift card. | Allowed values
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:
|
| 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 |
Category
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
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 |
Variants & Inventory
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.
| 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:
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 / FALSEExample: 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:
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.
| Allowed values:deny / continueExample: 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:
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 / FALSEExample: 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 |
Variant Custom Data
| 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 |
Image Data
| 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
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 |
Meta Filed
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.
Variant Meta Field
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.
SEO Data
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. |
