Magento 2 Regular, Special & Tier Price Importer
Share
This Price Importer Extension for Magento 2 is the fastest import tool for updating different prices like regular, cost, MSRP/MAP, special, tier & customer group price via different methods (admin, CLI & cron jobs).
Compatibility
Community: 2.1, 2.2, 2.3, 2.4Enterprise: 2.1, 2.2, 2.3, 2.4
- Store Demo
- Admin Demo
- User Guide
- Change Log
The fastest Magento 2 price import tool for bulk updating regular, cost, MSRP/MAP, special, tier & customer group prices — all from a single CSV file.
The Problem
Magento 2's built-in data transfer supports product and advanced pricing imports, but lacks the ability to update all price types in a single operation. Native import options for pricing are limited and slow for large catalogs.
The Solution
This extension provides the simplest and fastest way to import all types of pricing with a single CSV file. Combined with the export pricing feature, preparing and updating price data becomes effortless.
Key Features
x marker
Feature Highlights
Import All Price Types from a Single CSV
Bulk update (add, update, or delete) any type of price with a single CSV file. Supported price types:
- Regular Price
- Special Price (with From and To dates)
- Cost
- Manufacturer's Suggested Retail Price (MSRP) / Minimum Advertised Price (MAP)
- Tier Price / Customer Group Price (Group Price is a special case of Tier Price with qty = 1)
- Custom Decimal Price Attributes — coming soon
In-Depth Import Data Validation
All pricing data must pass validation before import to ensure consistency with the database. If validation fails, the extension describes each error — helping you quickly locate and fix problems in the CSV file.
Header/Column Errors
- We can't find required columns: "sku", "website_id"
- Header contains invalid attribute(s): "tier_price:{invalid-group}"
Data/Row Errors
- Product with specified SKU not found
- Tier Price / Group Price data is invalid
- Date or Price format is invalid
- To Date should be later than or same as From Date
Drag & Drop Uploader with CSV Preview
Upload CSV files with drag-and-drop, then preview the data directly in the admin panel. Verify that rows and columns are properly formatted before running the import.
Flexible Pricing Values
Update prices by increasing or decreasing with fixed amounts or percentages. Set prices as a percentage of a reference attribute, or mark with x to delete. Add, update, and delete prices in the same CSV file.
| Format | Description | Applied To |
|---|---|---|
10 |
Set fixed amount value | All Prices |
+10 |
Increase current value by 10 | All Prices |
-10 |
Decrease current value by 10 | All Prices |
10% |
10% of reference price (for tier_price: X% = discount) | msrp, special_price, tier_price |
+10% |
Increase current value by 10% | All Prices |
-10% |
Decrease current value by 10% | All Prices |
x |
Delete the current value | All Prices (except regular price) |
Price Rounding Options
Round calculated prices to whole numbers or apply psychological/strategic pricing (e.g. $9.99, $9.50). Three rounding modes are available:
| Rounding Type | Description | Example |
|---|---|---|
| No Rounding | Price is left as-is | 9.43 → 9.43 |
| Round Normally | Standard PHP round() | 9.43 → 9.00 | 9.63 → 10.00 |
| Round to Nearest | Psychological pricing (*.99, *.50, etc.) | 9.43 → 9.99 (if rounding value = 0.99) |
Import Pricing via CLI
For large CSV files, importing via SSH command-line avoids web server timeouts and memory limits. The CLI method is ideal for bulk operations on large catalogs.
Schedule via Cron
Automate price imports with cron jobs:
1 0 * * * /usr/bin/php /path/to/magento2/bin/magento mip:pricing:import --reindex /path/to/import/file.csvExport Pricing Data
Export existing prices to prepare your import file. Filter products and select which price types to export — especially useful for tier prices with multiple levels.
Installation
src/ folder to your {magento2-root-dir}/php bin/magento module:enable MagePsycho_MassImporterPro MagePsycho_MipPricing --clear-static-content
php bin/magento setup:upgradephp bin/magento cache:flushLive Demo
v1.0.3
released on 2020-06-05- fixed Fixed the special price from/to dates in case of website scope pricing
- fixed Fixed price updating issue in case of SKU available in multiple rows
- changed Tested compatibility against Magento 2.3.5
v1.0.2
released on 2020-01-24- fixed Fixed js minify issue during static content deploy
- fixed Fixed 0 price issue in case of empty values
- fixed Fixed rounding issue
- changed Refactored code
v1.0.1
released on 2020-01-15- fixed Fixed di compilation issue in Magento 2.2.3
- fixed Fixed css for uploader box in Magento 2.2.4
- fixed Fixed CSV popup preview issue
- changed Updated sample files
v1.0.0
released on 2019-12-25- added Initial Release
Generic
How can I pay for MagePsycho extensions?
If I buy an extension, how would I get it?
After you make a purchase, the order will appear in the "My Orders" section of your personal account page.
As soon as the order status becomes completed the purchased extensions can be downloaded from "My Downloads" section.
How can I get the license key(s) for the purchased extension?
In case if you have't received any license key(s), please Contact Us with the order #.
Are your extensions open source or encrypted?
Do you provide Magento customization service?
Can I get a refund if an extension doesn’t suit me?
After 30 days from the date of purchase, the refund is not applied. You also cannot ask for a refund for the installation service or custom service.
If you are looking for a specific solution for your store, please Contact Us.Can I request a free trial?
But if you buy an extension and it doesn’t suit you in any way, you can request a refund with no risks on your side.
Moreover, most of our extensions have demos, where you can see how our modules work.
What is the license policy? On how many websites can I use MagePsycho extensions?
In the case of additional licenses, we do provide a good discount.
