Jump to content

shimony

Members
 View Profile  See their activity

  • Posts

    65

  • Joined

  • Last visited

Contact Methods

Profile Information

  • Activity
    Agency

shimony's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. shimony
    Any response??? please ?
  2. shimony
    Hi. I have products that are made of different brands (its a collection of products in a package). I would like to assign more than one manufacturer for this product, any idea how this can be done? Or if there is any 3rd party tool to manage multiple brands to products i can use. Thanks.
  3. shimony
    Even better solution was to delete folder name cache and recreate it with 755 permissions - that make things much faster now.
  4. shimony
    Thank You!!! - I add the exact same problem and same solution worked for me too!!!
  5. shimony
    Just solved it - From SQL admin, use this sql query: SELECT `id_customer` , `active` , `id_gender` , `email` , `passwd` , `birthday` , `lastname` , `firstname` , `newsletter` , `optin` , "1" FROM `ps_customer` Click on Export, choose CSV, remove the "&quot& and replace the "," with ";". Copy the output to a text file with .CSV at the name Import Done.
  6. shimony
    Hi I have the same problem - i imported my customers and got successfully imported message, but no customers been imported. If anyone have a solution for this, please advise. thanks.
  7. shimony
    I got the same problem with the look. It is not as it should have been. Any idea how to fix it? it was ok on earlier versions. thanks.
  8. shimony
    It works with this line: $sql .= ' ORDER BY p.`quantity`>0 DESC,'.(isset($orderByPrefix) ? $orderByPrefix.'.' : '').'`'.pSQL($orderBy).'` '.pSQL($orderWay); But, the only problem now is when i have in same page products in stock and out of stock - in this case the order is not correct - it goes by the selected order (price for example).
  9. shimony
    Hi I finally found the location where to change the sorting in categories. Line 537 in Classes/category.php The original line to replace is $sql .= ' ORDER BY '.(isset($orderByPrefix) ? $orderByPrefix.'.' : '').'`'.pSQL($orderBy).'` '.pSQL($orderWay).' But i am not about the line that i need to put instead (as to whitelighter's suggestion) since the syntax here is different. Please help
  10. shimony
    Thank you whitelighter ! - your way works better (even without the problem i had with Name sorting). Let me know if you find the place i need to change so it will take effect on category view as well. Thanks again,
  11. shimony
    Come on! please! anyone? It should be easy to anyone that familiar with CSS. I need this for version 1.4.x . Thanks.
  12. shimony
    Ill try and let you know soon if this works too. Any idea where can i put this in order it to take effect on category vies as well? Thanks.
  13. shimony
    Ok, found it myself. Just added the following code into classes/Search.php at line 269 replace this: WHERE p.`id_product` '.$productPool.' '.($orderBy ? 'ORDER BY '.$orderBy : '').($orderWay ? ' '.$orderWay : '').' LIMIT '.(int)(($pageNumber - 1) * $pageSize).','.(int)$pageSize; with : WHERE p.`id_product` '.$productPool.' '.'ORDER BY CASE p.`quantity` WHEN 0 THEN p.`quantity` END ASC , CASE p.`quantity` WHEN 80 THEN p.`'.$orderBy.'` ELSE p.`'.$orderBy.'` END '.$orderWay.' '.' LIMIT '.(int)(($pageNumber - 1) * $pageSize).','.(int)$pageSize; One note - From some reason it doesnt work when ordering by name, so i just removed that option (works for me). Also, This affect only on searches, but not when going to a category (and usually there you would like to keep the original ordering). In case you know how to set the same in categories, please let me know. Thanks
  14. shimony
    Okay. i know now that this is the SQL ordering i would like to do, but i dont know where can i put the code so it will take affect: ORDER BY (CASE `quantity` WHEN 0 THEN `quantity` ELSE `id_product` END) DESC'
  15. shimony
    Hi All, I would like to change a bit the way products being presented. I need two level of sorting: 1. same as we have today - user choose it and default by order or date... 2. products with quantity=0 (not in stock) will always show last. Is it possible to do such sorting? thanks,
×
×
  • Create New...