Let us consider another case - when you use multi-value attributes for some of your products and set the price on the specific product options by adjusting the base product price with price modifiers.
Let us imagine that you have SKU 10001 (“Tall Slim Fit T-Shirt In White”). The t-shirt is available in the sizes S-M-L-XL. The base price of the product is set at $49.99, and this price applies to the sizing options S, M, and L, whereas the price on the XL option equals “base price + $2”:
For example, you need to change the price of this product so that the available sizing options have the following prices:
S - $47.99,
M - $48.99,
L - $49.99,
XL - $49.99.
This can be easily achieved using the export-import feature. To set the prices we require, we’ll adjust the price modifiers:
On the “Export in CSV” page of your store’s back end (Catalog > Export), choose to export product attribute values:
Download the resulting export file and open it in a spreadsheet editor.
Edit the file removing the columns whose contents will not need to be updated. Care not to remove the required columns. According to CSV import: Product attribute values, the required columns for importing product attribute values are productSKU, type, name, and value. Keep those columns - and the column priceModifier (You will need it to update the price modifiers). Now, if you look at the lines of SKU 10001, you should see something like the following:
Adjust the values in the priceModifier column:
Add the price modifier “-2” for the sizing option S ($49.99 - 2 = $47.99)
Add the price modifier “-1” for the sizing option M ($49.99 - 1 = $48.99).
Make sure the price modifier value for the sizing option L is NULL (= $49.99).
Remove the price modifier “+2” for the sizing option XL, so XL's price modifier value is also NULL (= $49.99).
Save the file and import it back into your store via the Import page in your store’s Admin area (Catalog > Import).
After the import process is completed, you should be able to see the updated prices.