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.|
A quick rating takes only 3 clicks. Add a comment to help us improve Magento even more.