How to Update Product Price in Bulk During Magento 2 Import

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? You will find the answer in our Magento bulk price update guide.

With the default data transfer tools, you have to apply most price adjustments manually to every product in your catalog. The more products you have, the more time you will spend. However, nobody wants to calculate and apply each new price manually.

In this article, you will learn how to update product prices in Magento in mass with the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2, introducing the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products. 

Magento Bulk Price Update Solution №1

As you know, native Magento 2 import doesn’t let you update prices. The only thing you can do is to specify a new price value. However, if you want to raise prices for the whole catalog, you will need to consider additional time for price calculations and pasting values to the import table.

With Improved Import and Export extension, we’ve introduced Price Rules – a set of conditions to adjust the price of the imported products. With Price Rules, you can now increase and decrease the price of the imported product for a flat value, like $10, or a percent value, like 10% in bulk.

Get Improved Import Magento 2 Extension

It doesn’t mean that you can only update the price of the NEW products. You can run the Magento bulk price update for products that are already in your Magento 2 catalog. To do this – export products from your Magento 2, and import this file back using the extension with the price rules set up.

How to Update Product Price in Mass in Magento 2

Working with Price Rules is simple. If you ever tried creating a discount coupon in Magento 2 you should have no problems.

To update the product price while importing you will need:

1. Improved Import and Export extension installed (we offer free installation);
2. Properly formatted table with products (read how to compose a table).

That’s it. Once you have the extension and table you can start updating prices. Let’s break down the process in steps to describe the pattern.

Step 1: Create an import job

Import and export jobs are considered the main entity of the Improved Import and Export extension. They allow you to schedule automatic import and export procedures, mapping product categories, attributes, and table separators.

This blog post cannot include every piece of information about the import jobs. If you are new to the extension – start by reading the Improved Import and Export manual and check the Magento 2 import/export guide list.

To create an import job navigate to your store admin panel > System > Improved Import/Export > Import Jobs.

When on the job settings screen – fill in all necessary information and proceed to the next step.

Step 2: Upload an import table

You have created the job. Now, select the import entity – ‘Products’ – and set up proper separators for the table. Proceed to the ‘Import Source’ section to upload the table with the products you have.

The most convenient way to do this – is to use Google Sheets. Upload the table you have to Google Drive, share it, and copy and paste the link into the job.

To get more information on how to import every Magento 2 entity from Google Sheets read this blog article.

Step 3: Set up price rules

Once you have uploaded the table, proceed to the Price Rules section.

Here, you can add as many rules as you like to run your Magento bulk price update. Set up complex conditions that identify the products from the import table. Specify the type of price update required – flat or percent. And add or subtract from the product price using negative values.

Remember, that the price will be updated only for the products from the table you import. The rest of the products you already have in your catalog won’t be the subject of this price update.

NOTE:

If you want to update the prices of the products that are already in your Magento 2 catalog follow these steps:

1. Export your Magento 2 catalog
2. Import this very table using the extension
3. Don’t forget to add price rules

This way you can update the product price in mass in Magento 2.

Step 4: Run the job and see price updates

Once done with the settings and price rules – hit the big orange ‘Save & Run’ button. The job will import the products from the table and update the prices.

You can now navigate to Catalog > Products to see the price updates of the imported products.

If you require further instructions on how to import different entities or product types to your Magento 2 store, follow our Magento 2 Import Guide List:

Read Magento 2 Import Guide List

Get Improved Import Magento 2 Extension

Magento 2 Product Price Import & Export FAQ

Let’s take a look at other nuances of adjusting product prices in Magento 2 during import processes with the help of the Improved Import & Export Magento 2 extension.

Final Words

Magento bulk price update is a simple process that can established with the Improved Import & Export extension. You can freely update product prices, including MAP and tier prices, in mass in Magento 2 for all products or only the chosen items. Just add the necessary records to your CSV and create price rules. Next, our module will do everything for you. Please, follow the link below and contact our support regarding other aspects of product price updates in Magento 2 or Adobe Commerce:

Get Improved Import Magento 2 Extension