![]() |
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. :)
|
Not without some kind of custom mod to do such.
|
Could it be done via the DB?
|
You could but it would be one helluva SQL query.
basic jest: SELECT prices INSERT prices+% :D |
PHP script would be useful for that kinda stuff.
Hrrrm *puts thinking cap on* |
Do I smell yet a new MM add-on....
|
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...
|
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. |
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: |
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.