# How to Update product price for next order that don't to be change previous product price? **URL:** \ **Category:** Ask for Help\ **Created:** [October 24, 2024, 9:03am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282 "2024-10-24T09:03:04Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Minn\_Shein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/minn_shein/32/80636_2.png) [@Minn\_Shein](https://community.glideapps.com/u/Minn_Shein)\ **Post date:** [October 24, 2024, 9:03am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/1 "2024-10-24T09:03:04Z")
Here previous price ![Minn's App · Glide - Google Chrome 10_24_2024 2_24_02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a58611ee3f5c58dd854fd8d1cf0934829d70ad01.jpeg) Then I Changed price ![Minn's App · Glide - Google Chrome 10_24_2024 2_24_28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7aec065c31e81c75176c9ad0274a0ce3dff1f655.png) The whole column have been changed price.I want to change price for next order not for previous ![Minn's App · Glide - Google Chrome 10_24_2024 2_23_00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5fe9fed0346ae33c425754801da979d02e22a32c.jpeg) Thanks All ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 24, 2024, 11:48am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/2 "2024-10-24T11:48:39Z")
Write the price to a basic column in the sale table when a row is added instead of using a lookup to get the price. Also for the future, a Rollup column is not necessary the way you are using it. The Lookup column should be enough as long as your relation is a single relation instead of a multiple relation. But for this case, you shouldn’t need a relation, lookup, or rollup if you write the price when the row is added. ---
**Author:** ![wendel\_ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendel_ferreira/32/19580_2.png) [@wendel\_ferreira](https://community.glideapps.com/u/wendel_ferreira)\ **Post date:** [October 25, 2024, 3:52am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/3 "2024-10-25T03:52:53Z")
Tenho um projeto da maneira que você esta tentando fazer, uso outra tabela para atualizar o preço, depois uso um relacionamento para vuscar informações sobre atualizacoes de preços, em seguida uso uma coluna para inverter os preços e uso o último. Ao invés de buscar o valor do produto por um relacionamento, tente gravar o preço assim que for salvo ---
**Author:** ![Minn\_Shein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/minn_shein/32/80636_2.png) [@Minn\_Shein](https://community.glideapps.com/u/Minn_Shein)\ **Post date:** [October 26, 2024, 6:05am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/5 "2024-10-26T06:05:06Z")
I don’t understand.The previous price have been changed when I try that you say.I want to create POS. ---
**Author:** ![Graralatino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/graralatino/32/81205_2.png) [@Graralatino](https://community.glideapps.com/u/Graralatino)\ **Post date:** [October 27, 2024, 12:53am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/6 "2024-10-27T00:53:07Z")
To change the price automatically, I would put a stock on the product, then a conditional, that when the stock is equal to the minimum that you decided to execute, it changes to the column with the other price, it is something simple to do, remember to synchronize the buy action button so that the stock is automatically subtracted, so when the quantity is lowered it will apply to the column with the new price. ---
**Author:** ![Minn\_Shein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/minn_shein/32/80636_2.png) [@Minn\_Shein](https://community.glideapps.com/u/Minn_Shein)\ **Post date:** [October 27, 2024, 6:11am UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/7 "2024-10-27T06:11:23Z")
But item are still.How to do that I want change only price? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 27, 2024, 11:01pm UTC](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/8 "2024-10-27T23:01:18Z")
> [@How to Update product price for next order that don't to be change previous product price?](https://community.glideapps.com/t/how-to-update-product-price-for-next-order-that-dont-to-be-change-previous-product-price/77282/2): > > Write the price to a basic column in the sale table when a row is added instead of using a lookup to get the price. Also for the future, a Rollup column is not necessary the way you are using it. The Lookup column should be enough as long as your relation is a single relation instead of a multiple relation. But for this case, you shouldn’t need a relation, lookup, or rollup if you write the price when the row is added. Have you tried doing exactly this?