Frequently, Magento 2 store owners need to mass update the prices of their products. Thanks to the simple Magento 2 Export Products to CSV module, this can be done quickly and conveniently, using export and import of data in CSV format. In this article, we will discuss 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 preserving the corresponding column headers. After updating the data, you can import this sheet without errors into magento with the built-in function for imports.
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 attributes:
- SKU (product identifier),
- PRICE (current product price).
2.2. Go to product list:
In the administration panel, go to the list of products: Catalog > Products
2.3. Select products for export:
- Use the 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 checbox in the first column for selected products or full list
2.4 Export data:
- Undo the Action dropdown and 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 (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 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. Unload 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 with Magento attributes, such as:
- Column SKU -> Attribute SKU,
- Column PRICE -> Attribute Price,
4.4. Start import:
- Click Import and wait for the system to finish processing.
5. Verify the changes made
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 mass update hundreds of products 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 update in Magento 2 thanks to a module from Blacksmith is an extremely convenient and efficient solution. With the ability to export and edit in Google sheets, you can quickly adjust your store to changing market conditions. If you want to implement such a solution in your store, contact Kowal and ask for details about the module.
Ready to go? Get started today!