Adjusting orderprice

If you're adding a large number of vehicles, adjusting prices can be time-consuming, but if you want static prices - for example, for dealerships to order vehicles at 10% of the selling price - you can do so very easily by adjusting the values in the 'price' column in the 'vehicles' table. Then, all you need to do is input the following query into your database to adjust all order prices based on a percentage of the vehicle price.

Query to adjust orderprice as 10% of price value

UPDATE vehicles SET `orderprice` = `price` * 0.1 WHERE `model` IS NOT NULL AND `model` != '';

Last updated