Jump to content

fernandokerber

Members
  • Posts

    129
  • Joined

  • Last visited

Everything posted by fernandokerber

  1. I have a suggestion! Instead of showing the payments methods just AFTER user saving the address, prestashop should show some "unable" payment logo, and turn it on only after saving address. Before saving the address the client should see the payment logos in black & white or something like that...... what do you think? PS: my suggestion doesn't discard the translating idea.
  2. Hi I got exactly the same error, but i solved it. This code seems to be missing the DB_PREFIX in some places. I changed it and now it is working nice to export de Products CSV. Take a look at this peace of code: function getProducts() { global $db; $csvOutput = array(); //from http://nemops.com/prestashop-export-products/ $query = 'SELECT p.*, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition FROM product p LEFT JOIN product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN category_product cp ON (p.id_product = cp.id_product) LEFT JOIN category_lang cl ON (cp.id_category = cl.id_category) WHERE pl.id_lang = '.LANG_ID.' AND cl.id_lang = '.LANG_ID.' GROUP BY p.id_product'; This code forgot the "ps_" (in my case) in it's last lines. Try to insert the DB Prefix manually. My new code became this way: function getProducts() { global $db; $csvOutput = array(); //from http://nemops.com/prestashop-export-products/ $query = 'SELECT p.*, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) WHERE pl.id_lang = '.LANG_ID.' AND cl.id_lang = '.LANG_ID.' GROUP BY p.id_product'; I Hope to help you EDIT: Now i have another problem: In my site the image url looks like: www.site.com/store/1261-2522-home/pelicula-1183.jpg But in the CSV i have this kind of URL: www.site.com/store/img/p/4/4.jpg How to fix that?
  3. Hi there. Some time ago I was searching for a FREE module to login/create account based on Facebook account. I didnt find any free solutions, so I gona ask one more time Does we have any module to do that? Ty
  4. Seria bastante interessante, confesso que nunca vi tal módulo funcionando, pode citar alguns sites que tem esta ferramenta? Após redirecionar o cliente para o banco, o cliente tem que efetuar login e alguns sites utilizam leitora de cartões, plugins e etc, será que funcionaria bem?
  5. olá pessoal. ainda não encontrei nenhum módulo relacionado a pagamento e correios que funcione na versão 1.5 não existe nada? estou procurando pagSeguro e frete Correios, posso ajudar a desenvolver caso alguém esteja tentando abraço!
  6. hi! I need some help here. I want to put an hyphen ( "-" ) between the post code. Here in Brazil our post code format is xxxxx-xxx In the country options, I set "Zip/post code format" to "NNNNN-NNN" But in my shipping address the number appears like NNNNNNNN. Without the hyphen.... Any help? I have other problem, I need to separate the City name from the State name wth a bar ( "/" ). How could I do that? I attached an image to ilustrate my issue. Thanks in advance.
  7. hi folks. I'm having a big problem with my Ajax cart functions. When I click for the very first time in any "add to cart" , it takes over 10 seconds to add the product to the cart. The second, third and all the next times I click in "add to cart" it takes about 1 or 2 seconds.. How should I solve this? When I install a fresh version of prestashop, it looks like quicker. But after making some visual changes and adding some modules it happens what I said. I tried to reinstall my shop 3 times but this always happens when I'm almost finishing it. I was thinking about to make a "ajax" call with a "ghost" product before the customer clicks in "add to cart". This ghost call should be called when the customer open the site. So when he try to add hist first product to the cart, the ajax call should be faster And now? PS: I have my CCC, force compile and cache settings configured to improve the performance.
  8. hi.. strange problem.. using version 1.4.8 i cant access the mail alerts module I tried to install a new fresh version and another one from this forum without success any help? thanks in advance
  9. i have the same problem using 1.4.8 any ideas on how to fix this?
  10. Thank you very much for your fast response! Im gonna try this probably just tomorrow and I`ll say you if it worked. Thanks again
  11. hi! excelent module but i have a question: how can I limite this module effects just to one kink od user? (based on user groups) I need to check if that user is logged as VIP CUSTOMER group (for example) and so go on with the discounts...
  12. Hi. I used this module and its a very good one. fow now I have one problem, I want to apply this discount just if determinated kind of user (group) is logged. How can I make an user group check? Any idea? thanks? http://www.prestashop.com/forums/topic/140803-free-module-category-quantity-discount-apply-quantity-discounts-across-all-products-in-a-category/
  13. hi i've never seen an online store without this function. How can we do this with prestashop? thanks
  14. Hi I have this code in my LikeALot facebook plugin. {if $product} <meta property="og:title" content="{$product.name|escape:'htmlall':'UTF-8'}"/> <meta property="og:type" content="product"/> <meta property="og:image" content="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home')}"/> <meta property="og:description" content="descricao."/> <meta property="og:url" content="http://{$smarty.server.HTTP_HOST}{$smarty.server.REQUEST_URI}"/> {/if} This code puts into og:image the address of the product cover image. But how can i set the og:image pointing to the secod product image?
  15. hi! it was easy to solve this In likealotmodule/likealot.tpl just change the font value to one of the fonts supported by facebook. example: verdana (with small letters) and VOILA
×
×
  • Create New...

Important Information

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