rodistrict Posted January 19, 2010 Share Posted January 19, 2010 Salut,Mar interesa cum pot face discount pe categoria Xenoane daca vreau sa fac discount la toate de 17% sa nu stau sa il iau pe fiecare in parte.Va Multumesc Anticipat Link to comment Share on other sites More sharing options...
valentin.g Posted January 19, 2010 Share Posted January 19, 2010 din phpmyadmin intri la sql si executi sintaxa de mai jos: UPDATE ps_product SET reduction_percent = 20 WHERE id_product IN (SELECT id_product FROM ps_category_product WHERE id_category=4) unde am pus 20% la reducere pentru categoria cu id-ul= 4ca sa preiei id-ul categoriei tale deschide categoria din meniul cu categorii si vezi in url ce apare la id_categoryvezi ca am folosit prefixul ps_ , care poate fi diferit in cazul tau vezi cu phpmyadmin ce aparealtfel, am vazut un modul(dar contra cost) in care poti sa faci modificari pe seturi de date cum doresti tu direct din catalog in back office. Link to comment Share on other sites More sharing options...
rodistrict Posted January 19, 2010 Author Share Posted January 19, 2010 si cat costa acel modul ? Link to comment Share on other sites More sharing options...
valentin.g Posted January 19, 2010 Share Posted January 19, 2010 nu m-a interesat si nu mai retin detalii ! cauta si tu ... Link to comment Share on other sites More sharing options...
rodistrict Posted January 19, 2010 Author Share Posted January 19, 2010 am cautat de am inebunit nu am gasit nimic ai putea sa imi zici o denumire dupa cum sa il caut ? Link to comment Share on other sites More sharing options...
valentin.g Posted January 19, 2010 Share Posted January 19, 2010 ai impresia ca tin secret !? :bug: Link to comment Share on other sites More sharing options...
rodistrict Posted January 19, 2010 Author Share Posted January 19, 2010 pff inebunesc ca am o cat de 200 si ceva de prod ce trebe sa le fac discount de 21% si nu am chef de modificari cu mysql ... manual Link to comment Share on other sites More sharing options...
valentin.g Posted January 19, 2010 Share Posted January 19, 2010 pai se modifica toate automat ! Link to comment Share on other sites More sharing options...
rodistrict Posted January 19, 2010 Author Share Posted January 19, 2010 dar mie sa nu gafez unde bag aia arata o poza unde trebe sa scriu aia Link to comment Share on other sites More sharing options...
valentin.g Posted January 19, 2010 Share Posted January 19, 2010 intrii pe baza ta de date, si apoi selectezi tabul sql ! verifica ca tabelele au prefixul ps_ daca nu schimbi, si mai pui si id-ul de la categoria ta ! Link to comment Share on other sites More sharing options...
rodistrict Posted January 19, 2010 Author Share Posted January 19, 2010 nus speriat le am cu mysql ... dar nus fix unde trebe sa bag Link to comment Share on other sites More sharing options...
valentin.g Posted January 20, 2010 Share Posted January 20, 2010 ia vezi aici : http://www.prestashop.com/forums/viewthread/41320/module_i_teme/problema_modul_massupdatenu este ceea ce ti-am zis eu mai sus . dar pare sa fie in directia buna 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