site wide price %

[Andy c]

Hi

My next problem is with getting my percentage from the csv files as doing them 1 by 1 is virtually insane ..I have tried to follow this link
http://www.e-commerce-forum.co.uk/index.php/topic,250.0.html
I don;t understand the sql (Reply #2) but have tried the other (Reply #4) from 6 onward I can't seem to fathom out
Also have tried "site wide, category & product mark up"
are there any other options that are easier to follow or a few pointers on either would  be great

thanks again

[gordym75]

You could update your price on the csv before uploading it. Copy the price column to a blank spreadsheet, use a formula to update the price for the whole column then copy the updated column and use paste special then select values to paste the numbers back into the csv file.

[seamus]

the sql patch, that works by running a command in admin>tools>install sql patches

if you go in there, there is a text box, you write in the code and click the button, that executes the code and depending on what the code is, it'll add tables to the database or in this case it updates the price column increasing the price by 10%

Code:

UPDATE products SET products_price = products_price * 1.10;

1.10 being 100% of the price and add 10% ontop, if you want to add 45% it would be 1.45

by sticking that line of code in and clicking the button, it should adjust all the prices and add 10% onto them all, thats not my code mind you, its from the other thread so I'v not tested it to see if it works alright,

gordys suggestion would be a good one, means there is nothing to break on the store, adding sql statments could break things if the code isnt right

[Andy c]

well b*gger me lol
That works great ,first time no problems .... I like it like that

thanks

I've just noticed you can't undo it and go back to original price ..so you will have to keep a safe csv copy as backup

[paulc010]

You can undo it in a way...... if you divide by the same ratio:

Code:

UPDATE products SET products_price = products_price / 1.10

Less accurately you could multiply by the reciprocal (1 divided by 1.1) which would be approximately 0.909 

Paul

[Andy c]

ok ..will give that a go and see