[script] Change all prices by a percentage.

[gabrielcrowe]

here is the pastebin url for a vbscript.

Create a file called 'AllPricesEdit.vbs' and put the contents of the pastebin entry inside it.

BEWARE: not for noobs, please test on a test catalog first. dont mangle your production catalog. you have been warned.

This script:
1) rifles through your products, multiplying their price by an offset.
2) Rounds the price to whole units (pence)
3) is section and catalog agnostic. It does EVERY product.

Useful for:
- Adjusting all prices by a percentage.

Be aware that there are much better tools to do this than this script, and they are more focused. This one just blasts the whole catalog. Both fergus and Jans solution for price shifting are much better. This is more a proof of concept than anything else.

Fun and comments below plz. kthnx.

[JSnow]

The "Displaying Store Prices In Three Currencies" gem in the aug can be modified to do something similar.

I use it on www splab co za to display the credit card price. It takes the product price, multiplies it by a % and displays the result.

The trick comes in when checking out. The trigger on whether to charge the cash price or credit card price is the selected payment method.

If the credit card payment method is selected, apply the difference between the cash and credit card prices as a credit card charge (surcharge).

Something else to bear in mind is that the cookie remembers the previous selected payment method and if that previous method happened to be the credit card, the surcharge will display in the cart with the subsequent order. So if the customer now chooses to pay with cash, the cart must be adjusted accordingly.


Simalarly, the same code could be used to display RRP's.

[chris ashdown]

Jan has a little program " Profit & Pricing Tool" that adjusts your prices with quite a lot of variations i.e. fixed amount, percentage