231 replies to this topic

[Jack_mcs]

lblanks240, on 19 April 2012, 22:04, said:

i am gettining this error when you click on a number or letter how can i fix it

Not Found

The requested URL /all-products.php-by-A.html was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

The first problem is most likely due to your url rewriter not having the required code to handle the rewrites. To verify that, turn the rewrtier off in admin and try the links again.

The second is saying you don't have a 404 page setup for your site, It is not related to this contribution. A 404 page is not required but all shops should have them.

[lblanks240]

what is the code for the mod rewrite

thanks
lenard

[Jack_mcs]

It won't help to just have that. The actual url rewriter has to be written to handle it. Ultimate SEO V2.2d, which is what I recommend, and, I think, SEO 5 Pro, has it built-in.

[Mazi]

Finally this great add-on is available for the 2.3.1 OSC release. Great work, Jack_mcs!

I was wondering if it would be possible to not sort the products at the all_products.php page alphabetically but sort it like the best sellers (most sold products on top). Would that be easy doable by extending the SQL query and adding a different sorting?

I'm no PHP/SQL crack so any advice would be appreciated!

Thanks,
Mazi

[Jack_mcs]

Mazi, on 24 April 2012, 15:18, said:

Finally this great add-on is available for the 2.3.1 OSC release. Great work, Jack_mcs!

I was wondering if it would be possible to not sort the products at the all_products.php page alphabetically but sort it like the best sellers (most sold products on top). Would that be easy doable by extending the SQL query and adding a different sorting?

I'm no PHP/SQL crack so any advice would be appreciated!

Thanks,
Mazi

In the all products file, you could change this line

$listing_sql .= " order by pd.products_name";

to

$listing_sql .= " order by p.products_ordered";

I have tested it but I think it iwill work.

Edited by Jack_mcs, 24 April 2012, 23:32.

[altoid]

Jack_mcs, on 24 April 2012, 23:31, said:

In the all products file, you could change this line

$listing_sql .= " order by pd.products_name";

to

$listing_sql .= " order by p.products_ordered";

I have tested it but I think it iwill work.

This is an interesting concept. Changing line 191 as above but including the DESC syntax, gives me the best sellers on the first page of all products, ordering my best sellers in descending order.

Then using the letter keys, the display produces alphabetically listed items. Full takes to the products listed by best sellers in descending order

The change initially duplicate what's in the best sellers box, but it may be useful in point out to customers right off what items are selling the best.

Something to think about.

[Jack_mcs]

The change I mentioned would only affect the main page. Once a letter is clicked on, different code is used. Below the code I mentioned are several lines like

		  $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

Change each of those to add the p.products_ordered like the following and it will probably work correctly

		  $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", p.products_ordered, pd.products_name";

[altoid]

Jack_mcs, on 25 April 2012, 03:01, said:

The change I mentioned would only affect the main page. Once a letter is clicked on, different code is used. Below the code I mentioned are several lines like

		  $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

Change each of those to add the p.products_ordered like the following and it will probably work correctly

		  $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", p.products_ordered, pd.products_name";

I'll try this out on one of the shops for a while to see how it goes. I think that there's may be a greater chance of customer engagement if more popular (best seller) items popped up on the all products pages as opposed to strictly alphabetical.

I realize this is also for the benefit of SEO, but I don't think a search engine would care of it was a best seller on page one vs the first product by alphabetical listing.

Thanks

[Mazi]

Jack_mcs, on 24 April 2012, 23:31, said:

In the all products file, you could change this line

$listing_sql .= " order by pd.products_name";

to

$listing_sql .= " order by p.products_ordered";

I have tested it but I think it iwill work.

This works like a charm, Jack. Thanks a lot for your help.

Note that you should add ...DESC at the end of the line to have the best sellers on top of you all products list.

Here is an example of the "Limesurvey Template Shop" where I am using the feature for the "View All Products" list.

[Jack_mcs]

Mazi, on 26 April 2012, 14:11, said:

This works like a charm, Jack. Thanks a lot for your help.

Note that you should add ...DESC at the end of the line to have the best sellers on top of you all products list.

Here is an example of the "Limesurvey Template Shop" where I am using the feature for the "View All Products" list.

I'm glad it worked out. And thanks for bringing it up since it isn't something I had thought about. I'll add it as an option in the next release. By the way, you may want to consider changing the display mode option. I think it would look better and provide an easier way to view the images. Just my opinion.

[joli1811]

Jack_mcs, on 15 April 2012, 18:04, said:

I don't support any contribution-specific changes in support threads because there are too many.

Hi,
 bm_categories_accordion.php   12.91K   1 downloads
for anybody wanting Jacks contribution integrated with accordion_categories_menu_1.1.2 here is the bm_categories_accordion.php

John

Edited by joli1811, 18 May 2012, 04:12.

[altoid]

joli1811, on 18 May 2012, 04:11, said:

Hi,
bm_categories_accordion.php
for anybody wanting Jacks contribution integrated with accordion_categories_menu_1.1.2 here is the bm_categories_accordion.php

John

John, I did a work around to get the links in a different box, but if I would not have I'd may have used this code you provided. So thanks for posting. By the way..you'll see there is a new version of the accordion categories if you check that thread. Thanks again.