Magento 2.2.x Notice: As outlined by the Magento Software Lifecycle Policy, Magento 2.2.x has reached the End-of-Support and will no longer receive quality fixes or documentation updates. To maintain your site's performance, security, and PCIPayment Card Industry: Refers to debit and credit cards and their associated businesses. compliance, upgrade to the latest version of Magento.
Importing Tier Prices
Rather than entering tier prices manually for each product, it can be more efficient to import the pricing data. Before you begin, create a sample file of exported tier price data that you can use as a template.
The following example exports tier pricing data for a single product. Then, you can use the exported data as a template for bulk imports of tier price data. To learn more about exporting advanced pricing data, see: Advanced Pricing Data.
|1.||On Admin sidebar, choose System. Then under Data Transfer, choose Export.|
|2.||Under Export Settings, set Entity Type to “Advanced Pricing.”|
|3.||In the Entity Attributes grid, scroll down to the SKU attributes. Then, do the following:|
|a.||For tier prices that are based on a discount percentage. enter the SKU of each product to be exported, separated by a comma.|
|a.||For tier prices that are based on a fixed amount. enter the SKU of each product.|
|4.||Scroll down and tap Continue.|
|5.||Look in the lower-left corner of your browser window for the export file. Then, open the file.|
Exported Tier Price Data
The following columns are included in the exported data:
You will use the exported data as a template for importing tier price data.
|1.||Update the tier price data for each product, as needed.|
|2.||Any products without tier price updates can be deleted from the CSV file. There is no need to reimport products that haven’t changed.|
|3.||Save the updated CSV file.|
The size of an import file cannot be larger than 2 megabytes.
|1.||On Admin sidebar, choose System. Then under Data Transfer, choose Import.|
|2.||Under Import Settings, set Entity Type to “Advanced Pricing.” Then, set Import Behavior to “Add/Update”.|
|3.||Under File to Import, tap Choose File. Then, select the file that you prepared to import from your directory.|
|4.||In the upper-right corner, tap Check Data.|
|5.||If the file is valid, tap Import . Otherwise, correct each problem with the data that is listed in the message, and try to import the file again.|