Changing 90% of product prices

[Steven Barkess]

Hi

I have been doing some price comparisons on my store vs a main competitor and it is clear that I need to reduce my average price to compete with them.

Normally, to reduce my prices, I would export into excel, do a simple formula and replace prices then import back to excel. However, one genre of product is already competive and I dont want to edit that price. So, any product that is 4.99 or under I dont want to touch, all products over this price, I want to reduce by 0.99.

Any thoughts on how to do this. Currently got about 700 products so looking for a quick(ish) way.

Thanks for thoughts.

Steven

[pinbrook]

sort the exported file into price order, then apply your formula to the rest of the column

[Stunty]

Currently got about 700 products so looking for a quick(ish) way.

700 products?

Is that all?? - there's 19,434 items on our store, and we've got a load of partial £ changes coming up in the next two weeks!!

*man.. I'd love to only have 700 items...*

[Mike Hughes]

Or use this formula in a macro:

' set the counter n to point to the first price row
' set the correct column in all cells statement (column C in this example)

n = 3
Price = Cells(n, "C").Value

Do While Price <> ""
If Price > 4.99 Then
Price = Price - 0.99
Cells(n, "C").Value = Price
End If
n = n + 1
Price = Cells(n, "C").Value
Loop

You might need to change the '4.99' to '499' and '0.99' to '99' if the prices are in pence.

Mike

PS. This assumes that the prices are continuous in the column and stops at the first blank value it finds.

[Steven Barkess]

Thanks for that.

First Macro. Once I figured out how to use, works great.

Steven