Rusty11 Posted February 16, 2010 Share Posted February 16, 2010 Dobry vecer,mam tady takovy problem. Rad bych se zeptal, jak by bylo mozny navysit vsechny ceny o x procent. Mam tam hrozne moc polozek a nemohu vsechny propisat Velke diky Link to comment Share on other sites More sharing options...
Mamejeradi.cz Posted February 16, 2010 Share Posted February 16, 2010 Ja pouzivam tohle:http://www.prestastore.com/bulk-update/188-presta-quickupdate.html Link to comment Share on other sites More sharing options...
vigel Posted February 16, 2010 Share Posted February 16, 2010 podle me nejjednoduzsi je to pres phpmyadminupdate ps_product set price Link to comment Share on other sites More sharing options...
Rusty11 Posted February 16, 2010 Author Share Posted February 16, 2010 dekuji,a prosimte nevedel by si dat nejaky podrobnejsi navod pro ne tak skusene uzivatele ? Link to comment Share on other sites More sharing options...
vigel Posted February 16, 2010 Share Posted February 16, 2010 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 299ale 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. Link to comment Share on other sites More sharing options...
milan77 Posted June 2, 2010 Share Posted June 2, 2010 Správně je to: UPDATE ps_product SET price=price*1.2 Link to comment Share on other sites More sharing options...
Mamejeradi.cz Posted June 3, 2010 Share Posted June 3, 2010 A dalo by se nějak jen určitou značku? Ikdyž je to zboží zařazené v několika kategoriích?Například adidas bude v botách, mikinách, tričkách, teplákách.... Link to comment Share on other sites More sharing options...
milan77 Posted June 3, 2010 Share Posted June 3, 2010 Mno, jedině mi napadá přes massupdate, ale hromadně to nejde, ale máš to vypsaný aspoň v tabuilceMě se to hodilo na všechny produkty, páč jsem zapnul DPH a potřeboval jsme o to DPH snížit cenu Link to comment Share on other sites More sharing options...
Mamejeradi.cz Posted June 3, 2010 Share Posted June 3, 2010 NJN tohle je na preste nedomysleny Link to comment Share on other sites More sharing options...
milan77 Posted June 3, 2010 Share Posted June 3, 2010 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 :-( Link to comment Share on other sites More sharing options...
Mamejeradi.cz Posted June 3, 2010 Share Posted June 3, 2010 Přesně tak bohužel...Taky si toho budu muset hodně nechat upravit. Link to comment Share on other sites More sharing options...
newpresto Posted June 3, 2010 Share Posted June 3, 2010 Tady ten modul vypadá propracovaně,ale zkušenost s ním nemám http://www.broucek-a-beruska.cz/moduly-prestashop/ Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now