Filters by prices

[DarkAngel]

I never noticed it before but the filter for low to high and high to low are confused...in 1.5.4 and 1.3.9h

when you click for it to do either of those you get the listing like you should get, but the prices are NOT in the order chosen.

Is this just how it is supposed to be or what do I need to do.

[stevesh]

I'm not seeing product listings on your site.

[DarkAngel]

I'm not seeing product listings on your site.

Hi stevesh,

the link is www.designerperfumesnob.com the 1.5.4 store anyway and the filter for that is in the categories or all products which have gone walk about cause they sure are not there anymore...They were showing when I posted this and up until about 2 this morning and gone now.

I am beginning to hate responsive templates with a passion. Fix one thing and something else goes kaput.

Last file I was in was the tpl_product_info_display.php, trying to get the footer to be at bottom again....I get the reviews at bottom of product page, but then if there is no review the footer comes up midway.

Now I have to reup that file and see what happened....after I check the logs


now they is back I forgot to comment out a stray } in the product_listing_alpha_sorter.php

[DarkAngel]

Just wondering if anyone has a clue what could be causing this.

[DarkAngel]

I have been comparing both the 1.5.4 store and that owner and my own store have fairly the same settings. The only real difference is that mine is still 1.3.9h and both stores list the items from low-high or vice versa but they are not listed on the page as so.

They are listing low to high up to a point...there may be a couple low (or high depending on filter used) but then the prices start showing higher or lower than the previous making it like 14.00, 15.00 then suddenly 12.00

I tried looking at the codes and the filter files don't really do much other than let you remove or change order of the filters showing in the drop menu. I am not really sure where or which file in the template folder to see if there is somewhere else to see if something got gone...LOL

MY store link http://fantasiesrealm.com/market/

Anyone have suggestions or should I just ignore it.

[mc12345678]

I thought I came across a store manager option (Update ALL Products Price Sorter) recently that allowed some sort of reset to be able to sort by displayed prices... Store manager is found in Admin screen, Tools, Store Manager. I also thought that I had done some research on this to see that there were some filters not on the problem site that are in a standard ZC site, which made me wonder what customization(s) were made to remove the additional filtering. But if you try the above "first", then maybe some more investigation is needed.

[DarkAngel]

I thought I came across a store manager option (Update ALL Products Price Sorter) recently that allowed some sort of reset to be able to sort by displayed prices... Store manager is found in Admin screen, Tools, Store Manager. I also thought that I had done some research on this to see that there were some filters not on the problem site that are in a standard ZC site, which made me wonder what customization(s) were made to remove the additional filtering. But if you try the above "first", then maybe some more investigation is needed.

The only editing was to remove the other filters from the drop list --- on the 1.54 site, but on my own 1.39 site the filter drop menus are not altered at all so not sure what is going on. I did go to admin before posting again to change the entries for anything to do with filters then save from what they were set to to anything else and that did not change a thing in either store.

I will be going to 1.5.4 in the near future so maybe it might behave but right now it does not matter on my store but the other newer one I am working on -- she would like the entries to show in their proper order. My question is will this reset change the order everything is showing...the filters in question are in the all and new listings only. Will that only reset those to show them right in the drop menu chosen or will it reset them all to show by prices instead of product name like they are now.

This is what was done:

1. To control the option in the sort by dropdown on new products and all products page: /public_html/includes/templates/template_default/templates/tpl_modules_listing_display_order.php

Find:

Can be controlled from line 31 to 37. Following is the code:

<option value="1" <?php echo ($disp_order == '1' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_NAME; ?></option>

<option value="2" <?php echo ($disp_order == '2' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_NAME_DESC; ?></option>

<option value="3" <?php echo ($disp_order == '3' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_PRICE; ?></option>

<option value="4" <?php echo ($disp_order == '4' ? 'selected="selected"' : ''); ?>><?php echo TEXT_INFO_SORT_BY_PRODUCTS_PRICE_DESC; ?></option>

options 5-7were deleted from file <!--<option value="5" <?php //echo ($disp_order == '5' ? 'selected="selected"' : ''); ?>><?php //echo TEXT_INFO_SORT_BY_PRODUCTS_MODEL; ?></option>

<option value="6" <?php echo ($disp_order == '6' ? 'selected="selected"' : ''); ?>><?php //echo TEXT_INFO_SORT_BY_PRODUCTS_DATE_DESC; ?></option>

<option value="7" <?php echo ($disp_order == '7' ? 'selected="selected"' : ''); ?>><?php //echo TEXT_INFO_SORT_BY_PRODUCTS_DATE; ?></option>-->



2. To control the options in the "Filter Results by" dropdown on all the category home pages: /public_html/includes/modules/custom/product_listing_alpha_sorter.php ---comment out lines in red--but I had to remove them totally

I think these are for removing the numerical sorter from the other category pages and leave only the alpha sorter.

Find:

// build alpha sorter dropdown
if (PRODUCT_LIST_ALPHA_SORTER == 'true') {
if ((int)$_GET['alpha_filter_id'] == 0) {
$letters_list[] = array('id' => '0', 'text' => TEXT_PRODUCTS_LISTING_ALPHA_SORTER_NAMES);
} else {
$letters_list[] = array('id' => '0', 'text' => TEXT_PRODUCTS_LISTING_ALPHA_SORTER_NAMES_RESET);
}
for ($i=65; $i<91; $i++) {
$letters_list[] = array('id' => sprintf('%02d', $i), 'text' => chr($i) );
}
for ($i=48; $i<58; $i++) {

$letters_list[] = array('id' => sprintf('%02d', $i), 'text' => chr($i) );

}

[mc12345678]

By review of the code (1.5.4), That option will change the products_price_sorter field in the products table to be equal to the actual products price. If you have EP4 installed on this site, you could add that field as a custom field, export all of the product and see if/what discrepancies exist in the price and possibly sort on that value to see if that is the issue before selecting the reset button.

No I do not know why that field would be different than the current actual price, other than something changed data without going back to the products table and updating that field...

[DarkAngel]

By review of the code (1.5.4), That option will change the products_price_sorter field in the products table to be equal to the actual products price. If you have EP4 installed on this site, you could add that field as a custom field, export all of the product and see if/what discrepancies exist in the price and possibly sort on that value to see if that is the issue before selecting the reset button.

No I do not know why that field would be different than the current actual price, other than something changed data without going back to the products table and updating that field...

Well that is all way above my brain grade...LOL

No idea what EP4 is and those are the only edits concerning the filter menus I did on this fresh install of both store and template. It might be something we both have to live with...since mine does it also with no edits what so ever to the filter menus.

Thanks for your help tough.

[mc12345678]

Are you saying that you have or have not pressed the reset button described above?

My point was that it has no effect on the options available to filter. It simply updates the data associated with the price and therefore when filtered by price will show correctly.