outblast Posted February 6, 2011 Share Posted February 6, 2011 Buna ziua, am si eu o problema cu actualizarea preturilor.Catalogul meu online are in jur de 4500 de articole la care din cand in cand trebuie sa modific preturile (nu la toate neaparat) in functie de preturile furnizorilor de la care primesc liste in format .xls, am cautat pe forumurile presta dar nu am gasit nimic concret, nu pot sa cred ca sunt singurul care se loveste de aceasta problema, ma gandeam ca exista un modul, ceva care sa iti faca update la pret comparand codurile produselor (sau asa ceva).Va rog daca puteti sa ma ajutati cu un sfat, idee, modul, link ....Multumesc Link to comment Share on other sites More sharing options...
costi43 Posted February 6, 2011 Share Posted February 6, 2011 prestamanager sau ceva de genul acesta , cautal pe forum, si in prestastore Link to comment Share on other sites More sharing options...
outblast Posted February 7, 2011 Author Share Posted February 7, 2011 Am cautat dar nu am gasit numai discutii, din 2008, si linkuri defecte... Alte sugestii? Link to comment Share on other sites More sharing options...
costi43 Posted February 7, 2011 Share Posted February 7, 2011 incearca massupdate, sau producteditsunt module Link to comment Share on other sites More sharing options...
valentin.g Posted February 7, 2011 Share Posted February 7, 2011 daca fisierul excel contine codul ID al produsului din presta, sau REFERENCE atunci poti face din phpmyadmin actualizareamai intai creezi o tabela in care importi fisierul ala al tau si apoi QUERYUPDATE products SET products.price = import.price WHERE products.id IN (SELECT id FROM import)asta era o idee! Link to comment Share on other sites More sharing options...
outblast Posted February 7, 2011 Author Share Posted February 7, 2011 F. buna ideea, direct in DB, ierftin si rapid, am sa incerc, ms de ajutor Link to comment Share on other sites More sharing options...
valentin.g Posted February 7, 2011 Share Posted February 7, 2011 F. buna ideea, direct in DB, ierftin si rapid, am sa incerc, ms de ajutor sa faci si un backup inainte la tabela products 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