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 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. You set the base price of the product 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.
You can quickly achieve it 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:
Then, 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 fields necessary for importing product attribute values are productSKU, type, name, and value. Keep them - 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).
Ensure the price modifier value for the sizing option L is NULL (= $49.99).
Remove the price modifier "+2" for XL's sizing option, 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 completes, you should see the updated prices.
Related pages: