Is It possible to Raise all Prodct Prices by 10%?

[Jam00dle]

How would I rise all my Product prices by 10% without individually changing them 1by1.

Tere are 1000s of products and I don't have the time to change them all individually.


Please tell me there is a way to globally increase prices.



Thanks in Advance.


James Eley.

[Duncan Rounding]

You can either use this tool:
http://www.mole-end.biz/acatalog/Pro...ng_Tool_b.html
or export the catalog and make the changes yourself in Excel format and re-import.

[Jam00dle]

Thanks!

Will that tool allow an increase to all prices of say.. 10%?

Do you have any experiance with the tool and can you tell me how easy it is to use?

[Jam00dle]

Also, is there anyway to talk to the developer of this tool to ask a few questions before purchase?

Thanks again.

[Duncan Rounding]

Yes - just email them from their site:
http://moleend.helpserve.com/index.p...kets&_a=submit

[miketait]

Have not tried this, but how about using the SQL update prog. from todays post "Increasing my Tax Inclusive Pricing for the 20% Tax Increase" http://community.actinic.com/showthread.php?t=49003 and change the code in the .SQL files from "/1.175*1.2,0" to "*1.1,0"

[Benjamin Dyer]

Have not tried this, but how about using the SQL update prog. from todays post "Increasing my Tax Inclusive Pricing for the 20% Tax Increase" http://community.actinic.com/showthread.php?t=49003 and change the code in the .SQL files from "/1.175*1.2,0" to "*1.1,0"

You beat me to it, I was just about to suggest the same. I have just tried it here in a test site and can see no problems. However my 5 minutes playing around doesn't constitute an official test!

[miketait]

If a % increase results in some unsatisfactory prices here is some example SQL code to round the results:

1. Round UP to nearest .49/.99p (like supermarket prices!) -
UPDATE Product SET [Price] = ROUND((INT(-2*[Price])),0)/-2-0.01 WHERE [Price]<>0;

2 Round to nearest 5p -
UPDATE Product SET [Price] = ROUND(20*[Price],0)/20 WHERE [Price]<>0;

3 Round UP to nearest 5p
UPDATE Product SET [Price] = ROUND((INT(-20*[Price])),0)/-20 WHERE [Price]<>0;

The table below shows results

Original ......SQL1.....SQL2......SQL3
£4.23..........£4.49....£4.25.....£4.25
£14.31........£14.49...£14.30...£14.35
£16.66........£16.99...£16.65...£16.70

[Jam00dle]

Would changing the VAT from 17.5% to 27.5% work?

[leehack]

No, because actinic would them show it was applying 27.5% vat which is illegal and wrong, plus the maths wouldn't work either. Like the lateral thinking, but seriously drop that idea, not a good one on this occasion.

[Jan]

Thanks for recommending my program Duncan. I would just add that there is a 30 day free trial with the program so if this change is a one off then you could use it to make the modifications you need free of charge.

Regards,