This reference provides an extensive list of attribute columns you can include into the CSV file to create and update your store catalog with import. Columns are grouped based on their type and have detailed formatting rules and requirements.
Learn more about the basics of building an import file →
Columns for products
Below is a list of columns you can use for rows that have “product” as their “type” column value.
The following columns are mandatory:
- To create new products, “product_name” is required.
- To update existing products, “product_sku” or “product_internal_id” is required.
To update products by their SKUs, you need to have unique product SKUs in your store. If you have non-unique or empty SKUs, you can only identify products by their ID.
All the other columns are optional. You can choose the ones you need for your import, but some columns may depend on each other (see the Description section for each column for more info).
See example CSV for a basic product →
| Column name | Description and what to write here | What if I make an error or leave the cell blank? |
| Mandatory columns | ||
| product_name | • Product name. • Any text you need (words, numbers, etc.), no longer than 255 symbols. |
If you're creating a new product and leave this cell blank, the product will not be created. |
| product_internal_id | • ID of your product. • A number without fractional parts. For example, "239904127". • Used while updating products that already exist in your catalog. • ID is generated when the product is created in your store. If you’re uploading a new product, you don’t know the ID yet, so you don’t need to specify it. |
• If you make an error in this cell, the whole row will be ignored (its data will not be imported). • You can leave the cell blank when updating a product if you specify its SKU. |
| product_sku | • Product SKU (“Stock Keeping Unit”), the code that identifies the product within your business. • Any text you need (words, numbers, etc.), no longer than 255 symbols. • For example, "NKBSMUS9". |
• When creating a product, you can leave this cell blank. • When updating a product, make sure you specify its ID if you don't specify its unique SKU. • If your store supports having empty SKUs and you leave this cell blank when updating a product, then existing product SKU (if any) will be reset to an empty value after import. |
| General product information | ||
| product_description | • The text of your product description. • Any text you need (words, numbers, etc.), no longer than 300 000 symbols. • If you import a description in HTML formatting, this formatting will be kept as is. If you import a description that has line breaks in your spreadsheet editor as plain text without HTML formatting, each line will be wrapped in <p></p> tags (visible if you view the description in the built-in text editor in the HTML mode in your store admin). |
If you leave this cell blank, product data will be imported without the description. If you update a product that already has a description, the existing description will be deleted. |
| product_price | • Product price. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • For example, "25" or "24.95". • You can add currency symbols, if you like, but prices will be displayed in the currency you chose for your store in Settings → General → Regional Settings. |
If you make an error in this cell or leave this cell blank, it will be ignored. Product price for new products will be set equal to "0". |
| product_media_main_image_url |
• URL path to the image that you want to be the main product media. Also used to add a custom preview image to the main product video. |
If you make an error in this cell or leave this cell blank, the image will not be added to the product. |
| product_media_gallery_image_url_{Image signifier} | • URL path to an image that you want to be the additional product media. Also used to add custom preview images to product videos with corresponding signifiers. • You can use URLs that start with http:// or https:// • Replace “{Image signifier}” in the column name with the signifier of the image. If you have several additional images for a product, use several columns for them. For example, product_media_gallery_image_url_1 and product_media_gallery_image_url_2. • The images will be sorted as they are numbered with signifiers (1, 2, 3, etc). • The image URL should lead directly to the image file, not to an HTML page that contains the image (e.g., http://example.com/images/product_1.jpg). • The image must be available online during import (not locked or deleted). • Product media data is rewritten after importing new media. When adding new video or image to an existing product, make sure you have all the pictures and videos listed in the file, even those that this product already has. If you need to replace all product media with new ones, simply upload a file with data on new images and videos for the product. |
If you make an error in this cell or leave this cell blank, the image will not be added to the product. |
| product_media_main_video_url | • URL path to the video that you want to be the main product media. • The URL should lead directly to the video page on YouTube, Instagram, Facebook, TikTok, Vimeo, or any other hosting. • You can use URLs that start with http:// or https:// • The video must be available online during and after import (not locked or deleted). • Product media data is rewritten after importing new media. When adding new video or image to an existing product, make sure you have all the pictures and videos listed in the file, even those that this product already has. If you need to replace all product media with new ones, simply upload a file with data on new images and videos for the product. |
If you make an error in this cell or leave this cell blank, the video will not be added to the product. |
| product_media_gallery_video_url_{Video signifier} | • URL path to a video that you want to be the additional product media. • You can use URLs that start with http:// or https:// • Replace “{Video signifier}” in the column name with the signifier of the video. If you have several additional videos for a product, use several columns for them. For example, product_media_gallery_video_url_1 and product_media_gallery_video_url_2. • The videos will be sorted as they are numbered with signifiers (1, 2, 3, etc). • The URL should lead directly to the video page on YouTube, Instagram, Facebook, TikTok, Vimeo, or any other hosting. • The video must be available online during and after import (not locked or deleted). • Product media data is rewritten after importing new media. When adding new video or image to an existing product, make sure you have all the pictures and videos listed in the file, even those that this product already has. If you need to replace all product media with new ones, simply upload a file with data on new images and videos for the product. |
If you make an error in this cell or leave this cell blank, the video will not be added to the product. |
| product_media_main_image_alt | • The alternative text that contains a description of your main product image. • Any text you need (words, numbers, etc.), no longer than 100 symbols. • You can only import alt text for an image if you also have a column with its URL in the import file. Also, make sure you have all the pictures, videos, and alt texts listed in the file, even those that this product already has. |
If you leave this cell blank, product media data will be imported without the alt text. If you update a product that already has alt text for an image, the existing text will be deleted. |
| product_media_gallery_image_alt_{Image signifier} | • The alternative text that contains a description of your additional product image. • Any text you need (words, numbers, etc.), no longer than 100 symbols. • Replace “{Image signifier}” in the column name with the signifier of the image. If you have several additional images for a product, use several columns for them. For example, product_media_gallery_image_alt_1 and product_media_gallery_image_alt_2. • You can only import alt text for an image if you also have a column with its URL in the import file. Also, make sure you have all the pictures, videos, and alt texts listed in the file, even those that this product already has. |
If you leave this cell blank, product media data will be imported without the alt text. If you update a product that already has alt text for an image, the existing text will be deleted. |
| product_is_available | • Product availability (whether the product is enabled). • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” |
If you make an error in this cell or leave this cell blank, it will be ignored. If you're importing a new product, it will be created as "Disabled". |
| product_weight | • Product weight. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • Please, do not enter units into the cell. • For example, "1.1" (and not "1.1 kg"). |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the value will be set to "0". |
| product_is_review_collection_enabled | • Whether reviews are enabled for this product. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” • You need to turn on the Product reviews toggle in Settings → General → Cart & Checkout to enable reviewing in your store. Otherwise, collecting reviews won't be available for any products. |
If you make an error in this cell or leave this cell blank, it will be ignored. Reviewing will not be enabled for your product (or, if you wanted to disable it, it will stay enabled). |
| Inventory and stock tracking | ||
| product_is_inventory_tracked | • Whether you use your online store to track the stock of this product. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the number of items left in stock will be set to "Unlimited". |
| product_quantity | • Quantity in stock for this product. • A number without fractional parts. • For example, "25". |
If you make an error in this cell or leave this cell blank, it will be ignored. If you use your online store to track the stock of this product, for new products, the number of items left in stock will be set to "0". |
| product_quantity_out_of_stock_behaviour | • Out of stock behavior for this product. • You can use one of these values: SHOW, HIDE, ALLOW_PREORDER |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, out of stock behavior will be set to your store's default out of stock behavior that you set in Settings → General → Cart & Checkout. |
| product_low_stock_notification_quantity | • The number of items left in stock at which you want to receive the Low Stock email that says you're running out of this product. • A number without fractional parts. |
If you make an error in this cell or leave this cell blank, it will be ignored. If you use your online store to track the stock of this product, for new products, the number of items left in stock at which you want to receive the Low Stock notice will be set to "1". |
| product_quantity_minimum_allowed_for_purchase | • Minimum order quantity limit for this product. • A number without fractional parts. • For example, "3". |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, minimum order quantity limit for this product will not be specified. |
| product_quantity_maximum_allowed_for_purchase | • Maximum order quantity limit for this product. • A number without fractional parts. • For example,"10". |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, maximum order quantity limit for this product will not be specified. |
| Product categories | ||
| product_is_featured | • Whether the product is featured on the store homepage. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” • If you use "no", your product must be assigned to some category other than Store front page. |
If you make an error in this cell or leave this cell blank, it will be ignored. A new product will not be featured (unless Store front page category is the only category it's assigned to). |
| product_is_featured_order_by | • Place of this featured product in the product list on the store homepage (as numbered starting from the left upper corner). • Used with the "product_is_featured" column. You need to mark the product as featured to be able to specify its position on the store homepage. • A number without fractional parts. • For example, "1" for the product that you want to go first and be on top of the store front page and "2" for the product that you want to go second. The bigger the number, the lower the place in the featured products list. • You need to choose Defined by store owner in the Default products sort order dropdown in Settings → General → Cart & Checkout for the sort order to be applied. |
If you make an error in this cell or leave this cell blank when importing catalog into an empty store, the cell will be ignored and its value will be set to "1". When adding new products to an existing catalog, they will be added to the end of the featured products list. |
| product_category_{Category signifier} | • Category where your product should be placed. • Any text you need (words, numbers, etc.), no longer than 255 symbols. • For example, Books/Science/Biology • Replace “{Category signifier}” in the column name with the signifier of the category (e.g., product_category_1). • If you have several categories for a product, use several columns for them. For example, product_category_1 and product_category_2. The first category will be the default category for this product. • If you don’t specify a category, the product will be added to the Store front page category. • If a product in your store already has a category, and you upload an import file that assigns it to another category (or categories), then the product will be removed from its previous category and placed into the new one(s) according to the import file. • If you want to remove an existing product from all its categories and add it to the Store front page category, you can import a file that has at least its product ID and product name columns along with an empty product_category_1 column. |
If you leave this cell blank, a new product will be added to the Store front page category. If you're updating an existing product that already has categories and you import a blank value, the product will be removed from all the categories except for the Store front page. |
| product_google_product_category_code | • The code of the marketplace category for this product (if you use your store to sell on marketplaces like Google Shopping). • A number without fractional parts. • You need to enter a valid Google product category code. • Marketplace category data becomes visible on the product page after you set up marketplace category for your store in Settings → General → Marketplace product settings. |
• If you make an error in this cell, it will be ignored. • If you leave this cell blank or enter "0", the category will be set to the default marketplace category that you've specified for your store. |
| Discounts and other pricing options | ||
| product_compare_to_price | • The price of your product before sale. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • For example, "35" or "34.95". • Current price during sale is set equal to the product price (you can use the "product_price" column to specify it). |
If you make an error in this cell or leave this cell blank, it will be ignored. |
| product_price_wholesale_quantity_{Range signifier} | • The number of items necessary for bulk discount. • A quantity range. You can enter closed intervals like “5-9” or open intervals like “10+” • Replace “{Range signifier}” in the column name with the signifier of the range (e.g., product_price_wholesale_quantity_1). • If you have several quantity intervals (e.g., 5-9 products cost $10, and 10+ products cost $7), use several columns for them. For example, product_price_wholesale_quantity_1 and product_price_wholesale_quantity_2 • If you want to import wholesale prices, you must specify a base price value in the "product_price" column. |
If you make an error in this cell or leave this cell blank, it will be ignored. The bulk discount data will not be imported. |
| product_price_wholesale_value_{Range signifier} | • Bulk discount pricing for this quantity of products. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • Replace “{Range signifier}” in the column name with the signifier of the range (e.g., product_price_wholesale_value_1) • If you have several quantity intervals (e.g., 5-9 products cost $10, and 10+ products cost $7), use several columns for them. For example, product_price_wholesale_value_1 and product_price_wholesale_value_2 |
If you make an error in this cell or leave this cell blank, it will be ignored. The bulk discount data will not be imported. |
| product_custom_price_enabled | • Whether Pay What You Want pricing is enabled for this product. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” • Minimum price is set equal to the product price (you can use the product_price column to specify it). |
If you make an error in this cell or leave this cell blank, it will be ignored. Pay What You Want pricing will not be enabled for your product (or, if you wanted to disable it, it will stay enabled). |
| product_custom_price_tier_{Tier signifier} | • Fixed price tiers for Pay What You Want pricing. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • Replace “{Tier signifier}” in the column name with the signifier of the fixed price tier (e.g., product_custom_price_tier_1) • If you have several fixed price tiers, use several columns for them. For example, product_custom_price_tier_1 and product_custom_price_tier_2 • The order of tiers will be set according to the order of columns in your import file. |
• If you make an error in this cell or leave this cell blank, it will be ignored. For products that have no valid price tiers, there will be only the minimum price value. • If a price tier value is lower than the minimum price value, it will not be displayed on the storefront. |
| product_lowest_price | • The lowest price for this product during the last 30 days (including any previously reduced price you announced as a promotion). • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • For example, "35" or "34.95". • Not visible on the product page unless you also set the "Compare to" price. |
If you make an error in this cell or leave this cell blank: • When updating existing products, it will be ignored. • When creating new products, the lowest price will be set equal to the product price or to the "Compare to" price (if it's specified). |
| Product types and attributes | ||
| product_brand | • The “Brand” attribute for your product. • Any text you need (words, numbers, etc.), no longer than 400 symbols. |
If you leave this cell blank, product data will be imported without the brand value. If you update a product that already has a brand value, the existing value will be deleted along with all its translations. |
| product_upc | • The UPC (EAN) attribute for your product. • Any text you need (words, numbers, etc.), no longer than 400 symbols. |
If you leave this cell blank, product data will be imported without the UPC (EAN) attribute value. If you update a product that already has a UPC (EAN) attribute value, the existing value will be deleted along with all its translations. |
| product_attribute_{Attribute name} | • Any custom product attribute (if you use additional product attributes in your store). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • Replace “{Attribute name}” in the column title with the name of your attribute (e.g., product_attribute_Country) • If the name of your attribute contains special symbols or consists of several words, it’s best to put it in curly brackets (e.g., product_attribute_{Country of origin}) |
If you leave this cell blank, product data will be imported without the custom attribute value. If you update a product that already has a custom attribute value, the existing value will be deleted along with all its translations. |
| product_class_id | • Product type (if you use additional product types for attributes in your store). • A number without fractional parts. • For General type, use “0”. • To get IDs of other product types, go to Settings → Product types and click on the type in the list. You’ll see a text in the browser’s address bar, where the numbers after id are what you need. E. g., #product-classes:id=53164002 |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, product type will be set to General. |
| product_units_in_product | • How many units come in a product (if you use price per unit). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • You need to enable the Show price per unit toggle in Settings → General → Cart & Checkout for this data to become visible on the product page. |
If you leave this cell blank, product data will be imported without the "how many units in product" value. If you update a product that already has a "how many units in product" value, the existing value will be deleted along with all its translations. |
| product_price_per_unit | • Price per unit of your product (if you use it). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • You need to enable the Show price per unit toggle in Settings → General → Cart & Checkout for this data to become visible on the product page. |
If you leave this cell blank, product data will be imported without the "price per unit" value. If you update a product that already has a "price per unit" value, the existing value will be deleted along with all its translations. |
| product_cost_price | • The “Cost price” attribute for your product. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • You need to enable the Cost price toggle in Settings → General → Cart & Checkout for this data to become visible on the product page. |
If you make an error in this cell or leave this cell blank, it will be ignored. |
| Shipping, delivery, and pickup | ||
| product_is_shipping_required | • Whether this product requires shipping or pickup. • true, True, yes, Yes, y — for “yes" • false, False, no, No, n — for “no” |
If you make an error in this cell or leave this cell blank, it will be ignored. New products will be uploaded as "requiring shipping". |
| product_length | • Product length for shipping calculation (if you use real-time rates from carriers in your store). • A number with or without fractional parts. • Fractional parts can be separated by a dot or a comma. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the value will be set to "0". |
| product_width | • Product width for shipping calculation (if you use real-time rates from carriers in your store). • A number with or without fractional parts. • Fractional parts can be separated by a dot or a comma. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the value will be set to "0". |
| product_height | • Product height for shipping calculation (if you use real-time rates from carriers in your store). • A number with or without fractional parts. • Fractional parts can be separated by a dot or a comma. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the value will be set to "0". |
| product_shipping_type | • Indicates that product-specific shipping rate of method of a certain type is used for this product. • You can use one of these values: GLOBAL_METHODS, SELECTED_METHODS, FLAT_RATE, FREE_SHIPPING |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, your store’s shipping methods (GLOBAL_METHODS) will be used. |
| product_shipping_white_list | • Shipping methods that are enabled for this product (if you want to apply product-specific shipping). • Used with SELECTED_METHODS shipping type. • A list of numbers without fractional parts. Values can be divided by a comma or semicolon. • To find the ID of the shipping method, click on that shipping method on the Shipping & Pickup page and copy the ID from the browser’s address bar. E.g., id=18985-1641926916646 |
If you make an error in this cell or leave this cell blank, it will be ignored. No new methods will be added to the list of enabled shipping methods. |
| product_shipping_black_list | • Shipping methods that are disabled for this product (if you want to apply product-specific shipping). • Used with SELECTED_METHODS shipping type. • A list of numbers without fractional parts. Values can be divided by a comma or semicolon. • To find the ID of the shipping method, click on that shipping method on the Shipping & Pickup page and copy the ID from the browser’s address bar. E.g., id=18985-1641926916646 |
If you make an error in this cell or leave this cell blank, it will be ignored. No new methods will be added to the list of disabled shipping methods. |
| product_shipping_fixed_rate | • Fixed rate per item value (if you want to apply product-specific shipping to this product). • Used with FLAT_RATE shipping type. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • For example, "5" or "5.5". |
If you make an error in this cell or leave this cell blank, it will be ignored. If you have FLAT_RATE shipping type, the rate will be set to "0". |
| product_shipping_method_markup | • Fixed fee per item value that is added to the cost of the shipping methods used in your store (if you want to apply product-specific shipping to this product). • Used with GLOBAL_METHODS shipping type. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • For example, "5" or "5.5". |
If you make an error in this cell or leave this cell blank, it will be ignored. The product will have no shipping markup. |
| product_shipping_preparation_time_for_shipping_in_days | • Order preparation time for shipping for this product. • A number without fractional parts or a quantity range. • Preparation time is entered in days. For example, "10" or "10-12". • You need to set up your shipping methods in Shipping & Pickup for this data to become visible on the product page. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, preparation time will be set according to your store's shipping methods. |
| product_shipping_preparation_time_for_local_delivery_in_minutes | • Order preparation time for local delivery for this product. • A number without fractional parts. • Preparation time is entered in minutes. For example, "120" (for 2 hours) or "1440" (for 1 day). If the product is available for local delivery right away, enter "0". • You need to set up your local delivery methods in Shipping & Pickup for this data to become visible on the product page. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, preparation time will be set according to your store's local delivery methods. |
| product_shipping_preparation_time_for_pickup_in_minutes | • Order preparation time for pickup for this product. • A number without fractional parts. • Preparation time is entered in minutes. For example, "120" (for 2 hours) or "1440" (for 1 day). If the product is available for pickup right away, enter "0". • You need to set up your pickup methods in Shipping & Pickup for this data to become visible on the product page. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, preparation time will be set according to your store's pickup methods. |
| product_shipping_preparation_time_for_preorders_in_days | • Order preparation time for this product when it's available for pre-orders. • A number without fractional parts or a quantity range. • Preparation time for shipping or pickup is entered in days. For example, "10" or "10-12". • You need to set up your shipping/pickup methods in Shipping&Pickup and make the product available for pre-orders for this data to become visible on the product page. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, preparation time for pre-orders will not be precified. |
| product_shipping_show_delivery_date_on_the_product_page | • Whether estimated delivery time is shown on the product page. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” • You need to set up your shipping/pickup methods in Shipping & Pickup for this data to become visible on the product page. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, estimated delivery time will not be showed on the product page. |
| SEO | ||
| product_seo_title | • Custom SEO field, meta title tag. • Any text you need (words, numbers, etc.), no longer than 8192 symbols. • It’s recommended to have SEO title no longer than 80 symbols. • This data will appear in the SEO tab of the product details page in your store admin. |
If you leave this cell blank, it will be ignored. If you update a product that already has a meta title tag, the tag will be reset to the product's name. |
| product_seo_description | • Custom SEO field, meta description tag. • Any text you need (words, numbers, etc.), no longer than 8192 symbols. • It’s recommended to have SEO description no longer than 160 symbols. • This data will appear in the SEO tab of the product details page in your store admin. |
If you leave this cell blank, it will be ignored. If you update a product that already has a meta description tag, the tag will be reset to the product's description. |
| url | • URL of the product in your storefront • Appears in catalog export files for products that already exist in your store • Not supported in catalog import as currently you cannot set product URLs in your store |
Any values will be ignored. |
| Related products | ||
| product_related_item_ids | • Specific related products that you want to assign to this product. • A list of numbers without fractional parts. Values can be divided by a comma or semicolon. • In the list, add IDs of specific products that already exist in your store and that you want to assign to this product as related. |
• If you leave this cell blank, it will be ignored. |
| product_related_item_skus | • Specific related products that you want to assign to this product. • Any text you need (words, numbers, etc.), no longer than 255 symbols. Values can be divided by a comma or semicolon. • In the list, add SKUs of specific products that you want to assign to this product as related. |
• If you leave this cell blank, it will be ignored. |
| product_related_items_random | • Whether you want to display random products as related. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” |
If you make an error in this cell or leave this cell blank, it will be ignored. After import, the product will not have random related products. |
| product_related_items_random_number_of_items | • The number of random products that you want to assign to this product as related. • A number without fractional parts. • For example, “4”. |
If you make an error in this cell or leave this cell blank, it will be ignored. If you have a category for your random products specified, the number of products will be set to "0". |
| product_related_items_random_category | • Product category from which related products are assigned. • Any text you need (words, numbers, etc.), no longer than 255 symbols. • Enter full path to the product category in your store (e.g., Books/Science/Biology). If this category does not exist yet, it will be created after import. • If you want to check “All products” for the category, leave the cell blank. |
If you leave this cell blank, related products will be added from all your catalog. |
| Ribbons and subtitles | ||
| product_ribbon_text | • The text of your product ribbon. • Any text you need (words, numbers, etc.), no longer than 30 symbols. |
If you leave this cell blank, it will be ignored. If you update a product that already has a ribbon, the existing ribbon text will be deleted. |
| product_ribbon_color | • The color of your product ribbon. • Any 7-symbol color code you need. • You need to enter a valid color code. For example, "#F50837". |
If you make an error in this cell or leave this cell blank, it will be ignored. The ribbon color will be set to #FE9800/"orange". |
| product_subtitle | • The text of your product subtitle. • Any text you need (words, numbers, etc.), no longer than 128 symbols. |
If you leave this cell blank, it will be ignored. If you update a product that already has a subtitle, the subtitle text will be deleted. |
| Recurring subscriptions | ||
| product_subscription_enabled | • Whether Recurring subscriptions are enabled for this product. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” • Subscription price ("Billed every month") is set equal to the product price. You can use the "product_price" column to specify it. |
If you make an error in this cell or leave this cell blank, it will be ignored. Subscription pricing will not be enabled for your product (or, if you wanted to disable it, it will stay enabled). |
| product_subscription_one_time_purchase_enabled | • Whether one-time purchase is enabled for this product. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” |
If you make an error in this cell or leave this cell blank, it will be ignored. One-time purchase will not be enabled for this product. |
| product_subscription_one_time_purchase_price | • One-time purchase price for this product. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • For example, "5" or "5.5". |
If you make an error in this cell or leave this cell blank, it will be ignored. |
| product_subscription_price_with_signup_fee | • Price for the first order on subscription (including the subscription fee). • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • If you enable one-time purchase for a product, data on the price for the first order on subscription will not be applied in your store admin after you import it. |
If you make an error in this cell or leave this cell blank, it will be ignored. |
| product_subscription_recurring_interval | • Whether intervals between subscription charges are years, months, weeks, or days. • You can use one of these values: DAY, WEEK, MONTH, YEAR • You can use only those periods that currently exist in the store admin: Once per day, once per week, once per 2 weeks, once per month, once per 3 months, once per year. For example, for "once per day" you need to enter "DAY". |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the subscription interval will be set to once per month. |
| product_subscription_recurring_interval_count | • The number of years, months, weeks, or days between charges. • A number without fractional parts. • You can use only those periods that currently exist in the store admin: Once per day, once per week, once per 2 weeks, once per month, once per 3 months, once per year. For example, for "once per day" you need to enter "1". |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the subscription interval will be set to once per month. |
| Taxes | ||
| product_taxable | • Whether this product should be taxed. • true, True, yes, Yes, y — to mark product as taxable |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the value will be set to "true". |
| product_enabled_manual_taxes | • Manual tax rate(s) that should be applied to this product. • A list of numbers without fractional parts. Values can be divided by a comma or semicolon. • For this field, you will need unique internal IDs of the tax rates that should be applied to this product. To find the tax rate ID(s), export a product that has the corresponding tax rate(s) assigned to it. • Use "all" or "ALL" to enable all the manual taxes that exist in your store for a product. |
If you make an error in this cell, all its contents will be ignored. All the manual taxes that exist in your store will be enabled for a product. If you leave this cell blank, all the manual taxes for a product will be disabled. If you are updating an existing product and don't use this column in your import, manual taxes for this product won't change. |
| product_tax_class_code | • The code of the tax rate for this product (if you're using automatic taxes). • Any text you need (words, numbers, etc.), no longer than 17 symbols. • You need to enter a valid tax class code. For example, "default". • To find the tax rate code you need, export a product that has the corresponding tax rate assigned to it or see the list of tax rate codes. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new products, the tax class code value will be set to the standard tax rate of your store’s region ("default"). |
| Multilingual storefront | ||
| product_name_{Language code} | • Product name in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 255 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_name_fr |
If you leave this cell blank, product name in the additional language will not be imported. If you update a product that already has a name in the additional language, the existing name will be deleted. |
| product_description_{Language code} | • The text of your product description in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 300 000 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_description_fr • If you import a description in HTML formatting, this formatting will be kept as is. If you import a description that has line breaks in your spreadsheet editor as plain text without HTML formatting, each line will be wrapped in <p></p> tags (visible if you view the description in the built-in text editor in the HTML mode in your store admin). |
If you leave this cell blank, product description in the additional language will not be imported. If you update a product that already has a description in the additional language, the existing description will be deleted. |
| product_ribbon_text_{Language code} | • The text of your product ribbon in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 30 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_ribbon_text_fr |
If you leave this cell blank, product ribbon text in the additional language will not be imported. If you update a product that already has product ribbon text in the additional language, the existing ribbon text will be deleted. |
| product_subtitle_{Language code} | • The text of your product subtitle in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 128 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_subtitle_fr |
If you leave this cell blank, product subtitle in the additional language will not be imported. If you update a product that already has a subtitle in the additional language, the existing subtitle will be deleted. |
| product_brand_{Language code} | • The “Brand” attribute for your product in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_brand_fr |
If you leave this cell blank, product data will be imported without the brand value in the additional language. If you update a product that already has a brand value in the additional language, the existing value will be deleted. |
| product_upc_{Language code} | • The UPC (EAN) attribute for your product in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_upc_fr |
If you leave this cell blank, product data will be imported without the UPC (EAN) attribute value in the additional language. If you update a product that already has a UPC (EAN) attribute value in the additional language, the existing value will be deleted. |
| product_attribute_{Attribute name}_{Language code} | • Any custom product attribute in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • Replace “{Attribute name}” in the column title with the name of your attribute (e.g., product_attribute_Country) • If the name of your attribute contains special symbols or consists of several words, it’s best to put it in curly brackets (e.g., product_attribute_{Country of origin}) • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_attribute_{Country of origin}_fr |
If you leave this cell blank, product data will be imported without the custom attribute value in the additional language. If you update a product that already has a custom attribute value in the additional language, the existing value will be deleted. |
| product_units_in_product_{Language code} | • How many units come in a product in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • You need to enable the Show price per unit toggle in Settings → General → Cart & Checkout for this data to become visible on the product page. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_units_in_product_fr |
If you leave this cell blank, product data will be imported without the how many units in product" value in the additional language." If you update a product that already has a "how many units in product" value in the additional language, the existing value will be deleted. |
| product_price_per_unit_{Language code} | • Price per unit of your product in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 400 symbols. • You need to enable the Show price per unit toggle in Settings → General → Cart & Checkout for this data to become visible on the product page. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_price_per_unit_fr |
If you leave this cell blank, product data will be imported without the "price per unit" value in the additional language. If you update a product that already has a "price per unit" value in the additional language, the existing value will be deleted. |
| product_seo_title_{Language code} | • Custom SEO field, meta title tag, in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 8192 symbols. • It’s recommended to have SEO title no longer than 80 symbols. • This data will appear in the SEO tab of the product details page in your store admin. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_seo_title_fr |
If you leave this cell blank, it will be ignored. If you update a product that already has a meta title tag in the additional language, the existing value will be deleted. |
| product_seo_description_{Language code} | • Custom SEO field, meta description tag in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 8192 symbols. • It’s recommended to have SEO description no longer than 160 symbols. • This data will appear in the SEO tab of the product details page in your store admin. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_seo_description_fr |
If you leave this cell blank, it will be ignored. If you update a product that already has a meta description tag in the additional language, the existing value will be deleted. |
| product_media_main_image_alt_{language code} | • The alternative text that contains a description of your main product image, in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 100 symbols. • You can only import alt text for an image if you also have a column with its URL in the import file. Also, make sure you have all the pictures, videos, and alt texts listed in the file, even those that this product already has. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_media_main_image_alt_fr |
If you leave this cell blank, product media data will be imported without the alt text translation. If you update a product that already has alt text translation for an image, the existing translation will be deleted. |
| product_media_gallery_translated_image_alt_{Image signifier}_{Language code} | • The alternative text that contains a description of your additional product image, in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 100 symbols. • Replace “{Image signifier}” in the column name with the signifier of the image. If you have several additional images for a product, use several columns for them. • You can only import alt text for an image if you also have a column with its URL in the import file. Also, make sure you have all the pictures, videos, and alt texts listed in the file, even those that this product already has. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_media_gallery_translated_image_alt_1_fr |
If you leave this cell blank, product media data will be imported without the alt text translation. If you update a product that already has alt text translation for an image, the existing translation will be deleted. |
| Store identifier | ||
| source_store_id | • Appears in catalog export files to identify the store from which the data was exported • When importing the file you've exported from store A into store B, keep the column with store A's ID so that the information is interpreted correctly during import • You can skip this column when re-importing the file you've exported from store A into store A |
If you import the file you've exported from store A into store B and keep the column with store A's ID, errors in the "product_internal_id" and "product_class_id" cells are expected. You can proceed with importing the file. |
Columns for product options and input fields
Below is a list of columns you can use for rows that have “product_option” as their “type” column value.
The following columns are mandatory:
- “product_option_name”;
- “product_internal_id” or “product_sku” of the product this option or input field belongs to.
All the other columns are optional. You can choose the ones you need for your import, but some columns may depend on each other (see the Description section for each column for more info).
Product option and input field data is rewritten after import, so make sure you include all the options and fields your product must have in the CSV, even those that already exist in your store.
See example CSV for a product with options →
| Column name | Description and what to write here | What if I make an error or leave the cell blank? |
| product_internal_id | • ID of the product this option or input field belongs to. • A number without fractional parts. For example, "239904127". • Used for adding options or fields to products that already exist in your store. • ID is generated when the product is created in your store. If you’re uploading a new product with options or fields, you don’t know the ID yet, so you don’t need to specify it. |
• You can leave this cell blank if you specify product SKU. • If you make an error in this cell, the whole row will be ignored (its data will not be imported). • If by mistake you enter an ID of a product that does not exist in your store, importing will be completed, but the option/field value specified in this row will not be added. |
| product_sku | • SKU (“Stock Keeping Unit”) of the product this option or input field belongs to. • Any text you need (words, numbers, etc.), no longer than 255 symbols. • For example, "NKBSMUS9". |
• You can leave this cell blank if you specify product ID. • If by mistake you enter an SKU of a product that does not exist in your store, importing will be completed, but the option/field value specified in this row will not be added (unless you've also specified a correct product ID). |
| product_option_name | • The name of your product option or input field. • Any text you need (words, numbers, etc.), no longer than 100 symbols. • For example, “Size”. |
If you leave this cell blank, it will be ignored. The option or input field will not be added to the product. |
| product_option_type | • The type of your option or input field. • You can use one of these values: DROPDOWNLIST, RADIOBUTTONS, CHECKBOXES, TEXTAREA, TEXTINPUT, DATEPICKER, UPLOADFILES, SIZE |
If you make an error in this cell or leave this cell blank, the option or input field value will not be added to the product. |
| product_option_value |
• Value of your option. |
• If you leave this cell blank for DROPDOWNLIST, RADIOBUTTONS, CHECKBOXES, or SIZE, the cell will be ignored. Option data will not be added to the product as these option types must have preset values to choose from. • You can leave this cell blank for TEXTAREA, TEXTINPUT, DATEPICKER, or UPLOADFILES (input fields don't have preset values). |
| product_option_markup | • Value of the price modifier. • A number with or without fractional parts. Fractional parts can be separated by a dot or a comma. • To adjust the price as an absolute value (e.g., $30), you can use numbers like “+30” or “30”. To make the price lower, use “-30”. • To adjust the price as a percentage, you can use numbers like “+30%”, “30%”, or “-30%”. |
If you make an error in this cell or leave this cell blank, it will be ignored. No price modifier will be added. |
| product_option_is_default_option_selection | • Whether this option value is pre-selected on the product page. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” • Checkboxes, text fields, text areas, date picker, and file upload don’t have pre-selected values, so you can leave this field empty for them. |
If you make an error in this cell or leave this cell blank, it will be ignored. |
| product_option_is_required | • Whether an option value or input field is required to be selected/filled out by the customer on the product page. • true, True, yes, Yes, y — if you want this option to be required. • false, False, no, No, n — if you don’t want this option to be required (for example, this option has a pre-selected value). • Checkboxes can't be marked as required. |
If you make an error in this cell or leave this cell blank, it will be ignored. The option or input field will not be marked as required. |
| product_option_name_{Language code} | • The name of your product option or input field in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 100 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_option_name_fr |
If you leave this cell blank, option or input field name in the additional language will not be imported. |
| product_option_value_{Language code} | • Value of your option in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 200 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, product_option_value_fr |
If you leave this cell blank, product option value in the additional language will not be imported. |
| source_store_id | • Appears in catalog export files to identify the store from which the data was exported • When importing the file you've exported from store A into store B, keep the column with store A's ID so that the information is interpreted correctly during import • You can skip this column when re-importing the file you've exported from store A into store A |
If you import the file you've exported from store A into store B and keep the column with store A's ID, the error in the "product_internal_id" cell is expected. You can proceed with importing the file. |
Columns for product variations
Below is a list of columns you can use for rows that have “product_variation” as their “type” column value.
The following columns are mandatory:
- “product_variation_option_{Option name}”;
- “product_internal_id” or “product_sku” of the product this variation belongs to.
All the other columns are optional. You can choose the ones you need for your import, but some columns may depend on each other (see the Description section for each column for more info).
Product variation data is rewritten after import, so make sure you include all the options and variations your product must have in the CSV, even those that already exist in your store.
See example CSV for a product with options and variations →
| Column name | Description and what to write here | What if I make an error or leave the cell blank? |
| product_internal_id |
• ID of the product this variation belongs to. |
• You can leave this cell blank if you specify product SKU. |
| product_sku |
• SKU (“Stock Keeping Unit”) of the product this variation belongs to. |
• You can leave this cell blank if your product does not have an SKU, but make sure you specify product ID. |
| product_variation_option_{Option name} |
• Values of the options that form your variation. |
If you leave this cell blank, importing will be completed, but variation data will not be added to any of the store products. |
| product_variation_sku |
• SKU of this product variation (if you want to specify an individual SKU for it). |
If you leave this cell blank, the variation SKU will either be set equal to the base product SKU or empty (if your store supports having empty SKUs). |
| product_price |
• Price of this particular product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, variation price will be set equal to the base product price. The bulk discount data (if present in the file) will also be ignored for this variation. |
| product_media_main_image_url |
• URL path to an image that you want to assign to this variation. |
If you make an error in this cell or leave this cell blank, the image will not be added to the variation. |
| product_media_main_image_alt |
• The alternative text that contains a description of your product variation image. |
If you leave this cell blank, product variation data will be imported without the image alt text. |
| product_media_main_image_alt_{language code} |
• The alternative text that contains a description of your product variation image, in the additional language (if you’re using multiple languages in your store). |
If you leave this cell blank, product variation data will be imported without the image alt text translation. |
| product_is_shipping_required |
• If this product variation requires shipping or pickup. |
If you make an error in this cell or leave this cell blank, it will be ignored. New variations will be imported as “requiring shipping”. |
| product_upc |
• A UPC (EAN) attribute for this product variation. |
If you leave this cell blank, variation data will be imported without the UPC (EAN) attribute value. If you update a variation that already has a UPC (EAN) attribute value, the existing value will be deleted. |
| product_brand |
• The “Brand” attribute for this product variation. |
If you leave this cell blank, variation data will be imported without the brand value. If you update a variation that already has a brand value, the existing value will be deleted along with all its translations. |
| product_brand_{Language code} |
• The “Brand” attribute for this product variation in the additional language (if you’re using multiple languages in your store). |
If you leave this cell blank, variation data will be imported without the brand value in the additional language. If you update a variation that already has a brand value in the additional language, the existing value will be deleted. |
| product_weight |
• Weight of this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, variation weight will be the same as the base product weight. |
| product_length |
• Product variation length for shipping calculation (if you use real-time rates from carriers in your store). |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, variation length will be the same as the base product length. |
| product_width |
• Product variation width for shipping calculation (if you use real-time rates from carriers in your store). |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, variation width will be the same as the base product width. |
| product_height |
• Product variation height for shipping calculation (if you use real-time rates from carriers in your store). |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, variation height will be the same as the base product height. |
| product_is_inventory_tracked |
• Whether you use your online store to track stock of this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, the number of items left in stock will be set to "Unlimited". |
| product_quantity |
• Quantity in stock for this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. If you use your online store to track the stock of this product variation, for new variations, the number of items left in stock will be set to "0". |
| product_quantity_out_of_stock_behaviour |
• Out of stock behavior for this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new variations, out of stock behavior will be set to your store's default out of stock behavior that you set in Settings → General → Cart & Checkout. |
| product_low_stock_notification_quantity |
• The number of items left in stock at which you want to receive the Low Stock email that says you're running out of this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. If you use your online store to track the stock of this product variation, for new variations, the number of items left in stock at which you want to receive the Low Stock notice will be set to "1". |
| product_quantity_minimum_allowed_for_purchase |
• Minimum order quantity limit for this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new product variations, minimum order quantity limit will not be specified. |
| product_quantity_maximum_allowed_for_purchase |
• Maximum order quantity limit for this product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new product variations, maximum order quantity limit will not be specified. |
| product_compare_to_price |
• The price of this product variation before sale. |
If you make an error in this cell or leave this cell blank, it will be ignored. |
| product_lowest_price |
• The lowest price for this product variation during the last 30 days (including any previously reduced price you announced as a promotion). |
If you make an error in this cell or leave this cell blank, it will be ignored. For new product variations, the lowest price will be set equal to the variation price or to the "Compare to" price (if it's specified). |
| product_price_wholesale_quantity_{Range signifier} |
• The number of items necessary for bulk discount. |
If you make an error in this cell or leave this cell blank, it will be ignored. The bulk discount data will not be imported. |
| product_price_wholesale_value_{Range signifier} |
• Bulk discount pricing for this particular product variation. |
If you make an error in this cell or leave this cell blank, it will be ignored. The bulk discount data will not be imported. |
| product_units_in_product |
• How many units come in a product variation (if you use price per unit). |
If you leave this cell blank, variation data will be imported without the "how many units in product" value. If you update a variation that already has a "how many units in product" value, the existing value will be deleted. |
| product_price_per_unit |
• Price per unit of your product variation (if you use it). |
If you leave this cell blank, variation data will be imported without the "price per unit" value. If you update a variation that already has a "price per unit" value, the existing value will be deleted. |
| source_store_id |
• Appears in catalog export files to identify the store from which the data was exported |
If you import the file you've exported from store A into store B and keep the column with store A's ID, the error in the "product_internal_id" cell is expected. You can proceed with importing the file. |
Columns for product files
Below is a list of columns you can use for rows that have “product_file” as their “type” column value.
The following columns are mandatory:
- “product_file_secret_url”;
- “product_file_filename”;
- “product_internal_id” or “product_sku” of the product this file belongs to.
The "product_file_description" column is optional.
Product file data is rewritten after import, so make sure you include all the files your product must have in the CSV, even those that already exist in your store.
See example CSV for a product with files →
| Column name | Description and what to write here | What if I make an error or leave the cell blank? |
| product_internal_id | • ID of the product this file belongs to. • A number without fractional parts. For example, "239904127". • Used for adding files to products that already exist in your store. • ID is generated when the product is created in your store. If you’re uploading a new product with files, you don’t know the ID yet, so you don’t need to specify it. |
• You can leave this cell blank if you specify product SKU. • If you make an error in this cell, the whole row will be ignored (its data will not be imported). • If by mistake you enter an ID of a product that does not exist in your store, the import will be completed, but the file will not be added. |
| product_sku | • SKU (“Stock Keeping Unit”) of the product the file belongs to. • Any text you need (words, numbers, etc.), no longer than 255 symbols. • For example, "NKBSMUS9". |
• You can leave this cell blank if you specify product ID. • If by mistake you enter an SKU of a product that does not exist in your store, importing will be completed, but the file will not be added (unless you've also specified a correct product ID). |
| product_file_secret_url | • URL path to your file on the Internet. • You can use URLs that start with http:// or https:// • The URL should lead directly to the file, not to an HTML page that contains it (e.g., http://example.com/files/product_1.mp3). • The file must be available online during import (not locked or deleted). • To import product files that belong to one store into another store, you will need to manually add an access token to the file URL. Otherwise, you'll get an error. |
If you make an error in this cell or leave this cell blank, importing can be completed, but the file will not be added to the product. |
| product_file_filename | • Name of the file in your store. • Any text you need (words, numbers, etc.), no longer than 100 symbols. • This will be the file name in the URL when customers download your file. This will also be the file name that you see in the Files tab in your store admin. |
If you leave this cell blank, importing can be completed, but no files will be added to the product. |
| product_file_description | • A short description of the uploaded file. • Any text you need (words, numbers, etc.), no longer than 200 symbols. • This will be the text on the link when customers download the file. This will also be the file description that you see in the Files tab in your store admin. |
If you leave this cell blank, file data will be imported without the file description. |
| source_store_id | • Appears in catalog export files to identify the store from which the data was exported • When importing the file you've exported from store A into store B, keep the column with store A's ID so that the information is interpreted correctly during import • You can skip this column when re-importing the file you've exported from store A into store A |
If you import the file you've exported from store A into store B and keep the column with store A's ID, the error in the "product_internal_id" cell is expected. You can proceed with importing the file. |
Columns for store categories
Below is a list of columns you can use for rows that have “category” as their “type” column value.
The following columns are mandatory:
- To create new categories, “category_path” is required.
- To update existing categories, “category_path” or “category_internal_id” is required.
All the other columns are optional.
See example CSV for store categories →
| Column name | Description and what to write here | What if I make an error or leave the cell blank? |
| category_internal_id | • ID of your product category. • A number without fractional parts. For example, "120581513". • Used for updating categories that already exist in your store. • ID is generated when the category is created in your store. If you’re uploading a new category, you don’t know the ID yet, so you don’t need to specify it. |
If you make an error in this cell, the whole row will be ignored. |
| category_path | • Path to the category. • Any text you need (words, numbers, etc.), no longer than 255 symbols. • For example, Books/Biology, where a category named Biology is placed inside the root Books category. • For root categories, category path corresponds to category name. |
If you leave this cell empty, it will be ignored. If you're creating a new category, in this case it will not be created. |
| category_name_{Language code} | • Name of the category in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 255 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, category_name_fr |
If you leave this cell blank, category name in the additional language will not be imported. If you update a category that already has a name in the additional language, the existing name will be deleted. |
| category_is_available | • Whether the category is enabled. • true, True, yes, Yes, y — for “yes” • false, False, no, No, n — for “no” |
If you make an error in this cell or leave this cell blank, it will be ignored. If you're importing a new category, in this case it will be created as "Enabled". |
| category_description | • Category description. • Any text you need (words, numbers, etc.), no longer than 300 000 symbols. • If you import a description in HTML formatting, this formatting will be kept as is. If you import a description that has line breaks in your spreadsheet editor as plain text without HTML formatting, each line will be wrapped in <p></p> tags (visible if you view the description in the built-in text editor in the HTML mode in your store admin). |
If you leave this cell blank, category data will be imported without the description. If you update a category that already has a description, the existing description will be deleted. |
| category_description_{Language code} | • Category description in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 300 000 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, category_description_fr • If you import a description in HTML formatting, this formatting will be kept as is. If you import a description that has line breaks in your spreadsheet editor as plain text without HTML formatting, each line will be wrapped in <p></p> tags (visible if you view the description in the built-in text editor in the HTML mode in your store admin). |
If you leave this cell blank, category data will be imported without the description in the additional language. If you update a category that already has a description in the additional language, the existing value will be deleted. |
| category_image | • URL path to the image that you want to be the category image. • You can use URLs that start with http:// or https:// • The image URL should lead directly to the image file, not to an HTML page that contains the image (e.g., http://example.com/images/product_1.jpg). • The image must be available online during import (not locked or deleted). |
If you make an error in this cell or leave this cell blank, the image will not be added to the category. |
| category_order_by | • Place of this category in the category list on the store homepage (as numbered starting from the left upper corner). • A number without fractional parts. Use values that go with an interval of "10": 0, 10, 20, 30, etc. • For example, "0" for the category that you want to go first and be on top of the store page, "10" for the category that you want to go second, and "20" for the third one. The bigger the number, the lower the place in the category list. |
If you make an error in this cell or leave this cell blank, it will be ignored. For new categories, field value will be set to "0" and they will be placed on top of the store homepage. |
| category_seo_title | • Custom SEO field, meta title tag. • Any text you need (words, numbers, etc.), no longer than 200 symbols. • It’s recommended to have SEO title no longer than 80 symbols. • This data will appear in the SEO tab of the category details page in your store admin. |
If you leave this cell blank, it will be ignored. If you update a category that already has a meta title tag, the tag will be reset to the category name. |
| category_seo_title_{Language code} | • Custom SEO field, meta title tag, in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 200 symbols. • It’s recommended to have SEO title no longer than 80 symbols. • This data will appear in the SEO tab of the category details page in your store admin. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, category_seo_title_fr |
If you leave this cell blank, it will be ignored. If you update a category that already has a meta title tag in the additional language, the existing value will be deleted. |
| category_seo_description | • Custom SEO field, meta description tag. • Any text you need (words, numbers, etc.), no longer than 50 000 symbols. • It’s recommended to have SEO description no longer than 160 symbols. • This data will appear in the SEO tab of the category details page in your store admin. |
If you leave this cell blank, it will be ignored. If you update a category that already has a meta description tag, the tag will be reset to the category description. |
| category_seo_description_{Language code} | • Custom SEO field, meta description tag in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 50 000 symbols. • It’s recommended to have SEO description no longer than 160 symbols. • This data will appear in the SEO tab of the category details page in your store admin. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, category_seo_description_fr |
If you leave this cell blank, it will be ignored. If you update a category that already has a meta description tag in the additional language, the existing value will be deleted. |
| url | • URL of the category in your storefront • Appears in catalog export files for categories that already exist in your store • Not supported in catalog import as currently you cannot set category URLs in your store |
Any values in this cell will be ignored. |
| category_image_alt | • The alternative text that contains a description of your store category image. • Any text you need (words, numbers, etc.), no longer than 100 symbols. |
If you leave this cell blank, category data will be imported without the image alt text. If you update a category that already has alt text for an image, the existing text will be deleted. |
| category_image_alt_{Language code} | • The alternative text that contains a description of your store category image, in the additional language (if you’re using multiple languages in your store). • Any text you need (words, numbers, etc.), no longer than 100 symbols. • Replace “{Language code}” in the column name with the code of your language. Language codes are specified according to the list of language codes. For example, category_image_alt_fr |
If you leave this cell blank, category data will be imported without the image alt text translation. If you update a category that already has alt text translation for an image, the existing translation will be deleted. |
| source_store_id | • Appears in catalog export files to identify the store from which the data was exported • When importing the file you've exported from store A into store B, keep the column with store A's ID so that the information is interpreted correctly during import • You can skip this column when re-importing the file you've exported from store A into store A |
If you import the file you've exported from store A into store B and keep the column with store A's ID, the error in the "category_internal_id" cell is expected. You can proceed with importing the file. |
A list of language codes
The table below contains a list of language codes. You can add them instead of the {Language code} part in the names of attribute columns if you’re using multiple languages in your store.
| Language | Language code |
| Albanian | sq |
| Arabic | ar |
| Armenian | hy |
| Basque | eu |
| Belorussian | be |
| Bulgarian | bg |
| Catalan | ca |
| Chinese | zh |
| Chinese (Taiwan) | zh_TW |
| Croatian | hr |
| Czech | cs |
| Danish | da |
| Dutch | nl |
| German | de |
| German (Switzerland) | de_CH |
| Greek | el |
| English | en |
| Estonian | et |
| Finnish | fi |
| Filipino | fil |
| French | fr |
| Icelandic | is |
| Indonesian | id |
| Italian | it |
| Japanese | ja |
| Hebrew | he |
| Hungarian | hu |
| Georgian | ka |
| Korean | ko |
| Latvian | lv |
| Lithuanian | lt |
| Macedonian | mk |
| Malay | ms |
| Marathi | mr |
| Mongolian | mn |
| Norwegian | no |
| Persian | fa |
| Polish | pl |
| Portuguese | pt |
| Portuguese (Brazilian) | pt_BR |
| Romanian | ro |
| Russian | ru |
| Serbian | sr |
| Slovak | sk |
| Slovenian | sl |
| Spanish | es |
| Spanish (Latin America) | es_419 |
| Swedish | sv |
| Thai | th |
| Turkish | tr |
| Ukrainian | uk |
| Vietnamese | vi |
| Welsh | cy |