Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

All Products SEO


231 replies to this topic

#221 Jack_mcs

  • Community Member
  • 24,449 posts
  • Real Name:Jack
  • Gender:Male

Posted 19 April 2012, 23:19

View Postlblanks240, 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.

#222 lblanks240

  • Community Member
  • 20 posts
  • Real Name:lenard blanks

Posted 20 April 2012, 04:23

what is the code for the mod rewrite

thanks
lenard

#223 Jack_mcs

  • Community Member
  • 24,449 posts
  • Real Name:Jack
  • Gender:Male

Posted 20 April 2012, 11:38

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.

#224 Mazi

  • Community Member
  • 16 posts
  • Real Name:Marcel M.

Posted 24 April 2012, 15:18

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

#225 Jack_mcs

  • Community Member
  • 24,449 posts
  • Real Name:Jack
  • Gender:Male

Posted 24 April 2012, 23:31

View PostMazi, 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.


#226 altoid

  • Community Member
  • 536 posts
  • Real Name:Steve
  • Gender:Male
  • Location:Pennsylvania

Posted 25 April 2012, 00:46

View PostJack_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.
I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.
I remember what it was like when I first started with osC. It can be overwhelming.
However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.
There are several good pros here on osCommerce. Look around, you'll figure out who they are.

#227 Jack_mcs

  • Community Member
  • 24,449 posts
  • Real Name:Jack
  • Gender:Male

Posted 25 April 2012, 03:01

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";


#228 altoid

  • Community Member
  • 536 posts
  • Real Name:Steve
  • Gender:Male
  • Location:Pennsylvania

Posted 25 April 2012, 16:41

View PostJack_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
I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.
I remember what it was like when I first started with osC. It can be overwhelming.
However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.
There are several good pros here on osCommerce. Look around, you'll figure out who they are.

#229 Mazi

  • Community Member
  • 16 posts
  • Real Name:Marcel M.

Posted 26 April 2012, 14:11

View PostJack_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.

#230 Jack_mcs

  • Community Member
  • 24,449 posts
  • Real Name:Jack
  • Gender:Male

Posted 26 April 2012, 15:34

View PostMazi, 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.

#231 joli1811

  • Community Member
  • 318 posts
  • Real Name:john dunlop
  • Gender:Male
  • Location:Ireland

Posted 18 May 2012, 04:11

View PostJack_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,
Attached File  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.


#232 altoid

  • Community Member
  • 536 posts
  • Real Name:Steve
  • Gender:Male
  • Location:Pennsylvania

Posted 21 May 2012, 00:32

View Postjoli1811, 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.
I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.
I remember what it was like when I first started with osC. It can be overwhelming.
However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.
There are several good pros here on osCommerce. Look around, you'll figure out who they are.