X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   Is there a way to up our prices accross the board by say 10% (https://forum.x-cart.com/showthread.php?t=6752)

bluecat 03-18-2004 07:02 AM

Is there a way to up our prices accross the board by say 10%
 
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 03-18-2004 09:59 AM

Not without some kind of custom mod to do such.

DogByteMan 03-18-2004 10:45 AM

Could it be done via the DB?

B00MER 03-18-2004 11:29 AM

You could but it would be one helluva SQL query.

basic jest:
SELECT prices INSERT prices+%

:D

groovico 03-18-2004 11:54 AM

PHP script would be useful for that kinda stuff.

Hrrrm *puts thinking cap on*

DogByteMan 03-18-2004 12:05 PM

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

Dmitri 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 03-24-2004 09:30 AM

Idea
 
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 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% :wink:

bluecat 03-24-2004 05:53 PM

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


All times are GMT -8. The time now is 09:29 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.