Price Increase Question

[mazoo]

I want to increase my product price by a certain amount then offer UK customers free postage, is there an easy way to do this or do i have to edit each product individually?

 

Kathryn

[nst888]

I want to increase my product price by a certain amount then offer UK customers free postage, is there an easy way to do this or do i have to edit each product individually?

 

Kathryn

 

You could always do it in mysql database directly updating the price column in the products table (remember the products price in the database is always ex VAT).

 

Oh, and make sure you do a backup first!

[mazoo]

You could always do it in mysql database directly updating the price column in the products table (remember the products price in the database is always ex VAT).

 

Oh, and make sure you do a backup first!

 

thanks,

 

good idea, I currently have 447 items/paintings in my shop and changing them all individually is going to be long winded but your idea will save some time but it is also open to human error, i don't know if there is a contribution anyone has that i can up my prices by £20 throughout all products/paintings.

 

Regards

 

Kathryn.

[davidinottawa]

I want to increase my product price by a certain amount then offer UK customers free postage, is there an easy way to do this or do i have to edit each product individually?

 

You want to increase by a fixed amount ????

You could do this to increae using a percentage.

This would increase all products by ten percent for example :

 

update `products` set `products_price` = (`products_price` * 1.1)

 

The issue here is that you don't know the number you are starting with. I could easily write a parsing script to do what you're asked.

But from the query wnidow .......................... I dunno.

 

Huh! Actaully this works, I just tested it :

 

update `products` set `products_price` = (`products_price` + 20)

 

Back up first. :-)

 

davidinottawa

[Guest]

I want to increase my product price by a certain amount then offer UK customers free postage, is there an easy way to do this or do i have to edit each product individually?

 

Increase price by 20 by doing this

update products

set products_price = (products_price + 20)

 

hth, Corrina

[mazoo]

You want to increase by a fixed amount ????

You could do this to increae using a percentage.

This would increase all products by ten percent for example :

 

update `products` set `products_price` = (`products_price` * 1.1)

 

The issue here is that you don't know the number you are starting with. I could easily write a parsing script to do what you're asked.

But from the query wnidow .......................... I dunno.

 

Huh! Actaully this works, I just tested it :

 

update `products` set `products_price` = (`products_price` + 20)

 

Back up first. :-)

 

davidinottawa

 

Cheers davidinottawa the following sql query update `products` set `products_price` = (`products_price` + 20)

Worked a treat, i tested it out on a dummy database first.

 

Thanks again

 

Kathryn