Magento 2 store owners often need to update product prices in bulk. Thanks to the simple Magento 2 Export Products to CSV module, this can be done quickly and conveniently by exporting and importing data in CSV format. In this article, we explain step by step how to update prices and other attributes in your Magento 2 store using this module.
1. Installing the Magento 2 Export Products to CSV module
If you are not yet using the Magento 2 Export Products to CSV module, install it according to the provided documentation. This module allows you to export selected product attributes, such as SKU and PRICE, while preserving the corresponding column headers. After updating the data, you can import this sheet into Magento without errors using the built-in import function.
2. Export data from Magento 2
- Log in to the Magento admin panel.
- Go to Stores > Configuration > KOWAL > Export to CSV (or the tab dedicated to the Blacksmith module, Blacksmith.co > Export to CSV > Settings).
2.1. Select columns for export:
In the export module settings, select the following attributes:
- SKU (product identifier),
- PRICE (current product price).
2.2. Go to the product list:
In the admin panel, go to the product list: Catalog > Products
2.3. Select products for export:
- Use filters (e.g., category, status, SKU) to select the products you want to update.
- If you want to update all products, leave the filters empty.
- Select the checkbox in the first column for the selected products or the full list.
2.4 Export data:
- Open the Action dropdown, click Export to CSV, and download the generated CSV file.
3. Edit the CSV file
3.1. Open the file in Google Sheets:
- Log in to your Google account:
- Go to Google Sheets and upload the CSV file.
3.2. Edit prices:
- In the PRICE column, change the product prices to the new values.
- You can also edit other attributes if you exported them, such as special_price, qty, or visibility.
3.3. Save the file:
After making changes, select File > Download > Comma Separated Values (.csv) to save the edited file.
4. Import updated data into Magento
4.1. Go to the import module:
- In the Magento admin panel, select System > Import (or the dedicated section of the Blacksmith module).
4.2. Upload the CSV file:
- Select the previously edited CSV file.
- Make sure the correct format (CSV) and import settings are selected.
4.3. Map the data:
- Check that the columns in the file are correctly mapped to Magento attributes, such as:
- Column SKU -> Attribute SKU,
- Column PRICE -> Attribute Price,
4.4. Start the import:
- Click Import and wait for the system to finish processing.
5. Verify the changes
After the import is complete:
- Go to the product catalog in the Magento admin panel.
- Check the selected products to make sure the prices have been updated.
- If you notice errors, you can re-import the corrected CSV file.
Benefits of this solution
Speed: You can update hundreds of products in bulk in minutes.
Flexibility: You can edit any attributes, not just prices.
Integration with Google tools: Editing a file in Google Sheets is intuitive and accessible from anywhere.
What else can be updated?
In addition to prices, the Blacksmith module allows you to export and import other product attributes, such as:
- Quantity in stock (qty),
- Product visibility (visibility),
- Product status (enabled/disabled),
- Promotional prices (special_price),
Summary
Bulk price updates in Magento 2 with a module from Blacksmith are an extremely convenient and efficient solution. With the ability to export and edit data in Google Sheets, you can quickly adjust your store to changing market conditions. If you want to implement this solution in your store, contact Kowal and ask for details about the module.
Ready to go? Get started today!