SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Increase all goods prices by a percentage ( 10%) (General)

posted by DavidJ(R), 13.10.2016, 06:50


Hopefully some one can help, I need to increase all prices for all stock on
sql-ledger by 10 %.

Thanks , Rebecca

IF you're familiar with postgresql and SQL-L, you could try something like :

UPDATE parts SET sellprice = sellprice*1.1

Or use listprice if thats what you want.
Warning. Don't try this at home without adult supervision.
If you break something, don't blame me.


Complete thread:

Back to the forum
Board view  Mix view
1024 Postings in 338 Threads, 355 registered users, 188 users online (0 registered, 188 guests)
SQL-Ledger User Forum | Admin contact
powered by my little forum