Magento 2 Magento 1

Magento 2 Regular, Special & Tier Price Importer

Rating:
100% of 100
Share
Login to earn Reward Points for sharing!

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.4
Enterprise: 2.1, 2.2, 2.3, 2.4
? Please enter the production domain without http:// or https://. For example: www.magepsycho.com For multiple purchases of the extension (i.e. Qty > 1), you can use comma separator(,) for multiple domains. Note that no of domains should not exceed the ordered qty.
? Please enter the development domain without http:// or https://. For example: www.magepsycho.com For multiple purchases of the extension (i.e. Qty > 1), you can use comma separator(,) for multiple domains. Note that no of domains should not exceed the ordered qty.
Regular Price $75.00 Special Price $55.00
v1.0.4
30 Days Money Back
Free Lifetime updates
100% Open Source

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).

Magento 2 Price Importer - CSV File Preview

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:

Format Description Applied To
10 Fixed amount value All Prices
+10 Increase the current value by 10 All Prices
-10 Decrease the current value by 10 All Prices
10% 10% of the reference price value (except for tier_price where X% represents the discount) msrp, special_price & tier_price
+10% Increase the current value by 10% All Prices
-10% Decrease the current value by 10% All Prices
x Delete the current value All Prices (except price)

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:

Rounding Type Description
No Rounding No action with the price
Round Normally Uses PHP's round() function. Examples:
  • 9.43 -> 9.00
  • 9.63 -> 10.00
Round to Nearest Used for psychological or strategic pricing(like *.99, *.50, etc.). Examples:
  • 9.43 -> 9.00 + (If Rounding Value = 0.99) = 9.99
  • 9.43 -> 9.00 + (If Rounding Value = 0.50) = 9.50

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.

Magento 2 Pricing Import via SSH CLI/Console Command

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

v1.0.4

released on 2023-01-26
  • fixed Resolved issue with importing pricing caused by PHP 8.x
  • fixed Made plugin compatible with Magento 2.4.5
  • changed Refactored the code

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

Extension

Why can't I import prices from the admin panel? The import button is disabled.

To resolve this issue, ensure that you have enabled the extension and have entered valid license keys.

What are the limitations of the default data import options in Magento 2 for updating products and pricing?

The default data import options in Magento 2 have limitations in updating all types of prices at once and have limited options for pricing. In contrast, this extension offers added features such as a preview option for uploaded files, detailed error messages during import validation, support for different types of price rounding, and the ability to import prices through various methods such as the admin interface, command line interface (CLI), and cron jobs.

How can I download the exported CSV when I receive the message "Message is added to queue, wait to get your file soon. Make sure your cron job is running to export the file" after initiating an export of prices in Magento 2?

Make sure that the cron job is running correctly on your server, as it is responsible for processing the export task and generating the CSV file for download. If you are still unable to download the exported CSV, you can try running the command bin/magento queue:consumers:start exportProcessor from your server's command line to manually start the export process. Once the export process is completed, you should be able to see the download option for the exported CSV file in the backend of your Magento store.

Can we use the Magento 2 Price Importer Extension to update the tier prices for multiple customer groups simultaneously?

Yes, it is possible to use the extension to update tier prices for multiple customer groups. The extension supports an unlimited number of customer groups. It's important to ensure that the correct headers (e.g. "tier_price:{group}") and values (e.g. "qty1:value1;...") are used when importing the pricing data in the CSV file.

How can I include plus (+) or minus (-) signs in price values when importing a CSV file?

You can use the plus (+) or minus (-) signs followed by an apostrophe ('). For example, "`+10" or "'-5".

How do I import product prices for specific store views (store_id)?

To import product prices for specific store views, first, install the FREE extension from https://www.magepsycho.com/magento2-store-view-pricing.html. Then use the MIP Pricing extension to import. If you encounter any issues, please contact us for assistance.

How can I import custom product prices that are different from the default options (regular, special, cost, msrp, group/tier prices)?

Currently, we do not support custom product prices other than regular, special, cost, msrp, group/tier prices. However, we are planning to introduce a new feature "custom_price:{price_field}" to support custom decimal type prices. If you need to update custom prices, please contact us for assistance.

Generic

How can I pay for MagePsycho extensions?

We only support PayPal for now. The other means are under processing.

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?

The license key(s) are sent along with the invoice email.
In case if you have't received any license key(s), please Contact Us with the order #.

Are your extensions open source or encrypted?

All of our extensions are developed on the open source platform.

Do you provide Magento customization service?

Yes, sure, we can help you with customization. Please, submit the Request Quote form.

Can I get a refund if an extension doesn’t suit me?

Absolutely. MagePsycho provides a 30-day money back guarantee. So feel free to purchase.

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?

MagePsycho doesn’t provide any trials. But we have a 30 days money back guarantee.
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?

Our license allows you to use in a single domain but an unlimited number of sub-domains.
In the case of additional licenses, we do provide a good discount.

Will I get free support and updates?

You will get free lifetime updates for extensions purchased from us.
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
You May Also Like