Magento 2 Mass Product Update: Bulk Price & Stock Update via Import & Export

magento 2 mass product update

Running an e-commerce website is associated with regular updates: prices often change, you receive new items, stock levels vary, etc. You may spend considerable time altering all these indexes manually. However, it is possible to facilitate the common methodology most merchants rely upon. Below, we’d like to introduce you to the Magento 2 mass stock update. It’s a process that can help you optimize regular data updates that take place on your e-commerce website.  Below, we focus on two aspects: prices and stock levels. You will discover what the Magento bulk price update is. At the same time, the article will teach you to update Magento stock in bulk. We use the Improved Import & Export Magento 2 extension to mass update Magento 2 product prices and quantity (stock).

Magento 2 Mass Product Update Step-by-step Tutorial

When managing a large product catalog, sometimes you need to manually update multiple product price and quantity values. For example, your supplier raised prices, and you have your warehouse manager sending you updates on what’s left in stock.

What are your options?

  • Magento 2 mass actions – this won’t help you as you can only specify a single value for multiple products, not updating products individually
  • Updating product by product in your Magento 2 backend – this will take a considerable amount of time, accounting for internet speed connection and page loading time.

We, however, know a better solution. You can export your product catalog using the Improved Import and Export Magento 2 extensionapply changes to price and stock data, and import the update back. Let’s see how to do that. 

Export Your Product Catalog from Magento 2 for Mass Update

The Magento 2 mass product update starts with your product catalog export. To edit a product catalog, you first need to get it. The Improved Import and Export Magento 2 extension can help you.

I: Create an Export Job

Navigate to System > Improved Import / Export > Export Jobs and click the ‘Add New Job’ button to create a new export job to update your product catalog in bulk.

magento 2 mass product update: add new export job

II: Configure Your Export Job

You do not need to fill each job setting, fill only the fields specified below. It will help you export the product catalog as fast as possible:

  • Job Title – name the job;
  • Entity – select ‘Products’;
  • Store View – select ‘Only Admin Values’ to export only default store values;
  • Export Source – select ‘File’;
  • File path – specify the path where to export the file. E.g. copy and paste: /var/import/my_products.csv.

III: Export Stock & Price Data

Use filters to simplify your Magento 2 mass product update by exporting only required products with attributes you are going to update: stock and price. 

  • Proceed to the Map Attributes section and add the following three fields to the System Attribute column:
    • sku – unique product identifier, you will need it to import products with the updates back;
    • price – attributes where the product price is saved;
    • qty – attribute where the product quantity is saved.
  • Check the ‘Only fields from Mapping’ selector to export only the three attributes you have selected instead of exporting all product data.

Your Map Attributes section should look like this:

magento 2 mass product update: export only sku, price, and qty

IV: Filter Products if Applicable

You don’t have to export a WHOLE product catalog for your Magento 2 bulk product update. Instead, export only the products you need to update.

Scroll down to the Filters section and apply the necessary filters. The following filter, for instance, exports products with the SKU that contains “firebear”:

magento 2 mass product update: filter products

V: Export Products

Hit the ‘Save & Run’ button in the upper-right corner of the screen to get the products exported.

The extension creates a file with the products and the attributes you have specified. It’s enough for your Magento bulk price and stock update. Now, you need to edit this file.

Upload Your Magento 2 Product Catalog to Google Sheets for Bulk Price & Quantity Editing

Now, you need to upload your CSV file with a product catalog to Google Sheets (File > Import > Upload > Browse). It will look as follows:

magento 2 mass product update: upload catalog to google sheets spreadsheet

Google Sheets is the best place to edit CSV files. If you are not familiar with the platform, you will be surprised how easy and fast it is, especially in terms of collaborations. You can easily add multiple managers to apply changes. 

Edit the file the way you need. Implement the Magento bulk price update by changing the values in the price column. Update your Magento stock in the qty column. 

magento 2 mass product update: edit the spreadsheet

Next, click the ‘Share’ button in the upper-right corner of the screen and set view permissions ‘by link‘. You will need to copy the spreadsheet’s link for the next step.

Mass Update Magento 2 Product Catalog by Importing The Edited Data 

Do not convert the Google Sheets back to CSV. With Improved Import & Export, you can paste the link to the Google Sheet table, and import it to the store.

I: Create an Import Job

Navigate to System > Improved Import / Export > Import Jobs and click the ‘Add New Job’ button.

II: Configure Your Import Job

You do not need to fill each job setting, fill only the fields specified below to quickly import product updates to your Magento 2 store:

  • Job Title – name the job;
  • Entity – select ‘Products’;
  • Import Behavior – select ‘Add/Update’;
  • Import file type – select CSV file type;
  • Import Source – select ‘Google Sheets’;
  • URL – paste the URL of the Google Sheet where you have edited product price and quantity:

magento 2 mass product update: import data from Google Sheets

If you upload a file from a supplier that contains the number of products sent to your store, you may want to ADD this QTY to the existing product stock at your Magento 2.

For example:

  • You have 100 items of product A in stock
  • Your supplier sends you another 50 items of product A
  • You can specify 50 in the qty column in the file you are importing and ADD it to the existing 100 inside your store.

To do this – enable the Add product QTY to existing value setting inside the Import Settings section of the Import Job.

magento 2 mass product update: att the imported qty to existing stock

III: Validate The File & Run The Magento 2 Mass Product Update

Inside the Import Source section, click the ‘Validate file’ button followed by the ‘Save & Run’ button at the upper-right corner. Then hit the ‘Run’ button to start your mass product update in Magento 2.

IV: Check The Result

Now that the import job is complete you can proceed to Catalog > Products and check the updated product prices and stock data.

magento 2 mass product update: check the imported data

V: Don’t Delete The Spreadsheet

Do not delete the Google Sheet file you have created. Save it for another price and stock update, along with the import job you have created. Next time, you will only need to upload the exported data to this spreadsheet, edit it, and launch the corresponding import profile.

Final Words

This is it! Now you know what the Magento 2 mass product update is. You have just updated your product catalog prices and stock quantities using the import procedure. This is a much easier and faster way to magento bulk price update with mass stock update simultaneously. Follow the link below to enable the corresponding functionality on your e-commerce website:

Get Magento 2 Improved Import & Export extension

Magento 2 Mass Product Update FAQ

Q: Do I need to export all Magento 2 product attributes to update price and quantity?

A: No, you only need attributes sku, price, and qty. SKU is required to identify the product price and quantity you are updating.

Q: Can I export only the required attributes with native Magento 2 import/export?

A: No, Magento 2 doesn’t let you filter products or export only a set of product attributes. You need to use an extension for that. For example Improved Import & Export for Magento 2 by Firebear.

Q: How can I edit exported CSV files for the Magento 2 mass product update?

A: The best solution is to upload it to Google Sheets and edit it there. Excel tends to break the formatting and mess with the date and time settings based on your location. Which may lead to the inability to import the file back to Magento 2.