Jump to content

Hromadne zvyseni cen, prosim pomoc


Rusty11
 Share

Recommended Posts

rád bych poradil ,ale taky to neni z moji hlavy ja pouzivam na zmenu >Z< >NA<
napr.

update ps_product set price=299 where id_product in (select id_product from ps_category_product where id_category=5) and price=305;


to me nastavi pouze v kategorii ID 5 cenu z 305 na 299

ale pozor, v databazi je cena bez DPH, takze pokud ma byt 299 s dph tak musis takhle

update ps_product set price=(299/1.2) where id_product in (select id_product from ps_category_product where id_category=5) and round(price*1.2)=305;


ted jen zkusim tvuj problem:
update ps_product set price*1.2


coz by melo zvednou cenu o 20%
Ale nerucim za to vyzkousej si to na localu.

Share this post


Link to post
Share on other sites

  • 3 months later...

Mno, jedině mi napadá přes massupdate, ale hromadně to nejde, ale máš to vypsaný aspoň v tabuilce

Mě se to hodilo na všechny produkty, páč jsem zapnul DPH a potřeboval jsme o to DPH snížit cenu

Share this post


Link to post
Share on other sites

Tak je tam několik věcí, co mi vadí a upravoval jsme si, na spoustu věcí moje znalosti už nestačí :-(
Třeba bych v Massupdate chtěl editovat koncové ceny s DPH a prostě nelze :-(

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More