If you want to update prices for products in batches, you can conveniently do so using the import tool. In the product import, you can set or update the regular price (Price), sale price (SalePrice), and purchase price (InPrice) of the product. If you're also dealing with multiple currencies or sales channels, you can update the prices differently for each on the product through the import.
Explanation of current fields.
| Price | Product price (in default currency if currency is not specified in the Currency column). Should not be mapped if empty. |
| SalePrice | Product's sale price (in default currency if currency is not specified in the Currency column). |
| InPrice |
Product's purchase price. |
| Currency | The currency of the price you want to update. |
| Channel | Which sales channel the price should apply to (for example, site.se, site.com). Price is set for the default sales channel if empty. |
Important to consider when working with multiple sales channels (such as .se, .com) and currencies is that the Currency and Channel columns always have a value set.
Example of fields in the import file for different types of price updates.
Example of fields in the import file based on the product import template, where the price of the product is set in the default currency on the default sales channel (if working with one):
Example of fields in the import file based on the product import template, where the sale price in a product's default currency is updated (important to note not to map the "price" field in the import if it's empty):
Example of fields in the import file based on the product import template, where the price of the product is set for a specific sales channel (channel) and currency:
Example of fields in the import file based on the product import template, where the price of the product is set for two different sales channels with two different currencies:
When you have your file ready:
- Click on "Import Tool" in the menu.
- Then click "New" to create a new import.
- Choose the file you want to import.
- Select the file type in the "File extension" dropdown.
- Choose "Template type: Product".
- Choose "Import mode: Insert/update".
- Press "Next".
- Ensure that the columns mentioned in the article are mapped to the system's columns.
- Press "Start import".
Once the import is complete and if all rows are imported successfully, the product prices should be updated. You can verify this by going to a product and checking the price fields, or alternatively, under the "Prices" tab, you should see that the prices match what you specified in the import.
Price field within a product.
Price corresponds to the Price column in the product import template, Discount price corresponds to the SalePrice column, and Purchase price corresponds to the InPrice column.
Prices listed under the "Prices" section within a product.
