Magento 2 Regular, Special & Tier Price Importer

Overview:

This Price Importer Extension for Magento 2 is the fastest import tool for bulk updating different prices like regular, cost, MSRP/MAP, special, tier & customer group price.

Magento 2 has built-in data transfer for importing products and advanced pricing. But it lacks the functionality of updating all types of prices whether it's regular or advanced pricing in a single go.
Also, the native import has very limited options for pricing.

With this extension, store admin can achieve the simplest & the fastest way to import all types of pricing with just a single CSV file(more import sources will be added soon).
And with the export pricing option, store admin can easily prepare the import file.

Key Features

• Provides bulk import functionality for all types of price (regular, cost, MSRP/MAP, special, tier & customer group price) with just a single CSV file
• Option to preview the uploaded file which gives the glance view of the file data
• The detailed error message provided during import validation helps to fix the price data faster
• Support for different types of price rounding (whole number to the psychological pricing)
• Price values can be increased(+), decreased(-) by a fixed amount value or percentage
• Price values can also be set as a certain percentage of some reference attribute value
• Ability to import prices via different methods (admin, command line interface (CLI) & cron jobs)
• Ability to export the different prices makes import file preparation much easier

Feature Highlights

Import Regular, Special, Tier, Customer Group Price, etc.

With this extension, store admin can bulk update(add/update or delete) any type of prices with just a single CSV file.
Supported price types by the extension:

• 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 in Magento 2 is the special case of Tier Price having tier qty equals to 1)
• Custom Decimal Price Attributes - coming soon

Sample CSV files are provided in the extension itself(Import Pricing > Download Sample File). Also, it be download from our GitHub Repository.

In-Depth Import Data Validation

All pricing data must pass validation before it can be imported into the system, to ensure that the values are consistent with the system database.
If validation fails, the extension describes each error. This helps the store owner to quickly find and correct the problem in the CSV file.

Validation is done on the header(column) level and data(row) level. And row level validation is performed only after header/column level validation is passed.

Some of the validation messages looks like:
Header/Column Level

• We can't find required columns: "sku", "website_id"
• Header contains invalid attribute(s): "tier_price:{some-invalid-group-name}"
• etc.

Data/Row Level

• Product with specified SKU not found
• Website doesn't exist
• Tier Price data is invalid
• Group Price data is invalid
• Date format is invalid
• Price format is invalid
• To Date should be later than or same as From Date
• etc.

Fancy Uploader with CSV File Preview

This extension comes with a fancy uploader for drag and drop uploading with an option to preview the imported CSV file.
This option is super helpful in checking the CSV data structure(For Ex: if rows & columns are properly formatted or not).

Flexible Pricing Values

With this extension, any price can be updated by increasing(+) or decreasing(-) by fixed amount or percentage.
Also, the price value can be specified as a percentage of some reference attribute value.

(The reference attribute for markup pricing can be configured from the extension settings)

And marking the price value with x will delete the price data from the system. With this adding, updating & deleting the different prices can achieved with the same file.

Supported example of different pricing format for importing are described below:

Price Rounding Options

Price values will likely have complex decimal values.
Rounding them off to the nearest whole number or the nearest 0.99 (for psychological or strategic pricing) is practical and recommended.
With this in mind, this import extension provides three types of options for price rounding:

Import Pricing via CLI

If you want to import prices with large CSV files, importing via SSH's command-line interface(CLI) is the best bet. This will not overload your web server and there won't be a 504 Gateway Time-out issue.

Also, the price importing can be scheduled via cron jobs. For example:

1 0 * * * /usr/bin/php /path/to/magento2/bin/magento mip:pricing:import --reindex /path/to/import/file.csv

Export Pricing

Updating Regular Price & Special Price might be comparatively easier. But updating tier price can be time-consuming because of the multiple level price it owns.
With this extension, you can filter the products and select the price types you wanted for the export.

Once the required price data is exported, the store admin can easily prepare the price data and perform the bulk update.

Installation

1. Download the extension .zip file and extract the files.
2. Copy the extension files from src/ folder to the {magento2-root-dir}/
3. Run the following series of command from SSH console of your server:

php bin/magento module:enable MagePsycho_MassImporterPro MagePsycho_MipPricing --clear-static-content
php bin/magento setup:upgrade

4. Flush the store cache

php bin/magento cache:flush

5. Go to Admin > SYSTEM > Mass Importer Pro > Here you can import, export & configure settings

Live Demo:

View Backend Demo