{"id":3714,"date":"2021-12-11T16:19:28","date_gmt":"2021-12-11T16:19:28","guid":{"rendered":"https:\/\/keys.support\/?post_type=docs&#038;p=3714"},"modified":"2022-05-12T18:04:31","modified_gmt":"2022-05-12T18:04:31","password":"","slug":"importing-tier-prices","status":"publish","type":"docs","link":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/","title":{"rendered":"Importing Tier Prices"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.magento.com\/user-guide\/system\/assets\/storefront-tier-pricing-water-bottle.png\"><\/a><em>Tier Pricing<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-export-the-tier-price-data\"><a href=\"https:\/\/docs.magento.com\/user-guide\/system\/data-import-price-tier.html#step-1-export-the-tier-price-data\"><\/a>Step 1: Export the tier price data<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"tier-pricing\"><a href=\"https:\/\/docs.magento.com\/user-guide\/system\/data-import-price-tier.html#tier-pricing\"><\/a>Tier pricing<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>On&nbsp;<em>Admin<\/em>&nbsp;sidebar, go to&nbsp;<strong>System<\/strong>&nbsp;&gt;&nbsp;<em>Data Transfer<\/em>&nbsp;&gt;&nbsp;<strong>Export<\/strong>.<\/li><li>Under&nbsp;<em>Export Settings<\/em>, set&nbsp;<strong>Entity Type<\/strong>&nbsp;to&nbsp;<code>Advanced Pricing<\/code>.<\/li><li>In the&nbsp;<strong>Entity Attributes<\/strong>&nbsp;grid, scroll down to the SKU attributes and do the following:<ul><li>For tier prices that are based on a discount percentage, enter the SKU of each product to be exported, separated by a comma.<a href=\"https:\/\/docs.magento.com\/user-guide\/system\/assets\/price-tier-export-sku.png\"><\/a><em>SKU(s) to Export<\/em><\/li><li>For tier prices that are based on a fixed amount, enter the SKU of each product.<\/li><li>Scroll down and click&nbsp;<strong>Continue<\/strong>.<\/li><\/ul><\/li><li>Locate the export file at the downloads location for your web browser and open the file.<a href=\"https:\/\/docs.magento.com\/user-guide\/system\/assets\/price-tier-customer-group-discount-export.png\"><\/a><em>Exported Customer Group Tier Price Data<\/em><\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"exported-tier-price-data\"><a href=\"https:\/\/docs.magento.com\/user-guide\/system\/data-import-price-tier.html#exported-tier-price-data\"><\/a>Exported tier price data<\/h3>\n\n\n\n<p>The following columns are included in the exported data:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>sku<\/code><\/li><li><code>tier_price_website<\/code><\/li><li><code>tier_price_customer_group<\/code><\/li><li><code>tier_price_qty<\/code><\/li><li><code>tier_price<\/code><\/li><li><code>tier_price_value_type<\/code><\/li><\/ul>\n\n\n\n<p>You use the exported data as a template for importing tier price data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-update-the-data\"><a href=\"https:\/\/docs.magento.com\/user-guide\/system\/data-import-price-tier.html#step-2-update-the-data\"><\/a>Step 2: Update the data<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>Update the tier price data for each product, as needed.Any products without tier price updates can be deleted from the CSV file. There is no need to reimport products that have not changed.<\/li><li><strong>Save<\/strong>&nbsp;the updated CSV file.The size of an import file cannot be larger than two megabytes.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3-import-the-updated-data\"><a href=\"https:\/\/docs.magento.com\/user-guide\/system\/data-import-price-tier.html#step-3-import-the-updated-data\"><\/a>Step 3: Import the updated data<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>On&nbsp;<em>Admin<\/em>&nbsp;sidebar, go to&nbsp;<strong>System<\/strong>&nbsp;&gt;&nbsp;<em>Data Transfer<\/em>&nbsp;&gt;&nbsp;<strong>Import<\/strong>.<\/li><li>Under&nbsp;<em>Import Settings<\/em>, set&nbsp;<strong>Entity Type<\/strong>&nbsp;to&nbsp;<code>Advanced Pricing<\/code>.<\/li><li>Set&nbsp;<strong>Import Behavior<\/strong>&nbsp;to&nbsp;<code>Add\/Update<\/code>.<\/li><li>Under&nbsp;<strong>File to Import<\/strong>, click&nbsp;<strong>Choose File<\/strong>&nbsp;and select the file that you prepared to import from your directory.<\/li><li>In the upper-right corner, click&nbsp;<strong>Check Data<\/strong>.<\/li><li>If the file is valid, click&nbsp;<strong>Import<\/strong>.Otherwise, correct each problem with the data that is listed in the message, and try to import the file again.<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Tier Pricing Step 1: Export the tier price data Tier pricing On&nbsp;Admin&nbsp;sidebar, go to&nbsp;System&nbsp;&gt;&nbsp;Data Transfer&nbsp;&gt;&nbsp;Export. Under&nbsp;Export Settings, set&nbsp;Entity Type&nbsp;to&nbsp;Advanced Pricing. In the&nbsp;Entity Attributes&nbsp;grid, scroll down to the SKU attributes and do the following: For tier prices that are based on a discount percentage, enter the SKU of each product to be exported, separated by a [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[262],"doc_tag":[],"knowledge_base":[108],"class_list":["post-3714","docs","type-docs","status-publish","hentry","doc_category-magento","knowledge_base-information-technology"],"acf":[],"year_month":"2026-06","word_count":325,"total_views":"460","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Anna Mayor","author_nicename":"anna-dev-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2","author_url":"https:\/\/keys.express\/support\/en\/author\/anna-dev-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2\/"},"doc_category_info":[{"term_name":"Magento Developers","term_url":"https:\/\/keys.express\/support\/en\/docs\/information-technology\/magento\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Importing Tier Prices - Keys Support<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Tier Prices - Keys Support\" \/>\n<meta property=\"og:description\" content=\"Tier Pricing Step 1: Export the tier price data Tier pricing On&nbsp;Admin&nbsp;sidebar, go to&nbsp;System&nbsp;&gt;&nbsp;Data Transfer&nbsp;&gt;&nbsp;Export. Under&nbsp;Export Settings, set&nbsp;Entity Type&nbsp;to&nbsp;Advanced Pricing. In the&nbsp;Entity Attributes&nbsp;grid, scroll down to the SKU attributes and do the following: For tier prices that are based on a discount percentage, enter the SKU of each product to be exported, separated by a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/\" \/>\n<meta property=\"og:site_name\" content=\"Keys Support\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-12T18:04:31+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/documentation\\\/importing-tier-prices\\\/\",\"url\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/documentation\\\/importing-tier-prices\\\/\",\"name\":\"Importing Tier Prices - Keys Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/#website\"},\"datePublished\":\"2021-12-11T16:19:28+00:00\",\"dateModified\":\"2022-05-12T18:04:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/documentation\\\/importing-tier-prices\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/documentation\\\/importing-tier-prices\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/documentation\\\/importing-tier-prices\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\\\/\\\/keys.express\\\/support\\\/de\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Importing Tier Prices\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/\",\"name\":\"Keys Support\",\"description\":\"Keys Support and It Works!\",\"publisher\":{\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/#organization\",\"name\":\"Keys Support\",\"url\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/keys.express\\\/support\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/KE-Logo-en.svg\",\"contentUrl\":\"https:\\\/\\\/keys.express\\\/support\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/KE-Logo-en.svg\",\"width\":248,\"height\":92,\"caption\":\"Keys Support\"},\"image\":{\"@id\":\"https:\\\/\\\/keys.express\\\/support\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Tier Prices - Keys Support","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/","og_locale":"en_US","og_type":"article","og_title":"Importing Tier Prices - Keys Support","og_description":"Tier Pricing Step 1: Export the tier price data Tier pricing On&nbsp;Admin&nbsp;sidebar, go to&nbsp;System&nbsp;&gt;&nbsp;Data Transfer&nbsp;&gt;&nbsp;Export. Under&nbsp;Export Settings, set&nbsp;Entity Type&nbsp;to&nbsp;Advanced Pricing. In the&nbsp;Entity Attributes&nbsp;grid, scroll down to the SKU attributes and do the following: For tier prices that are based on a discount percentage, enter the SKU of each product to be exported, separated by a [&hellip;]","og_url":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/","og_site_name":"Keys Support","article_modified_time":"2022-05-12T18:04:31+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/","url":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/","name":"Importing Tier Prices - Keys Support","isPartOf":{"@id":"https:\/\/keys.express\/support\/en\/#website"},"datePublished":"2021-12-11T16:19:28+00:00","dateModified":"2022-05-12T18:04:31+00:00","breadcrumb":{"@id":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/keys.express\/support\/en\/documentation\/importing-tier-prices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/keys.express\/support\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/keys.express\/support\/de\/docs\/"},{"@type":"ListItem","position":3,"name":"Importing Tier Prices"}]},{"@type":"WebSite","@id":"https:\/\/keys.express\/support\/en\/#website","url":"https:\/\/keys.express\/support\/en\/","name":"Keys Support","description":"Keys Support and It Works!","publisher":{"@id":"https:\/\/keys.express\/support\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/keys.express\/support\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/keys.express\/support\/en\/#organization","name":"Keys Support","url":"https:\/\/keys.express\/support\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/keys.express\/support\/en\/#\/schema\/logo\/image\/","url":"https:\/\/keys.express\/support\/wp-content\/uploads\/2025\/02\/KE-Logo-en.svg","contentUrl":"https:\/\/keys.express\/support\/wp-content\/uploads\/2025\/02\/KE-Logo-en.svg","width":248,"height":92,"caption":"Keys Support"},"image":{"@id":"https:\/\/keys.express\/support\/en\/#\/schema\/logo\/image\/"}}]}},"knowledge_base_info":[{"term_name":"Information Technology","term_url":"https:\/\/keys.express\/support\/en\/docs\/information-technology\/","term_slug":"information-technology"}],"knowledge_base_slug":["information-technology"],"_links":{"self":[{"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/docs\/3714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/comments?post=3714"}],"version-history":[{"count":1,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/docs\/3714\/revisions"}],"predecessor-version":[{"id":32784,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/docs\/3714\/revisions\/32784"}],"wp:attachment":[{"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/media?parent=3714"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/doc_category?post=3714"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/doc_tag?post=3714"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/keys.express\/support\/en\/wp-json\/wp\/v2\/knowledge_base?post=3714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}