Page 1 of 17 12311 ... LastLast
Results 1 to 10 of 169
  1. #1

    Default product filter module addon

    I wrote a sidebox module for product filter by attribute, and price range. I looked all over the places and couldn't find something similar, so ending writing my own. It seems to be working, but only tested using zen-cart v1.37.

    Don't forget to read the README file first. I tried to sumit to zen-cart.org. But the file didn't get submitted (don't know why).

    Anyways, Here's the download page in my blog. Zen Cart Product Filter by Attribute, Price RangeZen Cart Product Filter by Attribute, Price Range. I wish zen-cart can give me a place to host the file. I've already tried to submit to the download page, but it failed to upload.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Zen cart product filter module

    Quote Originally Posted by jye999 View Post
    I wish zen-cart can give me a place to host the file. I've already tried to submit to the download page, but it failed to upload.
    It uploaded fine:
    http://www.zen-cart.com/index.php?ma...roducts_id=760
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jan 2007
    Posts
    92
    Plugin Contributions
    2

    Default Re: Zen cart product filter module

    I have been looking for something like this but found to problems with this mod.

    First is no Images show.

    The second when you put price lowest to highest it gives this out.

    1054 Unknown column 'P.products_price' in 'order clause'
    in:
    [select DISTINCT p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status FROM zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_products_attributes pa, zen_products_options po , zen_products_options_values pov WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND pa.options_id = 1 AND pa.options_values_id = 26 AND p.products_id = pa.products_id AND p.products_status =1 AND p.products_quantity > 0 ) order by P.products_price ASC, p.products_date_added DESC, p.products_date_available DESC limit 0, 15]

    If these 2 things are corrected it has the makings of a great mod.

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Zen cart product filter module

    The reference P.products_price looks in correct as the alias is p and not P ...

    Perhaps a typo and you need this referencing the products table with p vs P ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Jan 2007
    Posts
    92
    Plugin Contributions
    2

    Default Re: Zen cart product filter module

    Quote Originally Posted by Ajeh View Post
    The reference P.products_price looks in correct as the alias is p and not P ...

    Perhaps a typo and you need this referencing the products table with p vs P ...
    Thanks for that it sounds like it could be the problem, I have not tried it because it is the images or lack of them I really need to sort out.
    Any ideas on that it just gives a page full of no image available boxes.

  6. #6
    Join Date
    May 2007
    Location
    Los Angeles
    Posts
    89
    Plugin Contributions
    0

    Default Re: Zen cart product filter module

    Quote Originally Posted by jye999 View Post
    I wrote a sidebox module for product filter by attribute, and price range. I looked all over the places and couldn't find something similar, so ending writing my own. It seems to be working, but only tested using zen-cart v1.37. ..........
    Thanks! exactly what I was looking for.
    Is there a way to exclude certain attributes?

  7. #7
    Join Date
    Apr 2006
    Location
    Fort Bragg, North Carolina
    Posts
    153
    Plugin Contributions
    0

    Default Re: Zen cart product filter module

    I'm having this same problem:


    1054 Unknown column 'P.products_price' in 'order clause'
    in:
    [select DISTINCT p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status FROM zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_products_attributes pa, zen_products_options po , zen_products_options_values pov WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND pa.options_id = 1 AND pa.options_values_id = 26 AND p.products_id = pa.products_id AND p.products_status =1 AND p.products_quantity > 0 ) order by P.products_price ASC, p.products_date_added DESC, p.products_date_available DESC limit 0, 15]

    It seems that you answered it and corrected the problem but I didn't quite understand how to do so.

    Exactly what do I do with:
    The reference P.products_price looks in correct as the alias is p and not P ...
    Perhaps a typo and you need this referencing the products table with p vs P ...

    Thanks

  8. #8
    Join Date
    Dec 2007
    Posts
    3
    Plugin Contributions
    0

    Default Re: Zen cart product filter module


    I got this module installed - but for some reason when i submit i get this response: TEXT_NO_PRODUCTS

    What do i have not configured correctly? eeek!

  9. #9
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Zen cart product filter module

    People with the P problem:

    Open: includes/modules/pages/product_filter_result/header_php.php
    Find:
    PHP Code:
    case 2:
                
    $order_str " order by P.products_price ASC, p.products_date_added DESC, p.products_date_available DESC "
    Replace by:
    PHP Code:
                $order_str " order by p.products_price ASC, p.products_date_added DESC, p.products_date_available DESC "
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  10. #10
    Join Date
    May 2007
    Location
    Los Angeles
    Posts
    89
    Plugin Contributions
    0

    Default Re: Zen cart product filter module

    I love this mod, but..

    The search results have "No Image Available"!
    I also get "TEXT_NO_PRODUCTS", on some searches. Does anyone have any thoughts?

    Thanks in advance!

 

 
Page 1 of 17 12311 ... LastLast

Similar Threads

  1. Product filter Module: Advanced search results page not working
    By WWRepair in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 5 Mar 2013, 11:51 PM
  2. v139h 1064 SQL error in product filter addon?
    By 4jDesigns in forum All Other Contributions/Addons
    Replies: 12
    Last Post: 17 Jan 2013, 07:59 PM
  3. Product Filter Module - 1109:Unknown table 'p' in field list
    By moesoap in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 28 May 2012, 01:40 PM
  4. modified product filter / alpha filter help please
    By bn17311 in forum General Questions
    Replies: 1
    Last Post: 5 Oct 2011, 09:43 PM
  5. SQL problem with filter by attributes addon
    By daparky in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 6 Jan 2010, 10:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR