Is there a way to up our prices accross the board by say 10%

bluecat · #1 03-18-2004, 07:02 AM

I was wondering if there's a way I can up the price on every product by say 8% to 10% for a certain group. Is this possible? Thank you.

B00MER · #2 03-18-2004, 09:59 AM

Not without some kind of custom mod to do such.

DogByteMan · #3 03-18-2004, 10:45 AM

Could it be done via the DB?

B00MER · #4 03-18-2004, 11:29 AM

You could but it would be one helluva SQL query.

basic jest:
SELECT prices INSERT prices+%

groovico · #5 03-18-2004, 11:54 AM

PHP script would be useful for that kinda stuff.

Hrrrm *puts thinking cap on*

DogByteMan · #6 03-18-2004, 12:05 PM

Do I smell yet a new MM add-on....

Dmitri · #7 03-21-2004, 08:51 PM

I can share script that does exactly that but it's done on ColdFusion, which probably won't be much help for most of you (I host my xcart on hybrid platform, so I have support of all Windows things as well as Unix i.e ColdFusion, PHP, ASP, MySQL, MSAccess etc...) all at the same time...

John7 · #8 03-24-2004, 09:30 AM

Simply export your catalog to a CSV.

Open it in Excel.

Increase the prices by 10%.

Save it as a CSV file.

Then import it back in.

Hope that helps.

shan · #9 03-24-2004, 09:43 AM

heres a simple way to update a column in your database by 10%

Code:

UPDATE xcart_pricing SET price=price/100, price=price*110;

backup your database before you run this if you dont trust it

The first bit divides your price by 100 which will give you 1%

The next bit times it by 110 which gives you your original + 10%

bluecat · #10 03-24-2004, 05:53 PM

Thanks everyone, it's very appreciated (was gone for a few days). Thanks again!