For the first issue, you'll need to modify /includes/index_filters/default_filter.php, line 51:
Code:
$listing_sql = "SELECT " . $select_column_list . " p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description,
to add the DISTINCT clause:
Code:
$listing_sql = "SELECT DISTINCT " . $select_column_list . " p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description,
I'll be submitting a PR to the Zen Cart GitHub repository to correct the issue.
Bookmarks